MySQL Forums
Forum List  »  PHP

What is the best/fastest way to copy tables?
Posted by: Wim Roffel
Date: April 26, 2015 04:44AM

I want to copy the data section of some software into an installation of a newer version of that software. That means that I have the following requirements:
- not all the tables should be copied, only about half of them.
- the tables into which the content is copied have the same names as the old tables. However, there are minor differences: some fields have become wider and some fields have been added. It is desirable to initiate these new fields as empty instead of null.
- occasionally it may happen that some extra restriction - like some extra unique key - has been added. It is no problem when that ends the process. However, it is desirable that the error message is clear.

I want to do this from PHP code and was wondering what is the fastest way to do this. The transfer concerns about 150 tables that in total contain a few million records.

Options: ReplyQuote


Subject
Written By
Posted
What is the best/fastest way to copy tables?
April 26, 2015 04:44AM


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.