How to Backup and Restore MySQL Databases
Quick Links: Video Guide
Step-by-Step Guide
This video shows how to backup and restore a MySQL database from the command line
Video Guide
Step-by-Step Guide
1.) If you need to reference the database name, open the MySQL Command Line Client and type – show databases;
2.) Open the Windows command prompt and navigate to the MySQL installation folder that contacts the following executable files:
– mysqldump.exe
– mysql.exe
3.) To backup the database, type the following – mysqldump -u username -p databasename > path\backupfilename.sql
4.) To restore the database, type the following – mysql -u username -p databasename < path\backupfilename.sql
Note: If the database you are restoring no longer exists, you need to recreate it by typing the following into the MySQL Command Line – create database databasename;
5.) To confirm, open the MySQL Command Line Client and type – use databasename, and then type – show tables;
6.) Confirm that the tables match up
Did you find this page helpful?
PID: 20180503-00001