Merging 2 MySQL db's

[Ericsson]

I bought a database of tutorials for www.retrotuorials.com

Example

INSERT INTO `tutorials` VALUES (36, 'Emoticon', 'Learn how to make cool emotions to express yourself!', 'July 27, 2005', 9, 'Nothin2lose', 'http://www.nothin2lose.net/?id=emotions', 10, 'pslogo.gif');

How do I add these to my site www.retrotutorials.com
Example from site:

INSERT INTO `tut_tutorials` VALUES (1, 'USB Cable End', 'Stephen Knox', 'http://www.stephenknox.com/tutorials/usbend/', 'Drawing', 1128701264, 1, 'This tutorial will teach you how to draw the plug end of a standard A-B USB cable.', 1128701409, 0, 0, 'uploads/USBCableEnd.jpg', 4);

 

[JFS]

you can create a php file that connects to bought databases and inserts one into the other, for that you must, of course, know the fields of both databases.

 

[Ericsson]

Could anyone do this for me? I can give you one months advertising on www.retrotutorials.com which gets 50 uniques daily, and it will go up when the tutorials are added.

 

[Kate]

If you have the SQL script handly you can run it from phpMyAdmin if it's installed on your server

 

[Ericsson]

But it doesnt seem to add it...

 

[JFS]

you should creat a php file where you read from the first database and do a cicle until the end of the database and each time do a insert to your database.
i hope i was clear with my post, if you still need help contact me

 

[wasistdas]

If there is no interference with table names you can just copy the new table files into your database directory and reload mysql.

 

[Ericsson]

Can someone do this for me?

 

[wasistdas]

Yup. PM me