I didn't see where you said you x'ed it out before it finished so yeah run Source drop_system.sql it'll reset and drop everything you did, then resource it this time LET IT FINISH. till it get's to where techyguy has shown. make sure you follow his pdf guide. it will take time if you system is slow mine took about 45-50 mins to finish. so go to command prompt:
cd\peq_db
c:\peq_db>mysql -u root -p
password:******
mysql> \u peq
database changed
mysql> source drop_system.sql
you should see dropped blah blah blah and more than likely beep you some cause you didn't let it finish.
then resource it
mysql> source load_system.sql
Query ok, 1 row affected (0.00 sec)
Query ok, 1 row affected (0.00 sec)
Query ok, 1 row affected (0.00 sec)
Query ok, 1 row affected (0.00 sec)
Query ok, 1 row affected (0.00 sec)
Query ok, 1 row affected (0.00 sec)
really really fast. ok then let it finish then do source Load_player.sql
same thing then just let it finish.
I had same issue and realized i was just being dumb and tired, then let it finish while i went to sleep. I too at one point got the error 2 message but i worked and figured out that i was being dumb and tired.
|