is there any good way to do mysql online backup - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

qust · 04-12-2010, 11:14 AM

for example,using mysqldump --master-data=1
but seems it will lose data when backup a large database,such as 10G
is there any good way?

david.baker1279 · 04-14-2010, 05:22 AM

mysqldump is a good idea, but other than that i dont think there is any other way for a backup. MySQL does not permit saving query files.

tomason · 02-11-2011, 10:38 PM

I want to help you. You can search the Spire.DataExport on the Internet.

pratap295 · 07-16-2011, 04:45 AM

mysqldump for online backup, if u r going to use replication, then u need huge amount of RAM, by which ur application, queries, and so on... and even live backup takes place.

so look at it if have enough amount of RAM, my opinion is 8GB RAM will be fair for this task.

but why don't u a shell script or use any user tweakable source application in which the process is like this

1) first it make dump compressed with tar.gz then transfer to storage.
ofcourse it will also take much memory but with less bandwidth.

Rukbat · 09-16-2011, 04:21 PM

If you're doing it through a web page, you'll probably time out on such a large database. You also might hit the operating system's max file size limitation (and there's no way to change that). See if the dump works from the shell. If it doesn't, try (if the server is on a Linux box) piping the output to gz or some other compression program.

If the file is just too large, you may have to back up a table at a time.