Bug #49731 Creating sym file for mysql

• Submitted: 16 Dec 2009 6:48
• Modified: 16 Dec 2009 12:18
• Reporter: Venkatranman Guruswamy
• Status: Can't repeat
• Category: MySQL Server
• Severity: S5 (Performance)
• Version: 5.0
• OS: Windows (XP)
• CPU Architecture: Any

[16 Dec 2009 6:48] Venkatranman Guruswamy

Description:
I have a database named mydb and I wish that one to be in E:/
So I Created a mydb.sym which has the following info
datadir="E:/mydb"
But this one is not working...
Could some one explain how to give the data on to the sym file

How to repeat:
Could some one explain how to give the data on to the sym file

Suggested fix:
Could some help me to fix this bug...

[16 Dec 2009 12:18] MySQL Verification Team

Thank you for the bug report. I couldn't repeat the reported behavior, please read the Manual:

http://dev.mysql.com/doc/refman/5.0/en/windows-symbolic-links.html

Microsoft Windows [versão 6.0.6001]
Copyright (c) 2006 Microsoft Corporation. Todos os direitos reservados.

C:\DBS>mkdir e:\mydb

C:\DBS>type 5.0\data\mydb.sym
E:\mydb
C:\DBS>50

C:\DBS>c:\dbs\5.0\bin\mysql -uroot --port=3500 --prompt="mysql 5.0 > "
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.90-Win X64-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 5.0 > use mydb
Database changed
mysql 5.0 > create table mydbtable(id serial);
Query OK, 0 rows affected (0.08 sec)

mysql 5.0 > show tables;
+----------------+
| Tables_in_mydb |
+----------------+
| mydbtable      |
+----------------+
1 row in set (0.04 sec)

mysql 5.0 > exit
Bye

C:\DBS>dir e:\mydb
 O volume na unidade E é excel
 O Número de Série do Volume é 14F1-6827

 Pasta de e:\mydb

16/12/2009  10:16    <DIR>          .
16/12/2009  10:16    <DIR>          ..
16/12/2009  10:16             8.556 mydbtable.frm
16/12/2009  10:16                 0 mydbtable.MYD
16/12/2009  10:16             1.024 mydbtable.MYI
               3 arquivo(s)          9.580 bytes
               2 pasta(s)   123.898.384.384 bytes disponíveis

C:\DBS>