| Author |
rescuing database from MySql data folder
|
miguel lisboa
Ranch Hand
Joined: Feb 08, 2004
Posts: 1281
|
|
several years ago i wrote a stand alone application using MySql 4
instead of backing up the database i copied the folder "data" from Mysql install folders, which i still have but cant open
nowadays i have instaled MySql version 5 and, when i was looking for a similar folder called "data", i noticed it does not exists in this 5 version
as i dont have the script document (i guess its called ddl) for creating the database and i cant remember how it was (from my application all i have is the jar), i wonder how i can rescue that database in MySql4 format and rebuilt it...
the data folder has a folder named the database i want to rescue, and inside has several files with frm extension - i 'm sure those are my my tables
hope i made myself clear
thanks in advance
note: i didnt install the 4 version of MySql because i'm afraid of possible incompatibilities with databases i nowadays need and use ... maybe i'm wrong...
|
java amateur
|
 |
Paul Clapham
Bartender
Joined: Oct 14, 2005
Posts: 16483
|
|
|
This sounds very much like a question about MySQL and not about JDBC at all. So you would be better off looking on MySQL's site for information. I'm sure it's something which is asked a lot over there and I'm sure if you search (for example) their FAQ section for the word "migration" you should come up with something.
|
 |
miguel lisboa
Ranch Hand
Joined: Feb 08, 2004
Posts: 1281
|
|
case solved
i borrowed this laptop, installed MySql4, droped this folder, made a database backup, imported it to my pc and all went fine
anyway thanks, bartender Paul!
|
 |
Campbell Ritchie
Sheriff
Joined: Oct 13, 2005
Posts: 32694
|
|
Well done
|
 |
 |
|
|
subject: rescuing database from MySql data folder
|
|
|