Error 2 at SQL CMD?

Zandig · #1 11-22-2007, 02:24 AM

You are using the wrong syntax.

Here is the proper syntax:

Code:

\. load_system.sql

Also make sure all of the files are in your mysql/bin directory.

Sakrateri · #2 11-22-2007, 02:45 AM

Or you could

Quote:

source load_system.sql;

Attere · #3 11-22-2007, 05:05 AM

Okay, so .. I'm in the midst of attempting to set up my own server. I've read over this, and tried each of the ways that have been posted to load the .sql files.

I get the same error, no matter the syntax. Also, the .sql files are in the bin folder, 'cept it seems to change absolutely nothing.

Is there any other issue that it could be..?

techguy84 · #4 11-22-2007, 05:37 AM

Navigate to the directory you downloaded the database to, like C:\peqdb first. Do this by running your command prompt and typing cd\peqdb or whatever directory you put it in.

Another method would be to copy the two load files over to your C:\Program Files\Mysql\bin directory and then run the MySQL CLI from your start menu and do exactly what you are already doing.

Detailed instructions to do the first method are located in my PDF guide so you have some screen shots to go along with.

\. and source are the same thing, so either will work.