dutchie
05-16-2002, 09:03 AM
I have phpmyadmin running as a test to see wether i should offer Mysql to customers.
I let one user as a trail create some databases, but suddenly he could not edit his db anymore, the page in the right frame of phpmyadmin would not show for his database anymore.
I deleted the database, recreated it and now it works again.
Is this a common problemand what can i do against it ?
Thanks !
Cephren
05-17-2002, 08:33 AM
The best place to start looking at this problem is:
1. Is it MYSQL's problem or PHPmyAdmin's problem.
2.What kind of box is this? cobalt?
3. Have you taken a look at the following files and if anything have been changed in them?
db_details.php3
and
tbl_properties.php3
dutchie
05-18-2002, 01:30 PM
I guess its a Mysql problem because all other db's worked, and when i deleted the one with problems and created it again the problem was solved.
I just wondered if others had the same problem.
FiberOptic
05-18-2002, 01:32 PM
I don't think it's a common MySQL problem.
We run around 50 MySQL databases on 1 RaQ4r, never lost any data
Cephren
05-19-2002, 02:35 AM
Them it could be that the database became severly corrupt.
Ever have extremly high usage on the server? and high ram usage, where the swap partition has gone nuts?
Weve had databases corrupt with a runaway servers or tons of high traffic sites before and that means its time to migrate some sites off.
Other wierd stuff that could happen include corrupt folders, which evidently is shown with ? for the Root read permissions.
dutchie
05-19-2002, 04:55 AM
No high server loads.
The only thing I can think of is that the owner of the db messed it up, or that i did something worng setting up phpmyadmin.
Well lets hope its a one time incident an it won't happen again, if it does i'll be back :D