aspose file tools*
The moose likes JDBC 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
Bookmark "rescuing database from MySql data folder" Watch "rescuing database from MySql data folder" New topic
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: 18570
    
    8

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: 38851
    
  23
Well done
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: rescuing database from MySql data folder