Register



Closed Thread
Results 1 to 9 of 9

Thread: phpmyadmin problem

  1. #1
    amber.long's Avatar
    Status : amber.long is offline
    Age: 23
    Posts : 15
    Thanks : 0
    Thanked: 0
    Rep : 1
    amber.long is on a distinguished road

    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.
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!


  2. #2
    Riverwire's Avatar
    Status : Riverwire is offline
    Location : Norfolk Uk
    Posts : 1,838
    Thanks : 53
    Thanked: 22
    Rep : 10
    Riverwire will become famous soon enough Riverwire will become famous soon enough

    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
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!

  3. #3
    amber.long's Avatar
    Status : amber.long is offline
    Age: 23
    Posts : 15
    Thanks : 0
    Thanked: 0
    Rep : 1
    amber.long is on a distinguished road

    Default

    Thanks for help
    PSD to Magento Customizationfrom Creative Glance.
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!

  4. #4
    RDragos's Avatar
    Status : RDragos is offline
    Age: 22
    Posts : 33
    Thanks : 0
    Thanked: 0
    Rep : 1
    RDragos is on a distinguished road

    Default

    You can also try to divide the file, and import it separately.
    The best UK Webmaster Forum
    Register your domain at Web Address Registration
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!

  5. #5
    midlandi's Avatar
    Status : midlandi is offline
    Location : Uk
    Posts : 4,681
    Thanks : 0
    Thanked: 0
    Rep : 50
    midlandi will become famous soon enough

    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/
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!

  6. #6
    webtalk's Avatar
    Status : webtalk is offline
    Posts : 119
    Thanks : 0
    Thanked: 0
    Rep : 2
    webtalk is on a distinguished road

    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
    cpanel host : cpanel host
    quality hosting at excellent price $2.5/m
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!

  7. #7
    midlandi's Avatar
    Status : midlandi is offline
    Location : Uk
    Posts : 4,681
    Thanks : 0
    Thanked: 0
    Rep : 50
    midlandi will become famous soon enough

    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.
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!

  8. #8
    webtalk's Avatar
    Status : webtalk is offline
    Posts : 119
    Thanks : 0
    Thanked: 0
    Rep : 2
    webtalk is on a distinguished road

    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
    cpanel host : cpanel host
    quality hosting at excellent price $2.5/m
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!

  9. #9
    expertsweb's Avatar
    Status : expertsweb is offline
    Age: 27
    Posts : 23
    Thanks : 0
    Thanked: 0
    Rep : 1
    expertsweb is on a distinguished road

    Default

    create custom php.ini in your root directory and add
    post_max_size = 100M and upload_max_filesize = 100M
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!

Closed Thread

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:

Nobody landed on this page from a search engine, yet!

Tags for this Thread

Bookmarks

Posting Permissions

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

SEO Consult