Results 1 to 2 of 2

Thread: How to upload large database ?

  1. #1
    Join Date
    Sep 2011
    Posts
    9
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Default How to upload large database ?

    I have exported large mysql database.Now its size is 22.7 mb.I am not able to import this now.When i tried to import this file an error shows .

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

    How to resolve this. ? please kindly help me.

    Thanks in advance

    Ghanasyam

  2. #2
    Join Date
    Mar 2006
    Location
    Illinois, USA
    Posts
    12,164
    Thanks
    265
    Thanked 690 Times in 678 Posts

    Default

    Try searching for an answer for this. It's not an uncommon problem.

    I know of two methods:
    1. Split the file into smaller pieces. Database exports are not a single line of code-- they are many individual queries. Generally speaking, you can separate them at any semi-colon. Just split into chunks (always ending with semi-colons) then upload each in sequence. This can be a little difficult (not to mention time consuming) so be careful and make a backup first (both of what is already in the database and of your file).
    2. Upload the file to your server using FTP (or any other direct method-- not via a webpage), and then access it directly from within the server. This could be command prompt direct access to MySQL, or you could do it, for example, through PHP-- load the entire file as a string then execute the query. Generally the upload limits are much stricter than what the server can do with local files.

    I've had success with both of those methods.


    But again a search should give you lots of information and potential solutions.
    Daniel - Freelance Web Design | <?php?> | <html>| español | Deutsch | italiano | português | català | un peu de français | some knowledge of several other languages: I can sometimes help translate here on DD | Linguistics Forum

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
  •