What is the best way to dump a eZ Publish Mysql database?

Tools like phpmyadmin usually do not work properly wiht a eZ Publish database.

The best way to dump a big mysql transactional innodb database is from shell.

mysqldump -n --opt --single-transaction -hlocalhost -umyusername -pmypassword dabasename > dump.sql

Add the character set if your mysql client doesn`t run in utf8 mode.

mysqldump -n --default-character-set=utf8 --opt --single-transaction -hlocalhost -umyusername -pmypassword dabasename > dump.sql