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.
Hybrid Mode
