Anyone with great MySql & phpMyAdmin knowledge? - 10/12/2003 1:55 PM
(little background)
Prior to installing 6.3.2, we had -zero- issues with databases or cpu usage. Things ran very smooth. Installed 6.3.2 and from that moment on (9/11/03) this has been a living nightmare. I have tons of error logs (none before 'upgrade')
We allowed 'charcters' in member names, but when someone searched on a charcter like (') an error was generated, and seemingly it would cause member files to be deleted. All charcters were removed from member names (only alpha & numeric now) A trouble ticket was filled out, and it was reported to our host. The error logs have continued, members keep disappearing. IP says we have a corrupt table, host used shell to check and said a table couldn't be repaired. 3 days pass, I learn I can do CHECK TABLE and run it on each table and it reports they're all 'ok', no errors. We're still having problems.
We have a -very- busy forum, and at the moment, I am swamped with 'real life' committments.
My question (and I posed this to IP and to my host, but don't expect answers today on a weekend)
I have a backup from prior to our 'upgrade', and I have backed up since upgrading (problems within that backup though?)
What is the logical thing to do here w/out losing all of our posts & users... that's all I wish to 'preserve' if possible ?
Additionally, because life is very hectic right now, when emptying the polldata table yesterday, I hit 'dump' rather than empty Is there some way in phpMyAdmin to replace that table from the backup I have on my pc here ?
Thanks for your time.
Prior to installing 6.3.2, we had -zero- issues with databases or cpu usage. Things ran very smooth. Installed 6.3.2 and from that moment on (9/11/03) this has been a living nightmare. I have tons of error logs (none before 'upgrade')
We allowed 'charcters' in member names, but when someone searched on a charcter like (') an error was generated, and seemingly it would cause member files to be deleted. All charcters were removed from member names (only alpha & numeric now) A trouble ticket was filled out, and it was reported to our host. The error logs have continued, members keep disappearing. IP says we have a corrupt table, host used shell to check and said a table couldn't be repaired. 3 days pass, I learn I can do CHECK TABLE and run it on each table and it reports they're all 'ok', no errors. We're still having problems.
We have a -very- busy forum, and at the moment, I am swamped with 'real life' committments.
My question (and I posed this to IP and to my host, but don't expect answers today on a weekend)
I have a backup from prior to our 'upgrade', and I have backed up since upgrading (problems within that backup though?)
What is the logical thing to do here w/out losing all of our posts & users... that's all I wish to 'preserve' if possible ?
Additionally, because life is very hectic right now, when emptying the polldata table yesterday, I hit 'dump' rather than empty Is there some way in phpMyAdmin to replace that table from the backup I have on my pc here ?
Thanks for your time.