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
Subject
Written By
Posted
Can't create the table before run flush command
September 07, 2011 04:39PM
September 08, 2011 08:17PM
September 09, 2011 01:22AM
September 10, 2011 03:18PM
September 12, 2011 09:51AM
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.