Restore Backup MySQL .idb .frm Files

zlesavich

Member
Aug 11, 2014
14
0
51
cPanel Access Level
Root Administrator
I recently extracted the MySQL backup files for all existing databases from a cPanel backup. What is the procedure to restore those to a new server? They're a bunch of folders with .idb and .frm files.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,216
363
Hello :)

It looks like you restored an entire MySQL directory based on the information you have provided. It's a better idea to restore the accounts with databases included so that database ownership is properly assigned during the account restore.

Thank you.
 

zlesavich

Member
Aug 11, 2014
14
0
51
cPanel Access Level
Root Administrator
Hello :)

It looks like you restored an entire MySQL directory based on the information you have provided. It's a better idea to restore the accounts with databases included so that database ownership is properly assigned during the account restore.

Thank you.
That's an interesting thought... but I didn't do that at all. I THOUGHT the database backups would stay within the tar file of each individual account but they were just dumped in the system files backup. Very inconvenient. I'm asking how do I restore this folder of files now without disrupting the rest of the services that use MySQL?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,216
363
To clarify, in "WHM Home » Backup » Backup Configuration", please let us know which of the following options you selected:

Per Account Only
Entire MySQL Directory
Per Account and Entire MySQL Directory


Thank you.