How Can I Efficiently Export and Import MySQL Databases Using Command-Line Options?

Export and Import .SQL Files with Options from the Command Line

Exporting and importing .SQL files from the command line is a convenient way to handle MySQL database management. However, you may require additional options beyond the basic export/import functionality.

To export a .SQL file with specific options:

mysqldump -u <username> -p -h <hostname> <database_name> [options] > <filename>.sql

Where:

• -u username specifies the database username
• -p prompts for the password
• -h hostname indicates the server hostname (or IP address)
• is the name of the database to export
• [options] allows for various export options (see below)
• > .sql specifies the output file name

Common Export Options:

• --disable-keys: Disable foreign key checks
• --skip-add-drop-table: Export table data without including the table creation statements (structure only)
• --replace: Replace existing data if it exists

Importing a .SQL File:

mysql -u <username> -p -h <hostname> <database_name> < <filename>.sql

Where:

• -u username specifies the database username
• -p prompts for the password
• -h hostname indicates the server hostname (or IP address)
• is the name of the database into which to import
• < .sql specifies the input file name

Example:

• Exporting: mysqldump -u vivek -p -h localhost blog --disable-keys --skip-add-drop-table > backup.sql
• Importing: mysql -u vivek -p -h localhost blog < backup.sql

The above is the detailed content of How Can I Efficiently Export and Import MySQL Databases Using Command-Line Options?. For more information, please follow other related articles on the PHP Chinese website!