restore mysql database from [Program Files]
-
Hi, I had mysql installed on my laptop (Windows Vista) but my operating system got corrupted and i had to remove the hard disk and use it as external hard disk. so currently i have access to the laptop when i connect as external hard disk and the I can go to the Program Files\Mysql folder just like any folder in my external hard. Now I want to know how can I restore-re-create the database on my new machine using the files of the mysql available on my external hard disk (which use to be my laptop hard disk)? Thanks, Jassim
-
Hi, I had mysql installed on my laptop (Windows Vista) but my operating system got corrupted and i had to remove the hard disk and use it as external hard disk. so currently i have access to the laptop when i connect as external hard disk and the I can go to the Program Files\Mysql folder just like any folder in my external hard. Now I want to know how can I restore-re-create the database on my new machine using the files of the mysql available on my external hard disk (which use to be my laptop hard disk)? Thanks, Jassim
-
Change my.ini to point to the correct datadir and restart MySql. Where's your backup? Precisely, and that's why you need one. Store it on a USB-key and keep it under your pillow when you go to sleep :)
Bastard Programmer from Hell :suss:
I know! it's a big mistake not to take a backup :) huhuhu :) listen.... I tried but mysql services was failing to start..
datadir="F:/ProgramData/MySQL/MySQL Server 5.5/Data/"
then I tried putting it in a folder within the new machine with no2 like this:
datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data2/"
and still the same problem.. then I tried to copy the folders for the dbxxx (my database) in the C:/ProgramData/MySQL/MySQL Server 5.5/Data and I got it in the list but i am getting: 1146 Table dosen't exist for every table when i try to open it.. what should I do now?
-
I know! it's a big mistake not to take a backup :) huhuhu :) listen.... I tried but mysql services was failing to start..
datadir="F:/ProgramData/MySQL/MySQL Server 5.5/Data/"
then I tried putting it in a folder within the new machine with no2 like this:
datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data2/"
and still the same problem.. then I tried to copy the folders for the dbxxx (my database) in the C:/ProgramData/MySQL/MySQL Server 5.5/Data and I got it in the list but i am getting: 1146 Table dosen't exist for every table when i try to open it.. what should I do now?
this is the error when I tried to start mysql services in the first scenario.. The MySQL service terminated unexpectedly.
-
I know! it's a big mistake not to take a backup :) huhuhu :) listen.... I tried but mysql services was failing to start..
datadir="F:/ProgramData/MySQL/MySQL Server 5.5/Data/"
then I tried putting it in a folder within the new machine with no2 like this:
datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data2/"
and still the same problem.. then I tried to copy the folders for the dbxxx (my database) in the C:/ProgramData/MySQL/MySQL Server 5.5/Data and I got it in the list but i am getting: 1146 Table dosen't exist for every table when i try to open it.. what should I do now?
-
Sounds like the database-file is corrupt. Did it die during a write?
jrahma wrote:
what should I do now?
Google for "repair corrupt MySQL" and try everything you find.
Bastard Programmer from Hell :suss:
no it dies during laptop booting only even before windows starts its booting