MyBB Community Forums

Backup in ACP faster than in phpMyadmin , but I want config charset database to UTF-8 when backup, Please help me !

You need to previously convert the database to UTF-8 if you wanted a UTF-8 backup.

I can't used phpMyAdmin to Import file .sql.gzip which was backup in ACP Mybb .If I export by phpMyAdmin, I'll import easy. I think it has a problem with file Backup option in ACP MYBB
Now I still use phpMyAdmin to backup instead of ACP Mybb. Thanks

myb123 Wrote:I can't used phpMyAdmin to Import file .sql.gzip which was backup in ACP Mybb .If I export by phpMyAdmin, I'll import easy. I think it has a problem with file Backup option in ACP MYBB
Now I still use phpMyAdmin to backup instead of ACP Mybb. Thanks

Yes you can. You just extract it to its .sql format and upload it via phpMyAdmin.

why do you say that " I can " ?
But I have way to do it well.

myb123 Wrote:why do you say that " I can " ?

Because you can?

if use .sql is large size , my host limit size 1027 kB upload MySql
Thanks
We'll kill more times to divide database then import partial.
:p Tell me: How way you backup your database ?

myb123 Wrote:Tell me: How way you backup your database ?

Have you tried the BigDump to restore a large backup file?

http://www.ozerov.de/bigdump.php

myb123 Wrote:if use .sql is large size , my host limit size 1027 kB upload MySql
Thanks
We'll kill more times to divide database then import partial.
:p Tell me: How way you backup your database ?

I use a cron job that executes a mysqldump command

Tikitiki Wrote:I use a cron job that executes a mysqldump command

Good news for you myb123!! I'll surely do my best to find you a much easier way.