How to take the updated data backup?

I have a database at mysql and the same with on the device, i want to synchronize the updated data once in a period on my device, how can i achieve this ? Please advise. I got one worst case solution that is writing triggers for each table and update the details to another table, but i have 20 tables i need to write 4 trigger operations on each table, so overall 80 triggers i need to write, can 开发者_开发技巧anyone tell me the solution.Please help

Look at the mysqldump command (It's not an SQL command, it's a command-line tool).

Create a program in your favorite programming language and let it copy the data, the program is started via cron job every X period.