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.
Tagged with: 4 months • complete database • database backup
Filed under: Data Security
Like this post? Subscribe to my RSS feed and get loads more!
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 have a database to which you are only inserting data and you know when each row has been inserted is to use the select into … outfile syntax.
I do not think that you can do that.