Hi Bruce,
Error 28 means that "not enought diskspace", free some more disk space and
try again.
--
Eero
2013/4/24 Bruce Whealton <bruce@xxxxxxxxxxxxxxxxxxxx>
> >
> > If time is pressing, and he's not sure how to get mysqldump to
> > function properly, I'd suggest shutting down the mysql server, taking
> > a tarball backup of /var/lib/mysql (or wherever the database files
> > are), compressing that (xz is nice for these purposes), and then
> > getting the mysqldump backup.
>
> I'm a bit confused here. If I get a tarball and compress that, then is
> that
> for download and moving to the other server? Is this just in case the
> mysqldump does not work at all.
> >
> > As for getting the mysql dump itself, if he's not sure what privileges
> > are set up, I'd probably skip resetting permissions and instead taking
> > the dump from a daemon running under --skip-grant-tables.
>
> So, I start mysql-server with the option --skip-grant-tables and then try
> to
> do the mysqldump?
>
> >
> > It all depends on how much time he has before the system becomes
> > unavailable to him.
> >
> >
> In my previous email, I point out that the error now is different. It is
> error 28 from the storage engine. So, I have to google that and see what
> that means.
>
> Thanks,
> Bruce
>
>
> >Definitely another option.
>
> >The only thing I would say is if getting the dump under
> --skip-grant-tables
> you need to make absolutely >sure external access to the database is
> blocked
> as the daemon will presumably be running a lot longer in
> ->-skip-grant-tables to complete a dump than it would be just to reset a
> password.
>
> _______________________________________________
> CentOS mailing list
> CentOS@xxxxxxxxxx
> http://lists.centos.org/mailman/listinfo/centos
>
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
