How to Backup and Restore MySQL Database Command Line Windows

How to Backup and Restore MySQL Database Command Line Windows

If you want to keep your database secure and safe, then you have to back it up from time to time. And it is also true that there should always be a backup of the data. If ever there is an attack on the server. Or if the data is lost by mistake, then you can use your old backup.

In this tutorial, you will learn how to take backup and restore mysql database using command line or command prompt in windows.

How to Backup and Restore MySQL Database Command Line Windows

  • Backup MySQL Database from Command Line Windows
    • Step 1: Open Command Prompt
    • Step 2: Navigate to MySQL Bin Directory
    • Step 3: Run the mysqldump command
  • Restore MySQL Database from Command Line Windows
    • Step 1: Open Command Prompt
    • Step 2: Navigate to MySQL Bin Directory
    • Step 3: Create the Database
    • Step 4: Restore the Database

Backup MySQL Database from Command Line Windows

By using these steps, you can take backup MySQL database from command line or command prompt in windows:

Step 1: Open Command Prompt

To start the backup mysql database process, So, press the “Windows key” + “R” and type “cmd” in the Run dialog box, then press Enter to open the Command Prompt:

Step 2: Navigate to MySQL Bin Directory

Now, execute the following command on command prompt to navigate to the MySQL bin directory:

cd C:\Program Files\MySQL\MySQL Server 8.0\bin

Note that:- Replace the path with the location where you have installed MySQL into your server.

Step 3: Run the mysqldump command

Execute the following mysqldump command on command prompt to backup the MySQL database:

mysqldump -u username -p database_name > C:\backup\database_name.sql

Before execute the above given command, please replace to followings:

  • “username” with your MySQL username,
  • “database_name” with the name of the database you want to backup
  • “C:\backup\database_name.sql” with the path where you want to save the backup file

Once you run this command, the MySQL database backup will be saved in the same directory as the MySQL bin folder.

Restore MySQL Database from Command Line Windows

By using these steps, you can take restore MySQL database from command line or command prompt in windows:

Step 1: Open Command Prompt

To start the restore mysql database process, So, press the “Windows key” + “R” and type “cmd” in the Run dialog box, then press Enter to open the Command Prompt:

Step 2: Navigate to MySQL Bin Directory

Now, execute the following command on command prompt to navigate to the MySQL bin directory:

cd C:\Program Files\MySQL\MySQL Server 8.0\bin

Note that:- Replace the path with the location where you have installed MySQL into your server.

Step 3: Create the Database

If you do not have a database. Then execute the following command on command prompt to create a database:

mysql -u username -p -e "CREATE DATABASE database_name;"

Step 4: Restore the Database

To restore a MySQL database, execute the following command on command prompt to restore the MySQL database:

mysql -u username -p database_name < backup_file.sql

Before execute the above given command, please replace to followings:

  • “username” with your MySQL username
  • “database_name” with the name of the database you want to restore
  • “backup_file.sql” with the name of the backup file

Once you run this command, the MySQL database will be restored from the backup file.

Conclusion

Backing up and restoring MySQL databases from the command line in Windows is a simple and effective way to protect your data and ensure business continuity. By following the steps outlined in this tutorial, you can create backups and restore MySQL databases with ease. Remember to schedule regular backups to ensure that you always have a recent and reliable copy of your data.

AuthorAdmin

My name is Devendra Dode. I am a full-stack developer, entrepreneur, and owner of Tutsmake.com. I like writing tutorials and tips that can help other developers. I share tutorials of PHP, Python, Javascript, JQuery, Laravel, Livewire, Codeigniter, Node JS, Express JS, Vue JS, Angular JS, React Js, MySQL, MongoDB, REST APIs, Windows, Xampp, Linux, Ubuntu, Amazon AWS, Composer, SEO, WordPress, SSL and Bootstrap from a starting stage. As well as demo example.

Leave a Reply

Your email address will not be published. Required fields are marked *