View Single Post
  #8  
Old 08-26-2011, 01:48 PM
rencro
Hill Giant
 
Join Date: Sep 2008
Location: So. California
Posts: 219
Default

Theres different ways to do the import, me, I like to download the database to c:\EQEmu\db but you can put it anywhere, just for my method My Documents would not be wise. Anyways, I then start a command window from windows by going to START--RUN--I type cmd in the command box and hit enter.. I go into the command box and type cd c:\EQEmu\db

then I do dir to make sure my sql is there, in this case for you db_dump.sql, remember you downloaded that file here, or where-ever you have your db_dump.sql file...

Once I'm in the same directory as my sql, then I start mysql with mysql -uroot -ppassword

Use your actual account user name for mysql, I know I know, there will be those that pop in and say "DONT USE ROOT", whatever, set up a specific user name for mysql if you wish, the -ppassword is your password, so for instance if your user is root and password is joe it would look like this:

mysql -uroot -pjoe

after you are in mysql type use peq unless your db is named something else, but usually the db name will be peq

then type source db_dump.sql;

when its done type exit
you can close the command box

then you will need to import all the updates to come current to the release of your distribution. These will be in the c:\EQEMUDIRYOUDOWLOADEDTO\Utils\sql\svn from 1900 and up that are not listed as optional...Again many ways to do this, but for simplicity just use NAVICAT or HEIDISQL to import these into your peq database..

Last edited by rencro; 08-26-2011 at 01:49 PM.. Reason: oh well, I color coded all the commands but not working..
Reply With Quote