Mantis mysql backup size discrepancy
Posted: 22 Aug 2024, 11:36
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
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