my dog learned polymorphism
The moose likes JDBC and Relational Databases and the fly likes rescuing database from MySql data folder Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "rescuing database from MySql data folder" Watch "rescuing database from MySql data folder" New topic

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

Joined: Oct 14, 2005
Posts: 19973

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

Joined: Oct 13, 2005
Posts: 46320
Well done
I agree. Here's the link:
subject: rescuing database from MySql data folder
It's not a secret anymore!