Back up and restore a database with phpMyAdmin
Export your tables to an SQL file and import them again on another site or server.
Export
- Open phpMyAdmin in cPanel and select your database on the left.
- Click Export and keep the Quick method.
- Choose SQL and press Export. A file downloads to your computer.
Import
- Create an empty database and select it in phpMyAdmin.
- Click Import and choose your SQL file.
- Press Import at the bottom and wait for the green message.
Tip: Files above the upload limit can be zipped first, or imported from the terminal with mysql -u user -p dbname < backup.sql.
