Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Percona Discussion
Home
+ new post
About this group
Join this group
Percona tool pt-online-chema-change problem ....
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   4 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
mySQLgirl  
View profile  
 More options Nov 16 2012, 2:31 am
From: mySQLgirl <yerik...@gmail.com>
Date: Thu, 15 Nov 2012 23:31:52 -0800 (PST)
Local: Fri, Nov 16 2012 2:31 am
Subject: Percona tool pt-online-chema-change problem ....
Print | Individual message | Show original | Report this message | Find messages by this author

HELP
What's wrong with my command ?
it will not work , why?
I have tried all kinds alternative but this should work !!!
thx
Yvonne

[root@itdtstdb01 ~]# pt-online-schema-change --user=root --ask-pass --alter
"ADD column ip VARCHAR(32)"  D=ye t=ye2  h=localhost   --dry-run
Usage: pt-online-schema-change [OPTIONS] DSN

Errors in command-line arguments:
  * Specify only one DSN on the command line
  * The DSN must specify a database (D) and a table (t)


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Ovais Tariq  
View profile  
 More options Nov 16 2012, 6:06 am
From: Ovais Tariq <ovais.ta...@percona.com>
Date: Fri, 16 Nov 2012 16:00:00 +0500
Subject: Re: [percona-group] Percona tool pt-online-chema-change problem ....
Print | Individual message | Show original | Report this message | Find messages by this author

The command line used is wrong, it should be as follows:

pt-online-schema-change --user=root --ask-pass --alter "ADD column ip
VARCHAR(32)" --dry-run D=ye,t=ye2,h=localhost

where "ye" I suppose is the name of the database and "ye2" is the name of
the table that has to be altered.

Best,

--

Ovais Tariq, Principal Support Engineer, Percona Inc.

http://www.percona.com | http://www.mysqlperformanceblog.com
Phone               : +1 (888) 401-3401 Ext. 552
Mobile               : +92 3212949959 (PKT)
24/7 Emergency : +1 888 401 3401 ext 911
Skype               : ovaistariq

Training : http://www.percona.com/training/
Support  : http://www.percona.com/mysql-support/

Percona Live MySQL Conference: New York 2012
http://www.percona.com/live/nyc-2012/


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Ewen Fortune  
View profile  
 More options Nov 16 2012, 9:02 am
From: Ewen Fortune <ewen.fort...@gmail.com>
Date: Fri, 16 Nov 2012 15:02:02 +0100
Local: Fri, Nov 16 2012 9:02 am
Subject: Re: [percona-group] Percona tool pt-online-chema-change problem ....
Print | Individual message | Show original | Report this message | Find messages by this author
Yvonne,

On Fri, Nov 16, 2012 at 12:00 PM, Ovais Tariq <ovais.ta...@percona.com> wrote:
> The command line used is wrong, it should be as follows:

> pt-online-schema-change --user=root --ask-pass --alter "ADD column ip
> VARCHAR(32)" --dry-run D=ye,t=ye2,h=localhost

As a side note, it looks like you are going to store an IP address as
VARCHAR(32)
If this is the case, you may wish to store as a 4 byte INT and convert
from and to dotted quad using the inet_aton and inet_ntoa

http://dev.mysql.com/doc/refman/5.5/en/miscellaneous-functions.html#f...
http://dev.mysql.com/doc/refman/5.5/en/miscellaneous-functions.html#f...

Ewen


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Justin Swanhart  
View profile  
 More options Nov 16 2012, 10:37 am
From: Justin Swanhart <justin.swanh...@percona.com>
Date: Fri, 16 Nov 2012 08:37:42 -0700
Local: Fri, Nov 16 2012 10:37 am
Subject: Re: [percona-group] Percona tool pt-online-chema-change problem ....
Print | Individual message | Show original | Report this message | Find messages by this author

Hi,
A DSN must have no spaces and items in the DSN are comma separated.  

Try this:
"D=ye,t=ye2"

Sent from my iPhone

On Nov 16, 2012, at 12:31 AM, mySQLgirl <yerik...@gmail.com> wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2013 Google