View Single Post
  #8  
Old 10-07-2004, 10:06 AM
maveren
Sarnak
 
Join Date: Sep 2004
Location: Wisconsin
Posts: 72
Default

Quote:
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Your access rights arent correct.
1: Delete C:/Windows/my.ini
2: Run C:/mysql/winmysqladmin.exe
3: Write down the *UserName* and *Password***REMEMBER THIS***
4: [Start] Run, type "cmd" in the Run dialoge window.
5: "Shell>" = your default login... an example is C:\Document and Settings\User>...
Code:
shell> mysql -u root mysql
mysql> use eq.sql
mysql> source c:/mysql/bin/PEQ_Classic_058.sql
this should take quite awhile, if you get a error message saying that it cannot open the file you downloaded it and the file was damaged during extraction. ~ Make a copy of a working db.sql file and clear its contents with notepad, then open PEQ_Classic_058.sql with notepad and cut blocks of the database and past them into the copy of the working database. go through all the same steps but replace the
Code:
source PEQ_Classic_058.sql
with the one you just pasted to.
After about 20 minutes of scripting the database should be compleate.
if you get errors, open C:/mysql/data/eq and delete the contents (restarting might be required to get all the files)
Rince and Repeate the whole
Code:
source workingdatabase.sql
or
Code:
source PEQ_Classic_058.sql
when your done with the scripting

Grant all on eq.* to Username@localhost... or whatever the grant scripts are, you can find them.
This should take care of the database being closed for security reasons.
Reply With Quote