Exporting a database in ISPmanager

  1. "Databases" → tick the database.
  2. Click "Dump" → "Export".
  3. The browser downloads the dump file.
The "Dump" menu
The "Dump" menu

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

  1. Open phpMyAdmin: phpMyAdmin login.
  2. Select the database on the left and the "Export" tab at the top.
  3. "Quick" method, SQL format exports the whole database. "Custom" lets you pick tables and gzip compression.
  4. 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.gz

Delete the dump from the site folder after downloading: it contains all site data, including users and orders.

To load a dump back — database import.

Questions and answers
As an SQL dump that can be loaded into any MySQL.
Yes, with the "Export" tab in phpMyAdmin.
No.