How To: download sql database on MAC...?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Aze
    Junior Member
    • Mar 2004
    • 27

    How To: download sql database on MAC...?

    Hey folks,

    I remember to backup my forums database (on my PC) I used to use the 'PuTTy' program. It's been a while, I don't remember how to use PuTty [I forgot the script code] - also, I'm now using a MAC (osx 10.3.3). Will PuTty work for Mac? If not - then what program do I use (free)?

    Thanks in advance,
    - Aze.
  • halyfax
    Senior Member
    • Mar 2004
    • 124

    #2
    Originally posted by Aze
    Hey folks,

    I remember to backup my forums database (on my PC) I used to use the 'PuTTy' program. It's been a while, I don't remember how to use PuTty [I forgot the script code] - also, I'm now using a MAC (osx 10.3.3). Will PuTty work for Mac? If not - then what program do I use (free)?

    Thanks in advance,
    - Aze.
    have you used teh built in backup in your cpanel

    Comment

    • Buddha
      Senior Member
      • Mar 2004
      • 825

      #3
      When I have Mac questions, I goto:



      It helps to know where the Mac people hang out.
      "Whatcha mean I shouldn't be rude to my clients?! If you want polite then there will be a substantial fee increase." - Buddha

      Comment

      • halyfax
        Senior Member
        • Mar 2004
        • 124

        #4
        Originally posted by Buddha
        When I have Mac questions, I goto:



        It helps to know where the Mac people hang out.
        I have to recommend baseboard.net for all you mac people out there. High quality people there

        Comment

        • dammitjanet
          Junior Member
          • Jan 2005
          • 29

          #5
          peter

          Try using SSH, there should be a version already on the mac.

          Personally, I dont use the databse backup feature, as it as very poor IMHO. It never puts backticks around table names or column names which can and does cause problems on a restore.

          PHPMySqlAdmin from the control panel does give you a better degree of control over the dump process, but sometimes has similar issues.

          Comment

          • sdjl
            Senior Member
            • Mar 2004
            • 502

            #6
            I think Aze is trying to use MySQL via command line to dump the database down and then transfer it.
            If you do a search on google for MAC SSH tools, you get a few links appear.
            Try this one:


            David
            -----
            Do you fear the obsolescence of the metanarrative apparatus of legitimation?

            Comment

            • dammitjanet
              Junior Member
              • Jan 2005
              • 29

              #7
              actually i tred this on my iBook last night, ssh is installed on the mac and its usable.

              I went in and did both a mysqldump and a full mysql session

              Comment

              • Aze
                Junior Member
                • Mar 2004
                • 27

                #8
                Okay, maybe I wasn't that clear on this one.

                I have a VBulletin installed on my website - and fear of having it hacked (again) leads me to want to download the database regularly - just as I did with PuTty on my PC. So... I'm just looking for a MAC program to do so, and some help [possibly a step-by-step] on how to work it.

                Comment

                • dammitjanet
                  Junior Member
                  • Jan 2005
                  • 29

                  #9
                  Putty is a SSH client for the PC, so bscially its the same on the mac, just use SSH instead and follow the same instructions you used on the pc.

                  Comment

                  • joan
                    Junior Member
                    • Apr 2004
                    • 20

                    #10
                    Originally posted by Aze
                    Okay, maybe I wasn't that clear on this one.

                    I have a VBulletin installed on my website - and fear of having it hacked (again) leads me to want to download the database regularly - just as I did with PuTty on my PC. So... I'm just looking for a MAC program to do so, and some help [possibly a step-by-step] on how to work it.
                    Here's how I'd do it.

                    Run terminal. Open two windows.
                    In one window, ssh to your host
                    Code:
                    ssh username@sitename.com
                    Login, then run your dump command
                    Code:
                    mysqldump -udbusername -pdbpassword  sitename_dbname | gzip -c >database.sql.gz
                    Then in the other window, copy it to your mac
                    Code:
                    scp username@sitename.com:database.sql.gz ./database.sql.gz

                    Comment

                    • Aze
                      Junior Member
                      • Mar 2004
                      • 27

                      #11
                      I don't know how to 'run terminal'. Do I need to download an application first? If so which, if not, then what do I run?... I'm so lost.

                      Thanks in advance,
                      - Aze.

                      Comment

                      • openbox
                        Senior Member
                        • Mar 2004
                        • 238

                        #12
                        Look in Applications/Utilities for the Terminal program.

                        Comment

                        Working...