Professional Web Applications Themes

MySQL - saving data - MySQL

Hello, just another questions I have 3 databased : A, B, C I can find these 3 databases into /var/lib/mysql/ (3 folders and 2 Ib_log files and a file called : mysql.sock) If I save only these 3 folders ? should it be enough to recover it in case of crash ? THanks for your help...

  1. #1

    Default MySQL - saving data

    Hello, just another questions

    I have 3 databased : A, B, C
    I can find these 3 databases into /var/lib/mysql/
    (3 folders and 2 Ib_log files and a file called : mysql.sock)

    If I save only these 3 folders ? should it be enough to recover it in case
    of crash ?

    THanks for your help


    Stephane M Guest

  2. #2

    Default Re: MySQL - saving data

    Stephane M wrote:
    > I can find these 3 databases into /var/lib/mysql/
    > (3 folders and 2 Ib_log files and a file called : mysql.sock)
    >
    > If I save only these 3 folders ? should it be enough to recover it in case
    > of crash ?
    This is not a safe or reliable way of backing up the data. As Peter
    Coffin points out, you should use the mysqldump tool that comes with MySQL.

    The reason copying the files is not reliable is that the MySQL server
    may keep some data in memory, not yet written to disk. If you copy the
    files, you may get an incomplete version of the database. Maybe not
    this time, but sometimes you will.

    Use mysqldump; it is designed to get all the data correctly. Basically,
    I agree fully with Peter, I just want to reinforce the recommendation. :)

    There is no need to back up the log files or the mysql.sock file, to
    recover databases.

    Regards,
    Bill K.
    Bill Karwin Guest

Similar Threads

  1. Replies: 0
    Last Post: March 8th, 09:16 AM
  2. saving data from a w3d game
    By ImLearningW3D in forum Macromedia Director 3D
    Replies: 2
    Last Post: April 10th, 02:41 AM
  3. saving data from .FSO
    By GaryCCY in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: March 23rd, 07:40 AM
  4. saving data in XML
    By paulo fabiano in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: March 3rd, 05:21 PM
  5. Saving data to desktop - XML?
    By zorkus238 in forum Macromedia Flash Actionscript
    Replies: 3
    Last Post: February 20th, 06:51 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