Archive for the ‘MySQL’ Category.

MySQL DUMP

September 3, 2008, 2:27 pm

Reading time: < 1 minute

Command to backup all the MySQL database in single shot is ,

$mysqldump -u root -p --all-databases > alldatabases.sql

Command to restore the MySQL database is ,

( Please make sure that you have database created before you can restore the data )

$mysql -u root -p database_to_restore < alldatabases.sql

  • Share/Bookmark
Category: MySQL  |  Comment