Re: duplicating a database
1. Use dbexport to export the Database.
2. This will create a <dbname>.exp Directory.
3. Rename it to <newdbname>.exp.
4. Cd to that directory and do the same with the <dbname>.sql file
5. Use dbimport to import the Database.
See dbexport -- And dbimport -- for the command options.
If your Database is over 2 GIG then repost, you'll need different
commands.
HTH,
Zev Berezin
Informix DBA
B&H Photo
www.bhphoto.com
On 17 Jun 2003, at 12:50, web_djs wrote:
> I'd like to make an exact copy of my current database and rename it to
> something else. How do I do this?
>
> Norm
>
sending to informix-list
In message <bco1t4$11e$1@terabinaries.xmission.com>, Zev Berezin
<zevb@bhphotovideo.com> writes
>
>1. Use dbexport to export the Database.
>2. This will create a <dbname>.exp Directory.
>3. Rename it to <newdbname>.exp.
>4. Cd to that directory and do the same with the <dbname>.sql file
>5. Use dbimport to import the Database.
>
>See dbexport -- And dbimport -- for the command options.
>
>If your Database is over 2 GIG then repost, you'll need different
>commands.
>
>HTH,
>Zev Berezin
>Informix DBA
>B&H Photo
>www.bhphoto.com
>
>
>On 17 Jun 2003, at 12:50, web_djs wrote:
>
>> I'd like to make an exact copy of my current database and rename it to
>> something else. How do I do this?
>>
>> Norm
>>
>
>
>sending to informix-list
Although this would duplicate the content, queries (etc) against the
'new' database would not exhibit the same time response owing to disk
layout, index filling, statistics, etc, differences.
--
Andrew Lennard andy@kontron.demon.co.uk