Backup Mysql DBs

Linux, mysql

Here you need to dump. To take one, use mysqldump.

mysqldump -u user -p --all-databases > mybackup.sql

To back up a few dbs and also all commands to delete existing tables ...

mysqldump -u user -p --add-drop-table --databases db1 db2

Comments powered by Disqus

Copyright 2010. All Rights Reserved.