Merging 2 MySQL db's

Ericsson · 10-26-2005, 11:20 AM

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, 12: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, 03: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, 07: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, 07:32 AM

But it doesnt seem to add it...

JFS · 10-31-2005, 07: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, 07: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, 09:16 AM

Can someone do this for me?

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

Yup. PM me

10-26-2005, 12:25 PM	#2 (permalink)
JFS NamePros Regular Join Date: Oct 2005 Location: Portugal Posts: 760 56.85 NP$ (Donate)	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 Selling : 19P.ORG - ARCADEHITS.ORG - AZIAN.NET - COREFANS.COM - CTUTORIALS.NET - DEDISEEK.COM - HITCHECK.COM - HOST15.COM - HOSTCUSTOMER.COM - LARGETIPS.COM - SCRIPTCANDY.COM - VISUALBOOK.NET - VOXVPS.COM / .NET - WALLPAPERSARENA.COM

10-29-2005, 07:16 AM	#4 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 6,285 1,095.94 NP$ (Donate)	If you have the SQL script handly you can run it from phpMyAdmin if it's installed on your server __________________ Buy now - MassDeveloper.com $500

10-31-2005, 07:44 AM	#6 (permalink)
JFS NamePros Regular Join Date: Oct 2005 Location: Portugal Posts: 760 56.85 NP$ (Donate)	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 Selling : 19P.ORG - ARCADEHITS.ORG - AZIAN.NET - COREFANS.COM - CTUTORIALS.NET - DEDISEEK.COM - HITCHECK.COM - HOST15.COM - HOSTCUSTOMER.COM - LARGETIPS.COM - SCRIPTCANDY.COM - VISUALBOOK.NET - VOXVPS.COM / .NET - WALLPAPERSARENA.COM

11-01-2005, 07:04 AM	#7 (permalink)
wasistdas Senior Member Join Date: Oct 2005 Location: Ukraine Posts: 1,559 152.20 NP$ (Donate)	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: Loan.IM, EnjoyArcade.com, Arcadoid.com

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

10-29-2005, 03:44 AM	#3 (permalink)
Ericsson Senior Member Join Date: Aug 2005 Location: Belfast Posts: 1,215 23.40 NP$ (Donate)	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, 07:32 AM	#5 (permalink)
Ericsson Senior Member Join Date: Aug 2005 Location: Belfast Posts: 1,215 23.40 NP$ (Donate)	But it doesnt seem to add it...

11-04-2005, 09:16 AM	#8 (permalink)
Ericsson Senior Member Join Date: Aug 2005 Location: Belfast Posts: 1,215 23.40 NP$ (Donate)	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 01:24 PM
MySQL Tips	shahid_146	Webmaster Tutorials	4	10-18-2005 12:53 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 09:46 PM
HOW TO: Use shell to control MySQL.	abdulmueid	Webmaster Tutorials	16	08-27-2005 08:17 AM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM