Steps for removal of old database before adding the newer serverfiles.
copy peqdb_rev2100.sql (without the .gz) extract the file before copying to C:\MySQL\bin Directory using winzip or rar
copy player_tables directory
copy updates directory
copy load_player.sql
Copy all Files and Folders too C:\MySQL\bin Directory
REMEMBER THE PASSWORD YOU GAVE when you set up MySQL ? (You need it NOW)
***WARNING*** - at this point, make sure you are in the C:\MySQL\bin Directory
Then type mysql -uroot -p
Hit enter and enter your password. (Hit enter again)
You should now see a prompt that looks like this: (along with "Welcome" text before it)
mysql>_
Type the following (in order):
use peq (Hit enter and you will see a short note saying "Database changed")
Then type the following:
type drop_bots.sql if loaded
type drop_player.sql
type drop_system.sql
next step soucing in new database
type source peqdb_rev2100.sql
then type source load_player.sql
Done I'm sure this is what you was looking for instead of reloading the whole server.
|