before posting I was digging whole site but didn't find help for my problem, so I hope someone will help...

Facts:

• 30 Gb mysql database on remote server (about 20.000.000 rows)

• data are once weekly updated in local network (mysql)

• I need to transfer/replace local updated database with remote

connection is about 2mb (real mb, not mbps) up/down

Point is that I can't have 'down time' of remote mysql server. Until now I

Tried:

• navicat data sync -> Ok, but take about 3 days to finish

• dbForge -> ok but need 5 days to finish

• mysql dump transfer to remote server and execution -> about day, but a lot of downtime

• rsync folder with database /mysql/lib/MY_DATABASE -> 4 hours, but after that I need to execute always 'repir on remote server' which takes about 2 hours, and a lot of down time

• mysql dump piped from cl to directly goto server -> still now satisfied many problems

• I could give you more things that I tried...

• mysql replication -> slow

Anyase, what is best,best way to:

• refresh remote mysql on weekly level

• and in same time to have 0 sec down time nor huge server load

If you have any idea please share