Re: mysqldump vs phpmyadmin dump

2009-11-20 Thread Wang Zi Feng
hi there, thanks for your reply. the mysql server is running on windows xp sp3, every time I use root user to log in. the command line i use for mysqldump is mysqldump --user=root --password=pass test>test.sql phpmyadmin is with following checked Add DROP TABLE / VIEW / PROCEDURE / FUNCTION /

Re: mysqldump vs phpmyadmin dump

2009-11-20 Thread Mark Goodge
Wang Zi Feng wrote: 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

mysqldump vs phpmyadmin dump

2009-11-19 Thread Wang Zi Feng
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 ex