Hi all

i am running a mysql database(free version ) which came with centOS. and due to HDD error the i am unable to boot the machine. i need the data which there in the mysql server.

i have check the filesystem by attaching it to another machine. the filesystem which is having mysql is intact. could anyone let me know how i can i export or move the mysql data to new system.

thanks in advance
nrao

Hi,
suppose your database name is "abc" in your old machine then
goto /var/lib/mysql folder, you will see folder name same as your database in our case "abc"

just copy that folder from your old machine to new one in /var/lib/mysql folder
and restart the mysql server

then
mysql -u root -p

mysql>show databases;
you will see your database along with data

mysql> show tables;