How can we shrink our mybb database?
Are you download it from your server as a Gzip file, compressed? Or are you download your database back-up as an uncompressed file? If the later, you should be downloading as Gzip.
Not sure why you need to shrink your database, but if you want to import a database to phpMyAdmin (or a similar script) and the database size is over its limit, you can use BigDump for that. As for shrinking the database, some say it's not a really good idea. But if you still want to do it:
http://stackoverflow.com/questions/43907...r-database
do you mean to Optimize the database (same as the SHRINK command in SQL Server)?
yes how do i shrink it using shrink command in sql, will this have negative effect?