CS & IT Solutions

Computer Scientists and IT Professionals Weblog

MySQL Backup/Restore from command line March 7th, 2010

Backup

Dump ALL MySQL Databases

`1`	`mysqldump` `--user=XXXXXXXX --password=XXXXXXX -A > /PATH/TO/DUMPFILE.SQL`

Dump Individual or Multiple MySQL Databases

`1`	`mysqldump` `--user=XXXXXXXX --password=XXXXXXX DB_NAME1 DB_NAME2 DB_NAME3 > /PATH/TO/DUMPFILE.SQL`

Dump only certain tables from a MySQL Database

`1`	`mysqldump` `--user=XXXXXXXX --password=XXXXXXXX DB_NAME --tables TABLE_NAME > /PATH/TO/DUMPFILE.SQL`

Restore

`1`	`mysql` `--user=XXXXXXXX --password=XXXXXXXX DB_NAME < /PATH/TO/DUMPFILE.SQL`

source here

Tags: backup, CentOS, debian, dump, General, mysql, restore
This entry was posted on Sunday, March 7th, 2010 at 7:13 pm and is filed under CentOS, databases, debian, fedora, feebsd, linux, mysql, Networking, ubuntu. You can follow any responses to this entry through the RSS 2.0 feed.You can leave a response, or trackback from your own site.