Bruce, one other option if you are low on diskspace is using ssh to pipe the file to another server. Check out http://christiank.org/wp/2010/12/pipe-a-gzipped-mysql-dump-over-ssh/ for an example of how you might do this On Wed, Apr 24, 2013 at 7:06 PM, Eero Volotinen <eero.volotinen at iki.fi>wrote: > Hi Bruce, > > Error 28 means that "not enought diskspace", free some more disk space and > try again. > > -- > Eero > > > 2013/4/24 Bruce Whealton <bruce at futurewaveonline.com> > > > > > > > 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 at centos.org > > http://lists.centos.org/mailman/listinfo/centos > > > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos >