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.
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 !
copy_database.jpg (420.6 KiB) Viewed 69 times
For Sale: Turnkey URLs with Opencart installed
My present Opencart Testsite: http://www.velomech.ch/shop/
Attacker IP Blocks are denied from further access to my Sites!
Just contact me for more Information at: email@example.com
666 FREE OC Extension-Repositories - from OC v.1.5.x up
on the largest Opencart-Mod Github Site: https://github.com/IP-CAM
Users browsing this forum: No registered users and 10 guests