我遇到了一个很头疼的问题,请大家帮看看。
我将A服务器数据库文件存到我的移硬盘里,然后在A服务器的MYSQL里使用 “符号连接” 方式连接到数据库库。是好用的哦
然后呢。我在B服务器上也是这么做,B服务器可以找到数据库,可以显示出所有,可是一双击表就显示 1146错误,找不到表。
请问这是什么问题呢?
附符号链接原文档:
2.6.2.5 Splitting Data Across Different Disks on Windows Beginning with MySQL Version 3.23.16, the mysqld-max and mysql-max-nt servers in the MySQL distribution are compiled with the -DUSE_SYMDIR option. This allows you to put a database on different disk by adding a symbolic link to it (in a manner similar to the way that symbolic links work on Unix). On Windows, you make a symbolic link to a database by creating a file that contains the path to the destination directory and saving this in the mysql_data' directory under the filename
database.sym'. Note that the symbolic link will be used only if the directory mysql_data_dir\database' doesn't exist. For example, if the MySQL data directory is
C:mysqldata' and you want to have database foo located at D:\data\foo', you should create the file
C:mysqldatafoo.sym' that contains the text D:datafoo. After that, all tables created in the database foo will be created in D:\data\foo'. Note that because of the speed penalty you get when opening every table, we have not enabled this by default even if you have compiled MySQL with support for this. To enable symlinks you should put in your
my.cnf' or `my.ini' file the following entry: [mysqld]use-symbolic-links In MySQL 4.0 we will enable symlinks by default. Then you should instead use the skip-symlink
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。