{"id":19658,"date":"2024-09-03T03:05:42","date_gmt":"2024-09-03T10:05:42","guid":{"rendered":"https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/"},"modified":"2024-11-14T05:59:35","modified_gmt":"2024-11-14T13:59:35","slug":"guide-importing-exporting-databases-mysqldump","status":"publish","type":"article","link":"https:\/\/www.pingcap.com\/ko\/article\/guide-importing-exporting-databases-mysqldump\/","title":{"rendered":"Guide to Importing and Exporting Databases with Mysqldump"},"content":{"rendered":"\n

In today’s data-driven world, the ability to efficiently import and export databases is crucial for businesses and developers alike. Whether it’s for backup purposes, data migration, or ensuring high availability, managing databases effectively is a common task in software development. MySQL dump<\/strong> emerges as an indispensable tool in this process, enabling users to create backups and transfer data seamlessly between MySQL servers. Its versatility and reliability make it a preferred choice for handling database operations, ensuring that your data remains accessible and secure across various platforms.<\/p>\n\n\n\n

<\/span>Prerequisites<\/span><\/h2>\n\n\n\n

Before diving into the practical aspects of importing and exporting databases with mysqldump<\/strong>, it’s essential to ensure that your system meets the necessary prerequisites. This preparation will help streamline the process and minimize potential issues.<\/p>\n\n\n\n

System Requirements<\/h3>\n\n\n\n

Supported Operating Systems<\/h4>\n\n\n\n

mysqldump<\/strong> is a versatile tool compatible with various operating systems. It supports:<\/p>\n\n\n\n

    \n
  • Linux<\/strong>: Most distributions, including Ubuntu, CentOS, and Debian, are well-suited for running mysqldump.<\/li>\n\n\n\n
  • Windows<\/strong>: Ensure you have the MySQL client installed, as it includes mysqldump.<\/li>\n\n\n\n
  • macOS<\/strong>: Compatible with macOS versions that support MySQL installations.<\/li>\n<\/ul>\n\n\n\n

    It’s crucial to verify that your operating system is updated to a version that supports the latest MySQL client tools.<\/p>\n\n\n\n

    Required Software and Tools<\/h4>\n\n\n\n

    To effectively use mysqldump<\/strong>, you’ll need:<\/p>\n\n\n\n

      \n
    • MySQL Client<\/strong>: This package includes the mysqldump utility. Ensure you have the latest version to access all features and improvements.<\/li>\n\n\n\n
    • Command-Line Interface (CLI)<\/strong>: Familiarity with using a terminal or command prompt is necessary, as mysqldump operates via command-line instructions.<\/li>\n\n\n\n
    • Text Editor<\/strong>: While not mandatory, having a text editor like Vim, Nano, or Notepad++ can be helpful for reviewing and editing SQL dump files.<\/li>\n<\/ul>\n\n\n\n

      Access and Permissions<\/h3>\n\n\n\n

      Proper access and permissions are critical for successfully using mysqldump<\/strong>. Without the right privileges, you may encounter errors during the export or import processes.<\/p>\n\n\n\n

      Database User Privileges<\/h4>\n\n\n\n

      Ensure that the database user account has the following privileges:<\/p>\n\n\n\n

        \n
      • SELECT<\/strong>: Required to read data from the database tables.<\/li>\n\n\n\n
      • LOCK TABLES<\/strong>: Necessary for ensuring data consistency during the export process.<\/li>\n\n\n\n
      • SHOW VIEW<\/strong>: Needed if your database contains views.<\/li>\n\n\n\n
      • TRIGGER<\/strong>: If your database uses triggers, this privilege is essential.<\/li>\n<\/ul>\n\n\n\n

        These privileges can be granted using the MySQL GRANT<\/code> statement, tailored to your specific database needs.<\/p>\n\n\n\n

        Network Access Considerations<\/h4>\n\n\n\n

        When working with remote databases, consider the following network access factors:<\/p>\n\n\n\n

          \n
        • Firewall Settings<\/strong>: Ensure that your firewall allows traffic on the MySQL port (default is 3306).<\/li>\n\n\n\n
        • VPN or SSH Tunneling<\/strong>: For secure connections, especially when accessing databases over the internet, consider using a VPN or setting up an SSH tunnel.<\/li>\n\n\n\n
        • IP Whitelisting<\/strong>: If your database server employs IP whitelisting, make sure your client machine’s IP address is allowed.<\/li>\n<\/ul>\n\n\n\n

          By addressing these prerequisites, you’ll set a solid foundation for using mysqldump<\/strong> effectively, ensuring smooth and efficient database management operations.<\/p>\n\n\n\n

          <\/span>Exporting Databases with Mysqldump<\/span><\/h2>\n\n\n\n

          Exporting databases is a fundamental task for database administrators and developers, enabling data backup, migration, and sharing. The mysql dump<\/strong> utility is a powerful tool that facilitates these processes with ease and efficiency. Below, we delve into the essential commands and options for exporting databases using mysqldump<\/strong>.<\/p>\n\n\n\n

          Basic Export Command<\/h3>\n\n\n\n

          Syntax and Options<\/h4>\n\n\n\n

          The basic syntax of the mysql dump<\/strong> command is straightforward, yet it offers several options to customize the export process:<\/p>\n\n\n\n

          \nmysqldump -u [username] -p [database_name] > [dump_file.sql]\n<\/code><\/pre>\n\n\n\n
            \n
          • -u [username]<\/code>: Specifies the MySQL username.<\/li>\n\n\n\n
          • -p<\/code>: Prompts for the password associated with the username.<\/li>\n\n\n\n
          • [database_name]<\/code>: The name of the database you wish to export.<\/li>\n\n\n\n
          • [dump_file.sql]<\/code>: The output file where the exported data will be saved.<\/li>\n<\/ul>\n\n\n\n
            Additional options can be used to tailor the export, such as --add-drop-table<\/code> to include a DROP TABLE<\/code> statement before each CREATE TABLE<\/code>, ensuring that tables are dropped before being recreated during an import.<\/p>\n\n\n\n
            Example Command<\/h4>\n\n\n\n
            For instance, to export a database named company_db<\/code> with a user admin<\/code>, the command would be:<\/p>\n\n\n\n
            \nmysqldump -u admin -p company_db > company_backup.sql\n<\/code><\/pre>\n\n\n\n
            This command creates a backup of company_db<\/code> in a file named company_backup.sql<\/code>.<\/p>\n\n\n\n
            Advanced Export Options<\/h3>\n\n\n\n
            Exporting Specific Tables<\/h4>\n\n\n\n
            Sometimes, you may only need to export specific tables rather than the entire database. The mysql dump<\/strong> command allows for this flexibility:<\/p>\n\n\n\n
            \nmysqldump -u [username] -p [database_name] [table1 table2 ...] > [dump_file.sql]\n<\/code><\/pre>\n\n\n\n
            For example, to export only the employees<\/code> and departments<\/code> tables from company_db<\/code>, use:<\/p>\n\n\n\n
            \nmysqldump -u admin -p company_db employees departments > selected_tables_backup.sql\n<\/code><\/pre>\n\n\n\n
            Using Compression<\/h4>\n\n\n\n
            To save space and reduce transfer times, you can compress the output file using gzip:<\/p>\n\n\n\n
            \nmysqldump -u admin -p company_db | gzip > company_backup.sql.gz\n<\/code><\/pre>\n\n\n\n
            This command compresses the export directly into a .gz<\/code> file, making it more efficient for storage and transfer.<\/p>\n\n\n\n
            Scheduling Regular Backups<\/h3>\n\n\n\n
            Regular backups are crucial for data integrity and disaster recovery. Automating these backups ensures that they occur consistently without manual intervention.<\/p>\n\n\n\n
            Using Cron Jobs<\/h4>\n\n\n\n
            On Unix-based systems, cron jobs can be scheduled to run mysql dump<\/strong> commands at specified intervals. For example, to schedule a daily backup at midnight, add the following line to your crontab:<\/p>\n\n\n\n
            \n0 0 * * * mysqldump -u admin -p[password] company_db > \/path\/to\/backup\/company_backup_$(date +%F).sql\n<\/code><\/pre>\n\n\n\n
            This command creates a backup file with the current date appended to its name, helping maintain an organized backup history.<\/p>\n\n\n\n
            Automating with Scripts<\/h4>\n\n\n\n
            For more complex backup strategies, scripts can be employed to automate the process. A simple bash script might look like this:<\/p>\n\n\n\n
            \n#!\/bin\/bash\nDATE=$(date +%F)\nmysqldump -u admin -p[password] company_db > \/path\/to\/backup\/company_backup_$DATE.sql\n<\/code><\/pre>\n\n\n\n
            By executing this script via a cron job, you can automate the backup process, ensuring your data is regularly and securely backed up.<\/p>\n\n\n\n
            <\/span>Importing Databases with Mysqldump<\/span><\/h2>\n\n\n\n
            Importing databases is a vital process for restoring data from backups, migrating data between servers, or setting up new environments. The mysql dump<\/strong> utility simplifies this task, allowing for efficient and reliable data importation. Let’s explore the steps and considerations involved in importing databases using mysqldump<\/strong>.<\/p>\n\n\n\n
            Preparing for Import<\/h3>\n\n\n\n
            Before initiating the import process, it’s essential to ensure that your environment is ready to accept the data.<\/p>\n\n\n\n
            Checking Database Compatibility<\/h4>\n\n\n\n
            Compatibility is crucial when importing data. Ensure that the MySQL version on the target server is compatible with the version used to create the mysql dump<\/strong> file. Incompatibilities can lead to syntax errors or data integrity issues during import. Always verify the SQL modes and character sets to prevent unexpected behavior.<\/p>\n\n\n\n
            Creating a New Database<\/h4>\n\n\n\n
            If you’re importing into a new environment, you’ll need to create a database to hold the imported data. Use the following command to create a new database:<\/p>\n\n\n\n
            \nCREATE DATABASE new_database_name;\n<\/code><\/pre>\n\n\n\n
            Replace new_database_name<\/code> with your desired database name. This step ensures that the data has a designated space for import.<\/p>\n\n\n\n
            Basic Import Command<\/h3>\n\n\n\n
            Once the environment is prepared, you can proceed with the import using the basic mysql dump<\/strong> command.<\/p>\n\n\n\n
            Syntax and Options<\/h4>\n\n\n\n
            The syntax for importing a database is straightforward:<\/p>\n\n\n\n
            \nmysql -u [username] -p [database_name] < [dump_file.sql]\n<\/code><\/pre>\n\n\n\n
              \n
            • -u [username]<\/code>: Specifies the MySQL username.<\/li>\n\n\n\n
            • -p<\/code>: Prompts for the password associated with the username.<\/li>\n\n\n\n
            • [database_name]<\/code>: The name of the database where the data will be imported.<\/li>\n\n\n\n
            • [dump_file.sql]<\/code>: The file containing the exported data.<\/li>\n<\/ul>\n\n\n\n
              Ensure that the user has sufficient privileges to write to the database.<\/p>\n\n\n\n
              Example Command<\/h4>\n\n\n\n
              For example, to import data into a database named company_db<\/code> using a user admin<\/code>, the command would be:<\/p>\n\n\n\n
              \nmysql -u admin -p company_db < company_backup.sql\n<\/code><\/pre>\n\n\n\n
              This command imports the data from company_backup.sql<\/code> into company_db<\/code>.<\/p>\n\n\n\n
              Handling Large Imports<\/h3>\n\n\n\n
              Large databases can pose challenges during import due to size constraints and performance issues. Here are strategies to manage large imports effectively.<\/p>\n\n\n\n
              Adjusting MySQL Configuration<\/h4>\n\n\n\n
              For large imports, adjust MySQL server configurations to optimize performance. Increase the max_allowed_packet<\/code> size to accommodate larger data packets and adjust innodb_buffer_pool_size<\/code> for better InnoDB performance. These settings can be modified in the MySQL configuration file (my.cnf<\/code> or my.ini<\/code>).<\/p>\n\n\n\n
              Using Split Files<\/h4>\n\n\n\n
              When dealing with extremely large databases, consider splitting the mysql dump<\/strong> file into smaller parts. Tools like split<\/code> can divide the file into manageable chunks:<\/p>\n\n\n\n
              \nsplit -l 1000 company_backup.sql part_\n<\/code><\/pre>\n\n\n\n
              This command splits company_backup.sql<\/code> into files with 1000 lines each, prefixed with part_<\/code>. Import each part sequentially to manage resource usage effectively.<\/p>\n\n\n\n
              By following these guidelines, you can ensure a smooth and efficient import process with mysql dump<\/strong>, safeguarding your data’s integrity and availability across different environments.<\/p>\n\n\n\n
              <\/span>Troubleshooting Common Issues<\/span><\/h2>\n\n\n\n
              Navigating the complexities of database management often involves encountering and resolving various issues. When using mysqldump<\/strong> for importing and exporting databases, certain errors can arise. Understanding these common problems and their solutions is crucial for maintaining smooth operations.<\/p>\n\n\n\n
              Common Export Errors<\/h3>\n\n\n\n
              Exporting databases with mysqldump<\/strong> is generally straightforward, but there are a few common errors that users might encounter.<\/p>\n\n\n\n
              Permission Denied<\/h4>\n\n\n\n
              One of the most frequent issues is the “Permission Denied” error. This typically occurs when the user lacks the necessary privileges to execute the export command. To resolve this:<\/p>\n\n\n\n
                \n
              • Verify User Privileges<\/strong>: Ensure that the MySQL user has the required permissions, such as SELECT<\/code>, LOCK TABLES<\/code>, and SHOW VIEW<\/code>. These can be granted using the GRANT<\/code> statement in MySQL.<\/li>\n\n\n\n
              • Check File System Permissions<\/strong>: Make sure the directory where you intend to save the dump file allows write access for the user executing the command.<\/li>\n<\/ul>\n\n\n\n
                Connection Timeout<\/h4>\n\n\n\n
                A “Connection Timeout” error can disrupt the export process, especially with large databases or slow network connections. To mitigate this:<\/p>\n\n\n\n
                  \n
                • Increase Timeout Settings<\/strong>: Adjust the connect_timeout<\/code> and net_read_timeout<\/code> settings in your MySQL configuration file to allow more time for the connection to establish and maintain.<\/li>\n\n\n\n
                • Optimize Network Conditions<\/strong>: Ensure stable network conditions by checking for any interruptions or bandwidth limitations that could affect the connection.<\/li>\n<\/ul>\n\n\n\n
                  Common Import Errors<\/h3>\n\n\n\n
                  Importing data into a MySQL database using mysqldump can also present challenges. Here are some typical import errors and their solutions.<\/p>\n\n\n\n
                  Syntax Errors<\/h4>\n\n\n\n
                  Syntax errors can occur if the SQL dump file contains commands or structures not supported by the target MySQL version. To address this:<\/p>\n\n\n\n
                    \n
                  • Review SQL Modes<\/strong>: Check the SQL modes on the target server to ensure compatibility with the commands in the dump file.<\/li>\n\n\n\n
                  • Validate Dump File<\/strong>: Manually inspect the dump file for any anomalies or unsupported syntax, especially if the source and target MySQL versions differ.<\/li>\n<\/ul>\n\n\n\n
                    Data Integrity Issues<\/h4>\n\n\n\n
                    Data integrity issues may arise if the imported data does not align with the existing schema or constraints in the target database. To prevent this:<\/p>\n\n\n\n
                      \n
                    • Ensure Schema Compatibility<\/strong>: Before importing, verify that the target database schema matches the structure of the data being imported. This includes checking for primary keys, foreign keys, and data types.<\/li>\n\n\n\n
                    • Use Transactional Imports<\/strong>: If possible, perform the import within a transaction to ensure that any errors can be rolled back without affecting the existing data.<\/li>\n<\/ul>\n\n\n\n
                      By proactively addressing these common issues, you can enhance the reliability and efficiency of your database management processes with mysqldump. This approach not only safeguards data integrity but also streamlines the import and export operations, ensuring that your databases remain robust and accessible.<\/p>\n","protected":false},"excerpt":{"rendered":"
                      Master database import\/export with mysqldump. Learn commands, troubleshoot issues, and integrate TiDB for efficient data management.<\/p>","protected":false},"author":8,"featured_media":19657,"template":"","class_list":["post-19658","article","type-article","status-publish","has-post-thumbnail","hentry"],"acf":[],"yoast_head":"\nGuide to Importing and Exporting Databases with Mysqldump<\/title>\n<meta name=\"description\" content=\"Master database import\/export with mysqldump. Learn commands, troubleshoot issues, and integrate TiDB for efficient data management.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pingcap.com\/ko\/article\/guide-importing-exporting-databases-mysqldump\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Guide to Importing and Exporting Databases with Mysqldump\" \/>\n<meta property=\"og:description\" content=\"Master database import\/export with mysqldump. Learn commands, troubleshoot issues, and integrate TiDB for efficient data management.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/article\/guide-importing-exporting-databases-mysqldump\/\" \/>\n<meta property=\"og:site_name\" content=\"TiDB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/pingcap2015\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-14T13:59:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2024\/09\/03030542\/9e61405525594c6ab43183d191f3accd.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"675\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:label1\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data1\" content=\"9\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/\",\"url\":\"https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/\",\"name\":\"Guide to Importing and Exporting Databases with Mysqldump\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2024\/09\/03030542\/9e61405525594c6ab43183d191f3accd.webp\",\"datePublished\":\"2024-09-03T10:05:42+00:00\",\"dateModified\":\"2024-11-14T13:59:35+00:00\",\"description\":\"Master database import\/export with mysqldump. Learn commands, troubleshoot issues, and integrate TiDB for efficient data management.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2024\/09\/03030542\/9e61405525594c6ab43183d191f3accd.webp\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2024\/09\/03030542\/9e61405525594c6ab43183d191f3accd.webp\",\"width\":1200,\"height\":675,\"caption\":\"Guide to Importing and Exporting Databases with Mysqldump\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\/\/www.pingcap.com\/article\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Guide to Importing and Exporting Databases with Mysqldump\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pingcap.com\/#website\",\"url\":\"https:\/\/www.pingcap.com\/\",\"name\":\"TiDB\",\"description\":\"TiDB | SQL at Scale\",\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pingcap.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pingcap.com\/#organization\",\"name\":\"PingCAP\",\"url\":\"https:\/\/www.pingcap.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"width\":811,\"height\":232,\"caption\":\"PingCAP\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/pingcap2015\",\"https:\/\/x.com\/PingCAP\",\"https:\/\/linkedin.com\/company\/pingcap\",\"https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Guide to Importing and Exporting Databases with Mysqldump","description":"Master database import\/export with mysqldump. Learn commands, troubleshoot issues, and integrate TiDB for efficient data management.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pingcap.com\/ko\/article\/guide-importing-exporting-databases-mysqldump\/","og_locale":"ko_KR","og_type":"article","og_title":"Guide to Importing and Exporting Databases with Mysqldump","og_description":"Master database import\/export with mysqldump. Learn commands, troubleshoot issues, and integrate TiDB for efficient data management.","og_url":"https:\/\/www.pingcap.com\/ko\/article\/guide-importing-exporting-databases-mysqldump\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_modified_time":"2024-11-14T13:59:35+00:00","og_image":[{"width":1200,"height":675,"url":"https:\/\/static.pingcap.com\/files\/2024\/09\/03030542\/9e61405525594c6ab43183d191f3accd.webp","type":"image\/webp"}],"twitter_card":"summary_large_image","twitter_site":"@PingCAP","twitter_misc":{"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"9\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/","url":"https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/","name":"Guide to Importing and Exporting Databases with Mysqldump","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2024\/09\/03030542\/9e61405525594c6ab43183d191f3accd.webp","datePublished":"2024-09-03T10:05:42+00:00","dateModified":"2024-11-14T13:59:35+00:00","description":"Master database import\/export with mysqldump. Learn commands, troubleshoot issues, and integrate TiDB for efficient data management.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2024\/09\/03030542\/9e61405525594c6ab43183d191f3accd.webp","contentUrl":"https:\/\/static.pingcap.com\/files\/2024\/09\/03030542\/9e61405525594c6ab43183d191f3accd.webp","width":1200,"height":675,"caption":"Guide to Importing and Exporting Databases with Mysqldump"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/article\/guide-importing-exporting-databases-mysqldump\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/www.pingcap.com\/article\/"},{"@type":"ListItem","position":3,"name":"Guide to Importing and Exporting Databases with Mysqldump"}]},{"@type":"WebSite","@id":"https:\/\/www.pingcap.com\/#website","url":"https:\/\/www.pingcap.com\/","name":"\ud2f0DB","description":"TiDB | SQL at Scale","publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pingcap.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.pingcap.com\/#organization","name":"PingCAP","url":"https:\/\/www.pingcap.com\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/","url":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","width":811,"height":232,"caption":"PingCAP"},"image":{"@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/pingcap2015","https:\/\/x.com\/PingCAP","https:\/\/linkedin.com\/company\/pingcap","https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA"]}]}},"card_markup":"        <a class=\"card-article\" href=\"https:\/\/www.pingcap.com\/ko\/article\/guide-importing-exporting-databases-mysqldump\/\">            <h3>Guide to Importing and Exporting Databases with Mysqldump<\/h3>            <p>Master database import\/export with mysqldump. Learn commands, troubleshoot issues, and integrate TiDB for efficient data management.<\/p>        <\/a>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/article\/19658","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/article"}],"author":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/users\/8"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media\/19657"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=19658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}