At 17:16 03/07/2001 +0800, tpchan 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.
I recommend to you the 3 option.
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
>Dear all,
>
>Did anyone now how to make symbolic link for mysql data directory under
>Windows NT 4.0. Mysql data directory sits on C:\mysql\data\ecom and I would
>like to transfer it to D:\ecom. My Mysql version is 3.23.32, installed using
>the '.exe' file.
>
>I would like to know if this is possible? If so, how?
>
>Thank you in advance.
>
>Emanduel Chan Tain Por
>System Engineer
>DotCom Consulting Sdn Bhd
>DID : 603-62763230 ext. 112
>
>
>---------------------------------------------------------------------
>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
