I currently own a gaming website, and it's database has about 70mb.
I'm changing to a VPS, so today i put the site under maintenance, uploaded the files to the new server, changed the DNS of the domain, and when i was uploading the database (Using PhpMyAdmin), everything looked fine until after like 1:20 hs, the window changed from the "uploading" status to the login page of plesk.
So i though "It must've finished"... but no, i logged in, and the database was empty, so apparently it didn't work.
Maybe because my internet connection isn't very good (640k) and a timeout occured?, idon't know.. but the thing is,
Is there a different way to upload the database that it isn't phpmyadmin?, or using it but uploading by small pieces, so this doesn't happen again... something like that.
I'd really appreciate different options, and as soon as possible, since i don't want to have my website offline for so long