sql import

    Hello,


    I meet a sql basic import problems with phpmyadmin. the base
    only 152 mb though:


    The time limit has been reached; if you want to complete the import, resubmit the same file and import will continue.


    I tried several times and nothing to do.


    Do you have a solution please?


    Thank you in advance.

    Hi @raln,


    What you could do is put the SQL file in /var/www/imscp/gui/data/uploads/
    Then you'd be able to import it from there on.
    Make sure to remove the file afterwards, because all users can import the file if signed in.


    You could also use the mysqladmin command to import the file into the DB over SSH

    Hello,


    Thank you for your quick response.
    I tried directly via ftp and I have the same message unfortunately.
    On the command line, I never did.
    This is he single?


    Thank you in advance.

    a) Change PHP's time-limit in php.ini in order to remove the limit that caused your error. But this should only be a temporary fix.
    b) Upload sql-dump via scp to your imscp-server and use mysql-client directly from the shell.
    c) Create a ssh-tunnel and use mysql directly from your remote device: http://chxo.com/be2/20040511_5667.html


    Imho, 152MB is a bit to large for using phpmyadmin. It's great for simple tasks, but I wouldn't use it to upload big sql-files.

    Hello,


    I just passed directly command line.
    This saved me changed the value of php.ini.


    Thank you once again for your help :).