Merging 2 MySQL db's

Ericsson · 10-26-2005, 12:20 PM

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

Example

Code:

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:

Code:

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 · 10-26-2005, 01:25 PM

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 · 10-29-2005, 04:44 AM

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.

sdsinc · 10-29-2005, 08:16 AM

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

Ericsson · 10-29-2005, 08:32 AM

But it doesnt seem to add it...

JFS · 10-31-2005, 08:44 AM

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 · 11-01-2005, 08:04 AM

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

Ericsson · 11-04-2005, 10:16 AM

Can someone do this for me?

wasistdas · 11-04-2005, 01:59 PM

Yup. PM me

10-26-2005, 01:25 PM	#2 (permalink)
JFS NamePros Regular Join Date: Oct 2005 Location: Portugal Posts: 800	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. __________________ João Fernandes Silva

10-29-2005, 08:16 AM	#4 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 9,552	If you have the SQL script handly you can run it from phpMyAdmin if it's installed on your server __________________ NameNewsletter.com - free lists of available domain names ZoneFiles.net (beta) - ccTLD and gTLD droplists

10-31-2005, 08:44 AM	#6 (permalink)
JFS NamePros Regular Join Date: Oct 2005 Location: Portugal Posts: 800	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 __________________ João Fernandes Silva

11-01-2005, 08:04 AM	#7 (permalink)
wasistdas Senior Member Join Date: Oct 2005 Location: Ukraine Posts: 1,585	If there is no interference with table names you can just copy the new table files into your database directory and reload mysql. __________________ The Official Dead End Place: WWW.TODEP.COM. The best search engine ever. WWW.NULLSEARCH.COM For Sale: EnjoyArcade.com, Arcadoid.com

11-04-2005, 01:59 PM	#9 (permalink)
wasistdas Senior Member Join Date: Oct 2005 Location: Ukraine Posts: 1,585	Yup. PM me __________________ The Official Dead End Place: WWW.TODEP.COM. The best search engine ever. WWW.NULLSEARCH.COM For Sale: EnjoyArcade.com, Arcadoid.com

10-29-2005, 04:44 AM	THREAD STARTER #3 (permalink)
Ericsson Senior Member Join Date: Aug 2005 Location: Belfast Posts: 1,217	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.

10-29-2005, 08:32 AM	THREAD STARTER #5 (permalink)
Ericsson Senior Member Join Date: Aug 2005 Location: Belfast Posts: 1,217	But it doesnt seem to add it...

11-04-2005, 10:16 AM	THREAD STARTER #8 (permalink)
Ericsson Senior Member Join Date: Aug 2005 Location: Belfast Posts: 1,217	Can someone do this for me?

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HOWTO: Install the Apache Web Server, Perl, PHP, and MySQL on Windows	deadserious	Webmaster Tutorials	96	05-27-2007 02:24 PM
MySQL Tips	shahid_146	Webmaster Tutorials	4	10-18-2005 01:53 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 10:46 PM
HOW TO: Use shell to control MySQL.	abdulmueid	Webmaster Tutorials	16	08-27-2005 09:17 AM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 02:17 PM