Wednesday, 22 October 2014
MySQL database backup and restore
Backup commandline
mysqldump -u root -p dbtobackup >dbtobackup.sql
Restore commandline
mysqldump -u root -p dbtobackup >dbtobackup.sql
Restore commandline
- Log into mysql
- Create database
- Use database
- Source dbtorestore.sql
Subscribe to:
Comments (Atom)