SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Feb 2001
    Location
    Utah
    Posts
    174
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy Removing all data from a specific date.

    I run a good size vbulletin (v2.x) community. I believe the database is corupt on July 31st, each time i run the mysql repair tool, i loose all data in the post table after this date.

    Is there a way i can split the database into three parts, pre july 30th, july 31st and aug 1st, and aug 2nd and later. Then delete all data on the 31st and 1st, and merge the two halfs together?

    If not, how would i write a query that could delete all data in the database on these two days?

  2. #2
    SitePoint Addict Avido's Avatar
    Join Date
    Jul 2003
    Location
    Kortrijk, Belgium, Europe, the world
    Posts
    203
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Can't you export the whole thing in sql-format. Delete the lines that are supposed to be corrupt and re-import the modified file again.


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
  •