Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

mysql backup

Quote Reply
mysql backup
Hi

I was wondering if anyone have tried to backup all databases on the server ? I have followed mysql.org instruction for this, but it doesn´t seem to work ?

What I use was mysqldump -u username -p --all-databases and similar commands, like mysqldump -u username -p * < mysql.sql....I know how to backup one and one, but not all at the same time...

I get different errors, but the last was that --all-databases wasn´t an accepted command parameter. I have mysql 3.22.xx.

I also tried some programs that was supposed to back up all databases, but it doesn´t come further that create the *.sql files without any content.

Is is enough to just copy the table files from the mysql var catalog to get the backup ?

Thanks.

Are