Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 10-04-2008, 03:38 PM
Valcrist
Sarnak
 
Join Date: Aug 2006
Location: NJ
Posts: 85
Default Databse problems

Well, I have recently made a server, but we have scrapped it, I have gotten a database from a friend, and I am stumped on how to get .frm/.myi/.myd to convert to .sql, if any could help, would be appreciated greatly, thank you for your consideration of this problem
Reply With Quote
  #2  
Old 10-04-2008, 04:08 PM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default

On my Vista x64 box, MySQL databases are stored under:

Code:
C:\Program Files (x86)\MySQL\MySQL Server 5.0\data
E.g. I have a database called ykesha, and have various .frm/.MYD/.MYI files under

Code:
C:\Program Files (x86)\MySQL\MySQL Server 5.0\data\ykesha
I don't know if this will work (you should really transfer databases using mysqldump to a .sql file), but you could try and find where the MySQL databases are stored on your system, then create a directory and drop the .frm/.MYD/.MYI files in there.

E.g. using the paths on my system, I would try creating a directory:

Code:
C:\Program Files (x86)\MySQL\MySQL Server 5.0\data\eqdb
and dropping the files you have been given in there. You could then check if they are accessible by going into the MySQL command prompt and doing:

Code:
use eqdb;
show tables;
Just a guess, no idea if this will work.
Reply With Quote
  #3  
Old 10-04-2008, 10:10 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

If you create a new database then you can simply drop those in. It *should* work as long as the versions are the same. I've done this many times, but simply merging a different table format (inno.*) to one that's different won't work. If it's an old database table 4.x then you have to install a ver 4.x mysql on a test machine, and create a database, drop the files in then export to .sql without create table.

If the tables are different (as in fields) then you have to edit the .sql manually - assuming it won't load.

I've done this to nalgora and destiny databases with sucess for testing the contents with my tools.

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 10:37 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3