Hello, 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 :S Thank you very much! Nick
Split the files and upload to database there are lot of file splitters available use them to split your database .xls or.txt files and then upload them .
You can use the bigdump script from www.ozerov.de/bigdump.php to overcome the problem of importing a large mysql database.
I can attest to this script, it's awesome. If you have root though, stop mysqld and move the flat files, start mysqld. Nothing's quicker.
Why don't you upload the file via FTP and use MySQL's command line options to import the data? You can use either mysql or source command e.g. On shell shell> mysql database_name < database_dump.sql Code (markup): Or on mysql prompt mysql> USE database_name; mysql> source database_dump.sql; Code (mysq): Make sure you create a database first. You can still import the database using phpMyAdmin by increasing file upload limit.