MySQL Router 8.0.16 for MySQL Server 8.0 and 5.7 has been released

2019-04-25 Thread Bjorn Munch
Dear MySQL users, MySQL Router 8.0.16 is a new release for MySQL Router 8.0 series. MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Router 8.0.16. The MySQL Router is a new building block for high availability solutions based on MySQL InnoDB

Re: Replication and user privileges

2019-02-26 Thread Jim
have a question about user privileges. I understand on the master, the replication user must have the Repl_slave_priv privilege as described here: https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_replication-slave My question is about what replication-related users and

Re: Replication and user privileges

2019-02-26 Thread Jim
privileges. I understand on the master, the replication user must have the Repl_slave_priv privilege as described here: https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_replication-slave My question is about what replication-related users and privileges must exist on the slave

Re: Replication and user privileges

2019-02-26 Thread shawn l.green
replication user must have the Repl_slave_priv privilege as described here: https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_replication-slave My question is about what replication-related users and privileges must exist on the slave. So, for example, if an insert on the master

Re: Replication and user privileges

2019-02-25 Thread Jim
privilege as described here: https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_replication-slave My question is about what replication-related users and privileges must exist on the slave. So, for example, if an insert on the master that is to be replicated is performed by user

Re: Replication and user privileges

2019-02-25 Thread shawn l.green
/doc/refman/8.0/en/privileges-provided.html#priv_replication-slave My question is about what replication-related users and privileges must exist on the slave. So, for example, if an insert on the master that is to be replicated is performed by user 'abc' with proper insert permissi

Replication and user privileges

2019-02-25 Thread Jim
#priv_replication-slave My question is about what replication-related users and privileges must exist on the slave. So, for example, if an insert on the master that is to be replicated is performed by user 'abc' with proper insert permissions on the master, does that same 'abc&

Re: mysql V 8.0.12 and mysqdump

2019-02-14 Thread Walter Harms
7;ndbinfo\_version'': MySQL > > server has gone away (2006) > > I regulary hav this problem with the command-line client (mysql.exe) and > when I asked R H gave this answer (and with the command-line client it > is much less imporant): > > Forwarded Messa

Re: mysql V 8.0.12 and mysqdump

2019-02-09 Thread Walter Harms
7;ndbinfo\_version'': MySQL > > server has gone away (2006) > > I regulary hav this problem with the command-line client (mysql.exe) and > when I asked R H gave this answer (and with the command-line client it > is much less imporant): > > Forwarded Mes

Re: mysql V 8.0.12 and mysqdump

2019-02-09 Thread Halaasz Saandor
hen trying to dump tablespaces mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'ndbinfo\_version'': MySQL server has gone away (2006) I regulary hav this problem with the command-line client (mysql.exe) and when I asked R H gave this answer (and with the command-li

mysql V 8.0.12 and mysqdump

2019-02-08 Thread Walter Harms
mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'ndbinfo\_version'': MySQL server has gone away (2006) I seems it get stuck in this query: explain SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE, ENGINE, EXTRA FROM INFORMATION_SCHEMA.FILES WHERE FILE _TYPE = &

MySQL Router 8.0.15 for MySQL Server 8.0 and 5.7 has been released

2019-02-01 Thread Bjorn Munch
Dear MySQL users, MySQL Router 8.0.15 is a new release for MySQL Router 8.0 series. MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Router 8.0.15. The MySQL Router is a new building block for high availability solutions based on MySQL InnoDB

MySQL Shell 8.0.15 for MySQL Server 8.0 and 5.7 has been released

2019-02-01 Thread Balasubramanian Kandasamy
Dear MySQL users, MySQL Shell 8.0.15 is a maintenance release of MySQL Shell 8.0 Series (a component of the MySQL Server). The MySQL Shell is provided under Oracle's dual-license. MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Shell 8

MySQL Shell 8.0.14 for MySQL Server 8.0 and 5.7 has been released

2019-01-21 Thread Kent Boortz
Dear MySQL users, MySQL Shell 8.0.14 is a maintenance release of MySQL Shell 8.0 Series (a component of the MySQL Server). The MySQL Shell is provided under Oracle's dual-license. MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Shell 8

MySQL Router 8.0.14 for MySQL Server 8.0 and 5.7 has been released

2019-01-21 Thread Bjorn Munch
Dear MySQL users, MySQL Router 8.0.14 is a new release for MySQL Router 8.0 series. MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Router 8.0.14. The MySQL Router is a new building block for high availability solutions based on MySQL InnoDB

ANN: Database Workbench 5.5.0 released and free Lite Edition for MySQL

2019-01-15 Thread Martijn Tonies (Upscene Productions)
tems, that includes PostgreSQL 11, InterBase 2017 and MySQL 8. There's also a new release of the free Lite Edition for MySQL: version 5.4.6 has been made available today. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you!

In MySQL 8, how do you distinguish between Roles and Users in table mysql.user?

2018-10-30 Thread Martijn Tonies (Upscene Productions)
Hi there, In MySQL 8, how can you figure out if an entry in the mysql.user table is a role or a user? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and

MySQL Router 8.0.13 for MySQL Server 8.0 and 5.7 has been released

2018-10-22 Thread Bjorn Munch
Dear MySQL users, MySQL Router 8.0.13 is a new release for MySQL Router 8.0 series. MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Router 8.0.13. The MySQL Router is a new building block for high availability solutions based on MySQL InnoDB

Step-by-Step Tutorial: How to Setup Your Own e-Commerce Online Store using WooCommerce 3.4.5, Wordpress 4.9.8, and CentOS 1805 (LAMP) in Amazon AWS Cloud

2018-09-28 Thread Turritopsis Dohrnii Teo En Ming
Good morning from Singapore, You can read my step-by-step tutorial on How to Setup Your Own e-Commerce Online Store using WooCommerce 3.4.5, Wordpress 4.9.8, and CentOS 1805 (LAMP) in Amazon AWS Cloud at any one of my two redundant blogs. My blogs were configured in RAID 1 mirroring array

[ANN] [Qt ORM] QxOrm 1.4.5 and QxEntityEditor 1.2.3 released : support MongoDB database and code source now on GitHub

2018-09-06 Thread QxOrm contact
Hello, *QxOrm library 1.4.5* and *QxEntityEditor application 1.2.3* just released : https://www.qxorm.com/ *QxOrm library 1.4.5 changes log :* * - Support MongoDB database : QxOrm library becomes a C++/Qt Object Document Mapper ODM library !- For more details about MongoDB integration, see

MySQL Shell 8.0.12 for MySQL Server 8.0 and 5.7 has been released

2018-07-27 Thread Hery Ramilison
Dear MySQL users, MySQL Shell 8.0.12 is a maintenance release of MySQL Shell 8.0 Series (a component of the MySQL Server). The MySQL Shell is provided under Oracle's dual-license. MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Shell 8

Re: Examples of savepoints and transactions

2018-01-24 Thread shawn l.green
Hello Lars, On 1/24/2018 8:50 AM, Johan De Meersman wrote: What you're looking for is simple backup and restore :-) Savepoints are, simply put, markers within a transaction; allowing you to rollback only part of a transaction instead of the whole thing. A commit will inevitably commi

Re: Examples of savepoints and transactions

2018-01-24 Thread Lars Nielsen
Kind Regards / Med venlig hilsen Lars Nielsen > - Original Message - >> From: "Lars Nielsen" >> To: "MySql" >> Sent: Tuesday, 23 January, 2018 23:19:29 >> Subject: Re: Examples of savepoints and transactions > >>> D

Re: Examples of savepoints and transactions

2018-01-24 Thread Johan De Meersman
What you're looking for is simple backup and restore :-) Savepoints are, simply put, markers within a transaction; allowing you to rollback only part of a transaction instead of the whole thing. A commit will inevitably commit the ENTIRE transactions, and thus remove the savepoints. A ty

Re: Examples of savepoints and transactions

2018-01-23 Thread Lars Nielsen
Den 22-01-2018 kl. 22:01 skrev shawn l.green: Hello Lars, On 1/21/2018 3:37 PM, Lars Nielsen wrote: Hi, I have a system that uses begin and commit transactions. It works like a dream! ;) Now I want to test it by creating test data. This how ever cannot be rolled back. I think the solution

Re: Examples of savepoints and transactions

2018-01-22 Thread shawn l.green
Hello Lars, On 1/21/2018 3:37 PM, Lars Nielsen wrote: Hi, I have a system that uses begin and commit transactions. It works like a dream! ;) Now I want to test it by creating test data. This how ever cannot be rolled back. I think the solution for rolling back test data is to use savepoints

Examples of savepoints and transactions

2018-01-21 Thread Lars Nielsen
Hi, I have a system that uses begin and commit transactions. It works like a dream! ;) Now I want to test it by creating test data. This how ever cannot be rolled back. I think the solution for rolling back test data is to use savepoints and rollback. I think it is hard to find examples of this

[ANN] QxOrm 1.4.4 and QxEntityEditor 1.2.2 released : boost dependency fully removed (replaced by C++11 features)

2017-06-13 Thread QxOrm contact
Hello, *QxOrm library 1.4.4* and *QxEntityEditor application 1.2.2* just released ( http://www.qxorm.com/) ! QxOrm library doesn't depend on boost framework anymore (the boost dependency has been fully removed, replaced by some C++11 features). So QxOrm library is now a pure Qt library

Re: Ssd vs mix of ssd and spinning disk

2017-05-13 Thread shawn l.green
Hi Shain, On 5/8/2017 1:53 PM, Shain Miley wrote: Hello, We have traditionally setup our mysql database servers with a mix of ssd and spinning disk drives. We use the ssd drives (Raid-1) for the mysql tablespace data, and we use the spinning disks (15 sas in Raid-1) for the index data, etc

Re: Ssd vs mix of ssd and spinning disk

2017-05-08 Thread Reindl Harald
Am 08.05.2017 um 19:53 schrieb Shain Miley: Hello, We have traditionally setup our mysql database servers with a mix of ssd and spinning disk drives. We use the ssd drives (Raid-1) for the mysql tablespace data, and we use the spinning disks (15 sas in Raid-1) for the index data, etc. I am

Ssd vs mix of ssd and spinning disk

2017-05-08 Thread Shain Miley
Hello, We have traditionally setup our mysql database servers with a mix of ssd and spinning disk drives. We use the ssd drives (Raid-1) for the mysql tablespace data, and we use the spinning disks (15 sas in Raid-1) for the index data, etc. I am wondering if going forward we should simply put

behavior and documents conflict for SELECT LAST_INSERT_ID()

2017-04-21 Thread Chenxi Li
Dear friends, 1. https://bugs.mysql.com/bug.php?id=78934 2. https://dev.mysql.com/doc/refman/5.7/en/information-functions.html#function_last-insert-id The document (2) says that LAST_INSERT_ID() will not be changed if no rows are inserted successfully. But (1) says that it's undefined when no r

Re: kill query and prepared statements

2017-01-11 Thread Sebastien FLAESCH
Sorry for the spam, and thanks for you suggestion Johan! http://bugs.mysql.com/bug.php?id=84470 Seb On 01/11/2017 11:21 AM, Johan De Meersman wrote: Seb, You should log a bug at http://bugs.mysql.com - this is not a developer list. /Johan - Original Message - From: "Seba

Re: kill query and prepared statements

2017-01-11 Thread Johan De Meersman
Seb, You should log a bug at http://bugs.mysql.com - this is not a developer list. /Johan - Original Message - > From: "Sebastien FLAESCH" > To: "MySql" > Sent: Tuesday, 10 January, 2017 14:55:42 > Subject: kill query and prepared statements >

Re: kill query and prepared statements

2017-01-10 Thread Sebastien FLAESCH
can someone from MySQL C API team try to reproduce and confirm? Thanks! Seb -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: kill query and prepared statements

2017-01-10 Thread Sebastien FLAESCH
some new connection or statement option...?!? IMPORTANT: This problem appeared in a 5.7.x, same code is working fine with 5.6(.16) Please can someone from MySQL C API team try to reproduce and confirm? Thanks! Seb -- MySQL General Mailing List For list archives: http://lists.mysql

kill query and prepared statements

2017-01-10 Thread Sebastien FLAESCH
5.7.x, same code is working fine with 5.6(.16) Please can someone from MySQL C API team try to reproduce and confirm? Thanks! Seb #include #include #include #include #include #include static char * c_host = "orion"; static char * c_user = "mysuser"; static cha

[ANN] QxOrm 1.4.3 and QxEntityEditor 1.2.1 released : the Qt ORM supports CMake and provides a new QxEntityEditor documentation

2016-12-14 Thread QxOrm contact
Hello, QxOrm library 1.4.3 and QxEntityEditor application 1.2.1 just released : http://www.qxorm.com/ The Qt ORM library now supports CMake and provides a new QxEntityEditor documentation : http://www.qxorm.com/qxorm_en/manual_qxee.html QxOrm library 1.4.3 changes log : - Support CMake : new

Re: a curse on OS sierra and MySQL?

2016-12-03 Thread Martin Mueller
Well, the command sudo /usr/local/mysql/support-files/mysql.server stop generates the error message: ERROR! MySQL server PID file could not be found! On the other hand, sudo launchctl unload -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist stops the server and sudo /usr/local

Re: a curse on OS sierra and MySQL?

2016-12-03 Thread Peter Brawley
could and should be more explicit about what is a significant change in Apple’s start/stop routines. If you mean that seriously, it needs to be more specific. PB - On 12/3/16, 12:43 PM, "Peter Brawley" wrote: On 12/2/2016 17:58, Martin Mueller wrote: > Alas, run

Re: a curse on OS sierra and MySQL?

2016-12-03 Thread Peter Brawley
On 12/2/2016 17:58, Martin Mueller wrote: Alas, running the stop and start commands under sudo makes zero difference. ?! The cited page recommends more than sudo starts and stops, eg ... |unset TMPDIR mysql_install_db | Did you try that? Did you check the pid setting in my.cnf, eg pid-file

Re: a curse on OS sierra and MySQL?

2016-12-03 Thread Hal.sz S.ndor
2016/12/02 18:58 ... Martin Mueller: Alas, running the stop and start commands under sudo makes zero difference. This is a very frustrating problem, and I hope somebody in the MySQl documentation department will take a look at it. It’s cleary a problem that has been around for years because

Re: a curse on OS sierra and MySQL?

2016-12-02 Thread Martin Mueller
Alas, running the stop and start commands under sudo makes zero difference. This is a very frustrating problem, and I hope somebody in the MySQl documentation department will take a look at it. It’s cleary a problem that has been around for years because the Web is full of complaints and tips

Re: a curse on OS sierra and MySQL?

2016-12-02 Thread Peter Brawley
On 12/2/2016 16:59, Martin Mueller wrote: I have been trying repeatedly and in vain to install the community edition of MySQL 5.7.16 on an iMac running OS sierra. I religiously followed the instructions for uninstalling previous versions found at http://community.jaspersoft.com/wiki

a curse on OS sierra and MySQL?

2016-12-02 Thread Martin Mueller
I have been trying repeatedly and in vain to install the community edition of MySQL 5.7.16 on an iMac running OS sierra. I religiously followed the instructions for uninstalling previous versions found at http://community.jaspersoft.com/wiki/uninstall-mysql-mac-os-x, and installation

Re: Mysql 5.6, Centos 7 and errno: 24 - Too many open files - Again

2016-12-01 Thread Reindl Harald
Am 01.12.2016 um 08:26 schrieb Götz Reinicke - IT Koordinator: it happend again and I can't fix it, may be someone has a working solution and information on that: surely -> man systemd LimitNOFILE=infinity LimitMEMLOCK=infinity OOMScoreAdjust=-1000 I installed the most recent m

Mysql 5.6, Centos 7 and errno: 24 - Too many open files - Again

2016-11-30 Thread Götz Reinicke - IT Koordinator
Hi, it happend again and I can't fix it, may be someone has a working solution and information on that: I installed the most recent mysql 5.6 community on a server and do get a lot of "errno: 24 - Too many open files". There are suggestions to increase the open_files_limit, cha

Re: call the appropriate and correct database

2016-06-20 Thread Johan De Meersman
- Original Message - > From: "HaidarPesebe" > Subject: call the appropriate and correct database > How do I call first database table as follows : > > id | country | province | distric | cost > > 1 | U

call the appropriate and correct database

2016-06-19 Thread Abdullah Bahar
How do I call first database table as follows : id | country | province | distric | cost 1 | USA | Alanama | distrik | 20 2 | USA | Alabama | distrik2 | 22 3 | USA | Alabama | distrik3 | 22 4 | France | Paris | disrik4 | 30 now I use 3 kinds of ca

alter table and 'something wrong in indexes'?

2016-05-26 Thread MAS!
Hi! I use mysql/innodb tables on aws services in a small table (about 2M records) I changed some columns datatypes from unsigned int to decimal and from float to decimal I didn't change anything about primary key or other indexes after the change (done without troubles), all my queries

Reformat: Connector/Python and calling stored procedures with backticks

2016-05-07 Thread Magnus Lind Oxlund
ion.py", line 395, in _handle_resultraise errors.get_exception(packet)mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`insert_page`_arg1=NULL&

Connector/Python and calling stored procedures with backticks

2016-05-07 Thread Magnus Lind Oxlund
QL server version for the right syntax to use near '`insert_page`_arg1=NULL' at line 1 And here is the stored procedure call that produces it: args = (None, 'foo', 'bar', None)cursor.callproc('`insert_page`', args) Having gone through the Connector/Python m

Announcing release for MySQL 5.5 and 5.6 on CentOS Linux 6 and 7 x86_64 SCL

2015-12-21 Thread Honza Horak
I am pleased to announce the immediate availability of versions 5.5 and 5.6 of the MySQL on CentOS Linux 6 and 7 x86_64, delivered via a Software Collection (SCL) built by the SCLo Special Interest Group (https://wiki.centos.org/SpecialInterestGroup/SCLo). QuickStart -- You can get

QxOrm 1.4.1 released : new documentation (user guide), and boost::serialization becomes optional

2015-12-03 Thread QxOrm contact
(compilation options have changed compared to previous versions). Now, by default, QxOrm library is a much lighter library : QxOrm depends only on *QtCore* and *QtSql* (boost serialization is now optional and not required by default). By default, serialization engine is now based on Qt *QDataStream

ANN: DAC for MySQL 3.0.0-beta with RAD Studio 10 Seattle and mobile platforms support is out!

2015-09-16 Thread Aleksander Andreev
MicroOLAP Direct Access Components for MySQL and Delphi/C++ Builder (also known as MySQLDAC) is a Borland Delphi/C++Builder component set for direct connect to MySQL database server. DAC for MySQL allows you to create Delphi/C++Builder applications without BDE, ODBC, ADO and without libmysql.dll

Re: Free load balancing and sharding

2015-09-02 Thread Reindl Harald
Am 02.09.2015 um 09:55 schrieb S.Mohammad Emami Razavi: I want to cluster MySQL to several servers and have no idea to start. Some questions have stuck to my mind such as How to balance connections and How to make mesh of shards and ... Can you show me a way to do these tasks correctly? https

Free load balancing and sharding

2015-09-02 Thread S.Mohammad Emami Razavi
I want to cluster MySQL to several servers and have no idea to start. Some questions have stuck to my mind such as How to balance connections and How to make mesh of shards and ... Can you show me a way to do these tasks correctly? Many Thanks,

Re: Post-installation config and startup questions

2015-06-23 Thread Steve Matzura
On Tue, 23 Jun 2015 14:51:48 -0400, you wrote: > > >On 6/23/2015 10:59 AM, Steve Matzura wrote: >> I'm building a mail system with Dovecot, Postfix and Mailman with >> MySQL. I have the other three products installed but not yet >> configured. I'll do that

Re: Post-installation config and startup questions

2015-06-23 Thread shawn l.green
On 6/23/2015 10:59 AM, Steve Matzura wrote: I'm building a mail system with Dovecot, Postfix and Mailman with MySQL. I have the other three products installed but not yet configured. I'll do that after I get MySQL running. The documentation at http://dev.mysql.com/doc/mysql-repo-e

Re: Post-installation config and startup questions

2015-06-23 Thread a . smith
Hi Steve, you haven't said what OS you are installing this on or how you have installed MySQL. Normally you would use a version avaialable in your OS distribution as this avoids any overly complicated installation and will manage security and bug patches for you MySQL binarie

Post-installation config and startup questions

2015-06-23 Thread Steve Matzura
I'm building a mail system with Dovecot, Postfix and Mailman with MySQL. I have the other three products installed but not yet configured. I'll do that after I get MySQL running. The documentation at http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-rep

Re: Where to ask a question about installation and configuration

2015-06-23 Thread Claudio Nanni
Hello Steve, To what list should I post with a post-installation config and startup > question? > > This list, the MySQL General Mailing List, is the right place if the question is about MySQL! Cheers -- Claudio

Where to ask a question about installation and configuration

2015-06-23 Thread Steve Matzura
To what list should I post with a post-installation config and startup question? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: questions about timestamps and DST

2015-03-31 Thread Mark Goodge
On 31/03/2015 12:20, Larry Martell wrote: On Tue, Mar 31, 2015 at 1:13 AM, Andrew Moore wrote: When you use a timezone with DST there is no such thing as 2.30am on the date of changeover. That hour doesn't exist. I am using UCT - I am not using a timezone. In MySQL 5 and above, TIME

Re: questions about timestamps and DST

2015-03-31 Thread Larry Martell
On Tue, Mar 31, 2015 at 1:13 AM, Andrew Moore wrote: > When you use a timezone with DST there is no such thing as 2.30am on the > date of changeover. That hour doesn't exist. I am using UCT - I am not using a timezone. > Look up the difference between timestamp and datetime data

Re: questions about timestamps and DST

2015-03-30 Thread Andrew Moore
When you use a timezone with DST there is no such thing as 2.30am on the date of changeover. That hour doesn't exist. Look up the difference between timestamp and datetime data types. A On 31 Mar 2015 05:43, "Larry Martell" wrote: > I have a column that was a timestamp typ

questions about timestamps and DST

2015-03-30 Thread Larry Martell
I have a column that was a timestamp type. I was inserting rows using NOW(). When we switched to DST and the hour from 2am to 3am was non-existent I of course had no data for that hour. For reasons I don't need to go into, that missing hour caused problems downstream. To prevent this

[ANNOUNCE] QxOrm 1.3.2 and QxEntityEditor 1.1.8 released, support C++11 types

2015-03-25 Thread QxOrm contact
Hello, *QxOrm 1.3.2* (C++/Qt ORM Object Relational Mapping database library) and *QxEntityEditor 1.1.8* (the graphic editor) just released (http://www.qxorm.com/) ! Changes in version *QxOrm 1.3.2*: *- Support C++11 types (need to set compilation options in QxOrm.pri config file to enable

Re: Create Schema and repeatable import of XML

2015-03-10 Thread Iñigo Medina
to a good > resource for using XML with Mysql. > > Specifically I have a complex XML file, I would like to create a schema in > MYSQL based on it (I have XSD as well) and be able to upload new xml data > into the database as it's released to me. > > I cannot find a good way to

Create Schema and repeatable import of XML

2015-03-09 Thread Sayth Renshaw
Hi Hoping someone can help me work some information or direction to a good resource for using XML with Mysql. Specifically I have a complex XML file, I would like to create a schema in MYSQL based on it (I have XSD as well) and be able to upload new xml data into the database as it's rel

RE: Users and Groups

2015-03-04 Thread Martin Gainty
> Date: Wed, 4 Mar 2015 14:04:55 +0100 > From: vegiv...@tuxera.be > To: lu...@lambrate.inaf.it > CC: mysql@lists.mysql.com > Subject: Re: Users and Groups > > > That reminds me, this may be of interest: > http://www.percona.com/blog/2015/03/02/emulating-roles-per

Re: Users and Groups

2015-03-04 Thread Johan De Meersman
That reminds me, this may be of interest: http://www.percona.com/blog/2015/03/02/emulating-roles-percona-pam-plugin-proxy-users/ - Original Message - > From: "Lucio Chiappetti" > To: "MySql" > Sent: Wednesday, 4 March, 2015 12:39:01 > Subject: Re:

Re: Users and Groups

2015-03-04 Thread Lucio Chiappetti
On Sun, 1 Mar 2015, Reindl Harald wrote: Am 01.03.2015 um 20:07 schrieb Steffan A. Cline: Has anyone seen a plugin for MySQL that will allow you to set up users and groups for access but it has all features for privileges like for tables, views and even colums, you can even restrict the

Re: Users and Groups

2015-03-02 Thread Johan De Meersman
- Original Message - > From: "Reindl Harald" > Subject: Re: Users and Groups > Am 01.03.2015 um 20:07 schrieb Steffan A. Cline: >> Has anyone seen a plugin for MySQL that will allow you to set up users and >> groups for access where you can have a user w

Re: Users and Groups

2015-03-01 Thread Reindl Harald
Am 01.03.2015 um 20:07 schrieb Steffan A. Cline: Has anyone seen a plugin for MySQL that will allow you to set up users and groups for access where you can have a user who can login, create db etc but ONLY see the stuff that belongs to them? I'm speaking of a shared server where mul

Users and Groups

2015-03-01 Thread Steffan A. Cline
Has anyone seen a plugin for MySQL that will allow you to set up users and groups for access where you can have a user who can login, create db etc but ONLY see the stuff that belongs to them? I'm speaking of a shared server where multiple people can use the same instance but be fully sepa

relation between innodb_thread_concurrency and MySQL threads

2015-02-07 Thread Learner Study
Hello, Could someone educate me on relation between "innodb_thread_concurrency" and number of MySQL threads running on the server with "thread pool" feature in Enterprise version of MySQL (based on release 5.6.16 (.4)?) If I set "innodb_thread_concurrency=32", how m

Re: update and control flow

2014-12-09 Thread hsv
>>>> 2014/12/09 14:25 +, Martin Mueller >>>> I'm trying to get my feet wet with 'if' and 'when' uses in mysql. it would be very useful for update operations, but I can't get it right. If I read the documentation correctly, it should be p

Re: update and control flow

2014-12-09 Thread shawn l.green
Hello Martin, On 12/9/2014 9:25 AM, Martin Mueller wrote: I'm trying to get my feet wet with 'if' and 'when' uses in mysql. it would be very useful for update operations, but I can't get it right. If I read the documentation correctly, it should be possible to sa

Re: update and control flow

2014-12-09 Thread Michael Dykman
s the only chance to have it updating a row > based on a condition is developing a Stored Procedure or even having a > BEFORE Trigger associated with the main table. Those ways, you can test the > sent value and decide on what UPDATE you will execute afterwards. Consider > that this is just

Re: update and control flow

2014-12-09 Thread wagnerbianchi.com
You can do that, but, perhaps the only chance to have it updating a row based on a condition is developing a Stored Procedure or even having a BEFORE Trigger associated with the main table. Those ways, you can test the sent value and decide on what UPDATE you will execute afterwards. Consider that

update and control flow

2014-12-09 Thread Martin Mueller
I'm trying to get my feet wet with 'if' and 'when' uses in mysql. it would be very useful for update operations, but I can't get it right. If I read the documentation correctly, it should be possible to say something like UPDATE X if WORD like 'a%' SET

mysql_upgrade and GTID :

2014-10-23 Thread Tyfanie Wineriter
question: For those of you running GTID, do you run mysql_upgrade, and if so, how? Really Long version: I am applying patch 5.6.21, specifically for the PITR bug fix, though the others are needed as well. My process is to stop the slave, apply the patch to the slave, then start slave b

Possible bug with event and delete...limit ?

2014-09-23 Thread Johan De Meersman
updating | DELETE FROM `cacti_net`.`syslog` WHERE logtime < '2014-06-23 17:13:51' | +---+---++---+-+---+--+--------+ 411 rows in set (13.66 sec) -- What's tiny and yellow and very, very dangerous? A canary with the root password.

Re: backup of databases which have a mix of MyISAM- and InnoDB-tables

2014-08-22 Thread Hartmut Holzgraefe
XTrabackup can handle both InnoDB and MyISAM in a consistent way while minimizing lock time on MyISAM tables ... http://www.percona.com/doc/percona-xtrabackup/2.1/ -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) SkySQL - The MariaDB Company | http://www.skysql.com/ -- MySQL General

Re: backup of databases which have a mix of MyISAM- and InnoDB-tables

2014-08-22 Thread Reindl Harald
Am 22.08.2014 um 19:40 schrieb Lentes, Bernd: > i've been already reading the documentation the whole day, but still confused > and unsure what to do. > > We have two databases which are important for our work. So both are stored > hourly. Now I recognized that each datab

backup of databases which have a mix of MyISAM- and InnoDB-tables

2014-08-22 Thread Lentes, Bernd
Hi, i've been already reading the documentation the whole day, but still confused and unsure what to do. We have two databases which are important for our work. So both are stored hourly. Now I recognized that each database has a mixture of MyISAM- and InnoDB-tables. A backup of this mix

Call for Advisory And Review Board

2014-08-04 Thread radhika
Website Link :http://researchthoughts.us/http://bookchapter.org/prospect/RTCallForEditor.png

Problem with INSERT INTO and UPDATE queries

2014-06-25 Thread Antonio Fernández Pérez
​Hi list, I have some problems with INSERT INTO and UPDATE queries on a big table. Let me put the code and explain it ... I have copied the create code of the table. This table has more than 1500 rows. ​Create Table: CREATE TABLE `radacct` ( `RadAcctId` bigint(21) NOT NULL AUTO_INCREMENT

Re: Difference between log-buffer "flushing" and "log-buffer" syncing?

2014-04-17 Thread Ajay Garg
gt;> > > I do understand the meaning of Unix "sync" function. >> > > >> > > So, you mean to say that "flushing" and "syncing" are same, in the >> > context of MySQL? >> > >> > please get rid of top-posting and reply-all >

Re: Difference between log-buffer "flushing" and "log-buffer" syncing?

2014-04-17 Thread Manuel Arostegui
2014-04-17 11:11 GMT+02:00 Ajay Garg : > On Thu, Apr 17, 2014 at 2:28 PM, Reindl Harald >wrote: > > > > > > > Am 17.04.2014 10:55, schrieb Ajay Garg: > > > I do understand the meaning of Unix "sync" function. > > > > > > So

Re: Difference between log-buffer "flushing" and "log-buffer" syncing?

2014-04-17 Thread Ajay Garg
On Thu, Apr 17, 2014 at 2:28 PM, Reindl Harald wrote: > > > Am 17.04.2014 10:55, schrieb Ajay Garg: > > I do understand the meaning of Unix "sync" function. > > > > So, you mean to say that "flushing" and "syncing" are same, in the > c

Re: Difference between log-buffer "flushing" and "log-buffer" syncing?

2014-04-17 Thread Reindl Harald
Am 17.04.2014 10:55, schrieb Ajay Garg: > I do understand the meaning of Unix "sync" function. > > So, you mean to say that "flushing" and "syncing" are same, in the context of > MySQL? please get rid of top-posting and reply-all a flush without a

Re: Difference between log-buffer "flushing" and "log-buffer" syncing?

2014-04-17 Thread Ajay Garg
Reindl, I do understand the meaning of Unix "sync" function. So, you mean to say that "flushing" and "syncing" are same, in the context of MySQL? On Thu, Apr 17, 2014 at 2:15 PM, Reindl Harald wrote: > > Am 17.04.2014 10:37, schrieb Ajay Garg: > > I

Re: Difference between log-buffer "flushing" and "log-buffer" syncing?

2014-04-17 Thread Reindl Harald
Am 17.04.2014 10:37, schrieb Ajay Garg: > I am a newbie to MySQL, and have been going through several online > resources. > > I usually come across the terms - "flushing" and "syncing" the log-buffer. > In particular, these two terms hold great signific

Difference between log-buffer "flushing" and "log-buffer" syncing?

2014-04-17 Thread Ajay Garg
Hi all. I am a newbie to MySQL, and have been going through several online resources. I usually come across the terms - "flushing" and "syncing" the log-buffer. In particular, these two terms hold great significance while selecting the value of "innodb_flu

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-

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

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.

  1   2   3   4   5   6   7   8   9   10   >