MySQL Full Backup and Restore

From FiberWiki

Jump to: navigation, search

MySQL Full Backup and Restore

This guide is for users doing a full backup via command line. 

BACKUP
mysqldump -u root -p --all-databases > alldatabases.sql
RESTORE
mysql -u root -p < alldatabases.sql

It's as easy as that!

If you don't remember your MySQL root password click here.

Retrieved from "http://wiki.fiber-hosting.com/MySQL_Full_Backup_and_Restore"
Personal tools
Navigation