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.
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.
Are you really sure, you clicked ALL Tables, first, so, the BLOG-related selectors where active as well ?
Ernie
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.
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.
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.
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.
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.
If you have root access, I recommend installing automysql backup.
Does daily, weekly and monthly backups and rotates them
Does daily, weekly and monthly backups and rotates them
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
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.
Backup from cPanel. You can do a full backup that way.
Your Local Store.
http://www.frishops.ca
http://www.frishops.cn
Who is online
Users browsing this forum: No registered users and 61 guests