MySQL Backup - How you do it?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Pimpin_J
    Confirmed User
    • Jul 2006
    • 3637

    #1

    MySQL Backup - How you do it?

    Just tried it with PhpMyAdmin but it seems like the database is a way to big. 300mb++ So the browser times out. Aint got shell access, so is there any other remote tool who can handle this?
  • Nookster
    Confirmed IT Professional
    • Nov 2005
    • 3744

    #2
    easiest way i've found if you have a large database is code your own. you can code one relatively quick with php + mysql commands.
    The Best Affiliate Software, Ever.

    Comment

    • tical
      Confirmed User
      • Feb 2002
      • 6504

      #3
      phpmyadmin should have an export option, 300mb should be fine

      if u can get shell access use mysqldump
      112.020.756

      Comment

      • edgeprod
        Permanently Gone
        • Mar 2004
        • 10019

        #4
        That's VERY odd that it times out on 300MB. I exported a 2TB database onto a Webair server, and it was fine.

        Lucky I did, too, because the farm (well, only 5 servers, so mini-cluster) at Candid Hosting shit the bed shortly thereafter. Cost me thousands and thousands in downtime and lost data for some of the other sites, but luckily, they gave me .. uh .. $130 back, I think. *grumble*

        Comment

        • DomP_nl
          So Fucking What
          • Sep 2005
          • 631

          #5
          Mysqldumper is your friend

          Comment

          • Adultnet
            Confirmed User
            • Sep 2003
            • 8713

            #6
            Originally posted by DomP_nl
            yeah should do the work..


            TrafficCashGold Paying Webmasters Since 1996!

            Awesome Conversions! Fast Weekly Payments! Over 125 Tours!

            Comment

            • studiocritic
              Confirmed User
              • Jun 2005
              • 2442

              #7
              if you have shell access, just do mysqldump -u[username] -p -D [databasename] > [databasename].sql

              so like

              mysqldump -uroot -p -D gfy > gfy.sql

              then it'll ask for root's pass, enter it

              it'll write a file called gfy.sql, that will include all the commands to recreate the db. gzip it up to make it smaller if u want
              254342256

              Comment

              • edgeprod
                Permanently Gone
                • Mar 2004
                • 10019

                #8
                Originally posted by studiocritic
                if you have shell access, just do mysqldump -u[username] -p -D [databasename] > [databasename].sql

                so like

                mysqldump -uroot -p -D gfy > gfy.sql

                then it'll ask for root's pass, enter it

                it'll write a file called gfy.sql, that will include all the commands to recreate the db. gzip it up to make it smaller if u want
                Stop, you're turning me on.

                Comment

                Working...