Post by dom44 » Sat Aug 13, 2016 11:05 am

Hi,

I just used the backup tools on opencart to back up my database while I was fixing some problems.
Now when I restored the database a lot of information has not come out.
For example my blog, which was a module.
So my question is, is the backup supposed to back up the whole database or does it leave out tables that were made from modules.
Because if that is the case, I just screwed myself.

Even my products have disappeared.

New member

Posts

Joined
Thu Jul 16, 2009 6:54 am

Post by IP_CAM » Sat Aug 13, 2016 11:17 am

Are you really sure, you clicked ALL Tables, first, so, the BLOG-related selectors where active as well ?
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 dom44 » Sat Aug 13, 2016 12:49 pm

Thanks for the reply.

Yes, I checked all the boxes. After viewing the data in the sql fie, all the data was there. However restoring the data via the oc control panel did not put back all the data because some tables needed to be created. I did this manually and now everything is in order.

For the future, I would find it much easier to use phpmyadmin and export the sql.

New member

Posts

Joined
Thu Jul 16, 2009 6:54 am

Post by OSWorX » Sat Aug 13, 2016 6:58 pm

Just to explain that issue a bit:

the internal tool Backup is doing a full backup of all records of those tables which are checked!.
But (!) it exports only the data (records), not the commands to (re)create the tables.

So, whenever a 'Full' backup (tables and records) is needed (usually once a week) a tool like phpMyAdmin or other is the proper tool to use.
Specially when additonal extensions are installed, because they may need extra tables.

Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.


User avatar
Guru Member

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by uksitebuilder » Sat Aug 13, 2016 7:28 pm

If you have root access, I recommend installing automysql backup.

Does daily, weekly and monthly backups and rotates them

User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by IP_CAM » Sun Aug 14, 2016 2:53 am

And for those, looking for an even more complete Full Shop Backup-Solution, I assume, something
like this would do the Job well. But it does not come for free, like most well done things on earth.
But since Shop DB Backup Security is the upmost important Matter, it's wise to make sure, to have a
full DB available, not just it's Data, in Case, something goes wrong. Another easy thing to do, would be,
to regularely move the entire DB-Content (by MySql Admin/Functions) into a Copy of the DB, then, one
only has to switch config.php Links, to have a running Shop-DB online again in a minute.

Backup Pro for Opencart 2.0
http://www.opencart.com/index.php?route ... n_id=19334
---
Or then, one possibly uses a Server, offering this kind of Service, as found described here,
probably a similar way of doing it, as uksitebuilder described above, I guess,
but I never checked for such yet on my Server.
How to Fully Backup OpenCart
http://www.antropy.co.uk/blog/opencart-backup-restore/
---
And if one is able, to make some (not much!) v.1.5 code usable for v.2.x, in order to avoid
cost, the good old Opencart Scheduled DB Backup v1.1 up to v.1.5.6.5_rc Versions,
is still available on the Web.:
http://www.openshop.li/downloads/schedu ... p_v1.1.zip
Just to mention it! It does it's Job well, but I am not even sure, if the backup again would create tables, if they do
not exist, I have to check on this. I only customized my thing (shown) with a 'select all' option, after finding
it boring, to click on all 122 tables individually, after installing it somewhere... :-*

Just figured... ;)
Ernie
Last edited by IP_CAM on Tue Jul 03, 2018 7:49 am, edited 1 time in total.

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 frishops » Mon Aug 15, 2016 2:36 am

Backup from cPanel. You can do a full backup that way.

Image

Your Local Store.
http://www.frishops.ca
http://www.frishops.cn


New member

Posts

Joined
Tue Sep 15, 2015 5:58 am
Location - Quebec, Canada
Who is online

Users browsing this forum: No registered users and 61 guests