关于数据备份与导入
备份
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\export]
@="URL:export Protocol"
"URL Protocol"=""
[HKEY_CLASSES_ROOT\export\DefaultIcon]
@="cmd.exe,1"
[HKEY_CLASSES_ROOT\export\shell]
[HKEY_CLASSES_ROOT\export\shell\open]
[HKEY_CLASSES_ROOT\export\shell\open\command]
@="cmd.exe /c mysqldump -u用户名 -p密码 effort1 > D:/effort.sql"
导入
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\import]
@="URL:import Protocol"
"URL Protocol"=""
[HKEY_CLASSES_ROOT\import\DefaultIcon]
@="cmd.exe,1"
[HKEY_CLASSES_ROOT\import\shell]
[HKEY_CLASSES_ROOT\import\shell\open]
[HKEY_CLASSES_ROOT\import\shell\open\command]
@="cmd.exe /c mysql -u用户名 -p密码 effort1 < D:/effort.sql"
导入过程可能遇到的问题:
导入sql过大:解决方案
https://blog.youkuaiyun.com/IPROMISE_LX/article/details/105472922
https://www.cnblogs.com/linuxk/p/9371475.html