copy sql?

Posted by Calibaba, 01-11-2008, 05:08 PM
Quick question. How do I copy an entire mysql sql database file via ssh? Inside /var/lib/mysql the sql are per table, not one single sql. The db is over 300mb in size too. Using mysql 5 / centos 4.6
Posted by bitserve, 01-11-2008, 06:47 PM
http://dev.mysql.com/doc/refman/5.0/en/backup.html
Posted by david510, 01-14-2008, 06:26 AM
You need to copy the entire directory /var/lib/mysql/databasename/ ?

Was this answer helpful?

 Print this Article

Also Read

Box Overloading

Posted by SuperHosterz, 01-13-2008, 11:56 AMI've 50 sites hosted on server all are small sites,...

How to: secure yourself with (( cgitelnet.pl ))

Posted by X-x-X, 05-04-2007, 09:39 PMIt’s very important thing [URL removed] A hacker use...

I have a WHM/cPanel server shared server...

Posted by MightWeb-Greg, 04-21-2009, 06:45 PMI just had user KILL the server using 80% CPU and...

enabling shell_exec() for some user

Posted by dendis, 03-26-2008, 08:24 PMHi all, I need to run one PHP script from crontab as...

Wordpress Theme Development

Posted by phpforum, 10-16-2012, 03:30 AMI have a design and an HTML file. How can I convert it to...