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.<br /><br />Our tech people think the table was receiving queries and since there was nothing in it, some nasty loop situation occurred. <br /><br />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.

Did you drop it or only delete the content?<br /><br />To delete the table content: DELETE FROM "tablename"<br /><br />Then insert whatever you wish to insert.<br /><br />To insert data into a table that already contains potentially the same data:<br /><br />REPLACE INTO "tablename"

That little checkbox allowing me to overwrite the data did the trick. Thanks for your help.