EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Creating the Database... (https://www.eqemulator.org/forums/showthread.php?t=19837)

jetstrike 12-20-2005 02:28 PM
Creating the Database...
 
Whenever i try to create the database it looks something like this...


| mysql>
| mysql>Create Database eq
| ->use eq
| ->source load_system.sql; source load_empty_users.sql
| ERROR 1064: You have an error in your SQL syntax near 'use eq|
| source load_system.sql' at line 2
| mysql>

What do i need to do to fix this?

garim12 12-20-2005 02:32 PM
semicolons... every command should end in one

Code:
create database eq;
use eq;
source load_system.sql;
source load_empty_users.sql;

jetstrike 12-20-2005 02:52 PM
Quote:
Originally Posted by garim12
semicolons... every command should end in one

Code:
create database eq;
use eq;
source load_system.sql;
source load_empty_users.sql;
Your right but i had tried that once already. I jus created the database over again by putting a semicolon at the end then i started back over with a new cmd prompt and got to the mysql and just typed the last three commands which seemed to have worked thanks alot though. I knew the semicolon thing just forgot to type the in the code i showed u all learned that the hard way... damn c++.

Elysius 12-20-2005 06:24 PM
Quote:
Originally Posted by jetstrike
Your right but i had tried that once already. I jus created the database over again by putting a semicolon at the end then i started back over with a new cmd prompt and got to the mysql and just typed the last three commands which seemed to have worked thanks alot though. I knew the semicolon thing just forgot to type the in the code i showed u all learned that the hard way... damn c++.
LOL this isn't c++.


All times are GMT -4. The time now is 02:39 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.