Database import halfway through

[Lucarella]

Good morning everyone, I need your help...
I just updated my forum to 2.1.4, after some problems I succeeded.
I did this on a different hosting and now I'm uploading all the files via FTP and the database to phpmyadmin.
The problem I have is with the database, because if it loads only half of it, it gets stuck at the smf_log_topic_view table and doesn't go any further.
The next table is the smf_log_treasurey (not sure if it's part of 2.1) and it doesn't show up.

Do you have any advice on how to load the entire DB?

Thank you

[Aleksi "Lex" Kilpinen]

First thing I'd do is check the dump, is it actually complete? If you can open the dump in a text editor like notepad++ (may not work with large files) or glogg (should work with multi GB files), you can check to see the end of the file - usually when a dump is complete, there's a line at the very end saying so.

If the dump is complete, then we know the problem is in the importing, and to get around that you may need to either split the dump in to smaller parts, or ask your host to import it for you.

[Lucarella]

Thank you...
This is the end of the uncompressed file
[Screen-Shot-02-11-24-at-11-20-AM.png](https://postimg.cc/mt3Gyttf)
The strange thing is that when I load this uncompressed, I immediately get a timeout from phpmyadmin.

[Aleksi "Lex" Kilpinen]

That is actually not the line I was thinking of, that seems to be missing, but that is just as good - I would assume that to be complete, unless you can see actual data missing somewhere in between.

So, it is likely that the import is hitting server limits somewhere and getting cut short - I'd suggest you upload the dump to your server, and ask your host to import it for you, as they should be able to bypass the limits in a way you probably are unable to do yourself.

[Lucarella]

Yes, I contacted technical support, I hope they do everything they can.

Thank you

[Aleksi "Lex" Kilpinen]

No problem, please let us know how it goes

[Doug Heffernan]

The next table is the smf_log_treasurey (not sure if it's part of 2.1) and it doesn't show up.

This table is not part of Smf and it has been added by a third party mod.

I immediately get a timeout from phpmyadmin.

For future reference, almost all hosts have a file size memory limit for phpMyAdmins on their servers. When you have a medium and/or large database the backup done through phpmyadmin can be incomplete. The same goes if you want to importa a medium and/or large database backup file through phpmyadmin, it will result in a time out. In that case it's better to do the database backups and retorations through the Backup/Restore options at the cPanel or use a third party tool such as big dump for example. It handles large files quite well for retorations.

[Lucarella]

Thanks guys, the hosting technical team uploaded the DB and I solved the problem.
Doug, yes I am aware of the limit imposed by the hosting, which mine is 1024 MB, but my compressed DB does not exceed 250 MB, so I was alarmed...

[Aleksi "Lex" Kilpinen]

You are welcome, but please lets stick with English on the general boards, alright
There are other limits as well, the simple file size is just one alternative of many.

[Lucarella]

In my rush I forgot to translate :ridere: