How to find the MySQL backup?

Avatar
  • updated
  • Answered

Doing a site restore with only a full cPanel backup. Unfortunately we didn't do partial backups and the host provider deleted our data. We can’t find the Mysql database and file. How do we find it? The host provider also checked and couldn’t see the sql

Avatar
JT S.
Quote from Abetum

Hi. We do see this file. Is it the one?

oci_native_moodle_package.sql

There is a folder "new_table_from_mysql" is the one? Also these file:
mysql_collation.php
mysql_compressed_rows.php
mysql_engine.php
mysql_sql_generator.php
mysqli_native_moodle_recordset.php
mysqli_native_moodle_temptables.php

The .SQL file would likely be a database file. You can open the file in a text editor or import it to test it.

Avatar
-2
Abetum

Hi. We do see this file. Is it the one?

oci_native_moodle_package.sql

There is a folder "new_table_from_mysql" is the one? Also these file:
mysql_collation.php
mysql_compressed_rows.php
mysql_engine.php
mysql_sql_generator.php
mysqli_native_moodle_recordset.php
mysqli_native_moodle_temptables.php

Avatar
-2
Arnel C
  • Answered

Hello Abetum,

Sorry for the issue with your MySQL database.  A full cPanel backup includes MySQL databases, unless the host doesn't configure that way.  Here's a screenshot of the cPanel backup wizard:


If your provider deleted your data, and your back up file(s) do not include the database file, then you will not be able to recover it.  The database file will typically end in ".sql"  If you see that file, then you may have a copy of the database already.  We unfortunately cannot help much with a third party backup where the original data has been deleted.  You will need to speak with the support team for that host to see if they have backups that can provide the deleted files for you.

If you have any further questions or comments, please let us know.


Kindest Regards,

Arnel C.