Post by andywoodrow » Mon Oct 15, 2018 5:37 am

Hi,

I've copied the current site from the root folder into a dev folder and created a sub-domain, so that I can work on some major work on dev.domainname.com without messing with the production site, but I would also like to do the same with the DB.

I've already backed up the sql DB from the admin panel and I have created a new database on the remote server (dev-cl44-ocart (current production DB is cl44-ocart), but how do I import a copy of the production DB into a new table, so that the dev.domainname.com site will make changes to the dev-cl44-ocart and not the production one. I'm aware I also need to update the config in both root and admin folder.

I'm using phpmyadmin btw.

Cheers,
Andy

New member

Posts

Joined
Mon Nov 02, 2015 5:48 pm

Post by IP_CAM » Mon Oct 15, 2018 7:33 am

Well, instead of doing this the IMCOMPLETE way, since your Admin Function
does NOT fully download a working DB, better COPY the DB with your Server Admin
MyPHP DB Tool into another new DB, directly, and IN FULL !
Ernie
---
Image Link:
download/file.php?mode=view&id=35782

Attachments

copy_database.jpg

copy_database.jpg (420.6 KiB) Viewed 60 times


For Sale: Turnkey Top Domain URLs with Opencart installed!
My latest OpenShop enhanced OpenCart 1.5.6.5 V-Pro: http://www.velomech.ch
For detailled Information on URL's, please contact me at: jti@jacob.ch
Hundreds of Mods in 420+ Repositories for OC v.1.5.x - v.3.x
to be found for free on my Github Site: https://github.com/IP-CAM
Image


User avatar
Legendary Member

Posts

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

Users browsing this forum: No registered users and 61 guests