Re: Problem getting mysqldump on Centos 5.x server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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




[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux