A comprehensive guide covering MySQL and MariaDB database import/export operations using mysqldump and mysql command-line tools. Covers full database dumps, selective table exports, user account migration, handling large files with compression and splitting, performance optimization techniques, and common troubleshooting scenarios. Includes practical examples for backup, restoration, and data migration workflows.
Table of contents
IntroductionPrerequisitesExporting and Importing a MySQL or MariaDB DatabaseExporting and Importing Only Specific TablesExporting and Importing with User PrivilegesDealing with Large .sql Files and Slow ImportsCommon Mistakes to AvoidFAQsConclusionSort: