Emptying the search tables can already cut the size of the database in half if you're lucky.
Quite a few hosts have size limit on uploading and downloading (mine is 200MB but trying to make a backupfile near that limit, times out regularly.)HiFiKabin wrote: ↑Mon Jan 15, 2018 1:20 pmExporting all of the database tables in one is not a problem, but exporting them separately is never a good idea as you may end up with problems that will never be solved. By all means drop the content of the search table as that can be rebuilt after the transfer.
Export the database as one from the ACP, then you can use BigDump to import the whole database to your new host.