View Single Post
  #3  
Old 07-29-2008, 12:26 AM
AndMetal
Developer
 
Join Date: Mar 2007
Location: Ohio
Posts: 648
Default

If you're starting from scratch, you will need to source load_player.sql first. It basically loads all of the other .sql files, which correspond to individual tables, into the database, except for the peqdb_xxxxx.sql.gz file, which is all of the non-player info. You can do this one of 2 ways:
Code:
mysql -u root -pPASSWORD DATABASENAME
source /home/eqemu/server/database/load_player.sql;
exit
Or, you can do it all on 1 line:
Code:
mysql -u root -pPASSWORD DATABASENAME < /home/eqemu/server/database/load_player.sql
However, if you use the second option, you don't really get any info about errors. Once you've done that, you can load the rest of the database from the Gzipped file. First, you'll need to Gunzip it:
Code:
cd /home/eqemu/server/database
gunzip peqdb_1119a.sql.gz
That will extract it as peqdb_1119a.sql. Once that's done, just do the same thing as load_player.sql, except use peqdb_1119a.sql instead of load_player.sql. Then, your database should be all loaded. Going forward, if you need to update the database, you just need to source the peqdb file instead of running the load_players file.

Hope this helps.
__________________
GM-Impossible of 'A work in progress'
A non-legit PEQ DB server
How to create your own non-legit server

My Contributions to the Wiki
Reply With Quote