MySQL Forums
Forum List  »  General

Can't create the table before run flush command
Posted by: Selena W
Date: September 07, 2011 04:39PM

Hi,

We need to drop and create new tables monthly, most time using the same table name for the new tables. We don't have problem when we were using version 4.1. But after we upgrade MySQL from 4.1 to 5.5, we have problem to do this. We have to login to MySQL and run the command "flush tables" before run the program to create the tables which have the same name we dropped.

My question is if MySQL flush the database itself when we relogin. Why can't we create the table which existed before? Still in the cache? Is there any way we can change the database setting instead of changing our program to include "flush" command?

Thanks in advance.
- Selena

Options: ReplyQuote


Subject
Written By
Posted
Can't create the table before run flush command
September 07, 2011 04:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.