Hello, I recently transfered my website on new web host. However one of my databases is more than 150 MB, i was wondering how to important that big database as i do not have shell access to my server, for sure MyphpAdmin will timeout if i try to import this. Any idea how i can import this big dump. Kind regards...
Try use big dump script http://www.ozerov.de/bigdump.php "BigDump: Staggered MySQL Dump Importer Staggered import of large and very large MySQL Dumps (like phpMyAdmin 2.x Dumps) even through the web servers with hard runtime limit and those in safe mode. The script executes only a small part of the huge dump and restarts itself. The next session starts where the last was stopped."
well there should be no problem if you upload the dump, login to mysql via shell and use "source dump" .. Also mysql has it's own import program that you can use.
Without shell access is very dificult to do this. Phpmyadmin has a very small file size limit. This script does the job very well.
The right answer and, incidentally, stated as part of the thread's title. BigDump is a single-file solution that makes this job easier and you don't need shell access, just edit at the top of the file to match your MySQL connection (host, db username and db password), upload the file along with your sql file to your server via FTP and call the script from your browser's address bar to start the dump.