Hey, Over the last few days my database wont pull out the information I need it to. It pulls out some and just leaves the rest behind for no reason. Nothing has changed it worked one day and then the next it no longer worked! Any ideas?
plz elaborate your problem and describe it more clearly frankly speaking,we don;t understand what you want to say. /d
Hello, Did you contact your hosting provider asking them what happen? Or Are you using your computer? Jakomo
maybe the connection is lost during query , or maybe u should try repairing the table .. just incase!
How are you accessing this data and what version of MySQL are you using. I had a similar problem with MySQL version 4.x using IE version 6.x. When the dataset got a bit big, the connection would keep closing and only some info is displayed. Of course, if that is the case, you should see and error message. I installed MySQL version 5 and its been stable since... Regards, John
Just check out the load on your server. Else try the repair option in case your DB has gone corrupt. You will find info in mysql documentation about the repair db. It would be better if you could elaborate the problem more. Did you received any error messages? Is your DB of the size of a few GBs? Too big DBs are also a source of problem. Hope that helps. Best