I asked a relevant question few months back and got answer with wide variety of options for backup. But this time I have different scenario and I have got a database with 7 tables and 1 of them has exceeded 20GB (table1) and one another(table6) is 13GB while all other tables are well below 500MB.

In current scenario larger table (table1) is going to get even more data so I have a thought to create another table(table1-1) with same schema and insert all new data in that table. Because mostly there are INSERT calls and very few UPDATE calls are made to table1 and all data inserted are based on ID from table2. (I think its not very important to know though)

All tables are MYISAM and table6 is not going to grow in near future with same pace.

Now I want to ask few questions to gurus and few backup solutions.

First of all.. do you think as I have grown beyond 20GB and creating new table with same schema would help me because mostly there are INSERT calls so it will be light on system to insert in new place compared with inserting in a table which is already grown to 20GB+.

And all these tables are in single database so I want to backup whole database but not 1 big file rather it should be 1 file per table because it will reduce overhead of keeping local copy which now contains table1 all the time. Actually if table1-1 will be used then table1 will only be locally copied only once in a week while others are locally copied daily.

Please suggest me finest way to backup keeping in mind the data size and with minimal (only necessaary)downtime.