We have a table that gets a lot of activity and has about 4,500 records. I update it by using PhpMyAdmin to empty the table and then replace it with a textfile. A few days ago, as soon as I emptied the table the server went as screwy as I've ever seen it. We would reboot, and it would still go crazy - not returning queries, not accepting passwords, etc. After 2 days, we were able to load the textfile and the server has been fine since.
Our tech people think the table was receiving queries and since there was nothing in it, some nasty loop situation occurred.
Is there a way to update a table with entirely new data without dropping it first? Any suggestion on how to solve this problem are appreciated.