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

2013-04-24 Thread Bruce Whealton
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 database currently running

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

2013-04-24 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 mysqldump

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 br...@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

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

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 eero.voloti...@iki.fi

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 Les Mikesell
On Wed, Apr 24, 2013 at 2:06 PM, Bruce Whealton br...@futurewaveonline.com 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

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

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 ? From

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 mike...@gmail.com 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.