Hey I am trying to transfer a site of mine to a new server. It contains a large SQL database. One part of the file is too large to import through cPanel or MySQL, as there are over 7000 sections to this part (the user database). So, I'm hoping for some help - anyone know how to import the data? I've seen the 'Bigdump' tool here http://www.ozerov.de/bigdump.php, but if anyone can help using that, it'd be greatly appreciated. I will pay for someone to do the transfer if you are 100% sure you can ($5-$10 perhaps?).
Create a backup file, ftp to your server and then restore it. My webhost doesn't expose the restore functionality via any toolset, so I have to create a support ticket and ask them to restore it for me. They usually do it within the hour. G'luck.
you can break it up into sections Export a few fields at a time and import them to the new server. I do this sometimes when ime transfering large databases for clients.