How to clone an existing bugzilla database

[Jon Wilmoth]

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>