Web Analytics Made Easy -
StatCounter Urgent: Any way to undelete data? - CodingForum

Announcement

Collapse
No announcement yet.

Urgent: Any way to undelete data?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Urgent: Any way to undelete data?

    Hi,

    I have some data that was accidentely deleted in mysql.

    Is there any way I can retrieve it?

  • #2
    do you host the server your self or do you pay someone to do it?
    if you pay for hosting, they may have a backup system. You would need to
    contact them.
    eak | "Doing a good deed is like wetting your pants; every one can see the results, but only you can feel the warmth."

    Comment


    • #3
      ok thanks

      on another note, perhaps i should be creating another thread but..
      i did a search and didn't find anything

      what's the best way to back up your mysql database?
      Is it backing up the database itself or doing an complete backup of the server itself.

      What is normally done to a daily backup?

      thanks

      Comment


      • #4
        MySQLdump is what you want to look at.
        http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
        eak | "Doing a good deed is like wetting your pants; every one can see the results, but only you can feel the warmth."

        Comment


        • #5
          also look into mysqlhotcopy it will allow you to copy your data from a running database. to get an accurate copy of your database using mysqldump you must stop the server.

          Comment

          Working...
          X