At 10:42 AM 5/21/2010, you wrote:
Dear sirs,
Accidentally files in a database have been deleted (/ var/lib/mysql
/"database") when entering the mysql console shows that the database is
created but does not show any table, there is some method to recever the
information in this database?
You need to restore your database data directory from backup. You could try
to undelete the files in the data directory but that may not recover all of
the data since the tables may have been open when the files were erased.
Before restoring the files from your backup, make sure you either flush the
tables or shutdown the mysql server.
Mike
Centos 4.6
mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i686) using readline
4.3
Thanks
Jose Luis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
