且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

将MySQL数据库复制到另一台机器

更新时间:2023-02-02 16:48:55

在sql文件中导出DB Mysqldump,并将sql文件复制到 USB卡导入到其他机器。按照步骤,它将帮助您实现

Make a export DB Mysqldump in a sql file and copy the sql file to USB card and import it into the other machine.Follow the steps it would help you to achieve it

要使 mysql dump 以供参考 see here
示例:

To make mysql dump for reference see here Sample:

mysqldump -u admin -p passwd DB_Name > file/path/filename.sql

import sql 文件替换为 mysql DB

  mysql > use DB_Name;
  mysql >source yourfile.sql

(或)

  mysql -u USERNAME -p PASSWORD DATABASE-NAME < file/path/filename.sql

如果错误,请更正我