mysql 符号链接方式连接数据 1146了。

小桦 发布于 2012/09/25 10:53
阅读 787
收藏 1


我将A服务器数据库文件存到我的移硬盘里,然后在A服务器的MYSQL里使用 “符号连接” 方式连接到数据库库。是好用的哦

然后呢。我在B服务器上也是这么做,B服务器可以找到数据库,可以显示出所有,可是一双击表就显示 1146错误,找不到表。



附符号链接原文档 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:\mysql\data' and you want to have database foo located at `D:\data\foo', you should create the file `C:\mysql\data\foo.sym' that contains the text D:\data\foo\. 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: 


In MySQL 4.0 we will enable symlinks by default. Then you should instead use the skip-symlink option if you want to disable this.