How to use mysqldump remotely? How to configure access rules and firewall for mysqldump?

Solution Verified - Updated -

Issue

  • What is mysqldump?
  • How to create MySQL/MariaDB user for mysqldump?
  • How to configure iptables on DataBase server for remote dumps?
  • How to tunnel mysqldump output over SSH?

Environment

  • MariaDB 5
  • MySQL 5

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.