Mantis mysql backup size discrepancy

[hitesh.dhola]

Hello there,

I have just migrated from Mantis version 2.24.2 to 2.26.2 and XAMPP v8.2.12 (3.3.0). I usually take back with phpmyadmin >> export option. Everything is working fine till now. But manually taking backup cost me data when server was crashed. Now I want to make it automatic using script. for scripting I need to use mysqldump command.

When I exported database using mysqldump command, it's size is 20MB while If I do that using phpmyadmin >> export, it's size is 40MB.

I am not using any special operators, only simple command
mysqldump -u <user> -p <password> mantisbt > c:\

Also in phpmyadmin, I am not selecting anything just default export operation and go.

Anyone can explain this ? Will this be problematic when I restore using 20MB file ? If I export using phpmyadmin, can I import using "mysql" command ? or vice-versa ?

Regards,
Hitesh

[atrol]

I recommend to post this question in a phpMyAdmin forum.