Professional Web Applications Themes

Mysql on os/x 10.4 server - MySQL

Finally bit the bullet and upgraded to os/x server. Had to do a clean install (non upgrade). So now I'm back at square one. have a few questions: I installed 5.0.37 for OS/X (DMG format). I started getting the error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (38) Googling gave a number of suggestions, none really OS/X specific, but involved editing my /etc/php.ini and putting in mysql.default_socket = /var/mysql/mysql.sock /etc/my.cnf , and putting [mysqld] socket=/var/mysql/mysql.sock Yesterday, it worked. Granted, I had no databases, but it worked. So my multi part question is: What am I ...

  1. #1

    Default Mysql on os/x 10.4 server

    Finally bit the bullet and upgraded to os/x server. Had to do a clean
    install (non upgrade). So now I'm back at square one. have a few
    questions:

    I installed 5.0.37 for OS/X (DMG format). I started getting the error
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket
    '/var/mysql/mysql.sock' (38)

    Googling gave a number of suggestions, none really OS/X specific, but
    involved editing my /etc/php.ini and putting in

    mysql.default_socket = /var/mysql/mysql.sock

    /etc/my.cnf , and putting
    [mysqld]
    socket=/var/mysql/mysql.sock

    Yesterday, it worked. Granted, I had no databases, but it worked.

    So my multi part question is:

    What am I doing wrong?
    I've tried creating just that directory, creating the directory and a
    empty file, no go.

    When I do get it up and running, is there a way to import everything
    from say
    /Volumes/Macintosh HD/usr/local/mysql-max-5.0.27-osx10.4-powerpc/data/
    (That's where all my .frm and other data is.)

    Thanks.

    Evan
    Evan Guest

  2. #2

    Default Re: Mysql on os/x 10.4 server

    On Mar 11, 1:55 pm, Evan Platt <espphotography.com>
    wrote: 

    Perhaps you have no global MySQL conf (e.g. /etc/my.cnf) which would
    set parameters like socket path, data directory, etc.?
     

    If you can't run your old server any more, then mysqldump'ing won't be
    possible. You could try (making a backup, then...) setting the data
    directory of your new installation to the old data directory (in
    global conf, referred to above).

    I haven't often used an OS X installation of MySQL but I am happy to
    look at this further on my own OS X systems if you want more specific
    help.
     


    toby Guest

  3. #3

    Default Re: Mysql on os/x 10.4 server

    Hi,

    i had the same issue.
    Reason for me was that i have a dialup connection which gives me a
    different hostname every time.

    For me a restart did the trick.

    When i connect i use 127.0.0.,1, localhost gives me trouble.

    I'd test xampp which is very nice, but they have only a intel version.

    kind regards,

    Toni

    In article <com>,
    Evan Platt <espphotography.com> wrote:
     

    Oh. os/x server. No clue with that. I use xampp and OSX 10.4.8

    regards,

    Toni

    --
    Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner
    A. Guest

  4. #4

    Default Re: Mysql on os/x 10.4 server

    On Mon, 12 Mar 2007 16:23:35 +0100, A. Dischner wrote: 

    IIRC, localhost != 127.0.0.1 as far as mysql is concerned. 127.0.0.1
    uses a network socket (must turn on network access) and access is
    granted via <userid>%, localhost uses a local (filebased) unix socket
    instead and access is granted via <userid>localhost

    --
    38. If an enemy I have just killed has a younger sibling or offspring
    anywhere, I will find them and have them killed immediately, instead of
    waiting for them to grow up harboring feelings of vengeance towards me in
    my old age. --Peter Anspach's list of things to do as an Evil Overlord
    Peter Guest

  5. #5

    Default Re: Mysql on os/x 10.4 server

    On 11 Mar 2007 13:25:41 -0700, "toby" <com.au>
    wrote:
     

    Ok, I've got mysql 5 up and running (5.0.37 I believe).

    What's the easiest way now to import data from, according to the
    directory name, 4.1.21? Can I simply copy everything over?

    Also, where is the ... settings, such as usernames and passwords
    stored? In those directories?

    Thanks. :)

    Evan
    Evan Guest

  6. #6

    Default Re: Mysql on os/x 10.4 server

    On Mar 13, 1:52 am, Evan Platt <espphotography.com>
    wrote: 

    >
    > Ok, I've got mysql 5 up and running (5.0.37 I believe).
    >
    > What's the easiest way now to import data from, according to the
    > directory name, 4.1.21? Can I simply copy everything over?[/ref]

    The safest way is to mysqldump from the 4.1 server, which would mean
    installing 4.1 to do so.

    Since you probably don't want to go to that trouble, you could try
    accessing your existing data files in 5.0. I would do something like
    this:
    * back up your 4.1 data files.
    * change the datadir in v5.0 my.cnf to the 4.1 data directory.
    * follow the recommendations in http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
    in particular, see http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html
     

    Yes, that's all in the existing 'mysql' database.
     

    HTH
    --Toby
     


    toby Guest

Similar Threads

  1. Replies: 0
    Last Post: January 29th, 02:03 PM
  2. Replies: 7
    Last Post: June 12th, 07:43 AM
  3. Replies: 1
    Last Post: January 27th, 02:49 AM
  4. Replies: 0
    Last Post: January 24th, 10:55 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139