Clean database

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 427,753 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,702 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 3124 | Replies: 2

•

Join Date: Jun 2006

Posts: 1

Reputation: Shaftcmu is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

Shaftcmu

Offline

Newbie Poster

Clean database

Jun 13th, 2006

I need to "clean" the database so I only have data starting from 1-1-06. Can anyone help? Thanks.

•

Join Date: Jul 2005

Location: Dallas, TX

Posts: 481

Reputation: campkev is an unknown quantity at this point

Rep Power: 4

Solved Threads: 19

campkev

Offline

Posting Pro in Training

Re: Clean database

Jun 13th, 2006

what is your schema? do you have date fields in all the tables that need to be purged

•

Join Date: Oct 2005

Location: Manchester, UK

Posts: 482

Reputation: pty is on a distinguished road

Rep Power: 3

Solved Threads: 33

pty

Offline

Posting Pro in Training

Re: Clean database

Jun 13th, 2006

•

Originally Posted by Shaftcmu

I need to "clean" the database so I only have data starting from 1-1-06. Can anyone help? Thanks.

if you don't have date fields in the tables you want to 'clean', or tables you can easily join, it could be tricky.

can't you just revert to a backup?