Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : How to restore a full db saved with cpanel usinf phpmyadmin

[cftranslate]

It is easy to use cpanel backup utility on a remote server to save one full database to a local hard disk and then on another server I use cpanel again to restore and 'load' de local gz on the new SQL server.

Even the user prefix is changed automatically to suit the server user prefix used in the database!

locally on my computer I don't have cpanel but phpmyadmin.

How can I restore the full database I saved to a local disk as a gz fle using cpanel so that it is loaded into my home computer SQL server.?

(I have phpmyadmin on my remote servers and on my home computer but I use Apache on windows on my home computer where i just have phpmyadmin not cpanel)

Thanks.

[Captian_Spike]

Go into phpmyadmin and click the query link in the lowerleft corner. Then go to the import files tab and upload the gz file.

A second way to do it is extract the .gz file and open the extracted file with notepad. Then copy everything and paste it in the phpmyadmin query window and run the query.

A third option is doing this right from the command line if you are using mysql on linux.

The reason I gave three ways is the first sometime won't work with some compression methods, the second works only with a database that isn't to big, the third would work in all cases.