PDA

View Full Version : [ubuntu] Mysql backup



vksingh
October 14th, 2009, 03:43 PM
Hi,

Can some body tell how to backup mysql data base?

Thanks,

Vivek

DaithiF
October 14th, 2009, 03:48 PM
use mysqldump
example usage:

mysqldump -h host -u user -ppassword --databases database1 database2 > mysqlbackup.bak

vksingh
October 14th, 2009, 08:23 PM
How to create database files at given location?

Thanks,

Vivek

DaithiF
October 14th, 2009, 09:18 PM
what do you mean -- create a backup of a single database at a certain location?

mysqldump -h host -u user -ppassword --databases databasename > /path/to/yourbackup.bak
or just:

mysqldump -h host -u user -ppassword databasename > /path/to/yourbackup.bak