mysql5.6的data移动到5.7的data怎么不能用

发布网友发布时间：2022-05-01 09:30

共3个回答

懂视网时间：2022-05-01 13:52

help", "copyright", "credits" or "license" for more information. >>> import MySQLdb Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/usr/local/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 19, in <module> import _mysql

报错信息2

shufeng@shufeng-H97-D3H:/etc/mysql$ pip uninstall MySQL-python^C
shufeng@shufeng-H97-D3H:/etc/mysql$ pip install MySQL-python
Collecting MySQL-python
 Using cached MySQL-python-1.2.5.zip
 Complete output from command python setup.py egg_info:
 sh: 1: mysql_config: not found
 Traceback (most recent call last):
 File "<string>", line 1, in <module>
 File "/tmp/pip-build-YdPi5P/MySQL-python/setup.py", line 17, in <module>
 metadata, options = get_config()
 File "setup_posix.py", line 43, in get_config
 libs = mysql_config("libs_r")
 File "setup_posix.py", line 25, in mysql_config
 raise EnvironmentError("%s not found" % (mysql_config.path,))
 EnvironmentError: mysql_config not found
 
 ----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-YdPi5P/MySQL-python/

解决方法：

$ sudo pip uninstall MySQL-python
$ sudo apt-get install libmysqlclient-dev
$ sudo pip install MySQL-python

Mysql5.5升级到5.7后MySQLdb不能正常使用的问题解决

标签：

热心网友时间：2022-05-01 11:00

mysql5.6的data移动到5.7的data怎么不能用
使用命令行当然慢了，直接使用工具即可。使用sqlyog这个工具。用法如下先用sqlyog连接上两个库，在目标库上提前建立好数据库。右击源库，选择复制数据到其他主机(差不多这么写的)，然后弹出的界面是左边是源库，右边你选择目标库。

热心网友时间：2022-05-01 12:18

微波炉用具，