Exporting a database in ISPmanager
- "Databases" → tick the database.
- Click "Dump" → "Export".
- The browser downloads the dump file.

A dump is a .sql file with all tables and data of the database. Use it to move a site to another host, make a copy before a CMS update or hand the database to a developer.
With phpMyAdmin
- Open phpMyAdmin: phpMyAdmin login.
- Select the database on the left and the "Export" tab at the top.
- "Quick" method, SQL format exports the whole database. "Custom" lets you pick tables and gzip compression.
- Click "Export" (Go).
Large database
If the database is larger than a few hundred megabytes, the browser may cut the download. Dump it to a file in the panel Shell client and download it with the file manager or FTP:
mysqldump -u USER -p DB_NAME | gzip > ~/www/dump.sql.gzDelete the dump from the site folder after downloading: it contains all site data, including users and orders.
To load a dump back — database import.