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
Featured Articles:
- 30 Handy Bash Shell Aliases For Linux / Unix / Mac OS X
- Top 30 Nmap Command Examples For Sys/Network Admins
- 25 PHP Security Best Practices For Sys Admins
- 20 Linux System Monitoring Tools Every SysAdmin Should Know
- 20 Linux Server Hardening Security Tips
- Linux: 20 Iptables Examples For New SysAdmins
- Top 20 OpenSSH Server Best Security Practices
- Top 20 Nginx WebServer Best Security Practices
- 20 Examples: Make Sure Unix / Linux Configuration Files Are Free From Syntax Errors
- 15 Greatest Open Source Terminal Applications Of 2012
- My 10 UNIX Command Line Mistakes
- Top 10 Open Source Web-Based Project Management Software
- Top 5 Email Client For Linux, Mac OS X, and Windows Users
- The Novice Guide To Buying A Linux Laptop
{ 2 comments… read them below or add one }
mysql> quite;should be:
mysql> quit;(without the e)thanks for the heads up.