Post by alvin20031010 » Tue Feb 24, 2015 12:45 am

I just re-installed an Opencart with a brand new database, and I'm wondering how to replace the date from my previous database?

New member

Posts

Joined
Fri Feb 06, 2015 4:36 am

Post by IP_CAM » Tue Feb 24, 2015 3:03 am

Read here:
http://forum.opencart.com/viewtopic.php ... 00#p545100

But if you have fully 'installed' the OC with a clean, but 'default cat/product preloaded' DB, I would advise to delete (drop) ALL TABLES of the now existing 'new created' DB, before 'importing' YOUR OLD DB with the valid Category/Product/Customer Data Tables according the instructions, given on the linked Page, mentioned.

This way, you have a DB, just like newly created, but still fully empty as such, waiting to be filled with the content of your Backup from your old Server. The import procedure itself may take a while, so just keep calm...

Ernie
bigmax.ch/shop/
PS. I just realized, I'm in the v.2.x Forum..., but it should work the same, anyway...

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by alvin20031010 » Tue Feb 24, 2015 1:57 pm

Thanks for your reply.

for what i did is.
1. Re-install a fresh Opencart on a new database. (same domain, same host, only different name of database.)
2, Drop all the tables in the new database.
3. Import the backup.sql from my previous database.
4. everything look fine, except my host sent me an email said failed to connect to the "Old database", access denied. and ask them to perform a codeguard resource sync.

does anybody know what is happening?
Thanks

New member

Posts

Joined
Fri Feb 06, 2015 4:36 am

Post by IP_CAM » Wed Feb 25, 2015 9:51 am

Did you upload the same version Opencart as you worked with before?
Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by alvin20031010 » Wed Feb 25, 2015 11:28 am

yes, exact the same version

New member

Posts

Joined
Fri Feb 06, 2015 4:36 am

Post by IP_CAM » Wed Feb 25, 2015 12:09 pm

Did your Hoster already delete the Site, or do you really still have Access by use of the Server Admin Section MySql Admin? Why should you receive a Mail from the Hoster, if you just face a tyoe of connection problem, other than beeing seemengly CUT from access it ?! At least, if you Reupload the 'old' DB from your PC...

Funny, very funny, did you BACKUP/Download to DB in FULL, as requested?

Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by alvin20031010 » Wed Feb 25, 2015 12:34 pm

Image
This is what i received, and I don't have any problem to access my hosting account so far.
Just wondering do i have to delete my old database?

New member

Posts

Joined
Fri Feb 06, 2015 4:36 am
Who is online

Users browsing this forum: No registered users and 48 guests