您现在访问的是微软AZURE全球版技术文档网站,若需要访问由世纪互联运营的MICROSOFT AZURE中国区技术文档网站,请访问 https://docs.azure.cn.
使用导入和导出迁移 MySQL 数据库Migrate your MySQL database by using import and export
10/30/2020
本文内容
适用于:
Azure Database for MySQL-单服务器
Azure Database for MySQL-灵活服务器
本文介绍通过使用 MySQL Workbench 将数据导入和导出到 Azure Database for MySQL 服务器的两种常用方法。This article explains two common approaches to importing and exporting data to an Azure Database for MySQL server by using MySQL Workbench.
有关将数据库迁移到 Azure Database for MySQL 的详细信息和用例,请参阅 数据库迁移指南 。You can also refer to Database Migration Guide for detailed information and use cases about migrating databases to Azure Database for MySQL. 本指南提供的指导旨在将 MySQL 迁移成功规划和执行到 Azure。This guide provides guidance that will lead the successful planning and execution of a MySQL migration to Azure.
开始之前Before you begin
若要逐步执行本操作方法指南,需要:To step through this how-to guide, you need:
MySQL Workbench 或其他用于执行导入/导出操作的第三方 MySQL 工具。MySQL Workbench or another third-party MySQL tool to do the import/export.
在 Azure Database for MySQL 服务器上创建数据库Create a database on the Azure Database for MySQL server
若要创建数据库,请使用 MySQL Workbench、Toad 或 Navicat 在 Azure Database for MySQL 服务器上创建一个空数据库。Create an empty database on the Azure Database for MySQL server using MySQL Workbench, Toad, or Navicat to create the database. 数据库名称可与包含转储数据的数据库名称相同,或可以创建一个不同名称的数据库。The database can have the same name as the database that contains the dumped data, or you can create a database with a different name.
若要获取连接,请在 Azure Database for MySQL 的“概述”中找到连接信息。To get connected, locate the connection information in the Overview of your Azure Database for MySQL.
将连接信息添加到 MySQL Workbench。Add the connection information to MySQL Workbench.