How to clone an existing bugzilla database

[usmle Prep]

Thanks  a  lot!!!
--- Jon Wilmoth <JWilmoth at starbucks.com> wrote:
> Assuming your using mysql as a backend:
> 
> MySQL stores its data in files (.frm, .MYD, and
> .MYI). Each database
> instance has its own directory under which the files
> are stored.  Note
> the location of where all instances differs between
> versions of MySQL
> (i.e. verion 3.23.52 data files are under the 'var'
> directory while
> version 4.0.12 are under the 'data' directory). The
> database does it's
> own in-memory caching to improve performance. In
> order to ensure the
> files contain all the data you want them to, you
> need to flush the
> internal cache. The Database Backups section of the
> MySQL manual
> (http://www.mysql.com/doc/en/Backup.html) describes
> this in detail.
> 
> Also, the latest release of the MySQL gui client
> (MySQL Control Center
> 0.9.1 available from
> http://www.mysql.com/products/mysqlcc/index.html)
> lets you create new db's, flush tables and manage
> user
> permissions...very useful for BZ work.
> 
> -----Original Message-----
> From: usmle Prep [mailto:usmlekaplan at yahoo.com] 
> Sent: Thursday, May 08, 2003 8:08 AM
> To: developers at bugzilla.org
> Subject: Re: How to clone an existing bugzilla
> database
> 
> 
> Hi Joel,
> Thanks a lot for your help. We are using 2.16.1
> version.
> Can you please point me to the commands if you can.
> Thanks,
> Srikant
> --- Joel Peshkin <bugreport at peshkin.net> wrote:
> > usmle Prep wrote:
> > 
> > >Dear developers,
> > >I just want to retain the same data structure as
> > >existing bugzilla database. The newly created
> > database
> > >should have all the products,customfields similar
> > to
> > >the existing database, but should n't contain any
> > >bugs.Is it possible to achieve this.
> > >Please let me know.
> > >Thanks,
> > >Srikant
> > >
> > >_
> > >
> > Sure...
> > 
> > Just copy the database and use SQL commands to
> > delete all the records in 
> > bugs, bug_group_map, attachments, etc....
> > 
> > If we knew the Bugzilla version you were using, we
> > might even be able to 
> > tell you the commands to use.
> > 
> > -Joel
> > 
> > 
> > 
> > ----
> > To view or change your list settings, click here:
> >
>
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=usmlekaplan@yahoo.com>
> 
> 
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
> http://search.yahoo.com
> ----
> To view or change your list settings, click here:
>
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=jwilmoth@starbucks.com>
> 
> ----
> To view or change your list settings, click here:
>
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=usmlekaplan@yahoo.com>


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com