Again not helpfull at all
So i was able to find the peq datadir ill attempt this sorcing thing If anyone else has issues because there not setup the same your dirs for the sql may be located in \mysql\data\peq
and not in the c:\peqdb dir as some may have it no offense to the writer of the first page walkthrough its great you did that
mine happens to be
C:\eqemu\UniServer\usr\local\mysql\data\peq
Now i am starting with a naked Database
i have the standard structure of
DB information_schema - Standard mysql initial stuff unsure if anything needs altering
DB login - utf8 - bin Completly naked i assume i needed it so i created it
DB mysql - filled with the standard stuff for all my sql
DB peq - utf8 - bin format and completly empty (completly empty mind u)
DB performance_schema - again standard sql stuff
DB phpmyadmin - Standard stuff again and not relivant to eqemu
i went to the peq dir i did sorce it started importing and a bunch of errors like
Query OK, 0 rows affected (0.00 sec)
ERROR 1050 (42S01): Table '`peq`.`ground_spawns`' already exists
Query OK, 0 rows affected (0.00 sec)
ERROR 1146 (42S02): Table 'peq.ground_spawns' doesn't exist
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
in that order and alot more than that but it wont save that far up in the cmd window
i checked back and they really were missing after the import so what thats telling me is the .SQL file is telling mysql to create if not there before its telling mysql to delete it
so this whole time its not my importing through heidisql its the SQL itsself that is not working correctly
Its creating the table thats missing then deleting it then its unable to run the insert commands because the table is missing...
i appear to have a bad SQL db as i assumed... is there a 2068 DB around anywhere that is uncustomized? since the 2027 db im using is not allowing a full source
I did not run any updates because the initial sourcing failed and alot of stuff is not included anyway
what i came out with is a peqdb that was missing some tables
and not sure how to pupulate the login db so i will just copy another one into that one
i found the 2083 i will clear and try that one instead
http://code.google.com/p/projecteqdb/downloads/list
is where the 2083 db is