Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3D70698D4 for ; Thu, 8 Dec 2011 10:16:00 +0000 (UTC) Received: (qmail 88616 invoked by uid 500); 8 Dec 2011 10:15:57 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 88590 invoked by uid 500); 8 Dec 2011 10:15:57 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 88582 invoked by uid 99); 8 Dec 2011 10:15:57 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Dec 2011 10:15:57 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [74.125.82.44] (HELO mail-ww0-f44.google.com) (74.125.82.44) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Dec 2011 10:15:49 +0000 Received: by wgbdr13 with SMTP id dr13so2541685wgb.25 for ; Thu, 08 Dec 2011 02:15:29 -0800 (PST) Received: by 10.180.84.33 with SMTP id v1mr4127303wiy.4.1323339329110; Thu, 08 Dec 2011 02:15:29 -0800 (PST) Received: from mvapc ([80.179.102.198]) by mx.google.com with ESMTPS id m5sm7861868wie.2.2011.12.08.02.15.27 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 08 Dec 2011 02:15:28 -0800 (PST) From: "Michael Vaknine" To: References: <001f01ccb575$7fdca730$7f95f590$@com> In-Reply-To: Subject: RE: Schematool Date: Thu, 8 Dec 2011 12:15:15 +0200 Message-ID: <005101ccb592$488b4080$d9a1c180$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0052_01CCB5A3.0C141080" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Acy1jy767c+i7R29Tb+9YER/NmdvigAAwprw Content-Language: en-us X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------=_NextPart_000_0052_01CCB5A3.0C141080 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Thank you Alain. michael From: Alain RODRIGUEZ [mailto:arodrime@gmail.com] Sent: Thursday, December 08, 2011 11:52 AM To: user@cassandra.apache.org Subject: Re: Schematool You should be able to use the CLI "show schema yourkeyspace" if your cassandra is recent enough ( >= 0.8 if I remember well. I think it is better if you are in 0.8.7 because this command was fixed a couple of times in 8.6 and 8.7). You can put the "show schema" command into a file and call it with : "cassandra-cli -h yourhost -f yourfile > 20111208schema" then open your output file and remove the 2 or 3 useless lines that are written before "create yourkeyspace". Hope this will be helpful. Alain 2011/12/8 Michael Vaknine Hi, Since schematool has been removed from Cassandra is there a way to extract the schema from a working cluster in order to create a new empty cluster? Thanks Michael ------=_NextPart_000_0052_01CCB5A3.0C141080 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Thank you Alain.

michael

From:= = Alain RODRIGUEZ [mailto:arodrime@gmail.com]
Sent: Thursday, = December 08, 2011 11:52 AM
To: = user@cassandra.apache.org
Subject: Re: = Schematool

You should be able to use the CLI "show schema = yourkeyspace" if your cassandra is recent enough ( >=3D 0.8 if I = remember well. I think it is better if you are in 0.8.7 because this = command was fixed a couple of times in 8.6 and = 8.7).

You can put the "show schema" command into a = file and call it with : "cassandra-cli -h yourhost -f yourfile > = 20111208schema" then open your output file and remove the 2 or 3 = useless lines that are written before "create = yourkeyspace".

Hope this will be helpful.

Alain

2011/12/8 Michael Vaknine <michaelv@citypath.com><= /o:p>

Hi,

Since schematool has been = removed from Cassandra is there a way to extract
the schema from a = working cluster in order to create a new empty = cluster?

Thanks
Michael

------=_NextPart_000_0052_01CCB5A3.0C141080--