Post by dazthephot » Mon Jul 16, 2012 8:00 pm

Hi all, i have been contacted by my Host to say that they are shutting down the database where my opencart store lives and i should migrate the content onto a new msql database.

i can probably do it using php myadmin but which files in the opencart installation will have to adjusted with the new database name?

i tried recently on a coppermine picture database i manage but i was unsuccesful. This store i have is a commercial one i run for a client and would be devastated if i lost the store contents.

any help would be appreciated.

store is khinteriorsltd.co.uk/ocart

regards

daz

New member

Posts

Joined
Tue Jul 05, 2011 6:31 pm

Post by bigchili » Mon Jul 16, 2012 8:04 pm

The only files you would need to update with the new database name and password are the config.php and admin/config.php files.

As for the database itself, if you have cPanel, you can just go to backups and make a database backup there.

If you go into the OpenCart admin panel, System --> Backup / Restore, you can also backup the database contents from there.

User avatar
Active Member

Posts

Joined
Wed May 16, 2012 3:00 am


Post by dazthephot » Mon Jul 16, 2012 8:14 pm

thanks bigchilli

i do use the backup facility within opencart and i have downloaded the store via ftp very recently.

the contents of the store, i.e products, are they held within the database or does something in the database point to where the products are in a folder inside OC? i'm thinking about all the information linked to a product, price, description etc

i also have a category based shipping extension running, would that be affected?

New member

Posts

Joined
Tue Jul 05, 2011 6:31 pm

Post by bigchili » Mon Jul 16, 2012 8:22 pm

dazthephot wrote:the contents of the store, i.e products, are they held within the database or does something in the database point to where the products are in a folder inside OC? i'm thinking about all the information linked to a product, price, description etc
All the product info is in the database. Only thing I can think is product images, but as long as those pathways stay the same you shouldn't have a problem.
dazthephot wrote:i also have a category based shipping extension running, would that be affected?
Shouldn't be.

User avatar
Active Member

Posts

Joined
Wed May 16, 2012 3:00 am


Post by dazthephot » Mon Jul 16, 2012 8:31 pm

you're a star, thank you.

i'll be sure to post my progress incase anyone else encounters this.

regards

New member

Posts

Joined
Tue Jul 05, 2011 6:31 pm

Post by dazthephot » Sat Jul 21, 2012 12:39 am

Progress - success!

Had to get a bit of help as phpmyadmin kept timing out and only exporting half the tables. SQL administrator did a better job then the import went smoothly.

Once the config and admin/config files were altered with the new DB name and password all was well.

thanks again.

darren

New member

Posts

Joined
Tue Jul 05, 2011 6:31 pm

Post by elion » Tue Jul 24, 2012 10:45 pm

I usually did this by using cpanel->phpmyadmin, export the structures of the 'old' DB including the data, and import the structure and data to a new DB, and them edit the config.php and admin/comfig.php swithing 'old' DB to the 'new' DB. when importing, some hosts only let you to import little files, so in this stituation, i have to seperate the exported file (.sql)into several small sql files.

Newbie

Posts

Joined
Thu Dec 17, 2009 9:06 pm

Post by ungury » Sun Jul 29, 2012 10:02 am

Hello. I´m very new to this. I have two sites, one is in a older opencart version, and the new one with 1.5.3.1,I had decided to have different admins for design purposes. I already understood by your postings, how to back up a database, so now my question is How do you install the database to the new site? Please provide me with simple steps if you could, since I´m really a novice into this. Thanks a Lot! =)

Newbie

Posts

Joined
Sat Jul 28, 2012 11:27 am

Post by myroto » Mon Aug 06, 2012 9:36 am

I have the same question as ungury. Please help!

Newbie

Posts

Joined
Mon Aug 06, 2012 7:04 am
Who is online

Users browsing this forum: No registered users and 8 guests