MyBB Community Forums
[How To?] Restore Database through MyBB or PhPMyAdmin - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: [How To?] Restore Database through MyBB or PhPMyAdmin (/thread-167450.html)



Restore Database through MyBB or PhPMyAdmin - Willeos - 2015-02-20

So now I got a fresh forum, but I also have my sql.gz database backup that I wanna reinstall into my forum.
How do I do that?

I always get this error :
''Fatal error: Maximum execution time of 10 seconds exceeded in /home/mainhost/public_html/phpMyAdmin/libraries/sqlparser.lib.php on line 334''

What should I do? Is there any easier way? Thank you!


RE: Restore Database through MyBB or PhPMyAdmin - dragonexpert - 2015-02-20

Maybe this will help you some: http://stackoverflow.com/questions/22817670/php-maximum-execution-time-when-importing-sql-data-file


RE: Restore Database through MyBB or PhPMyAdmin - Crazycat - 2015-02-20

If you can, it's better to do that from the command-line, using mysql commands as explained at http://dev.mysql.com/doc/refman/5.0/en/mysql-batch-commands.html

From phpmyadmin, if you have FILE privilege, you can use LOAD DATA INFILE as explained at http://dev.mysql.com/doc/refman/5.1/en/load-data.html


RE: Restore Database through MyBB or PhPMyAdmin - Willeos - 2015-02-20

Ok will try. Will keep this post updated.

Can I use the admin control panel in the forum to import the backup and than upload it directly into the ACP?


RE: Restore Database through MyBB or PhPMyAdmin - Ircher - 2015-02-21

Probably not -- That would pose a huge security risk if account got hacked.