Godaddy and SQL - How to Import large database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • CherryV
    Confirmed User
    • Apr 2007
    • 700

    #1

    Godaddy and SQL - How to Import large database

    Ok I am trying to upload a 2.5mb database to a godaddy sql server on shared hosting. Anyone know how to get around the 2.0mb file size limit?

    Cheers,
    V
    100% Legal Sex Vacations at Blue Paradise_Exotic Resort
  • directfiesta
    Too lazy to set a custom title
    • Oct 2002
    • 30135

    #2
    not sure if it works with godaddy :

    add to .htaccess:

    php_value upload_max_filesize 6M


    Otherwise, ask them to up the limit, which they will refuse ... Or get them to copy the DB in the proper root folder for you .... or get a friendly host
    I know that Asspimple is stoopid ... As he says, it is a FACT !

    But I can't figure out how he can breathe or type , at the same time ....

    Comment

    • CherryV
      Confirmed User
      • Apr 2007
      • 700

      #3
      Will check it out

      Cheers!
      100% Legal Sex Vacations at Blue Paradise_Exotic Resort

      Comment

      • CherryV
        Confirmed User
        • Apr 2007
        • 700

        #4
        Well if anyone actually cares I tried the above and then contacted go daddy when it failed. Was able to accomplish this by FTP to my dbbackup folder and then restore DB. Its a work around for the normal way.
        100% Legal Sex Vacations at Blue Paradise_Exotic Resort

        Comment

        • directfiesta
          Too lazy to set a custom title
          • Oct 2002
          • 30135

          #5
          Originally posted by CherryV
          Well if anyone actually cares I tried the above and then contacted go daddy when it failed. Was able to accomplish this by FTP to my dbbackup folder and then restore DB. Its a work around for the normal way.
          nice ... better then I thought they would be .
          I know that Asspimple is stoopid ... As he says, it is a FACT !

          But I can't figure out how he can breathe or type , at the same time ....

          Comment

          • glow
            Registered User
            • Jan 2008
            • 68

            #6
            You can also use something called bigdump, its handy for the problem of timeout when trying to upload a DB.

            Comment

            • st0ned
              Confirmed User
              • Mar 2007
              • 8437

              #7
              Yeah I believe bigdump is what I used, it splits the database into multiple smaller files, making the import into godaddy possible.
              Conversion Sharks - 1,000+ adult dating offers, traffic management, and consistently high payouts.
              We will guarantee and beat your current EPC to win your dating traffic!
              Skype: ConversionSharks || Email: info /@/ conversionsharks.com

              Comment

              • budz
                Disruptive Innovator
                • Sep 2003
                • 4230

                #8
                navicat ftw
                C:\Code\
                C:\Code\Run\

                Comment

                • brandonstills
                  Confirmed User
                  • Dec 2007
                  • 1964

                  #9
                  LOL. Godaddy sucks ass. I had that problem too. I called their support and they wouldn't install it for me and they wouldn't give me any options to install it so I told my client godaddy refused to allow me to do what I needed and they should get another host.

                  You might look into installing a PHP script that gives you virtual shell access. Forget the names but I know a few of them exist. It basically gives you a terminal in your browser but it's run as user "nobody". You might be able to import it that way but I doubt the mysql command line client will be accessable.

                  Brandon Stills
                  Industry and programming veteran
                  [email protected] | skype: brandonstills | ICQ #495-171-318

                  Comment

                  Working...