View Single Post
  #4  
Old 11-27-2004, 01:51 AM
Topgun1969
Sarnak
 
Join Date: May 2003
Posts: 37
Default Mysqldump

Ok, i have tried that already, Get nothing in the bin folder. I was a bit wrong with that above. I have tried to just point at the Mysql/Bin and get the 1044 error access denied, this is when i get the 1kb file in the bin. So i know i need to get in the DB with....(mysql -u root mysql).
When i get in with that i type the command...(mysqldump eq > eq-backup.sql) and then the line drops to

->

results in nothing.

Which now i have noticed the DB corrupts itself somehow. PEQ.Kunark release. I have it set up on 2 comps with a dedicated comp for the server. Everything works normal after a few hours but then comp#2 will freeze up and have to manual boot it. When trying to log back in with the character on it, it seems like the character isn't there but is (lol). Just can move around with the character nothing else, can't interact with nothing. Did this twice now. First time i fresh installed the DB and it fixed it. It happened this time again after the character died. Also when you group the health bars move up and down resulting in when you get knocked unconcious it shows you get up and down up and down not being able to pull out of the state. I guess the DB is corrupted again somehow but don't understand why i can't backup the accounts and characters.

Ok, i just read this to be the exact problem i am having with my server.

http://www.eqemulator.net/forums/vie...1ea8d1f14beb73

*sigh* just wish this worked for me, no items were causing this. I could delete the whole equipment on the character and log out and back and it would be as if i hadn't touched it. Just wish i could drop the accounts, characters and fresh install but mysql commands won't work.
Reply With Quote