[dundee] MySQL backup woes

[Robert Ladyman]

In postgresql, I use pgdump (to text) and then compress: there is a similar 
method for MySQL, I think. This means I do not have to shut down the servers. 
However, you could try shutting down and then copying the 'real' data 
directories (rather than dumping). That can occasionally be faster.

> Got a Dell Poweredge DX-250 (Quad Core Intel Xeon 2.40Ghz, 1GB ECC
> DDR2 RAM, 160GB SATA 7,200RPM HD ) running Debian Lenny with the
> 2.6.26-2-686
> kernel (previously upgraded from an Etch install). It doesn't really
> run much - DNS, Apache and FTP. Its not under heavy load.
> 
> Anyway, I've been cleaning and sorting the server out and decided to
> schedule some backups:
> 
> 2,643,619 files into a 6GB archive
> 34 databases, 600MBs worth into a 100MB archive
> 
> Now the files backup in about 2 hours while the databases take 5
> hours. The time seems excessive to me, I'm use to long backup times on
> large databases (10GB+) but these don't seem all that large.
> 
> Anyone just wondering if anyone had advice or suggestions?
> 
> kris
> 
> _______________________________________________
> dundee GNU/Linux Users Group mailing list
> dundee at lists.lug.org.uk  http://dundeelug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/dundee
> Chat on IRC, #tlug on irc.lug.org.uk
> 

-- 

Robert Ladyman
File-Away Limited, 32 Church Street, Newtyle
Perthshire, PH12 8TZ SCOTLAND
Registered in Scotland, Company Number SC222086
Tel: +44 (0) 1828 898 158
Mobile: +44 (0) 7732 771 649
http://www.file-away.co.uk