Sorry to post again, i've simply forgot to give some details :
mysql show databases;
+--+
| Database
+--+
| mysql
| test
+--+
2 rows in set (0.00 sec)
However, i still have databases files present on the system :
syst@datasrv:/var/mysql$ ls -al
total 40
drwxr-xr-x8 mysqlmysql4096 Dec 23 10:55 .
drwxr-xr-x 17 root root 4096 Oct 9 08:33 ..
drwx--2 mysqlmysql4096 Dec 23 10:02 SDD
drwx--2 mysqlmysql4096 Dec 23 10:01 cnam
-rw-rw1 mysqlmysql2767 Dec 26 14:03 connections.log
-rw-r--r--1 mysqlmysql 781 Oct 7 15:33 datasrv.err
drwx--2 mysqlmysql4096 Sep 30 16:56 menagerie
drwx--2 mysqlmysql4096 Dec 23 10:04 mysql
drwxr-xr--2 root mysql4096 Sep 12 14:43 test
drwx--2 mysqlmysql4096 Dec 23 10:06 tiatest
and all files are present in subdir, for exemple
datasrv:/var/mysql# ls -al SDD
total 224
drwx--2 mysqlmysql4096 Dec 23 10:02 .
drwxr-xr-x8 mysqlmysql4096 Dec 23 10:55 ..
-rw-rw1 mysqlmysql2424 Dec 23 10:02 depl_mep.MYD
-rw-rw1 mysqlmysql2048 Dec 23 10:02 depl_mep.MYI
-rw-rw1 mysqlmysql9226 Oct 9 18:06 depl_mep.frm
-rw-rw1 mysqlmysql 14832 Dec 23 10:02 etat_pc.MYD
-rw-rw1 mysqlmysql 13312 Dec 23 10:02 etat_pc.MYI
-rw-rw1 mysqlmysql8688 Oct 11 11:50 etat_pc.frm
-rw-rw1 mysqlmysql 99092 Dec 23 10:02 liste_pc.MYD
-rw-rw1 mysqlmysql 19456 Dec 23 10:02 liste_pc.MYI
-rw-rw1 mysqlmysql8881 Oct 9 17:55 liste_pc.frm
-rw-rw1 mysqlmysql 0 Dec 23 10:02 temp.MYD
-rw-rw1 mysqlmysql1024 Dec 23 10:02 temp.MYI
-rw-rw1 mysqlmysql8604 Oct 9 17:55 temp.frm
So, if anyone can tell me why mysql doesn't see all thoses databases
anymore,
it woud be great.
Tank's in advance.
Vincent
__
Hello all,
I'm quite newbie with MySql, so i apologize if this is a trivial question.
I did a small database, but fortunately not yet in production.
This Week-End happened a power cut and I didn't made any backup of my
databases :(
When i restarted Mysql, i could not log in as any user i allowed before.
I had to log on as root, and i saw the user table was empty (only the root
user and an empty user).
the SHOW databases tell me only about the mysql and test one. None of mines
appears.
I then re-created one user, and then quit mysql to check all databases with
myisamchk.
it then successfully recovers all *.MYI
However, when restarting mysql, it didn't so much more databases.
I don't know if i'm clear enought, but if anybody could help me recover my
databases, this vould be great.
Thanks a lot
Vincent
-
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
