≡ Menu

mysql command line

MySQL/MariaDB: Run SQL Queries From A Shell Prompt / Command Line

How do I specify or run MySQL or MariaDB SQL queries on the UNIX or Linux command line?
[click to continue…]

Restore a backup of a MySQL Database Server

Q. How can I restore a backup of a MySQL database server made with mysqldump program discussed here?

A. You can use standard mysql - the MySQL command-line tool to restore a backup of a MySQL database server.

Read back dump file

You can read the dump file back into the server like this:
mysql db-name < backup-file.sql To restore database called sales, first create the database sales: $ mysql -u root -p
Now create database called sales using SQL statement:

mysql> CREATE DATABASE sales;
mysql> quit;

Now restore database, enter:
$ mysql -u root -p sales < /path/to/sales-backup-file.sql