Database backup in the bluetronix CMS – this is how you easily restore damaged tables
In this tutorial, you will learn how to use database backups in bluetronix CMS to quickly restore damaged tables. Whether it's a blog or shop – with automatic backup, you are always on the safe side.
Database backup: quickly restore damaged tables
In this tutorial, I will show you how to restore damaged database tables using the automatic backup function. Whether in the blog or in the shop – you can choose a backup at any time and restore the desired table.
When should you use a backup?
Use a backup when something goes wrong during import (e.g., wrong columns), an update has damaged articles, or you have accidentally deleted data. A restore will revert to the selected table state.
How the automatic backup works
The system creates automatic backups for each table – seven consecutive days. For example, you can choose the state from yesterday and restore the table.
Step by step: Restore backup
Open the Database ⯈ Backup section in the menu. Select the desired table (e.g., Blog or Shop), find the appropriate date, and click Restore. Confirm the process – the table will be reset to the selected state.
Import/Export as an alternative
If you have previously exported, you can correct the file (e.g., shop_export.csv) in Excel and import it again. During import, you can specify whether existing records should be replaced or only new ones added.
For developers: additional options
Developers have the option to execute their own MySQL commands. More details can be found in the video MySQL Records for Developers.
Important: Before larger imports or mass changes, it is advisable to manually create a backup. This way, you can restore the exact initial state at any time.
Conclusion
The backup function protects you from data loss: choose table, date, and restore – that's it. This way, you can quickly restore blog or shop tables to the desired state.
FAQ
what customers often ask us
When should I use a database backup?
A backup makes sense if you made a mistake during import, swapped columns, or an update in the shop or blog led to corrupted data. With the backup function, you can easily restore the affected table.
How do I access the backup area?
Switch to Database ⯈ Backup in the menu. There you will find all existing backups for your tables. Select the desired table, for example, Blog or Shop, and open the backup area.
How do I restore a backup?
Choose the desired date in the backup area, e.g., the state from yesterday, and click Restore. The selected table will be reset to this state – very easy and without technical knowledge.
How often are automatic backups created?
The system automatically creates seven daily backups for each database table. This way, you can easily access previous versions and select the appropriate state.
Can I also restore shop data?
Yes, the restoration works the same for all tables – even within the shop. For example, if you made a mistake during article updates, you can easily reset the shop using the backup function.
What happens to my current data after restoring?
During restoration, the table is reset to the selected state. Newer changes will be lost in the process. If you want to keep data, export it first as a CSV file.
Can I create a manual backup before an import?
Yes, that is recommended. Before making major changes or an import, create a manual backup so that you can restore the old state of your database at any time if errors occur.
What should I do if the import didn't work?
If the import fails or incorrect columns are assigned, you can easily restore the state before the import via Database ⯈ Backup. This way, your database remains fully functional.