Re: Installing Mysql Workbench

2012-02-16 Thread Adarsh Sharma
Thanks Vikas, I checked my versions and below are the details :- [root@]# gcc --version gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46) Copyright (C) 2006 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY

Re: Adding a column to a huge mysql table

2012-02-16 Thread Singer X.J. Wang
If you have a Master-Master and you explicitly name all the columns in your queries, you can do it by doing it on one master and flipping the application and etc. If not, look at http://www.percona.com/doc/percona-toolkit/2.0/pt-online-schema-change.html Singer On Thu, Feb 16, 2012 at 20:29, Wi

Re: Adding a column to a huge mysql table

2012-02-16 Thread Willy Mularto
duplicate the table structure, add the column to the new table, import the records into the table. this should be faster based on my experience and also will not disturb your transactions :) On Feb 17, 2012, at 8:21 AM, Angela liu wrote: > Hi, Folk: > > I will need to add a column to a huge

Re: Upgrade 5.0 -> 5.1 - long table names with invalid chars.

2012-02-16 Thread Shawn Green (MySQL)
On 2/15/2012 22:16, Bobb Crosbie wrote: Hi Folks, I'm preparing an upgrade of a 5.0.51a database to 5.1.58 (Ubuntu 11.10) - Some of the table names contain invalid characters which mysql_upgrade (mysqlcheck) is attempting to escape by renaming the filename. However I'm having trouble with some

Re: Installing Mysql Workbench

2012-02-16 Thread Adarsh Sharma
Any update on the issue Dear all, Today I am facing some issues while installing mysql-workbench-gpl-5.2.37-src] in CentOS 5.4. ./configure runs successfully but below command results in below error : make make[3]: Entering directory `/root/Desktop/MYSQLWORKBENCH/mysql-workbench-gpl-5.2.