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
Copy after login
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
Copy after login
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!