Re: [CentOS] Problem getting mysqldump on Centos 5.x server

2013-04-24 Thread Les Mikesell
On Wed, Apr 24, 2013 at 2:06 PM, Bruce Whealton wrote: >>Check out > http://christiank.org/wp/2010/12/pipe-a-gzipped-mysql-dump-over-ssh/ for an > example of how you might do this > > So, first it gave the usual error that relates to not enough disk space. That doesn't make much sense. If you a

Re: [CentOS] Problem getting mysqldump on Centos 5.x server

2013-04-24 Thread Bruce Whealton
>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 So, first it gave the usual error that relates to not enough disk space.

Re: [CentOS] Problem getting mysqldump on Centos 5.x server

2013-04-24 Thread Bruce Whealton
>> 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 wrote: Hi Bruce, E

Re: [CentOS] Problem getting mysqldump on Centos 5.x server

2013-04-24 Thread Clint Dilks
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 wrote: > Hi Bruce, > > Err

Re: [CentOS] Problem getting mysqldump on Centos 5.x server

2013-04-24 Thread Eero Volotinen
Hi Bruce, Error 28 means that "not enought diskspace", free some more disk space and try again. -- Eero 2013/4/24 Bruce Whealton > > > > 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 backu

Re: [CentOS] Problem getting mysqldump on Centos 5.x server

2013-04-23 Thread Bruce Whealton
> > 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 mysqld

Re: [CentOS] Problem getting mysqldump on Centos 5.x server

2013-04-23 Thread Bruce Whealton
s.org] On Behalf Of Clint Dilks Sent: Tuesday, April 23, 2013 9:42 PM To: CentOS mailing list Subject: Re: [CentOS] Problem getting mysqldump on Centos 5.x server Hi Bruce >From your message I am assuming that either you installed MySQL >yourself or had some do it for you? Is the mysql data

Re: [CentOS] Problem getting mysqldump on Centos 5.x server

2013-04-23 Thread Clint Dilks
On Wed, Apr 24, 2013 at 1:56 PM, Michael Mol wrote: > On 04/23/2013 09:42 PM, Clint Dilks wrote: > > Hi Bruce > > > >>From your message I am assuming that either you installed MySQL yourself > or > > had some do it for you? > > > > Is the mysql database currently running? If not it should be. >

Re: [CentOS] Problem getting mysqldump on Centos 5.x server

2013-04-23 Thread Michael Mol
On 04/23/2013 09:42 PM, Clint Dilks wrote: > Hi Bruce > >>From your message I am assuming that either you installed MySQL yourself or > had some do it for you? > > Is the mysql database currently running? If not it should be. > Are you able to access the database using the command line tools ?

Re: [CentOS] Problem getting mysqldump on Centos 5.x server

2013-04-23 Thread Clint Dilks
Hi Bruce >From your message I am assuming that either you installed MySQL yourself or had some do it for you? Is the mysql database currently running? If not it should be. Are you able to access the database using the command line tools ? From the machine its currently running on try mysql -p

[CentOS] Problem getting mysqldump on Centos 5.x server

2013-04-23 Thread Bruce Whealton
Hello all, I have a dedicated hosting account that I am closing down but I am having problems getting an access denied error when I run the mysqldump command from the ssh prompt, logged in as root. So, the hosting provider, who saw the same error, reported, " Hence, we would suggest you di