2015-11-25, 08:42 PM
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.
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.