Jump to content

Importing one WHMCS DB into another


web3k

Recommended Posts

Hi Guys,

 

I'm sure this has been covered before, though a search of the forum and via Google hasn't returned the results I'm looking for. Its not so much as an issue, as it is a question;

 

I have two WHMCS installs and I'd like to import one of those, with client all information (including any billing history, support history etc), into the other.

 

Seemingly if its just customer info, it doesn't appear to be too difficult, though I'm looking to bring everything over.

 

Any suggestions?

 

cheers,

 

Andrew

Link to comment
Share on other sites

I don´t get if you want to merge one to another or replace it, so here is what would do on both cases:

 

If you plan to merge it:

 

Open your database on phpmyadmin, select export and choose "data only", after it you will have the SQL´s necessary to store it on another database. The issue here is if you have matching keys on both databases, I would avoid this approach if possible.

 

If you plan to replace:

 

First, you have to upload the /install folder back.

Export your data, and clean up the destiny database, just load your exported data to the destiny database.

This will work as a new install, and you will have to open your /install folder again, to accept the terms of use, after it, remove the install folder again.

 

I never have any problem replacing the database.

 

Hope this help.

 

regards,

Link to comment
Share on other sites

Hi there,

 

Merging the two would be the end result I'm looking for as a I require all of the records from both installations. I understand the concept you've put forward to merge, though I would expect there will be matching IDs.

 

I was hoping this had been attempted before and at best a script was available to do this, though appears not.

 

thanks for your help!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated