List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:May 20 1999 4:27am
Subject:Re: best way to wipe info
View as plain text  
On Wed, May 19, 1999 at 09:08:52PM -0700, Xah Lee wrote:
> Here's the question again: What is the 'best' (i.e. proper, standard,
> scalable, expedient etc.) way to delete all info in a given database but
> keeps the schema? (in mysql)

I missed out on all of the ignorant answers, so maybe this one's
already been sniffed and and pissed on, but it's close enough to
what you're doing now that it might be preferable:

$ mysqldump --opt --nodata db-name | mysql db-name

Tim
Thread
best way to wipe infoXah Lee19 May
Re: best way to wipe infoGraeme B. Davis19 May
  • Re: best way to wipe infoFraser MacKenzie19 May
    • Re: best way to wipe infoglen19 May
    • Re: best way to wipe infoPaul DuBois19 May
Re: best way to wipe infojkraai19 May
Re: best way to wipe infoPiet Wesselman19 May
Re: best way to wipe infounknown19 May
Re: best way to wipe infoXah Lee20 May
Re: best way to wipe infoSasha Pachev20 May
Re: best way to wipe infoThimble Smith20 May
Re: best way to wipe infoPaul DuBois20 May
Re: best way to wipe infoGraeme B. Davis20 May