UBB.Developers Forums UBB.threads 7 Development How Do I? Need help moving servers

Can someone help me with moving the Threads forum to a new database?

What I've done so far:
1. Backed up the board in the CP and downloaded the files (.sql). Step COMPLETED.
2. Uploaded the files to the new server. Step COMPLETED.
3. Tried to use PHPMyAdmin to access these files and restore the tables. "Location of the textfile:" seems to point to my desktop instead of the folder where I've already uploaded the files. Step FAILED.

A) How can I go about restoring the tables using PHPMyAdmin? Or rather is it at all POSSIBLE to do so in my case:

Next to ""Location of the textfile:" I see the following: (Max: 51,200KB). Is this an absolutely unchangeable variable (even under threat of military intervention), regardless of whether I'm pointing to a '.sql' file on my desktop or one already on the new server? If it is, then w3t_Posts.sql won't go through as it occupies 215MB, so does that mean that it is impossible for me to import the tables using PHPMyAdmin?

P.S. I read somewhere that the $cfg['UploadDir'] string can be useful but have no clue as to whether it'll override the 51,200KB limit (seems like it: "This feature is useful when your file is too big to be uploaded via HTTP"). Also, how do I set up this feature? Can someone guide me through this? (I have a dedicated server so have full access to WHM/CP/etc.)

and https://www.ubbdev.com/forum/showflat.php/Cat/0/Number/116768 , thank Josh

Thanks Dudes, I used the first program in the Trouble importing LARGE MySQL database dumps (timeouts) thread and everything seems to have gone through just fine.

I did notice in PhpMyAdmin that in the two accounts (old server and new) there were slight discrepancies (really tiny ones) in certain tables with regards to size (like 0.1 MB on a 200MB file - posts) but yet at the same time the # of 'records' remained at an identical number.

Could this be a problem, maybe in the future perhaps, or is it natural/ok for something like that to happen? Board seems to work fine after the move.

Also, would you guys recommend backing up the database using one of the programs mentioned in that thread instead of the original backup feature in Threads' CP, especially if any future restore would also be made using that program?

No - the size will change - usually the new one will be smaller - as it reclaims space which is lost when rows are deleted. (When mysql deletes rows, it does not reclaim the space until you optimize, or reimport the database).

The backup feature in threads works just fine - and you can restore it with anything - including those "bigdump" programs.

Thanks Josh, you're a star! That 32kb php import file worked just as it should, nice and simple: easy setup, quick import, zero problems whatsoever.