mysql

mySQL

Submitted by hans
on Sat, 04/02/2011 - 10:08

Dump all databases

MySQL :: MySQL 5.0 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program

You can dump all databases by:

# mysqldump [options] --all-databases An example would be:

# mysqldump -u root -p --all-databases > all_dbs.sql If you just want to dump several databases into one file: # mysqldump [options] --databases db_name1 [db_name2 db_name3...]

An example would be:

Tags: 
mysql
Powered by Drupal