Page 1 of 2 12 LastLast
Results 1 to 10 of 12

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

  1. #1
    Junior Member
    Join Date
    Mar 2004
    Posts
    27

    Default 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.

  2. #2
    Senior Member
    Join Date
    Mar 2004
    Posts
    124

    Default

    Quote 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

  3. #3
    Senior Member Buddha's Avatar
    Join Date
    Mar 2004
    Location
    Florida USA
    Posts
    825

    Default

    When I have Mac questions, I goto:

    http://www.techsurvivors.net/forums/

    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

  4. #4
    Senior Member
    Join Date
    Mar 2004
    Posts
    124

    Default

    Quote Originally Posted by Buddha
    When I have Mac questions, I goto:

    http://www.techsurvivors.net/forums/

    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

  5. #5
    Junior Member
    Join Date
    Jan 2005
    Posts
    29

    Default

    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.

  6. #6
    Senior Member sdjl's Avatar
    Join Date
    Mar 2004
    Location
    London, UK.
    Posts
    502

    Default

    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:
    http://www.umbi.umd.edu/computing/sshmac.html

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

  7. #7
    Junior Member
    Join Date
    Jan 2005
    Posts
    29

    Default

    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

  8. #8
    Junior Member
    Join Date
    Mar 2004
    Posts
    27

    Default

    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.

  9. #9
    Junior Member
    Join Date
    Jan 2005
    Posts
    29

    Default

    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.

  10. #10
    Junior Member
    Join Date
    Apr 2004
    Posts
    20

    Default

    Quote 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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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