mysqldump to a tar.gz

mysqldump --opt <database> | gzip -c | ssh user@wherever 'cat > /tmp/yourfile.sql.gz'

You can’t use tar in a pipe like this, and you don’t need it anyway, as you’re only outputting a single file. tar is only useful if you have multiple files.

Related Posts:

  1. gzip: stdin: not in gzip format tar: Child returned status 1 tar: Error is not recoverable: exiting now
  2. How do I load a sql.gz file to my database? (importing)
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  5. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  6. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  7. How do I restore a dump file from mysqldump?
  8. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  9. When to use SELECT … FOR UPDATE?
  10. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  11. Create a new database with MySQL Workbench
  12. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  13. Search for all occurrences of a string in a mysql database
  14. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  15. How to convert a string to date in MySQL?
  16. MySQL COUNT DISTINCT
  17. How to update a record using sequelize for node?
  18. Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
  19. Convert MySQL to SQlite [closed]
  20. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  21. Convert partially non-numeric text into number in MySQL query
  22. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  23. tar: add all files and directories in current directory INCLUDING .svn and so on
  24. MySQL: What’s the difference between float and double?
  25. How can I search (case-insensitive) in a column using LIKE wildcard?
  26. Dump all tables in CSV format using ‘mysqldump’
  27. MySQL Select Multiple VALUES
  28. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  29. How to unblock with mysqladmin flush hosts
  30. Node.js MySQL – Error: connect ECONNREFUSED
  31. MySQL: Cloning a MySQL database on the same MySql instance
  32. mysqldump data only
  33. Solution to “subquery returns more than 1 row” error
  34. PHP date() format when inserting into datetime in MySQL
  35. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  36. How To have Dynamic SQL in MySQL Stored Procedure
  37. MySQL – UPDATE query with LIMIT
  38. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  39. What SQL Query to do a simple find and replace
  40. Scanning Database for malicious Data
  41. how to refresh wordpress permalink settings? (without admin panel)
  42. Ordering posts by day (not time) AND meta value
  43. wpdb->prepare function remove single quote for %s in SQL statment
  44. Problems with DBDelta with FOREIGN key?
  45. Alternative to mysql_real_escape_string
  46. Is it useful to turn on MySQL query cache for performance
  47. Programmatically changing role information; editing role name and deleting
  48. How to remove ‘GROUP BY’ from SQL query produced from get_posts?
  49. Search and replace in post content
  50. MySQL LIKE not working
  51. How to add 2 hours to the wordpress time formed with current_time(“mysql”, false)?
  52. wpdb insert and boolean fields
  53. 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)
  54. What are the issues associated with upgrading MySQL for WordPress?
  55. How to find meta entries with their posts missing via SQL?
  56. Why doesn’t this code add a table to my database?
  57. SQL database export-import
  58. Mysql SELECT posts
  59. How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
  60. #1115 – Unknown character set: ‘utf8mb4’
  61. Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
  62. How to add a private user page populated from sql?
  63. Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = ‘attachment'”
  64. Which is better and faster ? WordPress Queries or SQL Query
  65. Using WPDB->Insert()
  66. Active DB queries in WordPress?
  67. Changing MySQL password via WHM – does this affect WordPress?
  68. Run Username SQL Query from WordPress Child Theme Functions File
  69. SQL syntax error. However, it works normally at phpmyadmin
  70. string literals in query
  71. MySQL query for taxonomy-meta
  72. Editing mysql tables/database with wordpress or other app/cms
  73. Create pages from MySQL database
  74. Sql – Search with serialized Data / better database concept
  75. WordPress unescape text on mysql?
  76. Getting data from Mysql Table..confusing
  77. Exporting completed webiste for another server
  78. SQL Statement – Mass Delete Custom Post Types
  79. Ubuntu 12.04, Nginx and MySQL issue with WordPress Database
  80. Pull post name from value of a specific meta key
  81. PHP variables in mysql query
  82. latency problems with wordpress install (from SQL import)
  83. mysql – Delete keyword with link from wordpress post database
  84. Creating dynamic content and pages for 1000’s of locations
  85. Remove duplicate media entries from mysql database
  86. mysqli_sql_exception: Unknown column ‘wp_’ in ‘field list’ PHP 8
  87. In a MySQL query, one of the columns in the LEFT JOIN returns “Unknown column”
  88. DB option update with wp-cli
  89. Find locations of all featured images of draft posts via SQL
  90. wpdb insert into point column in db
  91. 403 Forbidden home on localhost with nginx server
  92. WPDB delivers wrong results from complex queries
  93. How to change link in all posts?
  94. #1115 – Unknown character set: ‘utf8mb4’
  95. get_results suddenly not working on a single table
  96. Get data from 3rd table
  97. “Error 1064” when importing msql database after updating wordpress version to 4.2.1
  98. Why can’t I connect to imported WP DB on local MAMP?
  99. Need SQL query to find&replace image URL
  100. Postgres equivalent to MySQL’s \G?

Leave a Comment