OpenCart Community

Hi I need to move everything to a new domain, all products categories etc, I have installed opencart on my new domain but how do I transfer everything please.

Export the database using myPHPadmin at your old domain and from the new domain do an import, these will import all tables and information saved to them.

Hi Daydreamer,

Just did this for four sites!

What worked for me was:
1. Zip up the entire site in cPanel (if you have it) or copy the site using ftp to your local machine
2. As the other poster pointed out, export the database with myPHPadmin (use a zip file).
3. Create the database on new server.
4. Import the data into your new database using the zip file and myPHPadmin.
5. Unzip your site in the desired server folder.
6. Update the configuration files config.php and admin/config.php to reflect your new domain path.

Worked for me! so far...

daydreamer wrote:Hi I need to move everything to a new domain, all products categories etc, I have installed opencart on my new domain but how do I transfer everything please.

I found this post when searching for doing the opposite- i.e., moving from my local machine to my live host.
I did the same as was advised here, but when I try to go to the shop I get:

Warning: require_once(home/xxxxxxxx/public_html/demostall/system/startup.php) [function.require-once]: failed to open stream: No such file or directory in /home/xxxxxxxx/public_html/demostall/index.php on line 12

Fatal error: require_once() [function.require]: Failed opening required 'home/xxxxxx/public_html/demostall/system/startup.php' (include_path='.:/usr/lib/php') in /home/xxxxxxxxxx/public_html/demostall/index.php on line 12

Line 12 is to do with register globals ( which is OFF on my host, but was ON on my local machine). I really don't understand much of all this, I sorta do stuff by trial and error learning.
I tried changing and even removing the php.ini that seemed to be where the problem is...made no difference.
I'm not sure what the " (include_path='.:/usr/lib/php')" bit means either.

Any advice/help would be gratefully received.
This is my first messing about with OpenCart- I've tried pretty much the whole A-Z of carts, and OpenCart is proving to be one of the best so far. ( All it seems to "lack" is a way to handle inventory with multiple attributes, but that's no real biggie really)

HI imaginetech,

Thank you very much for your post. It was very useful and my transfer worked very smoothly.

Kd

I had a similar problem to phoenixinOz, in that my links were trying to go to the old URL no matter what I changed in the config files.
In an attempt to try and fix it I uploaded the install directory and the original index.php and config.php files from the installation package.
I then went to my root URL and proceded with the installation procedure. (I noticed magic quotes gpc was set to 'on' at this stage so I turned it 'off' - perhaps this was causing the whole problem in the first place?)
Once I installed it I then deleted my database and recreated it before imported the original backup back into it and the whole thing started working properly again.

Hope this helps anyone who has the same issue.

See tutorial in the wiki: http://wiki.opencart.com/index.php?title=Moving_Website

Just an FYI the above link doesn't work. It auto redirects you to this URL which doesn't help:

http://search.dnsadvantage.com/main?Int ... entation=0

I'd sure like to know the answer myself since I too am having the same issue.

You need to change the store URL from the admin settings BEFORE you move to the new domain. Go to Admin - > System - > Settings . Change the store URL to your new domain. And then move them to the new domain. Am sure if you are having the URL issues, it means its too late. You might need to connect your oc on the old domain to the database and update it.

Probably one of the experts can tell us where to change in the database if we don't have access to the admin anymore?

Table: setting
Look for the key: config_url

But you should be able to access always the backend.
And then goto to settings and change the store URL (same as yo uwould change it directly in the database).

btw.: most of all these troubles come if the URLs in both config.php are NOT adopted!
This must be done BEFORE calling the new site (just edit both and change the URL).

OSWorX wrote:Table: setting
Look for the key: config_url

But you should be able to access always the backend.
And then goto to settings and change the store URL (same as yo uwould change it directly in the database).

btw.: most of all these troubles come if the URLs in both config.php are NOT adopted!
This must be done BEFORE calling the new site (just edit both and change the URL).

Thanks.

Hi guys,

I have a slightly different problem. I was using a domain to build up the store, but now i want to change the name (domain). I am using paid hosting and they said that MySQL database will stay untouched. So my question is when they (hosting company) change the main domain to be the new one will that affect the store??

in 2 words: hosting and everything stays the same, only the name goes from example.eu to example.bg

Please help!

KuriN wrote:Hi guys,

I have a slightly different problem. I was using a domain to build up the store, but now i want to change the name (domain). I am using paid hosting and they said that MySQL database will stay untouched. So my question is when they (hosting company) change the main domain to be the new one will that affect the store??

in 2 words: hosting and everything stays the same, only the name goes from example.eu to example.bg

Please help!

As already written, the postings above are also valid for you!

Ok, but do I have to export with phpmyadmin the SQL database. Because the hosting company said that they wont change anything. It's only the domain that changes, everything else stays the same!

KuriN wrote:Ok, but do I have to export with phpmyadmin the SQL database. Because the hosting company said that they wont change anything. It's only the domain that changes, everything else stays the same!

No export.
You can leave the database as it is, except the 'config_url' which must be adopted.

Sorry to bother you again, Im new to this. I tried searching on the net about adopting the config_url, but found nothing. How to do that? I realize that i sound stupid to you guys, sorry...

A few posts above: http://forum.opencart.com/viewtopic.php ... 26#p129093

KuriN wrote:Sorry to bother you again, Im new to this. I tried searching on the net about adopting the config_url, but found nothing. How to do that? I realize that i sound stupid to you guys, sorry...

Hello KuriN.

You can safely move your files to your new domain. Or whatever approach your host will use if they do it for you. After getting your files to the new domain, you will notice that the links are all pointing to your old site. What you need to do, in addition to changing the configuration files as below,

6. Update the configuration files config.php and admin/config.php to reflect your new domain path.

, is to go to phpmyadmin, your opencart database, and look for the table 'setting'. Find 'config_url', and click on edit. Change the domain to your new domain. And all will be working fine.

Hope that's clear and don't worry, you can ask again if it's not!

Thanks for the help bajaber, that is what i didn't get! Now I understand...

I am waiting for the DNS to refresh and the new domain to be active. I will post if everything goes well...

Thanks for the help!

thanks very much, now i can get my host work