Wednesday, 22 October 2014

MySQL database backup and restore

Backup commandline

mysqldump -u root -p dbtobackup >dbtobackup.sql

Restore commandline

  • Log into mysql
  • Create database
  • Use database
  • Source dbtorestore.sql

No comments: