MySQL restores a database in Windows and Linux

Restore database code in Linux:

1. Create an empty database cddl
Mysql> create database cddl;
Query OK, 1 row affected (0.00 sec)

2. Restore the database
[Root @ chicago mysqlsoftware] # cd/etc/rc. d/init. d
[Root @ chicago mysqlsoftware] # cd/etc/rc. d/init. d
[Root @ chicago init. d] # mysql-h 192.168.92.100-uroot-ppassword cddl </mysqlsoftware/cddl20140703. SQL
Warning: Using a password on the command line interface can be insecure.

 

Database restoration code in Windows:

1. Create an empty database mydb
2. run --> cmd-> cd C: \ Program Files \ MySQL Server 5.5 \ bin
3. mysql-h 192.168.92.100-uroot-ppassword mydb <d: \ cddl20140703. SQL