Results 1 to 7 of 7
  1. #1

    Phpmyadmin limit size in database upload?

    Hi, I am currently loading a dump file in phpmyadmin and it is 150mb big... I was wondering will phpmyadmin handle this or is their a limit? If so how else do i dump this file, and how do I make a database using ssh?

    Thanks!
    Aaron

  2. #2
    Join Date
    May 2001
    Location
    Dayton, Ohio
    Posts
    4,962
    It won't...

    The typical max upload on PHP is 2mb... Besides, the script would prolly timeout in the proccess of uploading...

    So the max upload and timeout would both need to be extended, and this can only be done as root...

    It would be better todo this in shell...
    -Mat Sumpter
    Director, Product Engagement
    Penton Media

  3. #3
    Join Date
    Jul 2002
    Posts
    3,729
    Yeah, that's one of those 'valid reasons' hosts give SSH access for.

  4. #4
    Whats the command to change the limit?

  5. #5
    This is really important! I need to move a sql database from my acct to another clients whos shell acct is disabled. By the way it is XMB forums

  6. #6
    Join Date
    Jan 2002
    Location
    Melbourne, AU
    Posts
    740
    Do a search here for 'mysqldump'.


    Lats...
    Lats...

  7. #7
    Join Date
    Jun 2000
    Location
    Washington, USA
    Posts
    5,991
    I believe you could upload the file via FTP, and then access it from phpmyadmin. Or, atleast ask the host to load the data.

Posting Permissions

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