My SQL

[aminthakkar]

Hi

If I have backup for MySQL database in .gz and .sql format and I want to upload databse how do I restore ?

Amin

 

[Triloxigen]

phpMyAdmin or with root access

 

[aminthakkar]

I have root access and phpmyadmin. Can you tell me in detail how do I upload database and users by command SSH?

Amin

 

[Cranky]

Upload SQL file, then run:

mysql -Ddatabase-name-here -uadmin -pplesk-password-here < databasedump.sql