Copy tables from one database to another

markthe5th

Hi,

I"m somewhat new to php, and I need to write a page from which a user can copy certain preset tables from one database to another - The tables and structures in database A and database B are set properly, its only the data which I need to copy from A to B. Basically its updating a database by mirroring the contents from the original one..

Is there an easy pre built function which will allow me to do that?

Any pointers?

any help would be much appreciated.

Mark

tomhath

I doubt you'll find anything ready made. How to do it depends a lot on what dbms you are using (mysql, sql server, etc). Also how big the tables are (tens of rows? hundreds? tens of thousands?). Too many unknowns to give an intelligent answer... 🙁

fandelem

insert into database_2.table_1 select * from database_1.table_1

..and repeat this for all tables needing to be copied.

cheers,

Mystikal

I believe this will only work with certain versions of mysql..

markthe5th

Hi,

Thanks for all the pointers....question...

insert into database_2.table_1 select * from database_1.table_1

the above code INSERTS the data, would that mean that each time it adds, as opposed to replace/append?

The reason I'm saying this, is because database1 would be the main database thats populated. periodically we need to update database2 with the contents of database1 so that they are basically mirrored...

Will this do the trick?

(I'll try it out anyhow..)

I was also wondering if I should be thinking of running SHELL commands to accomplish this.... any thoughts on approaching it that way?

Thanks again for all the reply's..appreciate it.

markthe5th

Just to make sure you know which page I'm on...

I'm using

PHP4 and mySQL running on UNIX.

I have two seperate databases on my domain...

Cheers

Mark