• Managed VPS
    1. #1
      Newbie amber.long's Avatar

      Join Date
      Jun 2009
      Age
      23
      Posts
      15
      Thanks
      0

      Default phpmyadmin problem

      hello everyone

      I have exported 20 mb sql file with phpmyadmin and when i trying to import that file with phpmyadmin it shows me this error

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

      any one can please give me suggestion how can i solve this error?

      thanks in advance
      PSD to Magento Customizationfrom Creative Glance.

    2. #2
      Administrator Riverwire's Avatar

      Join Date
      Jan 2008
      Location
      Norfolk Uk
      Posts
      2,182
      Thanks
      135

      Default

      Yeah this happens quite alot , just submit a ticket to your host and ask them to upload it for you , they will do it no problem

    3. #3
      Newbie amber.long's Avatar

      Join Date
      Jun 2009
      Age
      23
      Posts
      15
      Thanks
      0

      Default

      Thanks for help
      PSD to Magento Customizationfrom Creative Glance.

    4. #4
      Newbie RDragos's Avatar

      Join Date
      Nov 2009
      Age
      22
      Posts
      33
      Thanks
      0

      Default

      You can also try to divide the file, and import it separately.

    5. #5
      Can you smell that? midlandi's Avatar

      Join Date
      Jan 2007
      Location
      Uk
      Posts
      4,703
      Thanks
      2
      Thanked 1 Time in 1 Post

      Default

      Simplest is to use BigDump to import a big database:
      http://www.ozerov.de/bigdump.php

      MySQLDumper is an alternative too, which also can be used for big backups with time out issues:
      http://www.mysqldumper.de/en/

    6. #6
      Member webtalk's Avatar

      Join Date
      Nov 2009
      Posts
      126
      Thanks
      0

      Default

      you can export large file with phpmyadmin, you can export it via ssh

      login via ssh
      than
      mysql -u user -p databasename tableiftable < /path/to/dump

      cheers
      cheap cpanel hosting : cpanel host
      quality hosting at excellent price $2.5/m

    7. #7
      Can you smell that? midlandi's Avatar

      Join Date
      Jan 2007
      Location
      Uk
      Posts
      4,703
      Thanks
      2
      Thanked 1 Time in 1 Post

      Default

      Quote Originally Posted by webtalk View Post
      you can export large file with phpmyadmin, you can export it via ssh

      login via ssh
      than
      mysql -u user -p databasename tableiftable < /path/to/dump

      cheers
      Trouble is that alot of providers no longer allow ssh access on shared accounts.

    8. #8
      Member webtalk's Avatar

      Join Date
      Nov 2009
      Posts
      126
      Thanks
      0

      Default

      Quote Originally Posted by midlandi View Post
      Trouble is that alot of providers no longer allow ssh access on shared accounts.
      they will allow you if you have static ip, else you have to contact with your host to import
      cheap cpanel hosting : cpanel host
      quality hosting at excellent price $2.5/m

    9. #9
      Newbie expertsweb's Avatar

      Join Date
      Oct 2009
      Age
      27
      Posts
      23
      Thanks
      0

      Default

      create custom php.ini in your root directory and add
      post_max_size = 100M and upload_max_filesize = 100M

    Thread Information

    Users Browsing this Thread

    There are currently 1 users browsing this thread. (0 members and 1 guests)

       

    Similar Threads

    1. BIG problem
      By Orion in forum General Webmaster Discussion
      Replies: 3
      Last Post: 11-08-2009, 04:45 PM
    2. Any one see a problem with this ?
      By Riverwire in forum PHP/MySql
      Replies: 3
      Last Post: 10-11-2009, 02:23 PM
    3. ASP.net problem
      By Michael in forum Other Programming
      Replies: 1
      Last Post: 09-15-2007, 10:59 PM
    4. what's the problem here?
      By morris in forum Java Script/AJAX
      Replies: 1
      Last Post: 09-02-2007, 02:40 PM
    5. a bit of a problem
      By detoam in forum General Webmaster Discussion
      Replies: 2
      Last Post: 06-01-2007, 12:14 PM

    Visitors found this page by searching for:

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

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

    you probably tried to upload too large file. please refer to documentation for ways to workaround this limit. joomla

    you are probably trying to import a big file in PHPmyadmin

    yahoo small business mysql phpmyadmin problem

    phpmyadmin import 100M

    yahoo hosting phpmyadmin problem

    php.ini yahoo hosted phpmyadmin

    yahoo hosting phpmyadmin problems

    Tags for this Thread

    Like this page ? Spread the love :)

    Triphp Supporters:
    Advertise
    Advertise Advertise Advertise Advertise




    Advertise