Restore a zpanel backup on LEMP

October 22, 2014 2.5k views

How can I restore my website from a zpanel-backup into LEMP stack?

  • I'm on Centos 7 with LEMP stack
  • the Zpanel backup contains ( database-backup.sql and the website folder)
1 Answer

Transfer the mysql dump to your droplet and import it:

mysql -u root -p database-name < /path/to/database-backup.sql.sql

Then create a MySQL user for your site: How To Create a New User and Grant Permissions in MySQL | DigitalOcean.

Finally, copy the files to /var/www or /var/www/html (depending on your setup) and you should be good to go.

by Etel Sverdlov
MySQL is a powerful database management system used for organizing and retrieving data. This tutorial explains how to to create new MySQL users and how to grant them the appropriate permissions.
Have another answer? Share your knowledge.