DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) Windows symbolic links

Info Catalog (mysql.info.gz) Symbolic links to tables (mysql.info.gz) Symbolic links
 
 7.6.1.3 Using Symbolic Links for Databases on Windows
 .....................................................
 
 Beginning with MySQL 3.23.16, the `mysqld-max' and `mysql-max-nt'
 servers for Windows are compiled with the `-DUSE_SYMDIR' option.  This
 allows you to put a database directory on a different disk by setting
 up a symbolic link to it.  This is similar to the way that symbolic
 links work on Unix, although the procedure for setting up the link is
 different.
 
 As of MySQL 4.0, symbolic links are enabled by default. If you don't
 need them, you can disable them with the `skip-symbolic-links' option:
 
      [mysqld]
      skip-symbolic-links
 
 Before MySQL 4.0, symbolic links are disabled by default. To enable
 them, you should put the following entry in your `my.cnf' or `my.ini'
 file:
 
      [mysqld]
      symbolic-links
 
 On Windows, you make a symbolic link to a MySQL database by creating a
 file in the data directory that contains the path to the destination
 directory.  The file should be named `db_name.sym', where DB_NAME is the
 database name.
 
 Suppose that the MySQL data directory is `C:\mysql\data' and you want
 to have database `foo' located at `D:\data\foo'.  Set up a symlink like
 this:
 
   1. Make sure that the `D:\data\foo' directory exists by creating it if
      necessary.  If you have a database directory named `foo' in the
      data directory, you should move it to `D:\data'. Otherwise, the
      symbolic link will be ineffective.  To avoid problems, the server
      should not be running when you move the database directory.
 
   2. Create a file `C:\mysql\data\foo.sym' that contains the pathname
      `D:\data\foo\'.
 
 
 After that, all tables created in the database `foo' will be created in
 `D:\data\foo'.  Note that the symbolic link will not be used if a
 directory with the database name exists in the MySQL data directory.
 
Info Catalog (mysql.info.gz) Symbolic links to tables (mysql.info.gz) Symbolic links
automatically generated byinfo2html