Export a Database

<p>Perform this task to view database information in the exported file.</p> <p><strong><span style="font-size:18px">Prerequisites</span></strong></p> <p>1.&nbsp;&nbsp;&nbsp;&nbsp; You have successfully logged in to a database in the DMS console. For more information, see <a href="http://pinganyun.com/ssr/help/database/DMS/5d5e6ce2e9ca5f712e340eb2.5d5f481e1c51aa7124c5e3f9.5d5f486b1c51aa7124c5e3fa" target="_blank">Log in to an RDS MySQL Database</a>, <a href="http://pinganyun.com/ssr/help/database/DMS/5d5e6ce2e9ca5f712e340eb2.5d5f481e1c51aa7124c5e3f9.5d5f48ed1c51aa7124c5e3fb" target="_blank">Log in to an RDS PostgreSQL Database</a>, or <a href="http://pinganyun.com/ssr/help/database/DMS/5d5e6ce2e9ca5f712e340eb2.5d5f481e1c51aa7124c5e3f9.5d5f49b5e9ca5f712e340eb7" target="_blank">Log in to a DDS Database</a>.</p> <p>2.&nbsp;&nbsp;&nbsp;&nbsp; You have created storage space in the region where the database is located. For more information, see <a href="http://pinganyun.com/ssr/help/storage/obs/Operationguide.managespacestorage.cspace" target="_blank">Create Storage Space</a>.</p> <p><strong><span style="font-size:18px">Usage Guidelines</span></strong></p> <p>1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; You can export files of the RDS MySQL, RDS PostgreSQL, and DDS databases.</p> <p>2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The exported files are stored in the storage space that you have created. To view the exported files, download them from the DMS console.</p> <p><strong><span style="font-size:18px">Procedures</span></strong></p> <p>1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Log in to the <a href="http://pinganyun.com/console/dms/login" target="_blank">DMS Console</a>.</p> <p>2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In the left navigation pane, Click <strong>Quick Database Login</strong> to enter the <strong>Quick Database Login</strong> page.</p> <p>3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Select the target login tab, and then enter the domain name, port, database name, database username, and password.</p> <p>4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Click <strong>Log in Database</strong> to enter the <strong>Database Management</strong> page.</p> <p>5.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Click the <strong>Export</strong> tab.</p> <p>6.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Click <strong>Database export </strong>in the lower-left corner to enter the <strong>Database export</strong> page.</p> <p>7.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Click <strong>Whole database</strong> <strong>export</strong>, and then click <img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607160342-137dd17f963c.png" style="height:17px; margin:0px; width:16px" />&nbsp;to select the database to be exported.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607160354-17eb52579540.png" style="height:401px; width:700px" /></p> <p>8.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Click <strong>Next step</strong>.</p> <p>9.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Configure parameters as described in the following table:</p> <table border="1" cellpadding="0" cellspacing="0"> <tbody> <tr> <td style="background-color:#ededed; vertical-align:top"> <p><strong>Configuration item</strong></p> </td> <td style="background-color:#ededed; vertical-align:top"> <p><strong>Description</strong></p> </td> </tr> <tr> <td style="vertical-align:top"> <p>Export type</p> </td> <td style="vertical-align:top"> <p>Set the exported file type.</p> <ul> <li>RDS MySQL and RDS PostgreSQL can be exported as SQL and CSV files.</li> <li>DDS databases can be exported as JSON files.</li> </ul> </td> </tr> <tr> <td style="vertical-align:top"> <p>OBS Buckets</p> </td> <td style="vertical-align:top"> <p>Select the storage space.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607160447-1ea9ba9998f6.png" style="height:17px; margin:0px; width:65px" />: The storage space and the database must be in the same region.</p> </td> </tr> <tr> <td style="vertical-align:top"> <p>File character set</p> </td> <td style="vertical-align:top"> <p>Select the file character set. Currently, only UTF-8 is supported.</p> </td> </tr> <tr> <td style="vertical-align:top"> <p>Export content</p> </td> <td style="vertical-align:top"> <p>Select the data type to be exported. Options are:</p> <ul> <li>Data and structure.</li> <li>Data.</li> <li>Structure.</li> </ul> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607160447-1ea9ba9998f6.png" style="height:17px; margin:0px; width:65px" />: Only the structure of RDS MySQL and RDS PostgreSQL databases can be exported.</p> </td> </tr> <tr> <td style="vertical-align:top"> <p>Description</p> </td> <td style="vertical-align:top"> <p>Enter a description for the import task. A maximum of 400 characters are supported.</p> </td> </tr> </tbody> </table> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607160547-1529fad59bd2.png" style="height:479px; width:700px" /></p> <p>10.&nbsp;&nbsp; Click <strong>Confirm export</strong>.</p> <p><strong><span style="font-size:18px">Result</span></strong></p> <p>In the <strong>List of History Tasks</strong> area of the <strong>Export</strong> tab, the <strong>Status</strong> column of the exported file displays <strong>Task completed</strong>.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607160608-1dcd22bc9892.png" style="height:161px; width:830px" /></p> <p><strong><span style="font-size:18px">Subsequent Procedures</span></strong></p> <p>In the <strong>Operations</strong> column of the target export task, click <strong>Download</strong> to view the exported file. For more information, see <a href="http://pinganyun.com/ssr/help/database/DMS/5d5f4c9be9ca5f712e340eb8.5d5f5d75e9ca5f712e340ebd.5d5f8100c090ec71384d4b6c" target="_blank">Download and View an Exported File</a>.</p>
Did the above content solve your problem? Yes No
Please complete information!

Call us

400-151-8800

Email us

cloud@pingan.com

Online customer service

Instant reply

Technical Support

cloud products