*

Alex_PY

  • ***
  • 59 posts
Hello

During the creation of a mySQL backup from the site admin panel, the database backup is created incorrectly. And, as a result, the created mySQL backup cannot be uploaded back to the server. This cannot be done either through the admin panel or through phpMyAdmin. Video:https://youtu.be/H6E0LzUCfew

When trying to restore a site from a backup in the admin panel, the admin panel gives an error: "There was a problem importing the database"
When trying to restore a site from a backup in phpMyAdmin, we get an error:
#1824 - Failed to open the referenced table 'oc8_t_apm_permission'

We have seen that in the created file, the reference to the table goes before it is created - and, apparently, this leads to an error when trying to restore the database later - look at blue screenshot.

I ask you to resolve this issue, because at the moment the backup built into the admin panel does not work at all. As it turned out - a whole month and a half.

Sincerely, Alex.

*

MB Themes

Resolve issue with your backups? What?
Code: [Select]
  FOREIGN KEY (fk_i_permission_id) REFERENCES /*TABLE_PREFIX*/t_apm_permission (pk_i_id) ON DELETE CASCADE ON UPDATE CASCADE

Reference table created in step before.
Restore tables in proper order or disable foreign key checks.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

Alex_PY

  • ***
  • 59 posts
To be honest, I misunderstood your answer. I will ask my programmer to answer you.

*

MB Themes

You do not need to, if you create backup script, you are one that will create it correctly and handle foreign keys in it, or disable foreign key checks at all, or recreate tables in correct order.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

Alex_PY

  • ***
  • 59 posts
We do not create a backup script, but use the regular functionality. it is a regular backup that creates an incorrect file, from which it is impossible to restore the site later, due to the fact that the order of creating tables is incorrect.


*

MB Themes

Most of tables has foreign keys, you get this because it's this one just first in list, then there is another XY others.
As you told, it's feature of differnt tool not related to Osclass itself.
If you are telling that foreign keys must be dropped because your phpmyadmin cannot import tables after export, go for that...
For more support on this check support channels of this tool.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

Alex_PY

  • ***
  • 59 posts
Sorry, but two posts above I wrote to you that we use the standard backup tool from the admin panel. We are backing up tables with the regular backup button - but the regular restore button refuses to accept back the just made backup of tables.

One post above I showed you that it doesn't work after installing your plugin. Specially recorded video.

All plugins are purchased from you. All updated to the latest version. After installing Admin Permissions Manager Plugin, the regular backup does not work correctly.

We have not changed the backup code. Here is a list of all plugins - there are 20 of them. You can check the fact of their purchase on your site by API key.
Domain: mihogar.com.py

« Last Edit: February 10, 2023, 05:13:11 PM by Alex_PY »

*

MB Themes

You need to look for more skilled DBA because what you tell is that you do not know what is foreign key and what that error actually means.
And what is most important, that it is absolutely unrelated to osclass.
Wrong forum at all.
You do not do backup in osclass.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

Alex_PY

  • ***
  • 59 posts
Question: what do you mean when you write that this solution works as designed. Can your backup function back up only the base tables of the cms itself without taking into account the tables of additional modules or what?

*

MB Themes

Backup you talking about is not function of osclass.
You should have backup functionality on hosting level.
Tables must be exported in order that will not interfere with foreign keys, or foreign key check must be disabled.
You cannot import table A that depends on table B, before table B.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

Alex_PY

  • ***
  • 59 posts
Excuse me, but what I show in this video is whose function?

Video:

https://youtu.be/H6E0LzUCfew

*

MB Themes

Its Import SQL file functionality.
You can load i.e. countries or own table from sql.
In backup file you must review how it was generated.
It backup data but does not mean that you can restore it easily.
Anyway we will look how this file is generated and let you know  ;)
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

Alex_PY

  • ***
  • 59 posts
I have two consecutive backups of a SQL database with a range of 1 day.
From the first of them the base is still loaded.
From the second of them - the database is no longer loaded (after installing the Admin Permissions Manager Plugin).
Do you need them to understand the situation? (Screenshot)

If yes, write how to send them to you.



*

Alex_PY

  • ***
  • 59 posts
And, here is a screenshot of my configuration. Is everything here suitable for the correct operation of your products and plugins?