How to set backup based on date?

Asked By Madison Madison 20 points N/A Posted on - 12/21/2012

Hi guys,

How to set backup based on date? As a java web programmer developer here in our office I have to create some back up for my MySql server database system. I always do it every day before going home. How can I possibly set the backup according to date? I want to sort it accordingly by date.

 

Expecting some help, thank you.

• Status: Open
• Question Views: 919
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Espinoza Thor

Go To Solution

Answered By Maxwell Mark 0 points N/A #179322

How to set backup based on date?

Hello,

I think you can solve your problem. You need to do a test using the following: Server OS: Fedora Core 5, MySQL Version: MySQL 5.0.22 to set backups after 15 minutes. For this example, we should use a database that was recently supplied by Netflix as part of the Netflix movie recommendation algorithm. For this example, I have two websites to solve for this problem: 1. zmanda.com/quick-mysql-backup.html   2. dev.mysql.com/doc/refman/5.1/en/mysqldump.html

Thanks.

About Maxwell Mark

Questions
5

Answers
101

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 01/26/2013
• Question Category: MySQL Server

Best Answer

Best Answer

Answered By Espinoza Thor 0 points N/A #179323

How to set backup based on date?

 

Hi,

Setting the date for your backup is very important since it will not only ensure that the file is in an organized manner but it will also save you time instead of doing it manually.

Since you said that you are using SQL server and assuming that you are running Windows OS, you may want to try creating a .bat file first as shown below:

@echo off

Set mySqlPath = C:Program FilesMySMySQL Server 5.5

Set dbUser=bar

Set dbPassword=backup

Set dbname=[your database filename]

Set file=%dbName%.%DATE%_-_%dbName% ^> ^%path%%file%

“my%SQLPath%binmysqldump.exe” –u %dbUser% -p%dbPassword%

–result-file=”%path%%file” %dbName%

Echo Done!

*This next step will assume that you want to run backup every night at 23:30. For this, we will use at. In case you are using Linux, it will use the command cron.

C:/>at 23:30 /every: M, T, W, Th, F, S, Su C:DataBackupScriptsMySQL-backup.bat

Added a new job with job ID = 1

To see if the script you did is working, type at as shown below:

C:>at

Hope this helps you in your query. For further questions and help, please feel free to post it here at techyv.com

 

About Espinoza Thor

Questions
3

Answers
13

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 05/14/2013
• Question Category: MySQL Server