MyBB Community Forums

Full Version: Database restore problem
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello,
I've a strange problem. Some months ago i did a backup of my forum's database (mybb 1.6.x) and i got a file sql.gz;
this file is 89,1 MB, extracting the archive i've a file .sql of 462 MB.
When i try to do the upload of the database (either in local using xampp and online on a hosting space) on phpmyadmin , only SOME table appear, not all (for example mybb_users doesn't appear) .. so when i go on index.php the error appears.

Using an editor of text i could opened the file .sql and i searched if those tables (the tables that don't appear like mybb_users) actually existed or not. but as you can see in the next screenshot.. the table mybb_users exists.
And there are all the hash users. 
http://i.imgur.com/B4FJuxc.png 

So , how is possible that anything like this happens?
I searched the problem on google and i read that MAYBE it can be a problem with Windows, that corrupts the files..
or something like it.

These are the tables that it can up using the normal restore 
http://i.imgur.com/2I8AnIZ.png

Can anyone more expert than me help me please??

Thanks a lot in advance, best regards.
Look into query/time limits - it appears that the import is being stopped at some point.
Contact your host it is their problem not related to mybb if you import other database same size of your mybb it also will stop importing at a certain point if you think you cant do that then simply ask your host to upload that database for you.