[geeks] Mysql backup questions...

[Mike Meredith]

Resurrecting an ancient thread ...

On Tue, 12 Apr 2005 08:25:26 -0500, Brian Dunbar wrote:
> This is how my host provider recomends that you backup / restore your 
> database
> 
> backup
> mysqldump --opt -uusername -ppassword -h yourMySQLHostname dbname > 
> filename.sql

You missed out the '-q' option which someone else gave ... as I did. You
might want to put that in, as it can prevent 'out of memory' errors when
dumping large tables (probably ones with many columns rather than many
rows).