Friday, January 30, 2009

HOWTO Backup some database - MYSQL

HOWTO Backup some database - MYSQL

1.- We are going to backup db "somedb" into "db_Bkp" located in "backups_DB" directory

root@server:/# cd /var/www/backups_DB
root@server:/var/www/backups_DB# mysqldump -l --add-drop-table somedb > db_Bkp -uroot -pRootPasswd


No comments:

Post a Comment