Sourcing database

[DrDoom]

Hi , i could use a little help with sourcing the peqdb_rev2214.sql it just keeps saying to me failed to open file < blah blah > error 2 . could someone shine some light on what im doin wrong ?? im doin everything exactly the way the write says to

[lerxst2112]

Open a command prompt
Navigate to the directory where the peq database file is
mysql -uroot -ppassword peq < peqdb_rev2214.sql

Replace 'password' with whatever password you chose, and this assumes you already created the peq database using whichever instructions you are following.

Error 2 is file not found btw, so I assume you're either not spelling the filename correctly, or you're not in the right directory.

[DrDoom]

i created DB , did everything as stated on the forums to get started , but still says same thing , step by step .

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\Andy Chism>mysql -u root -p
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 16
Server version: 5.0.96-community-nt MySQL Community Edition (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> source peqdb_rev2214.sql;
ERROR:
Failed to open file 'peqdb_rev2214.sql', error: 2
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>

tried everything im lost at this point

[Maze_EQ]

did you cd to the directory your database is in?

dos>cd c:\

etc

[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

[DrDoom]

will try that ty