Professional Web Applications Themes

HELP! How can I get my tables (.FRM etc..) back into a database. - MySQL

Hi, Can anybody tell me how I can get the backup ( just a file copy of the directory with .frm, .MYI and .MYD files) back into a newly created database. I am failry new to MySQL. Due to a crash of my Windows 2003 server I was in a hurry creating a very quick backup so I didn't tokk the time to find out what a correct backup mechanisme shoul be. Now I have a new server and installed the latest MYSQL (I think I had an earlier version before) I just copied the files into the "mysql datafiles" ...

  1. #1

    Default HELP! How can I get my tables (.FRM etc..) back into a database.

    Hi,

    Can anybody tell me how I can get the backup ( just a file copy of the
    directory with .frm, .MYI and .MYD files) back into a newly created
    database.
    I am failry new to MySQL.
    Due to a crash of my Windows 2003 server I was in a hurry creating a very
    quick backup so I didn't tokk the time to find out what a correct backup
    mechanisme shoul be.
    Now I have a new server and installed the latest MYSQL (I think I had an
    earlier version before)
    I just copied the files into the "mysql datafiles" folder. It doesn't pick
    them up automaticaly.
    Can anybody tell me how to get them back in.

    I can't imagine the data's lost ?

    Many, many, Thanx in advance...

    Erik


    Erik van der Veen Guest

  2. #2

    Default Re: HELP! How can I get my tables (.FRM etc..) back into a database.

    Oke..

    Solved my own problem allready....
    Seemed that after reconfiguring the newly installed database to only ISAM
    usage, the data directory reverted to default.
    So I was putting the files in the wrong directory...

    Thanx







    "Erik van der Veen" <erik_vanderveenhotmail.com> schreef in bericht
    news:4409e950$0$11067$e4fe514cnews.xs4all.nl...
    > Hi,
    >
    > Can anybody tell me how I can get the backup ( just a file copy of the
    > directory with .frm, .MYI and .MYD files) back into a newly created
    > database.
    > I am failry new to MySQL.
    > Due to a crash of my Windows 2003 server I was in a hurry creating a very
    > quick backup so I didn't tokk the time to find out what a correct backup
    > mechanisme shoul be.
    > Now I have a new server and installed the latest MYSQL (I think I had an
    > earlier version before)
    > I just copied the files into the "mysql datafiles" folder. It doesn't pick
    > them up automaticaly.
    > Can anybody tell me how to get them back in.
    >
    > I can't imagine the data's lost ?
    >
    > Many, many, Thanx in advance...
    >
    > Erik
    >

    Erik van der Veen Guest

  3. #3

    Default Re: HELP! How can I get my tables (.FRM etc..) back into a database.

    "Erik van der Veen" <erik_vanderveenhotmail.com> wrote in message
    news:440a0a1a$0$11077$e4fe514cnews.xs4all.nl...
    > Due to a crash of my Windows 2003 server I was in a hurry creating a very
    > quick backup so I didn't tokk the time to find out what a correct backup
    > mechanisme shoul be.
    So you waited until you had a server crash before you thought about making
    database backups?
    > Seemed that after reconfiguring the newly installed database to only ISAM
    > usage, the data directory reverted to default.
    > So I was putting the files in the wrong directory...
    For what it's worth, the proper backup technique uses the "mysqldump" tool
    (or GUI front end to same). Read about backing up and restoring in the
    following section of the docs:
    [url]http://dev.mysql.com/doc/refman/5.0/en/disaster-prevention.html[/url]

    It is not safe to back up the files in the data directory while the MySQL
    server is running, because the contents of the files don't necessarily
    include all committed data in the databases; some data could reside in
    cache, in the memory of the MySQL service's process. If you copy the files
    in the data dir, you might get a version of the database that is incomplete
    and internally inconsistent.

    Regards,
    Bill K.


    Bill Karwin Guest

Similar Threads

  1. comparing 2 tables 1 database
    By adult.swim in forum Coldfusion Database Access
    Replies: 6
    Last Post: April 28th, 04:47 PM
  2. Database Tables Creation
    By webhead_1 in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: July 7th, 04:33 AM
  3. Missing Database Tables
    By mike400hp in forum Dreamweaver AppDev
    Replies: 1
    Last Post: May 26th, 09:20 PM
  4. Database is connecting but not seeing tables
    By saadiq31 in forum Dreamweaver AppDev
    Replies: 0
    Last Post: February 22nd, 02:23 PM
  5. Database Tables Not Showing
    By Khan44 in forum Dreamweaver AppDev
    Replies: 9
    Last Post: February 19th, 03:56 AM

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