P.s Don't remove your server directory
Code:
1. install ActivePerl-5.14.2.1402-MSWin32-x86-295342.msi
2. install mysql-5.1.73-win32.msi
Now install MySQL 5.1 (this will be installed to C:\mysql)
When you first start up the install, make sure you choose CUSTOM install.
IMPORTANT: after clicking "next" this is where you change the install
path to "C:\mysql
On that same menu, make sure ALL options are installed.
After clicking "next", on that menu, choose Detailed Configuration.
After clicking "next" again, choose Server Machine.
After clicking "next" again, choose Multifunctional Database
On the next menu, there is nothing to change, click "next" again.
On that menu, choose Online Transaction Processing (OLTP)
Then click "next". UNCHECK the strict mode option, and make sure that the
TCP/IP Networking is checked ENABLE and at port 3306.
After clicking "next" again, Choose Best Support for Multilingualism.
After clicking "next" again, make sure BOTH of the following are checked:
Install As Windows Service and Include Bin Directory in Windows Path
After clicking "next" again, you will be prompted for a password.
(This password is what goes with your SQL database username)
Your SQL username is automatically set as "root"
After you click "next" again, you will get a menu with "Execute" on it.
Just click that and wait, as it installs and finishes. Reboot.
3. download peqbeta_2014-09-25-02-01.tar.gz
unzip file to C:\MySQL\bin
make two directories peq and peqlogindb
C:\MySQL\data\peq
C:\MySQL\data\peqlogindb
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:
source peqbeta_2014-09-25-02_01.sql (when this is done, you will be back at the mysql>_ prompt)
Then type in the following:
source player_tables_2014-09-25-02_01.sql (this will load fast)
I use Navicat for Mysql needs database server setup only
I changed my server files too allow two servers per computer excepting the latest clients