Bug #49731 Creating sym file for mysql
Submitted: 16 Dec 2009 6:48 Modified: 16 Dec 2009 12:18
Reporter: Venkatranman Guruswamy Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server Severity:S5 (Performance)
Version:5.0 OS:Windows (XP)
Assigned to: CPU Architecture:Any

[16 Dec 2009 6:48] Venkatranman Guruswamy
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
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:


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

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

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