
mysql数据库备份与恢复
备份(终端执行)格式:mysqldump -u root -p -B dbName > savePathmysqldump -u root -p -B test_db > db.sql恢复(mysql命令行执行)mysql> source db.sql

linux下出现bash: ***: command not found
问题bash: ls: command not foundPATH环境变量异常导致命令不可用,重新刷新下环境变量即可.解决export PATH=/bin:/usr/bin:$PAHT

Navicat链接:Client does not support authentication protocol requested by server;
解决 Navicat 客户端 无法连接 mysql 问题!