Post by Garret H » Sun Mar 25, 2012 4:17 am

Hello,

So, I'm trying to move a store from one web account to another. The store was previously set up using Arvixe and I am moving it to a different hosting provider. I want to basically copy the entire store from Arvixe and move it to the new host, but I can't figure out how. I am running 1.5.1.3.1 and have installed that version on the new host...how do I go about copying my products, categories, and customers over to the new store? Any help you can provide is appreciated!

Thanks,
Garret

New member

Posts

Joined
Wed Jan 25, 2012 12:20 am

Post by rph » Sun Mar 25, 2012 6:34 am

Copy over all the images you have in the /imags/data folder. Then export your database through OpenCart's backup feature or phpmyadmin and restore it on your new website.

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by Garret H » Sun Mar 25, 2012 8:46 am

Thanks for the info. I already tried doing that but keep getting this error:

Notice: Error: Table 'localho3_wingmanrc.oc_address' doesn't exist
Error No: 1146
TRUNCATE TABLE `oc_address` in /home2/localho3/public_html/wingmanrc.com/system/database/mysql.php on line 49

Do the databases need to both have the same name, username, and password?

Garret

New member

Posts

Joined
Wed Jan 25, 2012 12:20 am

Post by amdev » Sun Mar 25, 2012 10:53 am

Garret H wrote:Thanks for the info. I already tried doing that but keep getting this error:

Notice: Error: Table 'localho3_wingmanrc.oc_address' doesn't exist
Error No: 1146
TRUNCATE TABLE `oc_address` in /home2/localho3/public_html/wingmanrc.com/system/database/mysql.php on line 49

Do the databases need to both have the same name, username, and password?

Garret
No , just creat a new database then import an old database to new db.
Check your config.php and admin/config.php

Code: Select all

// DB
define('DB_DRIVER', 'mysql');
define('DB_HOSTNAME', 'localhost');
define('DB_USERNAME', 'root'); //change to new db user.
define('DB_PASSWORD', 'root');//change to new db pwd.
define('DB_DATABASE', '152f');//change to new db name.
define('DB_PREFIX', '');//relate to old config.php

ร้านค้าออนไลน์
OpenCart Thailand Support Forum
How to Upgrade oc1.5 to 2.0.1.1
Upgrading OpenCart From v.1.4 or v.1.5 to V.2.2 Step by step


User avatar
Active Member

Posts

Joined
Fri Nov 27, 2009 3:40 pm
Location - Bangkok - Thailand

Post by Garret H » Tue Mar 27, 2012 2:13 am

Thanks for the help. Got it all done.

Garret

New member

Posts

Joined
Wed Jan 25, 2012 12:20 am

Post by ukracer » Sun Nov 11, 2012 10:01 am

amdev wrote:
Garret H wrote:Thanks for the info. I already tried doing that but keep getting this error:

Notice: Error: Table 'localho3_wingmanrc.oc_address' doesn't exist
Error No: 1146
TRUNCATE TABLE `oc_address` in /home2/localho3/public_html/wingmanrc.com/system/database/mysql.php on line 49

Do the databases need to both have the same name, username, and password?

Garret
No , just creat a new database then import an old database to new db.
Check your config.php and admin/config.php

Code: Select all

// DB
define('DB_DRIVER', 'mysql');
define('DB_HOSTNAME', 'localhost');
define('DB_USERNAME', 'root'); //change to new db user.
define('DB_PASSWORD', 'root');//change to new db pwd.
define('DB_DATABASE', '152f');//change to new db name.
define('DB_PREFIX', '');//relate to old config.php

What if you have several mods installed can you just copy the Open cart directory across to the new server after installing a new basic installation??

Active Member

Posts

Joined
Wed Oct 03, 2012 6:36 am

Post by bigpapa78 » Sun Jul 28, 2013 3:49 am

Am getting following error:
Notice: Error: Table 'newopencart.address' doesn't exist
Error No: 1146
TRUNCATE TABLE `address` in /var/www/clients/client7/web7/web/opencart/system/database/mysql.php on line 50
I have tried moving opencart to new database but no success. Any suggestion would be great. Thanks

interracial dating


Newbie

Posts

Joined
Sun Jul 28, 2013 3:32 am

Post by uglyeoin » Wed Apr 29, 2015 6:19 pm

I get the same error, it won't let me import the database

Newbie

Posts

Joined
Mon Jun 23, 2014 5:13 pm
Who is online

Users browsing this forum: No registered users and 16 guests