MyISAM / InnoDB

[Mike]

You can pass in the --single-transaction option to disable the table locks. (As most of the DB is InnoDB and these tables are independent, it's not a big deal to lose a small amount of consistency in them.)

 

[teletubbi]

As most of the DB is InnoDB and these tables are independent

As i understand he has no InnoDB only Myisam

 

[Paul B]

This is what I use:

Dump:

mysqldump -udatabase_user -p --single-transaction --skip-lock-tables database_name > /path/to/backup/database_name_$(date +%d.%m.%y).sql

Zip:

tar -czf database_name_$(date +%d.%m.%y).tar.gz /path/to/backup/database_name_$(date +%d.%m.%y).sql

Restore:

mysql -udatabase_user -p database_name < backup.sql

 

[Induslady]

Thanks @Mike and @Brogan.

Let me try this and will get back.