How to export and import a .sql file from command line with options? [duplicate]

by

Type the following command to import sql data file:

$ mysql -u username -p -h localhost DATA-BASE-NAME < data.sql

In this example, import ‘data.sql’ file into ‘blog’ database using vivek as username:

$ mysql -u vivek -p -h localhost blog < data.sql

If you have a dedicated database server, replace localhost hostname with with actual server name or IP address as follows:

$ mysql -u username -p -h 202.54.1.10 databasename < data.sql

To export a database, use the following:

mysqldump -u username -p databasename > filename.sql

Note the < and > symbols in each case.

More Related Contents:

  1. Downloading MySQL dump from command line
  2. MySQL treats password in script as database
  3. How do I import an SQL file using the command line in MySQL?
  4. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  5. How to run SQL script in MySQL?
  6. List of Stored Procedures/Functions Mysql Command Line
  7. How to remove all MySQL tables from the command-line without DROP database permissions? [duplicate]
  8. Dump a mysql database to a plaintext (CSV) backup from the command line
  9. How to connect to MySQL from the command line
  10. How to start MySQL server from command line on Mac OS Lion?
  11. Which DB technology is sued to solve the following search issue? [closed]
  12. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  13. How should I resolve –secure-file-priv in MySQL?
  14. node-mysql multiple statements in one query
  15. MySQL server startup error ‘The server quit without updating PID file’
  16. Select last row in MySQL
  17. Best type of indexing when there is LIKE clause [duplicate]
  18. MySQL LOAD DATA INFILE with ON DUPLICATE KEY UPDATE
  19. How do I restore a dump file from mysqldump?
  20. How to handle fragmentation of auto_increment ID column in MySQL
  21. MySQL – Conditional Foreign Key Constraints
  22. How to count items in comma separated list MySQL
  23. What effects does using a binary collation have?
  24. MySQL order by “best match”
  25. Are dynamic mysql queries with sql escaping just as secure as prepared statements?
  26. Using an IF Statement in a MySQL SELECT query
  27. Insert/ Update random date in MySQL
  28. How to determine which database is selected
  29. How do you force mysql LIKE to be case sensitive? [duplicate]
  30. MySQL Alter table causes Error: Invalid use of NULL value

Leave a Comment