source ax_classic_full_3.0b6 problem

[gutika113]

I have been following the steps to create a server with the ax classic database. When i get to the sourcing part I have problems and i dont know what is causing them. I followed the guide correctly. heres what happens when i try to source.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Jonathan>cd\ax_classic_db

C:\ax_classic_db>MYSQL -u root -p
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.0.45-community-nt MySQL Community Edition (GPL)

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

mysql> source ax_classic_full_3
ERROR:
Failed to open file 'ax_classic_full_3', error: 2
mysql> source ax_classic_core_update_3
ERROR:
Failed to open file 'ax_classic_core_update_3', error: 2
mysql>

Any help on this would be great.

mysql> source ax_classic_full_3
ERROR:
Failed to open file 'ax_classic_full_3', error: 2
mysql> source ax_classic_core_update_3
ERROR:
Failed to open file 'ax_classic_core_update_3', error: 2
mysql>


Do you have those files in the correct folder?

[gutika113]

yes they are in the ax classic db folder on my hard drive. i would believe they need to be there unless they need to be somewhere else.

[AndMetal]

Run this:

dir c:\ax_classic_db

And paste the results.

If I had to guess, I would say you're probably missing the .sql extension from the source files (MySQL doesn't assume the extension). This should do the trick:

mysql -u root -pPASSWORD DBNAME < ax_classic_full_3.sql
mysql -u root -pPASSWORD DBNAME < ax_classic_core_update_3

[gutika113]

ok so i have to guess im doing something totally wrong... (fyi first time working with any of this stuff so im a total effing newb). here are my results

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Jonathan>c:\
'c:\' is not recognized as an internal or external command,
operable program or batch file.

C:\Documents and Settings\Jonathan>dir c:\ax_classic_db
Volume in drive C is The Hold
Volume Serial Number is 54F6-D71E

Directory of c:\ax_classic_db

03/06/2008 07:54 PM <DIR> .
03/06/2008 07:54 PM <DIR> ..
01/13/2008 01:09 PM <DIR> add-ons
03/02/2008 11:34 AM <DIR> ax_classic launcher
03/02/2008 12:39 PM 200,112,888 ax_classic_core_update_3.0b6.sql
01/28/2008 07:14 PM 210,097,899 ax_classic_full_3.0b4.sql
08/02/2007 07:38 AM <DIR> client_maps
03/06/2008 07:51 PM <DIR> EQ_Launcher
12/23/2007 04:58 PM <DIR> night_day
03/06/2008 07:51 PM <DIR> php_updater
03/02/2008 11:41 AM <DIR> quests
03/02/2008 11:52 AM 2,109 README!!
03/02/2008 11:43 AM 72 version.sql
03/02/2008 11:55 AM 12,254 WhatsNew
5 File(s) 410,225,222 bytes
9 Dir(s) 23,136,210,944 bytes free

C:\Documents and Settings\Jonathan>mysql -u root -pPASSWORD DBNAME < ax_classic_
full_3.sql
The system cannot find the file specified.

C:\Documents and Settings\Jonathan>mysql -u root -p ******* ax_classic < ax_clas
sic_full_3.sql
The system cannot find the file specified.

ax_classic_core_update_3.0b6.sql
ax_classic_full_3.0b4.sql

is what they are called

ax_classic < ax_classic_full_3.sql

is what your trying to run.

The names arent the same.

[gutika113]

ok ill give that a try when i get home.

[Angelox]

If they insist on sourcing in a shell, the only one they can source is the "ax_classic_full" version. The update would work if they dropped all the tables they were updating with. Even the full won't work if there already is a full in the database.
My idea was to simplify things for people just starting out, and have them download MySql Administrator, use it's backup/restore features. If they don't use MySql Admin, then they are going to need the smarts to drop the tables first.