• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Rob Spoor
  • Devaka Cooray
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Jj Roberts
  • Al Hobbs
  • Piet Souris

rescuing database from MySql data folder

 
Ranch Hand
Posts: 1282
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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...
 
Marshal
Posts: 26909
82
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 1282
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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!
 
Marshal
Posts: 74348
334
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Well done:)
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic