• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

rescuing database from MySql data folder

 
miguel lisboa
Ranch Hand
Posts: 1281
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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...
 
Paul Clapham
Sheriff
Posts: 21416
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1281
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 50172
79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well done
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic