Home >Database >Mysql Tutorial >MySQL在Windows和Linux些还原数据库_MySQL
MySQL在Windows和Linux些还原数据库_MySQL
- WBOYOriginal
- 2016-05-31 08:48:341098browse
Linux下还原数据库代码:
1,创建一个空的数据库cddl
mysql> create database cddl;
Query OK, 1 row affected (0.00 sec)
2,还原数据库
[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
Warning: Using a password on the command line interface can be insecure.
Windows下还原数据库代码:
1,创建一个空的数据库mydb
2,run-->cmd->cd C:/Program Files/MySQL/MySQL Server 5.5/bin
3,mysql -h 192.168.92.100 -uroot -ppassword mydb
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysqldump的使用_MySQLNext article：Mysql User-Defined Variables 用户自定义变量 SET or DECLARE_MySQL