Tag: mysqldump

  • Linux backup using CRON to local directory

    As many have pointed out I am on a backup and disaster recovery kick lately. Some would say that it is about time, others are simply glad to see that data is now being backed up. I have found that it is easiest to zip up files on a local machine prior to moving them […]

  • MySqlDump export and MySQL import

    To export data as a backup you can’t beat mysqldump. # mysqldump -u username database > database_2007-05-14.sql Then to restore a database you would use: # mysql -u username -p database < database_2007-05-14.sql It doesn't get any easier than that!