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