Putty

Jhun Vert's picture

How to Backup and Restore MySQL Database from Linux Command Line

I wrote this post so that I can easily retrieve information that I pulled from several pages of the internet. I have this need to migrate some large MySQL database to another server and I need to do it from the command line of Linux. To make this information at least a little complete, below is the outline of my situation and what I need to do.

  • The OS of origin and destination servers are both CentOS 5
  • The control panel of the origin is cPanel and the destination is a custom made control panel
  • Databases are MySQL
  • Most websites are Drupal and some are WordPress
  • My machine where I am accessing my server is Windows
  • The SSH client I am using is PuTTy, it's free
  • I'm a Windows guy making mess in Linux. :)
Subscribe to RSS - Putty