Importin MySQL Issue :: Not importing small DB file

  • Resolved mrkingid

    (@mrkingid)


    15 years, 1 month ago

    Imported before with a different site but phpMyAdmin is giving me grief tonight.

    Using phpMyAdmin – 2.11.10 (latest for php4.x)

    In my php.ini file I have

    file_uploads=on
    memory_limit=50M
    post_max_size=25M
    max_input_time=300
    max_execution_time=300
    upload_max_filesize=20M
    safe_mode=off

    But it still gives me an error when I try to import it (Max: 20,480 KiB):
    No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.

    The database size is only 976kb.

    Any ideas from the gurus?

    my site info can be found here… https://michaelking.ca/phpinfo.php

Viewing 1 replies (of 1 total)
  • Thread Starter mrkingid

    (@mrkingid)

    Problem solved…

    was never able to import from c: directory of my machine…

    I had to add an upload directory in the phpMyAdmin folder and place my sql file there.

    I had to alter the config.inc.php file by adding:

    $cfg[‘UploadDir’] = ‘./upload’;

    at the bottom.

    After that, login to phpmyadmin and click your database and goto import. This time you should see anther drop down window in which you can select your sql database from your server. Click go and all done.

    Hope this helps someone else.

Viewing 1 replies (of 1 total)
  • The topic ‘Importin MySQL Issue :: Not importing small DB file’ is closed to new replies.