LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   mysql reinstallation distorted by previous tables in /var/mysql (http://www.linuxquestions.org/questions/linux-software-2/mysql-reinstallation-distorted-by-previous-tables-in-var-mysql-369738/)

mad4linux 10-04-2005 02:39 PM

mysql reinstallation distorted by previous tables in /var/mysql
 
I got a hard disk black out during summer and had to replace my secondary hard disk. Therefore, i just was able to save my data in /home /var and /srv using a livesystem running from cd.

After reinstallation of a linux system (suse 9.3) and mysql, i have the following problem:
I just have my old mysql-tables as files in /var/lib/mysql. No backup (dump) or anything done. If i try to copy the old file to the new /var/lib/mysql, mysqld doesn't even start. So i guess, that i have to start from a clear /var/lib/mysql directory?

But how can i get my tables up afterwards since mysql_dump does not work for my old tables?

Can i just copy the tables to var/lib/mysql, leaving /var/lib/mysql/mysql/ empty and import the table data somehow from my table dirs in /var/lib/mysql?

Any advice is greatly appreciated.


All times are GMT -5. The time now is 05:56 AM.