Question : How to take database backup from mysql server?
4 months data is present in mysql server, i take the whole database backup everyweek.so ,instead of taking complete database backup how to take only that particular weeks data backup from mysql server.
backup server

Best answer:

Answer by Bruce
You have a couple of options depending upon the version of MySQL, how much access you have to the server, and how the database is being used. The easiest is to use binary logs. These logs keep track of all of the changes that have been made to the database and can be used for incremental backups.

An alternative if you can afford a few bucks is to buy a software such as Auto Backup for MySQL by SwordSky to automate the process for you