1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Wamp - PHP MyAdmin - Get white screen when importing sql

Discussion in 'PHP & Perl' started by Darksider, Oct 8, 2013.

  1. Darksider

    Darksider Registered Member

    Joined:
    Jun 16, 2010
    Messages:
    81
    Likes Received:
    31
    Location:
    Europa
    Hello, I have problem with importing SQL in my localhost.I use WAMP.When tray import sql, I get White screen and no error.I tray make bck of my site, but I have problem with only one site.The other site when importing is all ok.My SQL is 16 M big.I tray importing wordpress SQL.
    I use this settings in my php ini files.Thanks for help.

    post_max_size = 30M
    upload_max_filesize = 25M
    memory_limit =128M
     
  2. srb888

    srb888 Elite Member

    Joined:
    Jul 30, 2008
    Messages:
    3,260
    Likes Received:
    5,067
    Gender:
    Male
    Occupation:
    WebzSurfer
    Location:
    Sun, Mon, Tue, WTF, Sat!!! :)
    Try this:
    Code:
    [URL]http://daipratt.co.uk/importing-large-files-into-mysql-with-phpmyadmin/comment-page-4/#comment-63552[/URL]
     
    • Thanks Thanks x 1
  3. | ALIEN |

    | ALIEN | Regular Member

    Joined:
    Jan 28, 2013
    Messages:
    277
    Likes Received:
    131
    Hi, I don't unerstand your question that well. Is it that you cannot import the sql backup or you get the white screen after you import the sql database successfully and when you visit your site?

    If you get it after you import the sql dump and when you visit the site after that, you should try updating permalinks. (Just click the update button.)

    [​IMG]
     
    • Thanks Thanks x 1
  4. | ALIEN |

    | ALIEN | Regular Member

    Joined:
    Jan 28, 2013
    Messages:
    277
    Likes Received:
    131
    And if you cannot import it, try using the command prompt

    mysql>mysql -uUsername -pPassword Localdatabasename < sqldump.sql

    and see what happens.
     
    • Thanks Thanks x 1
  5. qrazy

    qrazy Senior Member

    Joined:
    Mar 19, 2012
    Messages:
    1,111
    Likes Received:
    1,712
    Location:
    Banana Republic
    It could be because of maximum upload size or execution time limit.

    In ini file, Try increasing the

    to a larger value

    and add this line to increase the execution timeout

    Alternatively you can zip the sql file and import it.
     
    • Thanks Thanks x 1
  6. Darksider

    Darksider Registered Member

    Joined:
    Jun 16, 2010
    Messages:
    81
    Likes Received:
    31
    Location:
    Europa
    Thanks to all for helping me.I tray all your suggestions, but can not working.I tray srb888 method than qrazy. I check my ini files, but I don't found this line "max_allowed_packet" than I add this line max_allowed_packet = 500M, but still no luck.I tray add $cfg['ExecTimeLimit'] = 4000; and than I get error and my server do not start.I do't the expert, maby write this code in the wrong line.
    I also tray | ALIEN | , but when I type my pass, console just disappears.

    I can not import my sql, ich time when tray import sql, import just 4 row and than get white screen.