How to restore mysql Database from cpmove file through SSH | Web Hosting | Domain Registration | Wordpress Hosting | SSL Certificates

How to restore mysql Database from cpmove file through SSH

I have been asked a few times how to extract the mysql databases from cpmove cPanel files without extracting the full tar. 

tar -zxf navicosoftahostingcompany.tar.gz navicosoftahostingcompany/mysql;
mysql navicosoftahostingcompanydb < navicosoftahostingcompany/mysql/navicosoftahostingcompanydb.sql




If you want to create a for loop for achieving mysql databases from cpmove files, please use the following script to do so:


 for a in *;
do filenamewithonedot="${a%.*}";
filename="${filenamewithonedot%.*}"; 
tar -zxf $a $filename/mysql;mv $filename/mysql/*.* /home/abubakarsql/mysql --force;
echo $filename;
done;


Cheers!

SHARE