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...
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.
Joined: Feb 08, 2004
i borrowed this laptop, installed MySql4, droped this folder, made a database backup, imported it to my pc and all went fine