Home > Database > Mysql Tutorial > How Can I Efficiently Export and Import MySQL Databases Using Command-Line Options?

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

Patricia Arquette
Release: 2024-12-10 10:55:10
Original
307 people have browsed it

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
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!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template