Re: Data masking for mysql

2014-04-16 Thread shawn l.green
. That's why data masking tool required. -Original Message- From: "Jigal van Hemert" Sent: Wednesday, 16 April, 2014 11:56am To: mysql@lists.mysql.com Subject: Re: Data masking for mysql Hi, On 15-4-2014 18:42, Peter Brawley wrote: On 2014-04-15 5:37 AM, reena.kam...@jktech

Re: Data masking for mysql

2014-04-16 Thread reena . kamboj
From: "Jigal van Hemert" Sent: Wednesday, 16 April, 2014 11:56am To: mysql@lists.mysql.com Subject: Re: Data masking for mysql Hi, On 15-4-2014 18:42, Peter Brawley wrote: > On 2014-04-15 5:37 AM, reena.kam...@jktech.com wrote: >> It can be done by data masking tool itself.

Re: Data masking for mysql

2014-04-15 Thread Jigal van Hemert
wrong here :-) -- Kind regards / met vriendelijke groet, Jigal van Hemert. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
jktech.com, "mysql@lists.mysql.com" Subject: Re: Data masking for mysql On 2014-04-15 5:37 AM, reena.kam...@jktech.com wrote: > It can be done by data masking tool itself. Its one time activity, I do not > need it again & again. Rilly? If that's so, the data will never be ac

Re: Data masking for mysql

2014-04-15 Thread Peter Brawley
sage- From: "Reindl Harald" Sent: Tuesday, 15 April, 2014 2:49pm To: mysql@lists.mysql.com Subject: Re: Data masking for mysql Am 15.04.2014 11:08, schrieb reena.kam...@jktech.com: Yes, we can do it at application level and database level as well. for example mobile no. is 987841587

Re: Data masking for mysql

2014-04-15 Thread Jigal van Hemert
s of functions available to manipulate the data itself. [1] http://dev.mysql.com/doc/refman/5.5/en/update.html [2] http://dev.mysql.com/doc/refman/5.5/en/functions.html -- Kind regards / met vriendelijke groet, Jigal van Hemert. -- MySQL General Mailing List For list archives: http://lists.mysql

Re: Data masking for mysql

2014-04-15 Thread Reindl Harald
to do this - that's what sysadmins get paied for how do you expect ready tool matching exact a single one-time-need? > -Original Message- > From: "Reindl Harald" > Sent: Tuesday, 15 April, 2014 2:49pm > To: mysql@lists.mysql.com > Subject: Re: Data masking for

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
Actually data masking is a one time activity, so I need data masking tool. I do not need it again & again. -Original Message- From: "Jigal van Hemert" Sent: Tuesday, 15 April, 2014 3:43pm To: mysql@lists.mysql.com Subject: Re: Data masking for mysql Hi, On 15-4-2014 11

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
It can be done by data masking tool itself. Its one time activity, I do not need it again & again. Please suggest data masking tool link. -Original Message- From: "Reindl Harald" Sent: Tuesday, 15 April, 2014 2:49pm To: mysql@lists.mysql.com Subject: Re: Data masking f

Re: Data masking for mysql

2014-04-15 Thread Jigal van Hemert
-- xx5877) by using data masking. We can use any one data masking technique to protect our sensitive data from external exposure. I need a tool which will mask data in existing mysql db. You could create a VIEW on that table which contains processed columns. Use a special user for the

Re: Data masking for mysql

2014-04-15 Thread Reindl Harald
77) by using data masking. We can use any one data masking technique > at DB level to protect our sensitive data from external exposure. > I have sensitive data in existing mysql db. I need to do data masking at DB > level. > If any tools available for the same please respond

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
level to protect our sensitive data from external exposure. I have sensitive data in existing mysql db. I need to do data masking at DB level. If any tools available for the same please respond. -Original Message- From: "Manuel Arostegui" Sent: Tuesday, 15 April, 2014 2:02pm To:

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
data masking technique to protect our sensitive data from external exposure. I need a tool which will mask data in existing mysql db. -Original Message- From: "Reindl Harald" Sent: Tuesday, 15 April, 2014 1:51pm To: mysql@lists.mysql.com Subject: Re: Data masking for mysql Am

Re: Data masking for mysql

2014-04-15 Thread Manuel Arostegui
2014-04-15 8:52 GMT+02:00 : > Hi, > > I need to do data masking to sensitive data exists in mysql db. is there > any data masking tool available for mysql with linux platform. > if yes... please provide the links. > else... please suggest other alternatives for this requi

Re: Data masking for mysql

2014-04-15 Thread Reindl Harald
Am 15.04.2014 08:52, schrieb reena.kam...@jktech.com: > I need to do data masking to sensitive data exists in mysql db. is there any > data masking tool available for mysql with linux platform. > if yes... please provide the links. > else... please suggest other alternati

Data masking for mysql

2014-04-14 Thread reena . kamboj
Hi, I need to do data masking to sensitive data exists in mysql db. is there any data masking tool available for mysql with linux platform. if yes... please provide the links. else... please suggest other alternatives for this requirement. I look forward to hearing from you. With best regards

Benetl, a free ETL tool for MySQL, out in version 4.5

2014-04-12 Thread Benoît Carpentier
Dear all, Benetl, a free ETL tool for MySQL, is out in version 4.5. This version of Benetl is now Java 7 and has been tested on 64 bit systems. This versions is correcting two bugs: Trouble with double parsing when data contains ',' as float separator Divide function now accept

Re: Excluding MySQL database tables from mysqldump

2014-04-08 Thread Tim Johnson
mechanism for overriding this. The incompatibility kicks in when trying to restore the databases on linux - and I presume FreeBSD, sun OS and other posix systems would show the same problem. Live and learn ... -- Tim tim at tee jay forty nine dot com or akwebsoft dot com ht

Re: Excluding MySQL database tables from mysqldump

2014-04-07 Thread hsv
t;< Why not? That is not mentioned in the section devoted to mapping such names to the file-system. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

MySQL Connector/ODBC 5.3.2 GA has been released

2014-04-07 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/ODBC 5.3.2 GA, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select driver type you need based on

Re: Excluding MySQL database tables from mysqldump

2014-04-07 Thread Tim Johnson
* shawn l.green [140407 07:05]: > Hello Tim, > > On 4/4/2014 10:27 PM, Tim Johnson wrote: > >* Tim Johnson [140404 17:46]: > >>Currently I'm running mysql on a Mac OSX partition. > >> > >>I have installed an ubuntu dual-booted partition and put

Re: Excluding MySQL database tables from mysqldump

2014-04-07 Thread shawn l.green
Hello Tim, On 4/4/2014 10:27 PM, Tim Johnson wrote: * Tim Johnson [140404 17:46]: Currently I'm running mysql on a Mac OSX partition. I have installed an ubuntu dual-booted partition and put mysql on it. I have already set up a mysql user on the ubuntu OS. In the past I have used mysq

mysql server does not start

2014-04-05 Thread Nicolae Marasoiu
i made a different datadir and gave ownership and rights to mysql and trsted with su that mysql can read host.frm still errno 13: cannot acess ./mysql/host.frm my datadir comtains the mysql dir/schema pls help! i run ununtu thanks nicu

Re: Excluding MySQL database tables from mysqldump

2014-04-04 Thread Tim Johnson
* Tim Johnson [140404 17:46]: > Currently I'm running mysql on a Mac OSX partition. > > I have installed an ubuntu dual-booted partition and put mysql on > it. I have already set up a mysql user on the ubuntu OS. > > In the past I have used mysqldump with just the --al

Excluding MySQL database tables from mysqldump

2014-04-04 Thread Tim Johnson
Currently I'm running mysql on a Mac OSX partition. I have installed an ubuntu dual-booted partition and put mysql on it. I have already set up a mysql user on the ubuntu OS. In the past I have used mysqldump with just the --all-databases option to transfer data across different

MySQL Connector/NET 6.7.5 has been released

2014-04-04 Thread karen langford
MySQL Connector/NET 6.7.5, a new version of the all-managed .NET driver for MySQL has been released. This is the GA, is feature complete. It is recommended for production environments. It is appropriate for use with MySQL server versions 5.0-5.7. It is now available in source and binary form

no binary and source code of MySQL ODBC Connector 5.2.5 for AIX plarform

2014-04-02 Thread Shen, Tingting
Hi, I want to install MySQL ODBC Connector 5.2.5 on AIX 7.1 platform. But I cannot find any binary for installation on AIX platform. In addition, I also tried to build my own installation binary from source code , but found no source code for AIX platform. http://downloads.mysql.com/archives/c

MySQL Community Server 5.7.4-m14 has been released (part 2)

2014-03-31 Thread Bjorn Munch
ER TO unless explicitly set using MASTER_HEARTBEAT_PERIOD. In addition, the statement no longer resets Slave_received_heartbeats. (Bug #18185490) * Replication: The MASTER_SSL_CRL and MASTER_SSL_CRLPATH options are not available when using yaSSL; MySQL Replication

MySQL Community Server 5.7.4-m14 has been released (part 1)

2014-03-31 Thread Bjorn Munch
Dear MySQL users, MySQL Server 5.7.4 (Milestone Release) is a new version of the world's most popular open source database. This is the fourth public milestone release of MySQL 5.7. [Due to length restrictions, this announcement is split into two parts. This is part 1.]

MySQL Utilities 1.4.2 (including MySQL Fabric) RC has been released

2014-03-31 Thread karen langford
Dear MySQL users, MySQL Utilities version 1.4.2 is compatible with MySQL Server versions 5.1 and greater, but should work with earlier versions (greater than v4.1). Python v2.6 and v2.7 are supported. In addition to server utilities, MySQL Utilities also contains MySQL Fabric: a framework for

MySQL Connector/J 5.1.30 has been released

2014-03-31 Thread karen langford
Hello all, MySQL Connector/J 5.1.30, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.30 is suitable for use with many MySQL server versions, including 4.1, 5.0, 5.1, 5.4, 5.5 and 5.6. MySQL Connector

MySQL Connector/Python 1.2.1 RC has been released

2014-03-31 Thread karen langford
Dear MySQL users, MySQL Connector/Python v1.2.1 is the new version of the 1.2 release series of the pure Python database driver for MySQL. It is intended to introduce users to the new features. MySQL Connector/Python version 1.2.1 is compatible with MySQL Server versions 5.5 and greater, but

MySQL Workbench 6.1.4 GA has been released

2014-03-31 Thread karen langford
Dear MySQL users, The MySQL developer tools team announces 6.1.4 as our GA release for MySQL Workbench 6.1. MySQL Workbench 6.1 is an upcoming major update for the official MySQL graphical development tool. Introducing over 30 new features, this version has many significant enhancements

MySQL for Excel 1.2.1 has been released

2014-03-27 Thread Javier Treviño
The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.2.1.  This is a maintenance release for 1.2.x.   MySQL for Excel is an application plug-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It enables

MySQL Workbench 6.1.3 RC has been released

2014-03-24 Thread karen langford
Dear MySQL users, The MySQL developer tools team announces 6.1.3 RC - the final release candidate for MySQL Workbench 6.1. MySQL Workbench 6.1 is the upcoming major update for the official MySQL graphical development tool. Introducing over 30 new features, this version has many significant

Re: Decode Json in MySQL query

2014-03-21 Thread Andrew Moore
May also be of interest; http://www.slideshare.net/blueskarlsson/using-json-with-mariadb-and-mysql On Fri, Mar 21, 2014 at 12:27 PM, Sukhjinder K. Narula wrote: > Many Thanks for the kind replies. > > I have decoded in my code but just wondering in case I missed any solution > t

Re: Decode Json in MySQL query

2014-03-21 Thread Sukhjinder K. Narula
Many Thanks for the kind replies. I have decoded in my code but just wondering in case I missed any solution to decode via query. On Thu, Mar 20, 2014 at 3:05 PM, Michael Dykman wrote: > Short answer, no. There is nothing in MySQL to facilitate this. In > general, storing structured d

Re: Decode Json in MySQL query

2014-03-20 Thread Michael Dykman
Short answer, no. There is nothing in MySQL to facilitate this. In general, storing structured data as a blob (JSON, CSV, XML-fragment, etc..) is an anti-pattern in a relational environment. There are NoSQL solutions that provide the facility: Mongo comes to mind; there are some others, I am

Re: Decode Json in MySQL query

2014-03-20 Thread Kishore Vaishnav
Hi, http://blog.ulf-wendel.de/2013/mysql-5-7-sql-functions-for-json-udf/ This is not the exact solution for you query, but might help you better if you add the libraries. *thanks,* *-- *Kishore Kumar Vaishnav On Thu, Mar 20, 2014 at 11:35 AM, Sukhjinder K. Narula wrote: > Hello, > I

Re: Decode Json in MySQL query

2014-03-20 Thread Karr Abgarian
uot;name" : "Abc", >"age" : "20" > }, > { >"name" : "Xyz", >"age" : "18" > } > ] > > and after query, I want result as: > NameAge > Abc 20 > Xyz

Decode Json in MySQL query

2014-03-20 Thread Sukhjinder K. Narula
Hello, I would like to know if there is a way to decode the json string stored in one of the fields as text without using triggers or stored procedures. What I want to do is is within the query, I would like to get one row per element within the json string. For example: the json string is as follo

ANN: Database Workbench 4.4.5, special MySQL discount!

2014-03-19 Thread Martijn Tonies (Upscene Productions)
rkbench Pro for MySQL" using discount coupon MYSQLSPECIAL - additional modules can be purchased at a later stage. For more information, see http://www.upscene.com/go/?go=news&id=20140319 The FREE Lite Editions will be released at a later stage. Database Workbench supports: - Borlan

Re: Questions about building a dedicated MySQL server.

2014-03-17 Thread Carsten Pedersen
On 17-03-2014 16:21, Mister Vlad wrote: I am looking at building a dedicated MySQL server... was wondering about the downside to using SSD drives? My thoughts was going 2 servers, with 4 drives each in raid 5 (3+1) configuration. Is this a good idea? I was originally thinking about going

Questions about building a dedicated MySQL server.

2014-03-17 Thread Mister Vlad
I am looking at building a dedicated MySQL server... was wondering about the downside to using SSD drives? My thoughts was going 2 servers, with 4 drives each in raid 5 (3+1) configuration. Is this a good idea? I was originally thinking about going Raid5(3+1) and Raid 1 (Mirrored) but that

Re: New to MySQL

2014-03-11 Thread Asma rabe
Hi, Thank you for your help and nice tutorials An easy for installation is here: Thanks Andrew http://www.rackspace.com/knowledge_center/article/installing-mysql-server-on-centos Here is another link http://opensourcedbms.com/dbms/installing-mysql-5-6-on-cent-os-6-3-redhat-el6-fedora/ I

MySQL Enterprise Backup 3.10.0 has been released

2014-03-10 Thread karen langford
Dear MySQL users, MySQL Enterprise Backup v3.10.0, a new version of the online MySQL backup tool, is now available for download from the My Oracle Support (MOS) website as our latest GA release. This release will be available on eDelivery (OSDC) after the next upload cycle. MySQL Enterprise

RE: New to MySQL

2014-03-05 Thread Brian Van der Westhuizen [DATACOM]
Asma, I think maybe it is a good idea if you start reading Mysql for dummies or something similar. If you do not understand the basic concepts of unix/linux and mysql, I see a hard road for you. Google is you friend and I believe they would even have documentation in your native language

Re: New to MySQL

2014-03-05 Thread Reindl Harald
https://www.google.com/search?q=CentOS+mysql+log > On Wed, Mar 5, 2014 at 8:03 PM, Andrew Moore <mailto:eroomy...@gmail.com>> wrote: > > Next action is to review the MySQL error log for the reason that it > failed. > > On Wed, Mar 5, 2014 at 10:55 AM, Asma rabe &l

Re: New to MySQL

2014-03-05 Thread Andrew Moore
enable *isa not* start - :D This is true. The mailing list is not an interactive article on the basics of installing and starting MySQL. There are 1000s of blog articles, documentation and guides on doing this. Perhaps looking here; http://www.rackspace.com/knowledge_center/article/installing

Re: New to MySQL

2014-03-05 Thread Asma rabe
How to do that? Thank you On Wed, Mar 5, 2014 at 8:03 PM, Andrew Moore wrote: > Next action is to review the MySQL error log for the reason that it > failed. > > A > > > On Wed, Mar 5, 2014 at 10:55 AM, Asma rabe wrote: > >> Hi All, >> >> Tha

Re: New to MySQL

2014-03-05 Thread Reindl Harald
Am 05.03.2014 12:03, schrieb Andrew Moore: > Next action is to review the MySQL error log for the reason that it failed. oh no - don't reply with no clue chkconfig comes long before mysqld is invoked even if he would have spelled the service name correctly enable *isa not* start see

Re: New to MySQL

2014-03-05 Thread Reindl Harald
Am 05.03.2014 11:55, schrieb Asma rabe: > I checked if mysql installed > rpm -qa | grep mysql post outputs - it's respectless seek for help and hold back infos because as you said you are new you likely not understand really the output > and found it is installed, so n

Re: New to MySQL

2014-03-05 Thread Andrew Moore
Next action is to review the MySQL error log for the reason that it failed. A On Wed, Mar 5, 2014 at 10:55 AM, Asma rabe wrote: > Hi All, > > Thank you very much. > > I checked if mysql installed > rpm -qa | grep mysql > > and found it is installed, so no need for

Re: New to MySQL

2014-03-05 Thread Asma rabe
Hi All, Thank you very much. I checked if mysql installed rpm -qa | grep mysql and found it is installed, so no need for yum installation. when i tried to start the service chkconfig mysql on error reading information on service mysql: No such file or directory sorry to disturb you. Regards

Re: New to MySQL

2014-03-04 Thread Andrew Moore
Percona, MariaDB and Oracle provide YUM repos now. Remove all traces of MySQL before starting install using ; rpm -e {package} --nodeps then grab your YUM packages. A On Tue, Mar 4, 2014 at 7:01 PM, Brian Van der Westhuizen [DATACOM] < brian.vanderwesthui...@datacom.co.nz> wrote:

RE: New to MySQL

2014-03-04 Thread Brian Van der Westhuizen [DATACOM]
Why don't you just use yum install . Should sort out most if not all your problems regarding installation of mysql. Regards Brian vd Westhuizen -Original Message- From: Asma rabe [mailto:asma.r...@gmail.com] Sent: Wednesday, 5 March 2014 1:21 a.m. To: geetanjali mehra Cc: Joh

Re: New to MySQL

2014-03-04 Thread Reindl Harald
Am 04.03.2014 13:20, schrieb Asma rabe: > I have checked before installation if mysql is installed using which mysql > i found no mysql is installed. which is pointless rpm -qa | grep mysql > next i did rpm installation and got the errors > rpm -i MySQL-server-5.6.16-1.el6.x86_6

Re: New to MySQL

2014-03-04 Thread Asma rabe
Thank you very much for responding. I have checked before installation if mysql is installed using which mysql ,i found no mysql is installed. next i did rpm installation and got the errors rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech

Re: New to MySQL

2014-03-03 Thread geetanjali mehra
Thanks for responding. MySQL installation ,here, do not require mysql-libs package. As far as I know, there is no harm on using this command. I too got the same problem, and I didn't face any problem after removing this package. This package is installed by default and not needed here. So,

Re: New to MySQL

2014-03-03 Thread Morgan Tocker
Hi Asma, It looks from this error that there is an existing 5.1 installation present. As well as RPM packages (which can be downloaded from http://dev.mysql.com/downloads/mysql/5.6.html), there is also a yum repo for Enterprise Linux 6. It is available here: http://dev.mysql.com/downloads

Re: Install mysql server using RPM

2014-03-03 Thread Johan De Meersman
- Original Message - > From: "Asma rabe" > Subject: Install mysql server using RPM > > rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm > rpm -i MySQL-client-5.6.16-1.el6.x86_64.rpm I seem to recall that Oracle's Debian -server package included the clients

Re: New to MySQL

2014-03-03 Thread Johan De Meersman
- Original Message - > From: "geetanjali mehra" > Subject: Re: New to MySQL > > use > rpm -i --replacefiles MySQL-server*.rpm While that will work, it really shouldn't happen. I'm a Debian man myself, so I don't know wether it's a problem

Re: Install mysql server using RPM

2014-03-03 Thread geetanjali mehra
issue: mysql at the command prompt and let me know. also post the output of ls /var/lib On Mon, Mar 3, 2014 at 1:53 PM, Asma rabe wrote: > Hi all, > > I am trying installing Mysql server using RPM bundle > > > rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm > rpm -i MySQ

Re: New to MySQL

2014-03-03 Thread geetanjali mehra
use rpm -i --replacefiles MySQL-server*.rpm On Mon, Mar 3, 2014 at 11:30 AM, Asma rabe wrote: > I installed my sql using RPM as follows: > > rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm > > I got the following errors > file /usr/share/mysql/czech/errmsg.sys from install of >

Install mysql server using RPM

2014-03-03 Thread Asma rabe
Hi all, I am trying installing Mysql server using RPM bundle rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm rpm -i MySQL-client-5.6.16-1.el6.x86_64.rpm next i would like to start the server, i followed the mysql docs: The server RPM places data under the /var/lib/mysql directory. The RPM also

Re: New to MySQL

2014-03-02 Thread Asma rabe
I installed my sql using RPM as follows: rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish

Re: New to MySQL

2014-02-27 Thread Johan De Meersman
- Original Message - > From: "Asma rabe" > Subject: Re: New to MySQL > > so,Is it recommended to install RPM bundle which has compatlibs, MySQL > serveretc rather than installing the server only? The Server should suffice; the Bundle is merely a convenient

Re: New to MySQL

2014-02-27 Thread Asma rabe
Thank you very much Iqbal ,Johan, Actually I have Linux redhat already installed so I have to install MySQL server and client. so,Is it recommended to install RPM bundle which has compatlibs, MySQL serveretc rather than installing the server only? Thank you very much. Rabe On Fri, Feb

Re: New to MySQL

2014-02-27 Thread Johan De Meersman
- Original Message - > From: "Iqbal Aroussi" > Subject: Re: New to MySQL > > If you are new to MySQL and/or Linux. > Start with Ubuntu + MySQL. Iqbal, Please don't start distro wars on this list. Everyone chooses the platform he or she wants. Rabe, T

New to MySQL

2014-02-27 Thread Asma rabe
Hi, I would like t install MySQL server on Linux and MYSQL client and GUI may be workbench on client machine. For server installation, I found several options for download, I would appreciate if anyone can tell me which is better to install *Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 64

Re: New to MySQL

2014-02-27 Thread Iqbal Aroussi
Hi Asma, If you are new to MySQL and/or Linux. Start with Ubuntu + MySQL. Best Regards Iqbal Aroussi 514 451-9122 On Thu, Feb 27, 2014 at 10:43 AM, Asma rabe wrote: > Hi, > > I would like t install MySQL server on Linux and MYSQL client and GUI may > be workbench on cl

RE: How to make multiple master to single slave in mysql?

2014-02-25 Thread Zhigang Zhang
OK! Thank you very much! Zhigang. -Original Message- From: shawn l.green [mailto:shawn.l.gr...@oracle.com] Sent: Wednesday, February 26, 2014 11:57 AM To: mysql@lists.mysql.com Subject: Re: How to make multiple master to single slave in mysql? On 2/25/2014 9:55 PM, Zhigang Zhang

Re: How to make multiple master to single slave in mysql?

2014-02-25 Thread shawn l.green
On 2/25/2014 9:55 PM, Zhigang Zhang wrote: > How to make multiple master replicate to single slave in mysql? > > > > Tell me some approaches? > > Put your masters in a replication ring, hang a slave from one of them (as suggested by Mr. Van der Westhuizen) Us

How to make multiple master to single slave in mysql?

2014-02-25 Thread Zhigang Zhang
How to make multiple master replicate to single slave in mysql? Tell me some approaches? Thanks Zhigang

Re: Mysql into outfile problem

2014-02-19 Thread Carsten Pedersen
I don't know what you mean by "straight" mysql connection. At any rate, the idea is to use --quick or otherwise using a connection which uses mysql_use_result over mysql_store_result. http://dev.mysql.com/doc/refman/5.6/en/mysql.html Best, / Carsten On 19-02-2014 12:02, M

Re: Mysql into outfile problem

2014-02-19 Thread Johan De Meersman
- Original Message - > From: "Machiel Richards" > Subject: Re: Mysql into outfile problem > > I have checked now and there is nothing in the Slow logs. It may be turned off, then. Depending on your version you can change the settings without having to restart th

Re: Mysql into outfile problem

2014-02-19 Thread Machiel Richards
I have checked now and there is nothing in the Slow logs. On 19/02/2014 15:33, Johan De Meersman wrote: - Original Message - From: "Machiel Richards" Subject: Mysql into outfile problem - when we run an explain on the query it shows that it is using index

Re: Mysql into outfile problem

2014-02-19 Thread Johan De Meersman
- Original Message - > From: "Machiel Richards" > Subject: Mysql into outfile problem > > - when we run an explain on the query it shows that it is > using indexes and the amount of rows it accesses is about 165000 rows > out of a 90mil+ rows t

Re: Mysql into outfile problem

2014-02-19 Thread Machiel Richards
Hi, the queries are done by connecting to the database using mysql workbench or otherwise after ssh to server by using straight mysql connection. regards On 19/02/2014 12:51, Carsten Pedersen wrote: If you're doing this from the cmd-line client, try running it using --quick. th

Re: Mysql into outfile problem

2014-02-19 Thread Carsten Pedersen
for the amount of records and the fact that it uses indexes, this should be running quite fast, however we cant seem to figure out this behaviour. Can anyone perhaps assist me with this as the help woul dbe greatly appreciated. Regards -- MySQL General Mailing List For list arch

career advice - Excel Expert and MySQL SQL specialist

2014-02-19 Thread Lukas Lehner
Hi I passed Oracle SQL Expert and working on MySQL 5.6 developer exam. I work 5% of my job with SQL but I am searching for a full time SQL job. http://shop.oreilly.com/product/0790145363466.do Is the Excel exam (Microsoft Office Specialist - MOS) useful for getting a junior SQL pro job? What do

Mysql into outfile problem

2014-02-19 Thread Machiel Richards
this behaviour. Can anyone perhaps assist me with this as the help woul dbe greatly appreciated. Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: ODBC connector and MySQL Enterprise Edition

2014-02-17 Thread shawn l.green
Hello Femitha, On 2/17/2014 12:16 AM, Femitha Majeed wrote: Hi, Please help me by answering this question. Currently we've a database link between Oracle database and MySQL database using mysql-connector-odbc-5.1.8, will this connector work if I change my MySQL to enterprise edition ?

ODBC connector and MySQL Enterprise Edition

2014-02-16 Thread Femitha Majeed
Hi, Please help me by answering this question. Currently we've a database link between Oracle database and MySQL database using mysql-connector-odbc-5.1.8,  will this connector work if I change my MySQL to  enterprise edition ? Thank you.

mySQL Query support/assistance...

2014-02-11 Thread Don Wieland
Hi gang, I am looking for someone that I can pay a few hours to work with me on coming up with a few needed QUERIES for a large mysql database. The queries will span across tables, so I great knowledge of JOINS will most likely be necessary. We will work using SKYPE and GoToMeeting. Please

ANN: DAC for MySQL 2.9.6 is out!

2014-02-06 Thread Aleksander Andreev
DAC for MySQL is direct access components for MySQL, EnterpriseDB. It allows you to create Delphi/C++Builder applications with direct access to DAC for MySQL/EnterpriseDB without BDE and ODBC. What's new in v2.9.6: Several minor improvements and bugs fixes. Full changelog: [+] Co

ANN: SQL Maestro for MySQL 14.2 released

2014-02-06 Thread SQL Maestro Team
Hi! SQL Maestro Group announces the release of SQL Maestro for MySQL 14.2, a powerful Windows GUI solution for MySQL administration and database development. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/maestro/ Top 10 new features

Re: MySQL 5.7 release plan/date

2014-02-04 Thread Morgan Tocker
Hi Igor, > When MySQL 5.7 planned to be released as stable/production ready? We do not provide planned release dates. If I can recommend a video to watch about the release process, please watch Tomas Ulin’s Percona Live keynote April 2013: http://www.youtube.com/watch?v=OpHTV59I1gs Watch f

MySQL 5.7 release plan/date

2014-02-04 Thread Igor Dvorzhak
Hi all, When MySQL 5.7 planned to be released as stable/production ready? Best, Igor

Troubles with creating indexes on float columns on MyISAM tables in MySQL 5.6.15 and MySQL 5.6.14 running on FreeBSD 8.4

2014-01-29 Thread Mikhail Berman
I got an "interesting" problem with creation of indexes on MyISAM tables in MySQL 5.6.15 and MySQL 5.6.14 running on FreeBSD 8.4 for float columns - I am not able to create indexes on these columns Indexes on all other columns work just fine The problem occur while I was loading data

Re: ANN: MicroOLAP Database Designer for MySQL 2.1.2 is available!

2014-01-23 Thread Aleksander Andreev
Hi Jan! We are very sorry that we misled you. However, our Database Designer for MySQL works well under WineHQ. Best regards, On Thu, Jan 23, 2014 at 11:35 PM, Jan Steinman wrote: > Can you please add to your announcements that this product is Windows-only? > > It took some searchin

Re: ANN: MicroOLAP Database Designer for MySQL 2.1.2 is available!

2014-01-23 Thread Jan Steinman
Can you please add to your announcements that this product is Windows-only? It took some searching on your website to come up with that info, and I dare say the majority of MySQL users here are non-Windows-based. Thank you! (Now I have to go find and delete that download...) A low-energy

ANN: MicroOLAP Database Designer for MySQL 2.1.2 is available!

2014-01-23 Thread Aleksander Andreev
bug fixed [-] "Cannot merge model with views or stored routines" bug fixed [-] "Unable to find a Table of Contents when invoking help system" bug fixed You're welcome to download the Database Designer for MySQL 2.1.2 right now at: http://microolap.com/products/database/mysql-design

MySQL Enterprise Monitor 3.0.5

2014-01-22 Thread Molecki, Christian (STL)
Hello everyone, I'm using MySQL Enterprise Monitor 3.0.5. Is there any possibility to customize the dashboard, eg. one database activity graph for every instance? Does anyone know it? Best Regards Christian Molecki -- MySQL General Mailing List For list archives: http://lists.mysql.com/

Fosdem 2014 MySQL & Friends devroom and Community Dinner

2014-01-16 Thread Frédéric Descamps
Hi all, The schedule for the devroom is now online https://fosdem.org/2014/schedule/track/mysql/ and please don't forget to register for the Community Dinner: http://www.eventbrite.com/e/fosdem-mysql-and-friends-community-dinner-2014-tickets-10152563591 See you as much as possible in Bru

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-16 Thread Érico
LISTEN = mac:bin ericomtx$ netstat -ln | grep mysql ff801403c280 stream 0 00 ff801403b20000 /tmp/mysql.sock ff801403a9c0 stream 0 0 ff801bbb78b8 0

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-15 Thread Claudio Nanni
Hi > > > | | ericomtxmacbookpro.local | > > *E85DC00A0137C6171923BE35EDD809573FB3AB4F | > > > > mysql> DELETE FROM mysql.user WHERE user=''; mysql> FLUSH PRIVILEGES; maybe helps? Cheers -- Claudio

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-14 Thread Érico
yes it is ... also , the eclipse is also local ... in both ... mysql-admin php application , plus inside eclispe plugin ... same behavior in both 2014/1/13 Reindl Harald > i doubt that the webserver is running on the same > machine as your mysql command shell > > Am 13.0

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Reindl Harald
ttp://localhost/mysql/index.php > http://127.0.0.1/mysql/index.php > > in 127.0.0.1... after I submit the index.php ... it redirects to localhost > too .. signature.asc Description: OpenPGP digital signature

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread shawn l.green
Hello Reindl, On 1/13/2014 3:01 PM, Reindl Harald wrote: *your application* is connecting to mysql *your application* is using a hostname *your application* *may* use 127.0.0.1 *your application* should use localhost to *connect to the databse* *your application* can only use TCP *if there is

<    3   4   5   6   7   8   9   10   11   12   >