Export MySQL databases

You have two options when exporting your MySQL database. You can either export the entire database, or export selected tables of a database, to a file.

To Export the Complete Database

  1. Access your database via PHPMyAdmin (Web & Classic / cPanel / Plesk).
  2. On the phpMyAdmin page, click Export under MySQL.
  3. In the Export field on the left side of the View Dump pane, select the database you would like to export.
  4. Select your options in the SQL options pane. Click the Save as file checkbox and name the file.
  5. When you are satisfied with your options, click the Go button. You are prompted to download the file.

    Note: Web and Classic hosting accounts do not support database compression. What type of hosting account do I have?

Your database has been exported.

To Export Selected Tables Within a Database

  1. Access your database via PHPMyAdmin. For more information, see Log in to phpMyAdmin.
  2. Click on the Databases icon under MySQL.
  3. Click the database name you want to export tables from.
  4. Click the Export tab.
  5. In the Export field on the left side of the View Dump pane, select the tables you would like to export. Use the CTRL-key to select multiple tables.
  6. Select your options in the SQL options pane. Click the Save as file checkbox and name the file.
  7. When you are satisfied with your options, click the Go button. You are prompted to download the file.

    Note: Our hosting accounts do not support compression.

The selected tables have been exported.


이 글이 도움되었나요?
피드백을 보내주셔서 감사합니다. 고객 서비스 담당자에게 문의하시려면 지원 전화 번호 또는 위의 채팅 옵션을 이용하시기 바랍니다.
도와드릴 수 있어 기쁩니다! 더 도와 드릴 것이 있나요?
그것 유감스럽습니다. 혼동이 되었던 사항 또는 솔루션이 고객님의 문제를 해결하지 못했던 원인을 알려주세요.