| Return to iWEBTOOL |
| |
|
| |||||||
 | Welcome to iWEBTOOL Talk, where you talk about
webmaster-related stuff.
1 Register
2 Browse the board
3 Discuss whatever may interest you! | |||||||||||||
 |
| | Thread Tools | Search this Thread | Display Modes |
04-05-2007, 09:41 PM
| #1 |
| Smurf  Join Date: Oct 2006
Posts: 31
 |  Merge Two MySql databases Hello, I have two databases on my website lebphoto.com with the same tables. One with a 1665 members and the other with 33 members, I want to merge them together. is there a way other than typing each records by myself or ask the members to register again? Thank you |
|
|
| |||||||
|
04-06-2007, 01:20 AM
| #2 | |
| Member Join Date: Apr 2007 Location: www.easywebx.com
Posts: 241
|  Re: Merge Two MySql databases Export one table, than import it in the other database. Quote:
__________________ EasyWebX.com offers  Cash Rebates up to $100 for lots of  web hosting plans.HostDomainZone.com offers cheap domains ($1.99*), web hosting ($3.19) and reseller plans ($59.99/yr) | |
|
|
|
04-06-2007, 02:23 AM
| #3 | |
| Contributor Join Date: Jun 2006 Location: Denver
Posts: 4,459
 | Re: Merge Two MySql databases Quote:
Could you elaborate a lot more, explain what the steps involved are? Export then Import doesn't mean anything. | |
|
|
|
04-06-2007, 05:56 AM
| #4 | |
| Member Join Date: Apr 2007 Location: www.easywebx.com
Posts: 241
| Re: Merge Two MySql databases OK. For example, database name: db1 and db2 The table name is tb. Export table 1) Use phpMyAdmin, select db1 2) Click Export 3) Select db table 4) unselect Structure 5) check Save as file 6) Click Go Import table 1) Use phpMyAdmin, select db2 2) Select db table 3) Click Import 4) Browse your exported file 6) Click Go Done Quote:
__________________ EasyWebX.com offers Cash Rebates up to $100 for lots of web hosting plans.HostDomainZone.com offers cheap domains ($1.99*), web hosting ($3.19) and reseller plans ($59.99/yr) | |
|
|
|
04-06-2007, 07:59 AM
| #5 |
| Contributor Join Date: Jun 2006 Location: Denver
Posts: 4,459
| Re: Merge Two MySql databases Thank you iwbbs. Let us know how that works for you. |
|
|
|
04-06-2007, 04:00 PM
| #6 | |
| Member Join Date: Apr 2007 Location: www.easywebx.com
Posts: 241
| Re: Merge Two MySql databases You are welcome. Quote:
__________________ EasyWebX.com offers Cash Rebates up to $100 for lots of web hosting plans.HostDomainZone.com offers cheap domains ($1.99*), web hosting ($3.19) and reseller plans ($59.99/yr) | |
|
|
| (Threads which have no activity for more than 30 days are automatically closed.) |
| Quick Reply | ||
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Databases for Webmasters | toddc | Content | 2 | 02-24-2007 01:04 PM |
| Databases and Web Content for sale | toddc | Content | 1 | 12-28-2006 12:15 PM |
| Website Content Databases - MySQL & MS Access | odditysoftware | Websites for Sale | 115 | 11-28-2006 08:19 PM |
| Wanted: databases | Lpspider | Want to Buy | 1 | 12-21-2005 10:43 PM |
Linear Mode
