whats the size of your db is it in gbs ? and tables type myisam or innodb , if myisam you can do mysql illegal copy (should shut down mysql while doing this) , if innodb there is no other option except the way you already do, you may also try script "mysql dumper" to make the process automated but still it will take LOT of time
bhanuprasad1981 Reviewed by bhanuprasad1981 on . Dedicated Server Backup Solution Hello, I'm looking for a fast/stable/secure backup solution for my dedicated server. Please give me some advices . Thank you. Rating: 5