From: Wang Zi Feng
Date: November 20 2009 5:50am
Subject: mysqldump vs phpmyadmin dump
List-Archive: http://lists.mysql.com/mysql/219432
Message-Id: <628f30740911192150l751a0144i974cd99fe7f5458a@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0016e64b96deb884670478c70d4c

--0016e64b96deb884670478c70d4c
Content-Type: text/plain; charset=UTF-8

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 export only
941kb file.

I know there must be some difference between the two export method, but
after I import the 941kb file which mysqldump created into a new database,
it just works fine.

So I'm not sure if I can use mysqldump as the best option to do mysql
backup, can someone can help me to figure out why phpmyadmin would generate
twice big file? And I see some post that address it is not recommend to
import mysqldump file by using phpmyadmin, because it will cause problem.

Thanks and best regards

Wang

--0016e64b96deb884670478c70d4c--