At 12:10 05/07/2001 +0800, Jaime Teng wrote:
Hi,
You can simulate the symbolic link on Windows using the today
Win32 MySQL 3.23.39 distribution.
You have in this distribution the following Max MySQL servers:
1- mysqld.exe the debug version.
2- mysqld-max.exe the optimized version for Win9x and NT/Win2k.
3- mysqld-max-nt.exe the optimized version for NT/Win2k with
support for named pipes.
The Max stuff besides the support of symbolic links has the support
of transactional tables InnoDB and BDB.
Below the instructions how to use the symbolic link. Notice if you
don't want the support of InnoDB and BDB tables un comment the variables
skip-innodb and skip-bdb. Otherwise read the item 8.7.2 InnoDB startup
options of the \mysql\docs\Manual.html.
1- Create the configuration file c:\my.cnf or \windir\my.ini.file.
2- Edit the configuration file:
[mysqld]
basedir=c:/mysql
datadir=c:/mysql/data
use-symbolic-links
#skip-innodb
#skip-bdb
Notice that in the sample above, you have the grant tables on
c:\mysql\data. If you want to have all the databases on d:\ecom, so you
don't need to use symbolic link, you only need to move the all
c:\mysql\data\mysql directory to d:\ecom\mysql and modify the
variable datadir=d:/ecom.
Now assuming that you want a database called mylink on d:\ecom.
First create on c:\mysql\data directory a file called mylink.sym.
Edit this file with the text: d:\ecom\mylink
Create the directory d:\ecom\mylink
Regards,
Miguel
>Hi,
>
>I have mysql on NT4 (soon to be win2000). one question is that the
>database files all reside under drive c. NT does not have symbolic link....
>
>is there a way to tell mysql that a particular database is located on
>a different folder? where is the documentation for this one?
>
>jaime
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Miguel A. Sol�rzano <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - S�o Paulo, Brazil
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
