Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2008
    Posts
    9

    Unanswered: phpmyadmin problem

    hi all

    i have 20 mb sql file.

    in this file i have all tables and data.

    i have exported it with phpmyadmin.

    now

    when i trying to import it with phpmyadmin

    it shows me following error messages

    "
    You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.
    ";

    where i have do the changes to solve this problem.

    any ideas?

    thanks in advance
    _____________________________
    Hotels in Barcelona iced tea

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    out of curiosity waht did the documentation suggest?
    I don't know if thats a PHPMyAdmin issue or a MySQL issue.. I'd guess its a PHPMyAdmin, and I'd guess it may be to do with the limit your PHP environment in the config file

    when I've hit these sort of issues before I've broken the file into several sections and uploaded those. whether that will work in PHPMyAdmin I don't know.. I tend to use MySQL Query browser, or upload using a PHP script
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2008
    Posts
    1
    I believe one of the solutions of the problem - if i understand the situation right - is to make an inquiry to your hosting provider. They will insert the necessary data into the db locally.

  4. #4
    Join Date
    Sep 2008
    Posts
    10
    you can try copy the sql script and paste in sql commands of the phpmyadmin and execute.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •