I have created a website for a customer on my own webspace with the Abundance theme. Now that the site is complete and the customer is happy with it, I need to migrate it to their own domain.
For some reason when I export the SQL database from my own domain's phpMyAdmin then try to import it in phpMyAdmin on their domain, it will only upload properly if I DON'T change all instances of "www.mydomain.com" to "www.theirdomain.com". In my experience in the past importing "dummy" dumps for templates I've purchased at Template Monster, you need to change the domain in the SQL file they provide.
Is this not how you do it with Theme Forest/Other themes?
If I do change the domain in the SQL file from mine to theirs it just won't import, I get a myriad of "duplication" errors.
Can you tell me why this is and how I should be migrating the site from one domain to the other, please? I've never had this problem before.
FYI - The process I'm undertaking when trying to setup my customised Abundance theme on my customer's domain is:
> Setup MySQL database/user/etc in customer's C-Panel
> Install Wordpress
> Install Abundance
> Install WooCommerce
> "Import Dummy Data" in Abundance Theme Options
> Upload via FTP my reconfigured Abundance theme files (copied from reconfigured site on my FTP)
> Upload via FTP my reconfigured WooCommerce files (copied from reconfigured site on my FTP)
> Upload via FTP my "uploads" folder from "wp-content" (copied from reconfigured site on my FTP)
> [Attempt to] Import SQL exported from my domain (this only works if I leave my own domain URL unchanged in the SQL file which, as you can imagine, causes a million headaches on the customer's domain and when I attempt to change the URLs manually it eventually bombs the whole reconfigured Abundance layout)
Don't know if this might help but another thing I noticed: When I do all of the above on my customer's domain I noticed in their phpMyAdmin that several of the tables I have at my end don't populate on theirs once I've installed Abundance and WooCommerce. All of the tables after "wp_woocommerce_termmeta" are missing (i.e. wp_wpsc_also_bought, wp_wpsc_cart_contents, wp_wpsc_checkout_forms, wp_wpsc_claimed_stock, wp_wpsc_coupon_codes, wp_wpsc_currency_list, wp_wpsc_download_status, wp_wpsc_meta, wp_wpsc_product_rating, wp_wpsc_purchase_logs, wp_wpsc_region_tax, wp_wpsc_submited_form_data).
I was supposed to have the new site uploaded to my customer's domain several hours ago, so any help would be highly appreciated.