MyBB Community Forums

for restore DB old IN mybb new - What should I do ?

I have a database with 80 MB
Mybb is installed on the host

in phpmyadmin i cant import DB
please say steps import DB in Phpmyadmin ?

Character set of the file : utf-8 ?

Allow the interruption of an import in case the script detects it is close to the PHP timeout limit. (This might be good way to import large files, however it can break transactions.) click or unclick ?

Number of rows to skip, starting from the first row : What number?

Format: SQL

SQL compatibility mode: None ?

Do not use AUTO_INCREMENT for zero valuesDocumentation: click or unclick ?

http://1.lped.comule.com/images/bd39eae38511.jpg

---

when the Default i uploaded DB - 4 5 hours working but dont uplaod

Leave all the settings as they are apart from the timeout one, tick that. A database of this size definitely shouldn't be taking anywhere near 4-5 hours to upload though, if it's taking that long you need to ask your host why. Also, what version of MyBB was this backup taken from??

MyBB 1.6.1

---

there this erorr :
http://1.lped.comule.com/images/e0feeaff84a1.jpg

---

how Increase Size of import File in phpmyadmin ?

Unless you have access to your php.ini file you'll need to ask your host, or use a tool like BigDump to split the backup up.