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. Problem while importing a site in WPLocal: SQL files fail to import
  41. How to use mysqli_query() in PHP?
  42. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  43. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  44. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  45. Column count doesn’t match value count at row 1
  46. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  47. MySQL string replace
  48. Cannot add or update a child row: a foreign key constraint fails
  49. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  50. String concatenation in MySQL
  51. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  52. Cannot add or update a child row: a foreign key constraint fails
  53. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  54. MySQL Error “Operand should contain 1 column”
  55. Rename a table in MySQL
  56. getting error HTTP Status 405 – HTTP method GET is not supported by this URL but not used `get` ever?
  57. How to use MySQL DECIMAL?
  58. Access denied for user ‘root@localhost’ (using password:NO)
  59. How should I tackle –secure-file-priv in MySQL?
  60. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  61. How to make MySQL table primary key auto increment with some prefix
  62. Access denied for user ‘root@localhost’ (using password:NO)
  63. MySQL ERROR 1290 (HY000) –secure-file-priv option
  64. MySQL error 2006: mysql server has gone away
  65. Which MySQL data type to use for storing boolean values
  66. sql query with multiple where statements
  67. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  68. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  69. Cannot delete or update a parent row: a foreign key constraint fails
  70. Cannot delete or update a parent row: a foreign key constraint fails
  71. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  72. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  73. Case statement in MySQL
  74. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  75. MySQL server startup error ‘The server quit without updating PID file’
  76. Rename a column in MySQL
  77. Can’t find mysqladmin on Mac OSX 10.6.8
  78. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  79. Cannot delete or update a parent row: a foreign key constraint fails
  80. Export Pervasive to MySQL (C#)
  81. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  82. MySQL server startup error ‘The server quit without updating PID file’
  83. Syntax error due to using a reserved word as a table or column name in MySQL
  84. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  85. MySQL root password change
  86. Installation of MySQL for Visual Studio 1.2.8 failed
  87. Not unique table/alias
  88. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  89. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  90. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  91. Your password does not satisfy the current policy requirements
  92. What does SQL Select symbol || mean?
  93. How do I import an SQL file using the command line in MySQL?
  94. Install mysql-python (Windows)
  95. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  96. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  97. SQL – Update multiple records in one query
  98. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  99. What is the definition of cardinality in SQL
  100. How to restart remote MySQL server running on Ubuntu linux?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)