Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::GeorgeS's Tools

Development::GeorgeS's Tools A forum just for GeorgeS's tools

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-29-2010, 04:54 PM
Garaborn
Fire Beetle
 
Join Date: Jun 2010
Location: Vancouver
Posts: 11
Default Error While importing db r1496 1316BOTS

Hi George,
New to this community.
I have been working on creating my own personal server last few days and after some fun head bashing I got pretty close.
I used your personallogin and it worked well thanks.
My problem according to my debug logs is the items wouldnt load.
I thought I would just try your database.
georges_db_r1496_1316BOTS_.rar

I am having a problem loading it. (not a mysql user).
I tried first creating a Database and importing your .sql file into it using heidisql but it failed on some syntax about a form of some sort in the code about 5% in.
I saw another post in this forum back in march that you used mysql gui 5.0 to backup and that may be required to restore (the link didnt work btw).

I went to mysql site and downloaded mysql-gui-tools-5.0-r17-win32.msi
Unfortunately, that did not recognize your file though as a backup. I tried anyways but there were two many errors.

So my question is. I am willing to try your thing from scratch.

What version of SQL should I use? I have mysql-essential-5.0.85-win32.
I installed it using recommendations from Redoggut's post with these settings...

•Choose Detailed Configuration, Click Next
•Choose Server Machine, Click Next
•Choose Multifunctional Database, Click Next
•Click next again for InnoDB Tablespace Settings
•Choose Online Transaction Processing (OLTP), Click Next
•Check Enable TCP/IP Networking making sure the port Number is 3306, Un-Check enable Strict Mode, Click Next
•Choose Best Support for Multilingualism, Click Next
•Check for both Install As Windows Service (Service name should be MySQL), and for Include Bin Directory in Windows PATH, Click Next
•Now enter your New Root Password, Confirm, and do not check for remote machine Access. Don?t select Create An Anonymous Account. Click Next
•Now click on Execute and wait for it to finish. Once it is done, click Finish.


Should I do it any differently to install it?

Thank you for your time, I appreciate your work.
Reply With Quote
 


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 09:20 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