Professional Web Applications Themes

upgraded mysql, lost all data? - MySQL

Evan Platt <evantheobvious.espphotography.com> writes: > Running OS / X, A while ago, attempted to compile MySql5. Didn't take > as far as I could tell, mysql -v still said 4. > > Today, near as I can tell after doing a fink-update, my mysql database > is gone. > > Mysql -v shows: > Your MySQL connection id is 79 to server version: 5.0.18-standard > > Unfortunately, I don't know enough SQL to be even dangerous. It's > mainly for my mambo server. > > Is there a way to find where my old data was and put it back ...

  1. #1

    Default Re: upgraded mysql, lost all data?

    Evan Platt <evantheobvious.espphotography.com> writes:
    > Running OS / X, A while ago, attempted to compile MySql5. Didn't take
    > as far as I could tell, mysql -v still said 4.
    >
    > Today, near as I can tell after doing a fink-update, my mysql database
    > is gone.
    >
    > Mysql -v shows:
    > Your MySQL connection id is 79 to server version: 5.0.18-standard
    >
    > Unfortunately, I don't know enough SQL to be even dangerous. It's
    > mainly for my mambo server.
    >
    > Is there a way to find where my old data was and put it back in my
    > 5.0 database? I don't even know what files to look for.
    In Terminal try 'which database_name' and/or 'find database_name' and
    see what turns up. Since you created the database(s), I am presuming
    you know the name(s). I'm just learning MySQL myself, so I can't say
    anything about what to do from inside it.
    > Hope this makes sense. It's late and I've spent the last few hours
    > trying to figure this out.
    I think it's an issue of the Fink filesystem. Fink creates it's own
    filesystem within the OS X filesystem- just about everything installed
    under Fink is placed in /sw and Fink modifies your $PATH to look for stuff
    there. My hunch is that your new version of mysql is looking for your
    databases perhaps in /sw/usr/local/ but your databases are probably in
    /usr/local/mysql instead.

    Are you using Fink for other packages, or just to install MySQL? If
    the latter, I'd recommend dumping Fink and removing the /sw parts of
    your $PATH. Fink is useful but also creates a number ofproblems by
    seting up its own filesystem in /sw. There is a native OS X version
    of 5.0.18 available at [url]www.mysql.com[/url] that will install into
    /usr/local. Make sure that you add /usr/local/mysql/bin to your $PATH
    so that your shell (bash by default in 10.3.x or 10.4.x) can find the
    MySQL binary. The OS X release from MySQL will also give you a
    prefpane for starting and stopping MySQL. There's also a MySQL
    Administrator application that seems pretty slick.

    If you want to keep Fink, then at least try adding
    /usr/local/mysql/bin and /usr/local/mysql to your $PATH and see if
    that fixes the problem.

    Hope this helps!
    Tim McNamara Guest

  2. #2

    Default Re: upgraded mysql, lost all data?

    Evan Platt <evantheobvious.espphotography.com> writes:
    > Adding the two directories to my path did the trick.
    > mysql -v now says 4.1.10, but I have my data back. :)
    Excellent! If you feel the need to upgrade to 5.0.18, consider the
    ..pkg binary from [url]www.mysql.com[/url] (and read the pages on ugrading, of
    course). And backing up that databse might not be a bad idea... ;-)
    Tim McNamara Guest

Similar Threads

  1. #38921 [NEW]: pdo lost the first row data:with firebird blob data
    By achun dot shx at gmail dot com in forum PHP Bugs
    Replies: 2
    Last Post: January 27th, 12:54 PM
  2. Replies: 1
    Last Post: January 23rd, 12:06 PM
  3. MySQL Databases lost
    By Stephane M in forum MySQL
    Replies: 3
    Last Post: April 5th, 03:34 PM
  4. Lost MySql Table Access
    By r.mcinteer in forum Dreamweaver AppDev
    Replies: 2
    Last Post: March 29th, 10:33 AM
  5. Upgraded php, lost php file association
    By steve in forum PHP Development
    Replies: 4
    Last Post: August 11th, 11:01 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