Export a database file with DMS

Procedure

1. Log on to the MySQL database on your Linux-based Web Hosting instance.

   For more information, see Log on to a database with the DMS web-based client.

2. In the top navigation bar, click Database Export.

   Note

   Alternatively, on the SQLConsole page, in the Table tab, right-click the target table and choose Export > Export Instance to create a data export ticket.

3. On the Database Export tab, configure the parameters for the data export ticket and click Submit.

   The following table describes the main parameters.

   Parameter	Description	Example
   Database	Select the database that you want to export.	bdm68233****@bdm68233****.my3w.com:3306
   Tables to Be Exported	Select Some Tables or All Tables. Note If you select Some Tables, select the required tables and configure filter conditions in the right-side pane.	All Tables
   Content to Be Exported	Select Data, Schema, or Data and Schema.	Data
   Export Format	Select an export format: SQL, CSV, or Excel.	SQL
   Schema Types to Be Exported	Select the schema types to export. Supported types include Stored Procedures, Functions, Triggers, Views, and Events. Note The supported schema types vary by database type. The options available in the console take precedence.	Stored Procedures
   Advanced Options	Click Big Data Export Options or Advanced SQL Script Options and select the desired export options.	Keep the default settings.

4. Once the ticket is approved, in the Download section, click Download Exported File.

   Important

   Download the exported file within 24 hours of ticket completion, as the download link will expire. If the link expires, submit a new data export ticket.