Welcome Guest ( Log In | Register)



 
 Reply to this topicStart new topic
> Mysql Database Copying
kery
post Apr 24 2007, 06:56 PM
Post #1


Newbie [Level 2]
**

Group: Members
Posts: 31
Joined: 22-April 07
Member No.: 42,034
Is there anyway to merge 2 databases? I have an XOOPS and SMF both installed with Fantastico, and the bridge is not working like the Joomla! one does. (with the seperate db capability)

i know how to transfer all the tables by hand but depending on how much data you have stored in mysql could take a long time.

Take short time!? Help me!

(list)

Go to the top of the page
 
+Quote Post
imacul8
post Apr 25 2007, 08:34 PM
Post #2


Member [Level 3]
******

Group: Members
Posts: 95
Joined: 21-May 06
From: Adelaide, Australia
Member No.: 24,017
Try this link - Merging MySQL Databases

Hope this helps smile.gif

(list)

Go to the top of the page
 
+Quote Post
kery
post Apr 26 2007, 07:02 PM
Post #3


Newbie [Level 2]
**

Group: Members
Posts: 31
Joined: 22-April 07
Member No.: 42,034
Thanks you!
Yesterday, I read 'Merging MySQL Databases' and merged 2 databases. Although It isn't easy!
Thanks again!

(list)

Go to the top of the page
 
+Quote Post
SamiFX
post Apr 28 2007, 09:02 PM
Post #4


Super Member
*********

Group: Members
Posts: 219
Joined: 3-February 07
From: Algeria
Member No.: 38,241
There is an easy way... use Export tables in the second database then go to the first database and Import that exported Sql file.. after that change the database name in the configuration file of the script that uses the second database smile.gif simple

(list)

Go to the top of the page
 
+Quote Post
Adam Roethburg
post Jun 24 2007, 09:06 PM
Post #5


Newbie [Level 3]
***

Group: Members
Posts: 45
Joined: 24-June 07
Member No.: 45,386
Thanks, this helped me much!

(list)

Go to the top of the page
 
+Quote Post
« Next Oldest · Database · Next Newest »
 

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Need Help With My Database [resolved](6)
  2. Is The Database System Gone Again? [resolved](12)
  3. Complete Login System(56)
  4. Database Or Pdf(1)
  5. Qupis : Free Hosting With Php, Mysql, Cpanel. (one Line Text Ad At Bottom)(41)
  6. Database With Mysql++(7)
  7. Import From Excel File Into Mysql Database(7)
  8. Html Form!(4)
  9. Mysql Won't Update(4)
  10. How Do I Find My Mysql Password? [resolved](5)
  11. Mysql-essential-5.0.51 Installion Problem(2)
  12. Please Explain Me Mysql(4)
  13. Remote Access Mysql(8)
  14. Mysql Database Size(6)
  15. Is It Possible To Access The Mysql Remotely?(10)
  1. Phpmyadmin(6)
  2. Check Referrer To Prevent Linking Yours From Other Sites(8)
  3. Create Table - Mysql Code - Help(1)
  4. Tools Needed!(9)
  5. Mysql(2)
  6. Mysql Error(3)
  7. Connect To Remote Oracle Database With Toad(6)
  8. Mysql + Php Question(5)
  9. How To Manage The Database For E-books Website In My Sql?(3)
  10. Best Php And Mysql Editor For Noobs(6)
  11. I Need Help Transferring Sql Database?(3)
  12. Learning Mysql(3)
  13. Can You Add Images Into A Mysql Database?(20)
  14. Installing Apache, Mysql, Phpmyadmin Locally(5)
  15. Php And Mysql Programming(2)


 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

- Lo-Fi Version Time is now: 26th July 2008 - 08:32 AM
Powered By IP.Board © 2008  IPS, Inc.
Licensed to: Xisto Corporation