Question:

How to back up a mysql database to an external hard drive using ubuntu?

by  |  earlier

0 LIKES UnLike

What I want to do is attach an external hard drive to the server and then have the server run a cron job at the end of each day zipping the database and storing it on the external hard drive. Is this possible?

 Tags:

   Report

2 ANSWERS


  1. Copy the whole mysql directory to the disk.


  2. The easiest way is to use phpmyadmin's export feature (look in synaptic package manager to download).  

    If you don't want to do that, you can use the mysqldump command.  Here's a tutorial on that:

    http://www.devarticles.com/c/a/MySQL/Bac...

    Hope this helps.

Question Stats

Latest activity: earlier.
This question has 2 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.