Solved

Script to take auto back up of MySQl DB 2 -3 times a day

Posted on 2009-05-15
2
330 Views
Last Modified: 2012-05-07
Need a script to auto back up all MySQL Databases on Server 2-3 times a day
0
Comment
Question by:npglobal
2 Comments
 
LVL 50

Accepted Solution

by:
Steve Bink earned 500 total points
ID: 24401693
Why not use mysqldump through cron (Linux) or Task Scheduler (Windows)?  It is run entirely on command line, and can generate a very compressible text-based backup.

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS Access - need to reduce row size 25 60
Complex SQL statement in VB.NET 7 31
Optimize the query 5 43
reverse engineer .sql from php files 11 35
All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question