Looks like Trevius beat me to the punch, but maybe this will help anyway.
You can do everything you need to from the command prompt and not have to worry about using a different tool to create the database. I remember when I originally tried to use SQLyog to source load_player.sql it failed because it doesn't set the current directory to where the file you're importing is so it couldn't find the player_tables directory.
I also show deleting the existing database just to be sure you are starting from scratch. It sounds like, from the issues you posted, that you may have had something leftover there causing a conflict.
Substitute whatever directory you have the peq files in for the first command. The blue text is what I typed. I didn't include all of the spam the source commands generate because it wouldn't be helpful. If you want to save all of the output to a file you can type
tee output.txt as the first command at the mysql> prompt. The file will be saved in the directory you started MySQL from.
If you are not using bots then skip the
source load_bots.sql command.
Code:
C:\>cd EQEmu\Database\peqdatabase
C:\EQEmu\Database\peqdatabase>dir
Volume in drive C has no label.
Volume Serial Number is 4A57-06FC
Directory of C:\EQEmu\Database\peqdatabase
12/06/2011 03:11 AM <DIR> .
12/06/2011 03:11 AM <DIR> ..
10/04/2010 10:20 PM 564 drop_bots.sql
12/05/2011 07:55 PM 2,566 drop_player.sql
12/05/2011 07:55 PM 2,752 drop_system.sql
10/04/2010 10:20 PM 276 load_bots.sql
12/05/2011 07:55 PM 2,659 load_player.sql
12/05/2011 02:02 AM 169,453,496 peqdb_rev2083.sql
12/05/2011 07:55 PM 22,451,506 peqdb_rev2083.sql.gz
12/05/2011 07:55 PM <DIR> player_tables
10/04/2010 10:20 PM 1,586 readme.txt
12/05/2011 07:55 PM <DIR> updates
8 File(s) 191,915,405 bytes
4 Dir(s) 495,992,610,816 bytes free
C:\EQEmu\Database\peqdatabase>mysql -uroot -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.0.91-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> drop database peq;
Query OK, 151 rows affected (2.15 sec)
mysql> create database peq;
Query OK, 1 row affected (0.00 sec)
mysql> use peq
Database changed
mysql> source peqdb_rev2083.sql
mysql> source load_player.sql
mysql> source load_bots.sql
mysql> quit