How do I load a sql.gz file to my database? (importing)

zcat /path/to/file.sql.gz | mysql -u 'root' -p your_database

> will write the output of the mysql command on stdout into the file myfile.sql.gz which is most probably not what you want. Additionally, this command will prompt you for the password of the MySQL user “root”.

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. How do I restore a dump file from mysqldump?
  4. How do I import an SQL file using the command line in MySQL?
  5. How do I quickly rename a MySQL database (change schema name)?
  6. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  7. Create a new database with MySQL Workbench
  8. How to get size of mysql database?
  9. 1052: Column ‘id’ in field list is ambiguous
  10. 1052: Column ‘id’ in field list is ambiguous
  11. difference between primary key and unique key
  12. How to create a foreign key in phpmyadmin
  13. importing a CSV into phpmyadmin
  14. How to check if mysql database exists
  15. Is there a Profiler equivalent for MySql?
  16. How to do a batch insert in MySQL
  17. MySQL: Cloning a MySQL database on the same MySql instance
  18. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  19. Data is not constantly loading from custom wordpress table
  20. Why is my database import losing text widget data?
  21. What’s a good strategy for planning WordPress DB growth?
  22. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  23. importing data from non-wordpress mysql db
  24. Import 10,000 Users into WordPress WITH a specific ID for each user
  25. MySQL Syntax Error upon restoring database from backup [closed]
  26. Error while importing database
  27. Unknown collation when I import a dump from an existing site into a development database?
  28. WordPress database import: Row size too large
  29. Create a form with custom autocomplete address field and CSV import values
  30. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  31. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  32. Exporting completed webiste for another server
  33. Export SQL query based on custom field?
  34. latency problems with wordpress install (from SQL import)
  35. Featured image from custom to WordPress database
  36. Weird characters displayed when importing WordPress MySQL db
  37. Importing Concrete5 content to WordPress
  38. mysqldump to a tar.gz
  39. After Import: Insert “Use” Statement in Database
  40. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  41. String concatenation in MySQL
  42. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  43. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  44. MySQL server startup error ‘The server quit without updating PID file’
  45. How do I import an SQL file using the command line in MySQL?
  46. SQL – Update multiple records in one query
  47. Column ‘user_id’ in field list is ambiguous
  48. Database sharding vs partitioning
  49. Escape string Python for MySQL
  50. how to overcome ERROR 1045 (28000): Access denied for user ‘ODBC’@’localhost’ (using password: NO) permanently
  51. SQL ZOO List each continent and the name of the country that comes first alphabetically
  52. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  53. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  54. How to install Python MySQLdb module using pip?
  55. Access denied for user ‘root’@’localhost’ (using password: YES) after new installation on Ubuntu
  56. Dump all tables in CSV format using ‘mysqldump’
  57. If variable equals value php [duplicate]
  58. mysqldump data only
  59. PHP date() format when inserting into datetime in MySQL
  60. How to fetch Data in WordPress using MySQLi or $wpdb
  61. Connect to database using wordpress wp-config file
  62. Get url of product’s images (woocommerce)
  63. How to properly insert data into custom table via plugin
  64. How does WordPress handle MySQL row lock errors?
  65. Alternative to mysql_real_escape_string
  66. Create Pages from Database
  67. Huge wp_options table
  68. Same option_id=0 for 2 options in wp_options?
  69. How can I call a row of user specific data from a custom table added to the WP Database
  70. How to let a user choose an authors and save it to the database?
  71. How to merge local and live databases?
  72. How to remove ‘GROUP BY’ from SQL query produced from get_posts?
  73. MySQL LIKE not working
  74. Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
  75. Emojis getting converted to “?”
  76. greatest() function returns undefined property
  77. Join new table with SQL query
  78. WordPress installation on valet php 8 (PHP Fatal error: Uncaught mysqli_sql_exception Table ‘wp_options’ doesn’t exist in wp-includes/wp-db.php:2056)
  79. MySQL crashed because of the large number of requests
  80. wpdb custom post_type problem
  81. Why doesn’t this code add a table to my database?
  82. SQL database export-import
  83. Can Someone Help Me Fix This WordPress Missing Argument Error?
  84. Create a clone from one WordPress site to another in a few minutes
  85. Help With MySQL to WPDB Query Conversion
  86. How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
  87. Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
  88. How can I save unique user data on my site? [closed]
  89. Import users from old WP site to new one
  90. SQL Database, repeated tables?
  91. Create table from array with prepare
  92. Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
  93. Why does the MySQL command line tool ignore the –port parameter?
  94. Postgres equivalent to MySQL’s \G?
  95. WordPress database connection failed, while mysql client is working [closed]
  96. Possible SQL injection. How to locate and fix?
  97. Can’t insert into a database wordpress
  98. WordPress cannot detect (present, loaded) mysqli
  99. Deleting WordPress posts and media files based on author via MYSQL database
  100. How to sync non-wp database with wp-database?

Leave a Comment