Am 19.08.2015 um 15:18 schrieb Jim:
On 8/19/2015 8:40 AM, Reindl Harald wrote:
Am 19.08.2015 um 14:29 schrieb Richard Reina:
I am writing a web application in perl that will create, edit, update
and
delete data from a MySQL database. I have written a perl module that
will
manage the
On 8/19/2015 8:40 AM, Reindl Harald wrote:
Am 19.08.2015 um 14:29 schrieb Richard Reina:
I am writing a web application in perl that will create, edit, update and
delete data from a MySQL database. I have written a perl module that will
manage the connections (issue database handles ). As new
I am writing a web application in perl that will create, edit, update and
delete data from a MySQL database. I have written a perl module that will
manage the connections (issue database handles ). As new users sign up for
the application should each get their own MySQL username and password or is
Am 19.08.2015 um 14:29 schrieb Richard Reina:
I am writing a web application in perl that will create, edit, update and
delete data from a MySQL database. I have written a perl module that will
manage the connections (issue database handles ). As new users sign up for
the application should
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/19/2015 05:29 AM, Richard Reina wrote:
As new users sign up for the application should each get their own
MySQL username and password or is okay to execute their queries
with the same (one generic) MySQL username and password?
That is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/19/2015 10:06 AM, Richard Reina wrote:
Data stored for each user would be a list of places visited that
and details relating to those trips. The type of queries they would
be able to perform be able to read, update and create new records.
Hello Martin,
Sorry about the delay. My normal support duties don't allow as much time
as I like to spend on community issues like this.
On 7/31/2015 10:41 AM, Martin Mueller wrote:
Dear Mr. Green,
first I'd like to thank you for your very clear explanations, which
helped. 'mysql' is an
Thanks everyone for their reply.
Best Regards,
Geetanjali Mehra
Senior Database Administrator
On Wed, Aug 12, 2015 at 7:07 PM, Reindl Harald h.rei...@thelounge.net
wrote:
Am 12.08.2015 um 15:07 schrieb geetanjali mehra:
I am in the process of creating a new slave. On my master, there is
Depending on the version of MySQL and InnoDB engine, the max key length can
be 3072 for InnoDB..
On Wed, Aug 12, 2015 at 9:21 AM, Johan De Meersman vegiv...@tuxera.be
wrote:
- Original Message -
From: geetanjali mehra mailtogeetanj...@gmail.com
Subject: Changing storage engine in
I have already made this attempt. And really I stucked into some problems.
I found lots of full text indexes created on the data directory . I don't
know from where they come. We have never created full text indexes for that
database. Slave also was not able to sync with its master. Now, I have
converting from MyISAM to innodb would certainly pose problems, I
guess the main question would be is MyISAM functionality a strict
sub-set of innodb?
I'm not sure, but maybe someone else here knows better.
Good luck,
Robert
--
MySQL General Mailing List
For list archives:
Am 12.08.2015 um 16:49 schrieb Bob Eby:
converting from MyISAM to innodb would certainly pose problems, I
guess the main question would be is MyISAM functionality a strict
sub-set of innodb?
I'm not sure, but maybe someone else here knows better
no it is for sure not
signature.asc
Hi,
I am in the process of creating a new slave. On my master, there is a mix
of innodb and myisam tables. I want all my tables to be created in innodb
on slave.
I have planned to change the value of storage engine from innodb to myisam
in dump file itself using sed .
Running that dump file on
- Original Message -
From: Richard Reina gatorre...@gmail.com
Subject: table desin question
Would this be the best way to design the schema and would it be best to
make the client ID and technician ID the same as the user ID as they relate
to the same person?
Close enough; but I
- Original Message -
From: geetanjali mehra mailtogeetanj...@gmail.com
Subject: Changing storage engine in dump file.
Is there any implications in doing so. Is this approach correct? Will I
face any problem in syncing the slave?
The first thing that occurs to me, is that the
I am ceating a database application with two different types of users,
clients and technicians. Both types of users have to create and account in
which they become users. From there they can become clients or
technicians or perhaps even both. Since each type describe different
attributes -- user
it is better to take the dump as it is on the master, restore it on the
salve and then change the storage engine through alter table commands that
will be the right way of doing and you could see any issues while
converting from MyISAM to InnoDB.
On Wed, Aug 12, 2015 at 6:51 PM, Johan De Meersman
Am 12.08.2015 um 15:07 schrieb geetanjali mehra:
I am in the process of creating a new slave. On my master, there is a mix
of innodb and myisam tables. I want all my tables to be created in innodb
on slave.
I have planned to change the value of storage engine from innodb to myisam
in dump file
On 2015/08/12 10:49, Bob Eby wrote:
converting from MyISAM to innodb would certainly pose problems, I
guess the main question would be is MyISAM functionality a strict
sub-set of innodb?
I'm not sure, but maybe someone else here knows better.
No, as already said: for one thing, MyISAM allows
On 2015/08/12 09:42, Johan De Meersman wrote:
- Original Message -
From: Richard Reinagatorre...@gmail.com
Subject: table desin question
Would this be the best way to design the schema and would it be best to
make the client ID and technician ID the same as the user ID as they relate
Thank you for answer. The problem is that I wrote in previous message
that there is no sql backup just the files for binary backup. Hardware
we are using is a simple laptop with Windows 7 that runs 5.1 server in
case the originally installed files are in use. It runs an 5.5 server
paralelly as
On Tue, August 4, 2015 16:05, Ryan Coleman wrote:
No but there should be. If there's not my task is useless.
Secondly yes. Unique name on it too.
--
Ryan Coleman
Publisher, d3photography.com
ryan.cole...@cwis.biz
m. 651.373.5015
o. 612.568.2749
On Aug 4, 2015, at 17:33, Wm Mussatto
Hello,
We are facing a strange innodb related problem. Our client ran mysql 5.1
on WinXP having file_per_table disabled. OS crashed after 5 years
continuous running and our client of course does not have any backup
(big company with own IT department so we do not have acces to their
system
Am 05.08.2015 um 17:06 schrieb Csepregi Árpád:
150805 17:02:31 InnoDB: Page dump in ascii and hex (16384 bytes):
hex...
150805 17:02:31 InnoDB: Page checksum 1094951825, prior-to-4.0.14-form
checksum 1449969277
InnoDB: stored checksum 1467223489, prior-to-4.0.14-form stored checksum
87759728
No but there should be. If there's not my task is useless.
Secondly yes. Unique name on it too.
--
Ryan Coleman
Publisher, d3photography.com
ryan.cole...@cwis.biz
m. 651.373.5015
o. 612.568.2749
On Aug 4, 2015, at 17:33, Wm Mussatto mussa...@csz.com wrote:
On Tue, August 4, 2015 11:19,
I have been a MySQL user and supporter for over a decade (since 2001) and I am
almost ashamed to admit that I haven’t the faintest idea on how to do joins and
unions.
I have a specific query I would love to run…
I have two tables, one with Unique data (“images”) and one with corresponding
On Tue, August 4, 2015 11:19, Ryan Coleman wrote:
I have been a MySQL user and supporter for over a decade (since 2001) and
I am almost ashamed to admit that I haven’t the faintest idea on how to do
joins and unions.
I have a specific query I would love to run…
I have two tables, one with
Data directory path mention in cnf is of old mysql.
Make a fresh data directory, configure it in configuration file and execute
mysqlinstall_db,
I don't understand the sentence about the data directory path mention. The
my.cnf file is at /etc/my.cnf . It doesn't have any data directory
Am 31.07.2015 um 14:40 schrieb Martin Mueller:
Sorry for the off-list reply. It was an oversight.
That said, the instructions for resetting a forgotten root password have a
section for Windows and a section for Unix. The Unix section begins as
follows:
1. Log on to your system as the Unix
Am 31.07.2015 um 16:23 schrieb Martin Mueller:
Dear Mr Harald,
I've learned some things from your responses and even more from shawn
green's. You might learn a lot from him about patience and courtesy, which
make life on a technical forum a lot easier. You clearly know a lot about
technical
Am 31.07.2015 um 14:45 schrieb Martin Mueller:
Data directory path mention in cnf is of old mysql.
Make a fresh data directory, configure it in configuration file and execute
mysqlinstall_db,
I don't understand the sentence about the data directory path mention. The
my.cnf file is at
Am 31.07.2015 um 15:40 schrieb shawn l.green:
1. Log on to your system as the Unix user that the MySQL server runs as
(for example, mysql).
Everything that executes on a Linux/Unix/Mac machine executes in the
context of some kind of user account (the system login). By default,
mysqld (the
Sorry for the off-list reply. It was an oversight.
That said, the instructions for resetting a forgotten root password have a
section for Windows and a section for Unix. The Unix section begins as
follows:
1. Log on to your system as the Unix user that the MySQL server runs as
(for example,
Dear Mr Harald,
I've learned some things from your responses and even more from shawn
green's. You might learn a lot from him about patience and courtesy, which
make life on a technical forum a lot easier. You clearly know a lot about
technical stuff, but you're short on patience, and it would
Dear Mr. Green,
first I'd like to thank you for your very clear explanations, which
helped. 'mysql' is an overdetermined word with all the advantages and
disadvantages of that.
While finally getting into the door, I ran into another problem: pid-file
quit without updating. This seems to be a
On 7/31/2015 8:40 AM, Martin Mueller wrote:
Sorry for the off-list reply. It was an oversight.
That said, the instructions for resetting a forgotten root password have a
section for Windows and a section for Unix. The Unix section begins as
follows:
1. Log on to your system as the Unix
first: don't reply off-list, a answer on a mailing-list is no invitation
for private support!
Am 31.07.2015 um 02:34 schrieb Martin Mueller:
I read that section but was stopped in my tracks by
Log on to your system as the Unix user that the MySQL server runs as
(for example, mysql)
Because
Data directory path mention in cnf is of old mysql.
Make a fresh data directory, configure it in configuration file and execute
mysqlinstall_db,
On Fri, Jul 31, 2015 at 5:11 AM, Martin Mueller
martinmuel...@northwestern.edu wrote:
I have installed mysql 5.1.73 on an old Mac Pro running OS
Am 31.07.2015 um 01:41 schrieb Martin Mueller:
I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot
run the mysql command because it challenges me for a password. But I did
not set any password, either for the root, for mysql, or for myself as a
user.
So the installation
I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot
run the mysql command because it challenges me for a password. But I did
not set any password, either for the root, for mysql, or for myself as a
user.
So the installation has somehow installed passwords about which I know
Share error log file
-Original Message-
From: Martin Mueller martinmuel...@northwestern.edu
Sent: 29-07-2015 21:05
To: mysql@lists.mysql.com mysql@lists.mysql.com
Subject: installation problem of MySQL on OS Lion
I installed MySQL on a Mac Pro running OS Lion.
The installation was
Hi Peter,
Thanks for the reply. So are you saying like this?
Repair
RID INT, Date DATE, Tech_ID INT, R_TYPE_ID INT
1 2015-07-28 3243 3
2 2015-06-15 1253 1
Repair_details
ID, APL_TYPE VARCHAR(35), REPAIR_CODE CHAR(4), DESC
1 Refridgerator
C
I installed MySQL on a Mac Pro running OS Lion.
The installation was successful, but starting the mysql server generated the
following error message:
Martin-Muellers-Mac-Pro:~ martin$ sudo
/usr/local/mysql/support-files/mysql.server start
Starting MySQL
... ERROR! Manager of pid-file quit
Hi Richard,
On 7/29/2015 10:19 AM, Richard Reina wrote:
If I were to create a database table(s) to tract most common repairs to
different appliances I can't decide if it would be better to create one
table with a long ENUM column that contains repairs that could be
attributed to any appliance
If I were to create a database table(s) to tract most common repairs to
different appliances I can't decide if it would be better to create one
table with a long ENUM column that contains repairs that could be
attributed to any appliance or different repair tables for each appliance.
All the
- Original Message -
From: Camilo Vieira camilo.vie...@gmail.com
Subject: Re: MySQL 5.5 Slow performance to insert
$ ./mysqltuner.pl --user root --pass abril@123
Thank you for that password :-) I don't particularly like MySQLtuner myself, it
makes assumptions about your workload
Hi Luis,
I have got the output below:
$ ./mysqltuner.pl --user root --pass abril@123
[OK] Logged in using credentials passed on the command line
MySQLTuner 1.5.0 - Major Hayden ma...@mhtx.net
Bug reports, feature requests, and downloads at http://mysqltuner.com/
Run with '--help' for
On 7/24/2015 4:35 PM, Camilo Vieira wrote:
Hi,
My MySQL server is performing very slow inserts. Does somebody could help
me to understand what's happening?
... snip ...
---TRANSACTION 31D6D74, ACTIVE 27107 sec
mysql tables in use 8, locked 8
7470 lock struct(s), heap size 801208, 849088 row
Hi,
Your INSEERquery status is Copying to tmp table,
this means fetching rows which has to be inserted is slow.
You should tune SELECT statement in your insert query.
Adding indexes and/or simplifying query and/or .. so on.
```
---TRANSACTION 31D6D74, ACTIVE 27107 sec
mysql tables in use 8,
Dear MySQL users,
MySQL Server 5.6.26, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.6.26 is
recommended for use on production systems.
For an overview of what's new in MySQL 5.6, please see
Hi,
My MySQL server is performing very slow inserts. Does somebody could help
me to understand what's happening?
mysql show engine innodb status \G
*** 1. row ***
Type: InnoDB
Name:
Status:
=
150724 17:40:28
why do you think we could do that for you and what do you think is that
link in every mail for? YES i send this to the list hopefully to save a
few of this meh i can't handle my mail.
To unsubscribe:http://lists.mysql.com/mysql
Am 22.07.2015 um 18:08 schrieb Charles Turner:
Dear
Dear Sirs,
I'd like to unsubscribe my subscription to this mailing list.
Thank you so much.
Regards
Andrea Fanni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
hopefully you did run mysql_upgrade first on the slave as all docs in that
context saying and after that on the master
Cool!! Yeah, running mysql_upgrade did the trick. After I performed that on
the slave, that error went away. I actually did the same on both nodes
figuring it would be best to
Am 22.07.2015 um 06:39 schrieb Tim Dunphy:
Hey guys,
I'm trying to setup multi master replication using SSL under MariaDB 10.20.
I've been able to specify my client certs on the second node (db2) with no
issue and start up the mysql service
what about running mysql_upgrade *directly* after
Am 22.07.2015 um 16:24 schrieb Tim Dunphy:
Hi Reindl,
what about running mysql_upgrade *directly* after the major update
and *before* touch anything else?
That was precisely what happened. In setting up the new database
machine, puppet had installed version 5 of mariadb. Before even
Hi Reindl,
what about running mysql_upgrade *directly* after the major update and
*before* touch anything else?
That was precisely what happened. In setting up the new database machine,
puppet had installed version 5 of mariadb. Before even starting up version
of for the first time, I
Hey guys,
I'm trying to setup multi master replication using SSL under MariaDB 10.20.
I've been able to specify my client certs on the second node (db2) with no
issue and start up the mysql service.
But for some reason when I do the same on the first node (db1) the mysql
service takes a really
Hi Reindel,
you client configuration shows no indication for SSL, i see it in my.cnf
only in the [mysqld] section and remember when you initrialize replication
you need to specify it there too
i doubt there is anything to change the logging but since you *know* what
that user requires that
Am 21.07.2015 um 05:03 schrieb Tim Dunphy:
I see absolutely NO indication as to why the login for the 'slave2' user
(that requires SSL) is failing
So my questions are 1) how to I bump up the verbosity on the logs so I can
get an indication as to why this is failing? 2) what is the best way to
Have u executed mysql_install_db?
On 15-May-2015 1:31 pm, Jørn Dahl-Stamnes sq...@dahl-stamnes.net wrote:
Hello,
I have reinstalled a test server after a disk crash. I upgraded from an
older Fedora Core (don't
remember the version) to Fedora Core 21.
Then I installed Mysql 5.7.7 from RPM.
Hey all,
I need to setup replication via SSL. 2 nodes master/master for H/A. Then 2
slave nodes for backup. Node 3 will slave off of node 1, and node 4 will
slave off of node 2 for redundant backups. Nodes 3 4 will store backups
to a directory mapped to S3 via S3FS. All nodes are physical.
Hi,
Can someone perhaps assist with the below... I'm not sure at all why my
index aren't being used for the ORDER BY. Currently some 443K records in
the table, but this will grow to a good few million. I simply cannot,
afford a filesort.
mysql SELECT COUNT(*) FROM myTable;
+--+
|
Hi,
Your query have to access all rows in `myTable`, thus MySQL optimizer
guesses reading sequentially is faster than working through an
index.
http://dev.mysql.com/doc/refman/5.6/en/mysql-indexes.html
The case of not using index,
* Reading whole myTable.MYD sequentially
* Sorting 443k rows
Upscene Productions is proud to announce a new release
of the popular multi-DBMS development tool:
“ Database Workbench 5.1.2
This version is the next big release after version 5 and includes new features,
enhancements and fixes.
The change log is available here:
Dear MySQL Users,
MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:
- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read write scalability
- Active-Active/Multi-Master
Dear Sir or Madam,
Due to business development requirements, we need to order coffee in large
quantities; The min order quantity is based on 40-foot container.
At present we are seeking for establishing long term partnership with overseas
manufacturers, and we’d like to become a regular
Just to be sure, is that first sentence supposed to be reading node-2 and not
node-1? The datafiles should not be in use anywhere, on any node, or disaster
will be your share.
Additionally, what is your shared filesystem? Is it possible that there is
still a lock on the datafiles at that
On 7/6/2015 1:39 PM, Claudio Nanni wrote:
Hi Jatin,
Say if i am using a DB instance for quiet some time on node-1 and
it has data in it. If i decide to have replication with another DB
instance , will all the data from node-1 be first replicated to
node-2's DB ? Or will it just
Hi All
We are basically intending to implement High Availability for our
application. In this regard , we want to use Mysql replication for this
purpose.
We would have a two-node cluster , say node-1 node-2.
Assume that if node-1is functioning we want the DB changes on it to be
replicated
On 7/5/2015 10:48 PM, Claudio Nanni wrote:
Hello Jatin,
We are basically intending to implement High Availability for our
application. In this regard , we want to use Mysql replication for
this purpose.
Your scenario(MySQL Master/Slave with Failover/Failback procedures)
has been a typical
Am 04.07.2015 um 06:24 schrieb Jatin Davey:
We are trying to High Availability solution for our database. We have
our application running on a node-1 and the DB running on the shared
storage which is shared across node-1 node-2. Whenever there is a
power Failure on node-1 , we start our
On 7/4/2015 2:26 PM, Reindl Harald wrote:
Am 04.07.2015 um 06:24 schrieb Jatin Davey:
We are trying to High Availability solution for our database. We have
our application running on a node-1 and the DB running on the shared
storage which is shared across node-1 node-2. Whenever there is a
Hello all,
MySQL Connector/J 5.1.36, a maintenance release of the production 5.1
branch has been released. Connector/J is a Type-IV pure-Java JDBC
driver for MySQL. It is suitable for use with MySQL server versions 5.5
and 5.6.
MySQL Connector Java is available in source and binary form from
Hi All
We are trying to High Availability solution for our database. We have
our application running on a node-1 and the DB running on the shared
storage which is shared across node-1 node-2. Whenever there is a
power Failure on node-1 , we start our application on node-2 but our
problem is
I have a very large table (~50GB) and periodically rows are purged
from it and I want to run OPTIMIZE TABLE to recover the space. But I
do not have enough space to run it. If I do run it the server hangs
and must be killed and restarted and the table is damaged and must be
repaired. I do this with
Found the problem here, someone had created on insert and on update
triggers on this table that were interferring with the process.
This logic works wonderfully when you need sequence numbers that are also
transaction safe. The key is you need a unique index on all the columns
involved.
I think
If the return value of the UPDATE stmt is zero, the following stmt is ran:
By return value I assume you mean rows affected ?
This is working great, and has been for many years; however,
today I noticed it was not working on a particular MySQL server.
By not working what exactly is the
Bernd wrote:
a password ?
Hi,
this is my system:
mysql status
--
mysql Ver 14.12 Distrib 5.0.26, for suse-linux (x86_64) using readline 5.1
Connection id: 142883
Current database: mysql
Current user: root@localhost
SSL:Not in
Hi,
this is my system:
mysql status
--
mysql Ver 14.12 Distrib 5.0.26, for suse-linux (x86_64) using readline 5.1
Connection id: 142883
Current database: mysql
Current user: root@localhost
SSL:Not in use
Current pager: less
I should add:
By working I mean:
The first time the UPDATE stmt runs, it will return a zero value for the
seq_id.
The insert stmt will initialize it to 1000
The second time the UPDATE stmt runs, it returns 1001.
The third time, 1002, etc.
When it doesn't work, the second time the code is ran
On 2015-06-29 7:03 PM, Johnny Withers wrote:
Hello all,
I have a tabled defined:
CREATE TABLE `store_seq` (
`seq_type_id` smallint(3) unsigned NOT NULL DEFAULT '0',
`store_id` int(10) unsigned NOT NULL DEFAULT '0',
`loan_model_id` int(10) unsigned NOT NULL DEFAULT '0',
Hello all,
I have a tabled defined:
CREATE TABLE `store_seq` (
`seq_type_id` smallint(3) unsigned NOT NULL DEFAULT '0',
`store_id` int(10) unsigned NOT NULL DEFAULT '0',
`loan_model_id` int(10) unsigned NOT NULL DEFAULT '0',
`store_bank_id` int(10) unsigned NOT NULL DEFAULT '0',
2015-06-25 14:02 GMT+02:00 wagnerbianchi.com m...@wagnerbianchi.com:
Some additional information here, just my 2 cents.
(...)
Just checking in: using two servers in replication, idle servers, on the
slave side I configured globally the slave_net_timeout=1 and log_warnings=2,
as I'm using
Further more, use logstash to collect the audit events and you can filter
out anything that wasn't an error and move it to a query error log.
On Wed, Jun 24, 2015 at 5:32 PM, Singer Wang w...@singerwang.com wrote:
Yep, as shown below:
root@audit-db.ec2:(none) select fark from fark from fark
Some additional information here, just my 2 cents.
The system variables slave_net_timeout will controls over the time the
slave server will be waiting for new data dumped form master's binlog. If
no interaction or inactivity is greater than slave_net_timeout, the
reconnection will be made. Here
For immediate release:
http://www.upscene.com/news/item/20150624
Upscene releases Database Workbench 5.1.0
Upscene Productions is proud to announce a new release
of the popular multi-DBMS development tool:
“ Database Workbench 5.1
This version is the next big release after version 5 and
From: Singer X.J. Wang w...@singerwang.com
Subject: Re: server-side logging of query errors?
You could log all queries using the audit plugin, 15% hit..
Fair point, though: maybe one of the different audit plugins has the capability
to specifically log faulty requests. Have a look through
The performance hit of the Percona Audit is 15% for disk logging and for
remote syslog we found it is lower. It logs everything including bad
queries (eg. select fark from fark from fark fark fark from frak). You
should be able to write a JSON parser that extracts what you want based on
the log
2015-06-22 13:45 GMT+02:00 Ben RUBSON ben.rub...@gmail.com:
2015-06-19 12:08 GMT+02:00 Ben RUBSON ben.rub...@gmail.com:
2015-06-18 22:52 GMT+02:00 shawn l.green shawn.l.gr...@oracle.com:
On 6/18/2015 2:10 PM, Ben RUBSON wrote:
Hello,
In order for the slave to quickly show a
Yep, as shown below:
root@audit-db.ec2:(none) select fark from fark from fark fark fark from
frak;
ERROR 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 'from fark fark fark from frak' at line 1
Normal general log also logs everything including bad queries (i.e.
SLCECT BLAH BLAH;) - although does not say if it was an error (i.e.
syntax) or not.
Does the audit plugin log the actual error?
Tomasz
On 2015-06-25 00:32, Singer Wang wrote:
The performance hit of the Percona Audit is 15%
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
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-repo.html
was
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
You could log all queries using the audit plugin, 15% hit..
On Tue, Jun 23, 2015 at 4:54 AM, Johan De Meersman vegiv...@tuxera.be
wrote:
- Original Message -
From: Tomasz Chmielewski man...@wpkg.org
It would be a mild security risk; a malicious
(or just stupid, see Hanlon's
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 binaries. Ie
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
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 after I get MySQL running.
The documentation at
Suppose I run a query which has a syntax error:
mysql blah;
ERROR 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 'blah' at line 1
How can I get mysql server to log this error?
According to
901 - 1000 of 154234 matches
Mail list logo