[mysql@master ~]$ mysqlhotcopy test /tmp
DBI connect(';host=localhost;mysql_read_default_group=mysqlhotcopy','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at
/usr/local/mysql5.6/bin/mysqlhotcopy line 197
[mysql@master lib]$ ls /var/lib/mysql/mysql.sock
ls: cannot access /var/lib/mysql/mysql.sock: No such file or directory
[mysql@master lib]$ ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
[mysql@master lib]$ mysqlhotcopy test /tmp
Flushed 3 tables with read lock (`test`.`students`, `test`.`t1`, `test`.`t2`) in 0 seconds.
Locked 0 views () in 0 seconds.
Copying 8 files...
Copying indices for 0 files...
U
mysqlhotcopy 只能用于MyISAM表不能用户InnoDB表
最新推荐文章于 2024-04-19 13:25:40 发布
MySQLhotcopy 是一个用于快速备份MyISAM表的工具,但不支持InnoDB表。在使用过程中,若出现无法连接到MySQL服务器的问题,可能是因为缺少socket文件。通过创建符号链接可以解决此问题。备份过程包括锁定表、复制文件和解锁表,能够高效地备份多个MyISAM表。
摘要由CSDN通过智能技术生成