phpMyAdmin import of database into MySQL in Windows not completing -- need help!
Posted on 2008-09-29
I am migrating data from one server to another. I am exporting (individually) each MySQL database table from my old server, saving it as a zipped SQL file, then importing it into MySQL on my new server. I have been successful for many tables, so far. I am, however, running into problems getting the larger tables to carry over. I am not getting any error, but the phpMyAdmin screen goes white and never completes.
I need to know all config variables that might be affecting this issue, so that I can increase them accordingly. There is a config file for MySQL, and also one for php. Any guidance that can be given as to how to work around this problem, is also welcome. I just need to get my data copied over somehow!!!