Re: mysqldump vs phpmyadmin dump

-insert --lock-tables --quick --set-charset. So I wonder what is the most secure way to backup mysql database to keep data consistency? Thanks and best regards Wang 2009/11/20 Mark Goodge m...@good-stuff.co.uk Wang Zi Feng wrote: Hi everyone, Here is a rookie question. The problem what I

mysqldump vs phpmyadmin dump

Hi everyone, Here is a rookie question. The problem what I found is that mysqldump and phpmyadmin generate different size of backup file against same database. I try to dump same database with the 2 different methods, the original database is 2.8mb, phpmyadmin export 1.5mb file, and mysqldump