Solved

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

Posted on 2009-05-15
2
329 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

831 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