Hi All, I am using MySql as a development database as well as on the server where my website is hosted. Now everday I punch new data into the database and save it as SQL dump using SQLyog. But when it comes to updating the data for that day on the server Mysql database I have to truncate the tables and then insert the new data. Which leads to following concerns :
Data being 5000+ rows in each table the insert query fails to execute. So I have to insert data in batches of 2000 rows.
For the time when I truncate a particular table and the new data is not yet inserted any request on the website will result in no data at all. Which is 5 to 7 minutes.
Everyday only around 300 rows are added into each table but I have to insert the complete data for a table.
Please sugges how can I take incremental backup of my local MySql database so I can update the same on the server and not the complete data till that day. Please help it is now killing me. Thanks to all.
regards