Home  >  Article  >  Database  >  MySQL在Windows和Linux些还原数据库_MySQL

MySQL在Windows和Linux些还原数据库_MySQL

WBOY
WBOYOriginal
2016-05-31 08:48:341058browse

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