Lost my MySQL database. OpenCart has current product data, can I restore Opencart?

Lost my MySQL database. OpenCart has current product data, can I restore Opencart?

Avatar image
Apr 04, 2014
ceilingFansHawaii wrote
I have been working on setting up an ecommerce website using Opencart and EmagicOne. Something happened with my webhost and my MySQL database was lost/damaged. I didn't make any backups. My webhost was able to restore an earlier version of my Opencart database, but the copy they restored was over 1 week old and I lost some data.

eMagicOne has the most up-to-date product information, but I can't find a way to "synchronize" my MySQL database to match was is in eMagicOne.

Any ideas on what I can do?
Reply
2 Answers
Avatar image
Apr 04, 2014
ceilingFansHawaii wrote
The subject of my post should read "EMAGICONE has current product data."
Avatar image
Apr 07, 2014
Tania Parashchuk agent wrote
Thank you for your post.

Store Manager is a desktop application and it connects to your store database remotely, using one of 3 connection types: direct, bridge or HTTP tunnel
You need to use your FTP details and store url to set up the connection
Then you may start working with your database.

Direct is the type of connection when Store Manager connects directly to your database, and all the changes you perform in Store Manager will be applied automatically

While working through bridge you must store your temporary data somewhere in local database. Bridge.php is used only for two major operations - getting data from remote database and posting data to that database. You have to understand the difference between Bridge connection and MySQL connection. Bridge.php is not a connection itself, actually this is just a way to transfer data between remote and local machine and nothing else.
With bridge connection you should always synchronize your local and remote databases

HTTP tunnel connection is like direct connection - changes will be applied automatically.

In case you use bridge connection - in this case - every time you start working with Store Manager you need to perform 'Get data from the web' operation firstly, then make changes, and only then press on 'Post data' button.