Sourcing database

[Wolfling]

Originally Posted by DrDoom

mysql> peqdb_rev2214.sql.gz;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'peqdb
_rev2214.sql.gz' at line 1
mysql>

Did You Extract the SQL from the archive?

Basic procedure to import - assuming you have the basic db structure setup

1/ extract the sql file from the peqdb_rev2214.sql.gz archive into a folder eg c:\db
2/ goto that folder = c:\db>_
3/ type mysql -uroot -p
4/ hit enter and enter your password. hit enter again = mysql>_
5/ type use peq or whatever your world db is called = database changed
6/ type source peqdb_rev2214.sql
7/ wait for the mysql>_ prompt
8/ source any other .sql's in same way

Hope that makes sense & helps

Wolf