Table structure backup/restore

Posted in 2009

Topics: Versions, Editions & End-of-Life

DEEPAK JOSHI — Wed, 30 Sep 2009 17:21:20 — source: IIUG Forums & Mailing Lists

Hi All, How I can take the backup of table structure and all its data and how to restore that table including all data.We are using IDS 7.13 running on HP-UNIX 10.01. Thx,

↪ replying to DEEPAK JOSHI

John Miller iii — Wed, 30 Sep 2009 17:29:46 — source: IIUG Forums & Mailing Lists

While you must backup at a system or dbspace level, you can restore at = a table, column and/or row using the table level restore feature introduced in version = 10. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) = From: "DEEPAK JOSHI" <djoshih@hotmail.com> = = To: ids@iiug.org = = Date: 09/30/2009 10:22 AM = = Subject: Table structure backup/restore [17255] = = Sent by: ids-bounces@iiug.org = = Hi All, How I can take the backup of table structure and all its data and how t= o restore that table including all data.We are using IDS 7.13 running on HP-UNIX 10.01. Thx, ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

↪ replying to John Miller iii

Knox, Ernest — Wed, 30 Sep 2009 17:47:54 — source: IIUG Forums & Mailing Lists

Is that available for ontape and onbar for the table, column and/or row, or just onbar? Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Miller iii Sent: Wednesday, September 30, 2009 12:30 PM To: ids@iiug.org Subject: Re: Table structure backup/restore [17256] While you must backup at a system or dbspace level, you can restore at = a table, column and/or row using the table level restore feature introduced in version = 10. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) = From: "DEEPAK JOSHI" <djoshih@hotmail.com> = = To: ids@iiug.org = = Date: 09/30/2009 10:22 AM = = Subject: Table structure backup/restore [17255] = = Sent by: ids-bounces@iiug.org = = Hi All, How I can take the backup of table structure and all its data and how t= o restore that table including all data.We are using IDS 7.13 running on HP-UNIX 10.01. Thx, ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. = ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Knox, Ernest

John Miller iii — Wed, 30 Sep 2009 18:05:36 — source: IIUG Forums & Mailing Lists

It is for both ontape and onbar With Point in Time Table Level Restore you can restore a single table, set of tables, specific columns in the table and/or specific rows in a table. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) = From: "Knox, Ernest" <Ernest.Knox@searshc.com> = = To: ids@iiug.org = = Date: 09/30/2009 10:48 AM = = Subject: RE: Table structure backup/restore [17257] = = Sent by: ids-bounces@iiug.org = = Is that available for ontape and onbar for the table, column and/or row, or just onbar? Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS= ! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [?mailto:ids-bounces@iiug.org] On Behalf Of John Miller iii Sent: Wednesday, September 30, 2009 12:30 PM To: ids@iiug.org Subject: Re: Table structure backup/restore [17256] While you must backup at a system or dbspace level, you can restore at = =3D a table, column and/or row using the table level restore feature introduced in version = =3D 10. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) =3D From: "DEEPAK JOSHI" <djoshih@hotmail.com> =3D =3D To: ids@iiug.org =3D =3D Date: 09/30/2009 10:22 AM =3D =3D Subject: Table structure backup/restore [17255] =3D =3D Sent by: ids-bounces@iiug.org =3D =3D Hi All, How I can take the backup of table structure and all its data and how t= =3D o restore that table including all data.We are using IDS 7.13 running on HP-UNIX 10.01. Thx, ***********************************************************************= =3D ******** Forum Note: Use "Reply" to post a response in the discussion forum. =3D ***********************************************************************= * ******* Forum Note: Use "Reply" to post a response in the discussion forum. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

↪ replying to DEEPAK JOSHI

Art Kagel — Thu, 01 Oct 2009 02:29:46 — source: IIUG Forums & Mailing Lists

dbexport dbimport See the Migration Guide manual for details. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Sep 30, 2009 at 1:21 PM, DEEPAK JOSHI <djoshih@hotmail.com> wrote: > Hi All, > > How I can take the backup of table structure and all its data and how to > restore that table including all data.We are using IDS 7.13 running on > HP-UNIX > 10.01. > > Thx, > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0ce03d0e7e20dc0474d66b40

Glossary

IDS (Informix Dynamic Server)