Professional Web Applications Themes

How to re-attach database after crash - MySQL

Hi, Maybe there's a FAQ here, but I did not find it. So I hope you don't mind me putting my qustion directly in this group. Situation: harddisk crash. Fortunately it was the systemdisk that crashed, so all the data was preserved. I've reinstalled MySQL agin, but now I need to re-attach the tables/ database from E:\Mysql50\F1 to the server. Can anyone tell me how? There's no back-up since this is a experimental server... Thanx in advance! Ron...

  1. #1

    Default How to re-attach database after crash

    Hi,

    Maybe there's a FAQ here, but I did not find it.
    So I hope you don't mind me putting my qustion directly in this group.
    Situation: harddisk crash. Fortunately it was the systemdisk that
    crashed, so all the data was preserved.
    I've reinstalled MySQL agin, but now I need to re-attach the tables/
    database from E:\Mysql50\F1 to the server.
    Can anyone tell me how? There's no back-up since this is a
    experimental server...

    Thanx in advance!

    Ron

    Ron Guest

  2. #2

    Default Re: How to re-attach database after crash

    Ron wrote: 

    Ron,

    It might be as simple as just going into your my.ini file and changing
    the datadir to E:\Mysql50\F1. Assuming, of course, you're running the
    same version of mySQL.

    Of course you'll have to restart MySQL.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  3. #3

    Default Re: How to re-attach database after crash

    Jerry Stuckle wrote: 
    >
    > Ron,
    >
    > It might be as simple as just going into your my.ini file and changing
    > the datadir to E:\Mysql50\F1. Assuming, of course, you're running the
    > same version of mySQL.
    >
    > Of course you'll have to restart MySQL.
    >[/ref]

    just copy the old data folder's contents to the new data folder, restart
    mysql and you should be back in business.

    --
    lark -- net
    To reply to me directly, delete "despam".
    lark Guest

Similar Threads

  1. How to recover a SQL Server database after a crash
    By Amit Basu in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: August 14th, 08:37 AM
  2. #40473 [NEW]: Crash with SQL database
    By william91 at hgcbroadband dot com in forum PHP Bugs
    Replies: 1
    Last Post: February 14th, 10:55 AM
  3. attach check box with database query result
    By sweetyp2005 in forum Coldfusion - Getting Started
    Replies: 3
    Last Post: October 19th, 07:00 PM
  4. attach 1 movie, then attach 3 movies to it, help?
    By kie webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 6
    Last Post: January 22nd, 05:09 PM
  5. attach database
    By xixi in forum IBM DB2
    Replies: 0
    Last Post: July 9th, 08:29 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