View Single Post
  #15  
Old 09-26-2008, 03:02 AM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,498
Default

But if he didn't end with a semi-colon, it wouldn't give him error 2 file not found. It would give him the ->.

Are you starting mysql from the directory where these .sql files are located?

start -> run -> cmd
Code:
C:\Documents and Settings\Your Name>cd \peq
C:\peq>cd peq_db
C:\peq\peq_db>dir
 Volume in drive C has no label.
 Volume Serial Number is ****-****

 Directory of C:\peq\peq_db

09/21/2008  08:22 AM    <DIR>          .
09/21/2008  08:22 AM    <DIR>          ..
02/12/2008  10:17 AM             1,861 aa_timers.sql
02/12/2008  10:17 AM             2,272 account.sql
04/21/2008  03:07 PM               387 Banned_IPs.sql
02/12/2008  10:17 AM             1,755 botinventory.sql
02/12/2008  10:17 AM             1,722 botleader.sql
02/12/2008  10:17 AM             1,763 botsowners.sql
03/29/2008  03:17 PM                98 bot_npcs.bat
03/16/2008  04:40 PM                98 bot_npcs.sh
02/12/2008  10:17 AM             2,363 character_.sql
02/12/2008  10:17 AM             2,372 character_backup.sql
04/21/2008  03:07 PM            23,992 commands.sql
09/14/2008  10:34 AM    <DIR>          CVS
09/06/2008  02:26 PM             1,250 drop_player.sql
09/06/2008  02:26 PM             1,780 drop_system.sql
02/12/2008  10:17 AM             2,078 eventlog.sql
02/12/2008  10:17 AM             1,835 faction_values.sql
.....
.....
etc, etc, etc.

C:\peq\peq_db>mysql -u root -p
Enter password: ****

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.51a Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>source load_player.sql;
Reply With Quote