首页 > 代码库 > mysql数据库数据备份与恢复
mysql数据库数据备份与恢复
备份数据：
C:\Users\Administrator>mysqldump -uroot --password -v test01 test02 >e:\temp\20170507\a3.sqlEnter password: ****-- Connecting to localhost...-- Retrieving table structure for table test02...-- Sending SELECT query...-- Retrieving rows...-- Disconnecting from localhost...
mysql> use test01;Database changedmysql> select * from test02 into outfile ‘e:\temp\20170507\a5.sql‘ -> ;ERROR 1 (HY000): Can‘t create/write to file ‘e: emp20170507a5.sql‘ (Errcode: 2 - No such file or directory)mysql> select * from test02 into outfile ‘e:/temp/20170507/a5.sql‘;Query OK, 8 rows affected (0.00 sec)
恢复数据：
使用load data方法
mysql> load data infile ‘e:/temp/20170507/a5.sql‘ into table test03;Query OK, 8 rows affected (0.03 sec)Records: 8 Deleted: 0 Skipped: 0 Warnings: 0
使用mysqlimport方法
C:\Users\Administrator>mysqlimport --user root --password -v test01 e:/temp/20170507/test03.sqlEnter password: ****Connecting to localhostSelecting database test01Loading data from SERVER file: e:/temp/20170507/test03.sql into test03test01.test03: Records: 8 Deleted: 0 Skipped: 0 Warnings: 0Disconnecting from localhost
mysql数据库数据备份与恢复
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。