<p>Perform this task to import a local SQL file to a database.</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. 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>or <a href="http://pinganyun.com/ssr/help/database/DMS/5d5e6ce2e9ca5f712e340eb2.5d5f481e1c51aa7124c5e3f9.5d5f48ed1c51aa7124c5e3fb" target="_blank">Log in to an RDS PostgreSQL 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 import SQL files only to the RDS MySQL and RDS PostgreSQL databases.</p> <p>2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; After a file is imported, DMS automatically executes SQL statements in the file.</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; Click 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> Import</strong> tab.</p> <p>6.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Click<strong> Importing files</strong> in the lower-left corner of the page to enter the <strong>Import Files</strong> page.</p> <p>7.&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; width:152px"> <p><strong>Configuration item</strong></p> </td> <td style="background-color:#ededed; vertical-align:top; width:577px"> <p><strong>Description</strong></p> </td> </tr> <tr> <td style="vertical-align:top; width:152px"> <p>Import database</p> </td> <td style="vertical-align:top; width:577px"> <p>Select the name of the target database.</p> </td> </tr> <tr> <td style="vertical-align:top; width:152px"> <p>Import type</p> </td> <td style="vertical-align:top; width:577px"> <p>Select the type of file to be imported. Currently, only SQL files are supported.</p> </td> </tr> <tr> <td style="vertical-align:top; width:152px"> <p>OBS Buckets</p> </td> <td style="vertical-align:top; width:577px"> <p>Select the storage space for the imported file.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607155521-1d98cace9360.png" style="height:17px; margin:0px; width:65px" />:</p> <p>1.&nbsp;&nbsp;&nbsp;&nbsp; The storage space and the database must be in the same region.</p> <p>2.&nbsp;&nbsp;&nbsp;&nbsp; The storage space is used for receiving the imported file, and DMS will automatically connect to the storage space to acquire the file.</p> </td> </tr> <tr> <td style="vertical-align:top; width:152px"> <p>File character set</p> </td> <td style="vertical-align:top; width:577px"> <p>Select the file character set. Currently, only UTF-8 is supported.</p> </td> </tr> <tr> <td style="vertical-align:top; width:152px"> <p>File upload</p> </td> <td style="vertical-align:top; width:577px"> <p>Click <strong>Select file</strong> to select the imported file. The maximum file size is 4 MB.</p> </td> </tr> <tr> <td style="vertical-align:top; width:152px"> <p>Description</p> </td> <td style="vertical-align:top; width:577px"> <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/20200607155549-13b263399276.png" style="height:529px; width:700px" /></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>Import</strong> tab, the imported file is in <strong>Task completed</strong> state.</p>