Finding the MySQL file in a cPanel backup

woodland

• January 15, 2018 12:22

Hi, first post I am trying to restore a wordpress site from a "cpmove-xxxx" file. The cPanel from which this cpmove file was made hosted the Wordpress site. The new server which i am moving the site to does not have cPanel installed. I am trying to upload the contents of the mySql database to phpMyAdmin. Is there i file in cpmove-xxxx from which i can get the database from the wordpress site?

• 

  cPWilliamL

  • January 15, 2018 20:08

  Hi @woodland, You may find the MySQL dumps in the '/mysql/' directory of the extracted backup. In the command below, we are just looking in the archive for files/directories that match "*mysql*sql", without actually extracting: # tar -tf /home/cpmove-cptest.tar.gz *mysql*sql cpmove-cptest/mysql/cptest_testdb.sql cpmove-cptest/mysql-timestamps/mysql cpmove-cptest/mysql.sql
  In the below example, we extract the archive for files/directories that match "*mysql*sql", then change to the desired directory, and list its contents: # tar -zxvf /home/cpmove-cptest.tar.gz *mysql*sql cpmove-cptest/mysql/cptest_testdb.sql cpmove-cptest/mysql-timestamps/mysql cpmove-cptest/mysql.sql # cd cpmove-cptest/mysql # ls cptest_testdb.sql
  Thanks,

  0
• 

  woodland

  • January 15, 2018 22:19

  My cpmove-xxxx/mysql does not contain the database however in homedir and subfolders i have several different .sql files. Could anyone of these be the database dump?

  0
• 

  cPWilliamL

  • January 16, 2018 13:39

  Those may actually be user-made MySQL dumps. I can't be sure if those are what you need, but '.sql' files are certainly database dumps. If the stamps are recent, and the filename matches your database, then those are likely useful. If the database was present under the cPanel user at the time of the backup, then the MySQL dumps should be found in the '/ mysql/' directory.

  0
• 

  Abetum

  • January 18, 2020 13:41

  Doing a site restore with only a full cPanel backup. We can"t find the Mysql database and file. The host provider also checked and couldn't see the sql file. There is a folder "new_table_from_mysql" is the one? Also these files: mysql_collation.php mysql_compressed_rows.php mysql_engine.php mysql_sql_generator.php mysqli_native_moodle_recordset.php mysqli_native_moodle_temptables.php Please assist.

  0
• 

  HostNoc

  • February 22, 2020 08:38

  Will you please let us know the Backup you generated from Cpanel did not have any error? Also can you make sure Database exists on Cpanel from where you generated Backup.

  0

Please sign in to leave a comment.