MySQL Forums
Forum List  »  MySQL Administrator

Copy tables
Posted by: matt tisdel
Date: September 23, 2005 02:09PM

I have a database with some tables that I would like to copy to another set of tables to back them up. My tables are setup like eqdkp_ and I want to be able to back them up to a set of tables called eqdkpBAK_. My problem is whenever I try and overwrite the old tables it says it cant because there is a table named eqdkpBAK_whatever already. Is there a command to simply overwrite the entire table or do I need to delete the table and recreate it?

Options: ReplyQuote


Subject
Written By
Posted
Copy tables
September 23, 2005 02:09PM
September 27, 2005 01:48AM


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.