Backup MySQL Database using mysqldump

One of the most common ways to backup MySQL database is to use a command called “mysqldump“.

Backing Up

The basic syntax of the command to backup mysql with mysqldump is:

mysqldump -u your_username -p database_to_backup > backup_file_name.sql

Restoring Dumped Data

To restore a database backup we created with mysqldump, we have to point the file into MySQL again.

First, log into MySQL by typing:

mysql -u your_username -p

Second, we need to create a blank database to restore the data into. The command below create a new database which will hold all of the data that will dumped and then exit out of the MySQL prompt:

CREATE DATABASE new_database_name;
exit

Next, we can restore the dump database file into the newly created database by using the command below:

mysql -u username -p database_name < backup_file_name.sql

You should have all your information restored to the database you’ve created.

How to Reset MySql Root password on MacOS 10.13

 Image source: Kinamo
People reacted to this story.
Show comments Hide comments
Comments to: How to Backup MySQL Database using mysqldump
  • August 22, 2018

    […] MySQL root password allows the root user to have full access to the MySQL database. You must have (Linux) root administrator access to the server to reset MySQL root password. Use […]

    Reply
Write a response

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

Attach images - Only PNG, JPG, JPEG and GIF are supported.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Login

Welcome to Typer

Brief and amiable onboarding is the first thing a new user sees in the theme.
Join Typer
Registration is closed.
%d bloggers like this: