> Am 04.09.2016 um 23:35 schrieb Reindl Harald :
>
>
>
> Am 04.09.2016 um 16:17 schrieb Matthias Schmidt:
>>> Am 04.09.2016 um 16:29 schrieb Reindl Harald :
>>>
>>> Am 04.09.2016 um 08:40 schrieb Matthias Schmidt:
2016-09-04 15:25:19 85518
Am 04.09.2016 um 16:17 schrieb Matthias Schmidt:
Am 04.09.2016 um 16:29 schrieb Reindl Harald :
Am 04.09.2016 um 08:40 schrieb Matthias Schmidt:
2016-09-04 15:25:19 85518 [ERROR] /usr/local/mysql/bin/mysqld: Can't
create/write to file
> Am 04.09.2016 um 16:29 schrieb Reindl Harald :
>
>
>
> Am 04.09.2016 um 08:40 schrieb Matthias Schmidt:
>> 2016-09-04 15:25:19 85518 [ERROR] /usr/local/mysql/bin/mysqld: Can't
>> create/write to file '/usr/local/mysql/data/mysqld.local.pid' (Errcode: 102
>> -
Am 04.09.2016 um 08:40 schrieb Matthias Schmidt:
2016-09-04 15:25:19 85518 [ERROR] /usr/local/mysql/bin/mysqld: Can't
create/write to file '/usr/local/mysql/data/mysqld.local.pid' (Errcode: 102 -
Operation not supported on socket)
2016-09-04 15:25:19 85518 [ERROR] Can't start server: can't
-
Operation not supported on socket)
2016-09-04 15:25:19 85518 [ERROR] Can't start server: can't create PID file:
Operation not supported on socket
the socket is created but then something goes wrong.
as I couldn’t find anything, which really would relate to the problem, I guess
I miss something here
Hi all,
Recently, I got the newest version of mysql-server from the github,
Bug I got some compile problem as follows:
cmake -DCMAKE_INSTALL_PREFIX=/u04/my3306 \
-DMYSQL_DATADIR=/u04/my3306/data -DMYSQL_USER=mysql \
-DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1
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
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
or there is some error in the installation process.
There is a lot on the Web about resetting a forgotten password. But the
assumption is always that you can get at the program via some other
password. But in this case every door is shut.
Does anybody recognize this problem? I've uninstalled and re-installed
password. But in this case every door is shut.
Does anybody recognize this problem? I've uninstalled and re-installed
the
program, but the results are always the same
* install and uninstall *never* removes the datadir
* users and permissions are in the DB mysql
* https://dev.mysql.com/doc/refman/5.0
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
/my.cnf . It doesn't have any data directory path
mention, but neither does the my.cnf file on a laptop, which works. So there
seems to be nothing wrong with the location or content of the my.cnf file.
your current problem is that you have no clue where your mysql-datadir
is *because* it's some
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
a forgotten password. But
the
assumption is always that you can get at the program via some other
password. But in this case every door is shut.
Does anybody recognize this problem? I've uninstalled and re-installed
the
program, but the results are always the same
* install and uninstall *never
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
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
at the program via some other
password. But in this case every door is shut.
Does anybody recognize this problem? I've uninstalled and re-installed
the
program, but the results are always the same
* install and uninstall *never* removes the datadir
* users and permissions are in the DB mysql
* https
.
There is a lot on the Web about resetting a forgotten password. But the
assumption is always that you can get at the program via some other
password. But in this case every door is shut.
Does anybody recognize this problem? I've uninstalled and re-installed the
program, but the results
.
Does anybody recognize this problem? I've uninstalled and re-installed the
program, but the results are always the same
* install and uninstall *never* removes the datadir
* users and permissions are in the DB mysql
* https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
nothing or there is some error in the installation process.
There is a lot on the Web about resetting a forgotten password. But the
assumption is always that you can get at the program via some other
password. But in this case every door is shut.
Does anybody recognize this problem? I've
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
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
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
Master:
+--+--+--+--+
| File
On 8/29/2014 5:11 PM, wagnerbianchi.com wrote:
Hello guys, some points to check here:
1-) Is the master server configured with sync_binlog=1 ?
It was not, I reconfigured and restarted mysql and...
2-) About the SHOW SLAVE STATUS output, when slave seems to be just reading
events from
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
after a more complex transaction;
There's a duplicate key on the audit table, 18699. Delete it and restart
slave (start slave). Check slave status again, might be more rows in there
duplicated.
You might want to compare the row to master to ensure it's a duplicate
before deleting from slave.
On Aug 30, 2014 7:52 AM, william
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously ) global var, below
+--+--+--+--+
|
Based on the SHOW SLAVE STATUS output you've sent us, I'd suggest that you
check what the application is doing, understand *why* the application is
violating the PK of the table information_server.audit, repair the possible
application problem and the, reconfigure the replication.
It seems
On 30/08/14 09:39, william drescher wrote:
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on
Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
Master:
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
mysql show global variables like 'log_bin%';
+-+---+
Thanks for pointing out the importance of the last error
I resynced the slave to the master, reset the master position,
and restarted the slave.
Now all works fine and I am much better equipped next time to
debug the loss of the link.
When is the Last Error data deleted from the show slave
On 30/08/14 12:56, william drescher wrote:
Thanks for pointing out the importance of the last error
I resynced the slave to the master, reset the master position, and
restarted the slave.
Now all works fine and I am much better equipped next time to debug the
loss of the link.
When is the
On 8/30/2014 12:53 PM, Jose Julian Buda wrote:
On 30/08/14 12:56, william drescher wrote:
Thanks for pointing out the importance of the last error
I resynced the slave to the master, reset the master position, and
restarted the slave.
Now all works fine and I am much better equipped next
Replication novice
I have a master server at the office and a replication server at
home. This setup has been working for a couple of years.
Occasionally the replication server gets out of sync (usually
following a internet problem and the vpn going down.)
I just stop the slave, make sure
server at home.
This setup has been working for a couple of years. Occasionally the
replication server gets out of sync (usually following a internet problem
and the vpn going down.)
I just stop the slave, make sure there is nothing going to the master
(when the office is closed),
copy
will...@techservsys.com wrote:
Replication novice
I have a master server at the office and a replication server at home.
This setup has been working for a couple of years. Occasionally the
replication server gets out of sync (usually following a internet problem
and the vpn going down.)
I
:
Replication novice
I have a master server at the office and a replication server at home.
This setup has been working for a couple of years. Occasionally the
replication server gets out of sync (usually following a internet
problem
and the vpn going down.)
I just stop the slave, make
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,
Hi
Run mysql_upgrade command at OS shell
DK Sent from Phone
On 28-May-2014, at 1:40 pm, Lentes, Bernd
bernd.len...@helmholtz-muenchen.de wrote:
Hi,
we just migrated from 5.0 to 5.5. Nearly everything went well. But we can't
access one particular table.
Automysqlback 3.0 says:
Hi,
we just migrated from 5.0 to 5.5. Nearly everything went well. But we can't
access one particular table.
Automysqlback 3.0 says: mysqldump: Got error: 1142: SELECT,LOCK TABL command
denied to user 'backup'@'localhost' for table 'cond_instances' when using LOCK
TABLES.
root has these
- Original Message -
From: Bernd Lentes bernd.len...@helmholtz-muenchen.de
To: mysql@lists.mysql.com
Sent: Wednesday, 28 May, 2014 10:10:33 AM
Subject: access problem for a particular table
we just migrated from 5.0 to 5.5. Nearly everything went well. But we can't
access one
Hi guys
I am hoping that someone might have experienced this before or
might know why we are getting this.
We regularly need to run some queries and export the results to a
csv file.
However we seem to be experiencing the following issues:
- when we run an
If you're doing this from the cmd-line client, try running it using --quick.
Best,
/ Carsten
On 19-02-2014 09:03, Machiel Richards wrote:
Hi guys
I am hoping that someone might have experienced this before or
might know why we are getting this.
We regularly need to run some
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
- Original Message -
From: Machiel Richards machiel.richa...@gmail.com
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 table
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 machiel.richa...@gmail.com
Subject: Mysql into outfile problem
- when we run an explain on the query it shows
- Original Message -
From: Machiel Richards machiel.richa...@gmail.com
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
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, Machiel Richards
-
From: Larry Martell [mailto:larry.mart...@gmail.com]
Sent: Tuesday, September 24, 2013 1:44 PM
To: shawn green
Cc: mysql mailing list
Subject: Re: Problem with having
On Tue, Sep 24, 2013 at 9:05 AM, shawn green
shawn.l.gr...@oracle.comwrote:
Hello Larry,
On 9/23/2013 6:22 PM, Larry
I
Sent from my D
- Reply message -
From: Rick James rja...@yahoo-inc.com
To: Larry Martell larry.mart...@gmail.com, shawn green
shawn.l.gr...@oracle.com
Cc: mysql mailing list mysql@lists.mysql.com
Subject: Problem with having
Date: Thu, Sep 26, 2013 12:11 PM
Still more to this saga
.date_time
WHERE d2.recipe_id IS NULL
As I said, there are many many ways to solve this problem. Here is one
that is going to perform much better for the generic case than what you
are doing.
CREATE TEMPORARY TABLE tmpMaxDates (key(recipe_id,maxdatetime))
SELECT recipe_id, max(date_time
solution:
SELECT d1.id, d1.date_time as MaxDateTime
FROM data_cstmeta d1
LEFT JOIN data_cstmeta d2 ON d1.recipe_id = d2.recipe_id AND
d1.date_time d2.date_time
WHERE d2.recipe_id IS NULL
As I said, there are many many ways to solve this problem. Here is one
that is going
Hi,
In your second query, you seem to have MIN(date_time), but you are talking
about maximum. So your group by query is actually pulling the minimum date
for this recipe.
Regards.
On Mon, Sep 23, 2013 at 3:35 PM, Larry Martell larry.mart...@gmail.comwrote:
I want to find the rows from a table
I want to find the rows from a table that have the max date_time for each
recipe. I know I've done this before with group by and having, but I can't
seem to get it to work now. I get the correct row id, but not the correct
date_time. I'm sure I'm missing something simple.
For purposes of showing
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
narula...@gmail.comwrote:
Hi,
In your second query, you seem to have MIN(date_time), but you are
talking about maximum. So your group by query is actually pulling the
minimum date for this recipe.
I pasted the wrong query in. I get the
Hi Larry,
On 9/23/2013 3:58 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
narula...@gmail.comwrote:
Hi,
In your second query, you seem to have MIN(date_time), but you are
talking about maximum. So your group by query is actually pulling the
minimum date for
select recipe_id,max(maxdatetime) from data_csmeta group by recipe_id
having recipe_id=19166;
On Mon, Sep 23, 2013 at 4:15 PM, shawn green shawn.l.gr...@oracle.comwrote:
Hi Larry,
On 9/23/2013 3:58 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
On Mon, Sep 23, 2013 at 3:15 PM, shawn green shawn.l.gr...@oracle.comwrote:
Hi Larry,
On 9/23/2013 3:58 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
narula...@gmail.comwrote:
Hi,
In your second query, you seem to have MIN(date_time), but you are
to complete the
condition by HAVING MIN(date_time) , or = something.
After reading this, I see what the problem is:
http://dev.mysql.com/doc/refman/5.0/en/group-by-extensions.html
Then I read this:
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
and changed
Hello all,As this is my first post to this list (though reading for some time yet), I maybe not complete in asking my question. Apologies for that.On the other hand, this is not a prio 1 problem, so if it takes some mailing, that's ok.I have a website on my private webserver, which consist of some
for that.
On the other hand, this is not a prio 1 problem, so if it takes some mailing,
that's ok.
I have a website on my private webserver, which consist of some kind of a
LAMP-server on a raspberry. Previously it ran on a laptop with Ubuntu and the
same kind of LAMP-server.
I'm trying
.
Luis H. Forchesatto
Em 08/09/2013 16:00, Trianon33 triano...@gmail.com escreveu:
Hello all,
As this is my first post to this list (though reading for some time
yet), I maybe not complete in asking my question. Apologies for that.
On the other hand, this is not a prio 1 problem, so
maybe not complete in asking my question. Apologies for that.
On the other hand, this is not a prio 1 problem, so if it takes some
mailing, that's ok.
I have a website on my private webserver, which consist of some kind of
a LAMP-server on a raspberry. Previously it ran on a laptop with Ubuntu
question. Apologies for that.
On the other hand, this is not a prio 1 problem, so if it takes some
mailing, that's ok.
I have a website on my private webserver, which consist of some kind of
a LAMP-server on a raspberry. Previously it ran on a laptop with Ubuntu
and
the same kind
What's the MySQL error log have to say?
- Original Message -
From: Luis H. Forchesatto luisforchesa...@gmail.com
To: Johan De Meersman vegiv...@tuxera.be
Sent: Tuesday, 23 July, 2013 3:39:55 PM
Subject: Re: InnoDB problem.
Yep, I do backup of /home/mysql/ib* files too :D
What
-
From: Luis H. Forchesatto luisforchesa...@gmail.com
To: Johan De Meersman vegiv...@tuxera.be
Sent: Tuesday, 23 July, 2013 6:34:47 PM
Subject: Re: InnoDB problem.
The error log:
130723 10:04:23 [ERROR] Plugin 'InnoDB' init function returned error.
130723 10:04:23 [ERROR] Plugin 'InnoDB
Did you change innodb_log_file_size?
-Original Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be]
Sent: Tuesday, July 23, 2013 9:57 AM
To: Luis H. Forchesatto; mysql list
Subject: Re: InnoDB problem.
Eek.
No immediate clue here, but maybe someone else does - so please
-Original Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be]
Sent: Tuesday, July 23, 2013 9:57 AM
To: Luis H. Forchesatto; mysql list
Subject: Re: InnoDB problem.
Eek.
No immediate clue here, but maybe someone else does - so please keep the
list in CC at all times
: Re: InnoDB problem.
2013/7/23 Rick James rja...@yahoo-inc.commailto:rja...@yahoo-inc.com
Did you change innodb_log_file_size?
innodb_log_file_size error always appears in the logs...he only posted a few
lines of his log...but I guess (or I want to believe) he's gone through the
whole log
Greetings.
I've restored an MySQL backup from our MySQL server into another server.
The backup includes InnoDB tables. After the import, MySQL recognized the
innodb tables fine but when I try to do a check table ir returns that the
table doesn't exists.
Permission and owner of the table files
- Original Message -
From: Luis H. Forchesatto luisforchesa...@gmail.com
Subject: InnoDB problem.
Permission and owner of the table files (.frm files) are ok, since it
recognizes MyISAM tables (they have the same permission).
Oops. You should always read the fine manual.
You took
Hi,
I've created a Trigger and want to edit it. Using MySQL Workbench, I can
Alter the table, and click Triggers and select the trigger action I want to
edit (on my local database, MySQL running on same PC)
However, if I try the exact same procedure on a Trigger on a remote
database, I don't
Begin forwarded message:
From: Napster Cao tx...@hotmail.com
Subject: character set problem
Date: June 11, 2013 11:04:18 PM GMT+08:00
To: mysql@lists.mysql.com
Hi Guys,
I installed a new CentOS server (6.4 x86_64), and when I try to log into
phpmyadmin, there's an ERROR:
Can't
independent how often you re-post it will not become magically
a MySQL problem if you have messed up your OS environment
Am 12.06.2013 15:27, schrieb Napster Cao:
BTW: Everytime I logged into system, I got:
-bash: warning: setlocale: LC_CTYPE: cannot change locale (UTF-8): No such
file
Hi,
I've a trigger that writes some data to a temporary table; and at the end
of the trigger writes all the temporary table data in one insert to our
normal Innodb table.
However, for some reason the trigger isn't copying the table from the
temporary table to the Innodb table. If I write in the
can you please share the code of the trigger. Any kind of error your getting
On Wed, May 29, 2013 at 6:49 PM, Neil Tompkins neil.tompk...@googlemail.com
wrote:
Hi,
I've a trigger that writes some data to a temporary table; and at the end
of the trigger writes all the temporary table data
This is my Trigger which doesn't seem to work; but doesn't cause a error
DROP TEMPORARY TABLE IF EXISTS tempHotelRateAvailability;
CREATE TEMPORARY TABLE tempHotelRateAvailability(AuditTrailId
varchar(36),UserId bigint(20),ActionType
enum('INSERT','UPDATE','DELETE'),TableName
did u check if data is getting inserted into tempHotelRateAvailability
On Wed, May 29, 2013 at 7:21 PM, Neil Tompkins neil.tompk...@googlemail.com
wrote:
This is my Trigger which doesn't seem to work; but doesn't cause a error
DROP TEMPORARY TABLE IF EXISTS tempHotelRateAvailability;
I took the following lines of code slightly modified and it returned some
data using a normal Query Editor
CREATE TEMPORARY TABLE tempHotelRateAvailability(AuditTrailId
varchar(36),UserId bigint(20),ActionType varchar(36),TableName
varchar(36),RowKey varchar(255),FieldName varchar(36),OldValue
But, does it work inside the trigger. If not, then based on the logic,
there will not be any data, and data goes not get inserted from temp table
to innodb table
On Wed, May 29, 2013 at 7:29 PM, Neil Tompkins neil.tompk...@googlemail.com
wrote:
I took the following lines of code slightly
OK, the data is going into the temp table. But when I run the
command INSERT INTO AuditTrail SELECT tempHotelRateAvailability.* FROM
tempHotelRateAvailability; from the TRIGGER it does not copy the data.
However if I run this query INSERT INTO AuditTrail SELECT
tempHotelRateAvailability.* FROM
2013/05/29 14:51 +0100, Neil Tompkins
This is my Trigger which doesn't seem to work; but doesn't cause a error
DROP TEMPORARY TABLE IF EXISTS tempHotelRateAvailability;
CREATE TEMPORARY TABLE tempHotelRateAvailability(AuditTrailId
varchar(36),UserId bigint(20),ActionType
Hi List
I have a table with a primary key with type binary(16) and a few columns.
I'd trying to create a view that looks up all rows with a particular key,
i.e. something like
CREATE OR REPLACE VIEW foo AS
SELECT *
FROM mytable
WHERE id = X'36a461c81cab40169791f49ad65a3728';
I use the
WHERE id = UNHEX('36a461c81cab40169791f49ad65a3728')
-Original Message-
From: Martin Koch [mailto:m...@issuu.com]
Sent: Tuesday, April 30, 2013 8:18 AM
To: mysql@lists.mysql.com
Subject: Long integer constant problem in views
Hi List
I have a table with a primary key
2013/04/30 17:17 +0200, Martin Koch
CREATE OR REPLACE VIEW foo AS
SELECT *
FROM mytable
WHERE id = X'36a461c81cab40169791f49ad65a3728';
Try this: _binary X'36a461c81cab40169791f49ad65a3728'
SHOW CREATE VIEW is the command for the client.
--
MySQL General Mailing List
For list
use DBI;
my $dbh = DBI-connect( DBI:mysql:rushload;192.168.0.1, $usrr, $passw, {
RaiseError = 3 } );
my $dbs = $dbh-selectcol_arrayref(show databases);
#my $dsn = dbi:mysql:information_schema:192.168.0.1:3306;
#my $dbh = DBI-connect($dsn, $usrr, $passw);
my $dbs = $dbh-selectcol_arrayref('show
I did a GRANT REPLICATION SLAVE ON *.* TO 'user'@'192.168.0.23' IDENTIFIED
BY 'psswd';
on the master. Doesn't *.* mean everything? Why would it just show me to
databases?
2013/4/2 Larry Martell larry.mart...@gmail.com
On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina gatorre...@gmail.com
On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina gatorre...@gmail.com wrote:
use DBI;
my $dbh = DBI-connect( DBI:mysql:rushload;192.168.0.1, $usrr, $passw, {
RaiseError = 3 } );
my $dbs = $dbh-selectcol_arrayref(show databases);
#my $dsn = dbi:mysql:information_schema:192.168.0.1:3306;
#my
Nope. That's just granting replication privileges so it can read updates
on all tables on all databases. It cannot select anything.
Why are you trying to connect with a replication slave user?
On 4/2/13 1:47 PM, Richard Reina gatorre...@gmail.com wrote:
I did a GRANT REPLICATION SLAVE ON
- Original Message -
From: ZhangFangXue zhangfang...@sogou-inc.com
well, the problem is that I used it like this:
prep_stmt = con - prepareStatement (INSERT INTO City (CityNumber)
The statement in your original mail used CityName, which sounds like it should
be a string. Fieldname
- Original Message -
From: ZhangFangXue zhangfang...@sogou-inc.com
Hi, when I use PreparedStatement in c++ connector, I find some
unexcepted error,
Well, first of all, you don't actually say what the error is that you're
seeing. This tends to be on the rather helpful side when
well, the problem is that I used it like this:
prep_stmt = con - prepareStatement (INSERT INTO City (CityNumber) VALUES
(?));
prep_stmt - setInt (1, 23); //this statement didn’t act normally!!!
then when I execute the statement, the result does not appear to be correct, as
CityNumber is not 23
: mysql@lists.mysql.com
主题: Re: 答复: PreparedStatement problem
- Original Message -
From: ZhangFangXue zhangfang...@sogou-inc.com
well, the problem is that I used it like this:
prep_stmt = con - prepareStatement (INSERT INTO City (CityNumber)
The statement in your original mail used
You can do:
SELECT last_name, first_name, phone, if(pub_email=Y,email,) as email
FROM `mydatabasetable` WHERE `current_member` = Y AND `pub_name` = Y
ORDER BY last_name ASC
Gracias, Carlos. This worked fine!
---Fritz
--
MySQL General Mailing List
For list archives:
De-lurking here.
I am trying to figure out how to return results from a query. What I need to do
is to return 4 columns from a database. This is easy:
SELECT last_name, first_name, phone, email FROM `mydatabasetable` WHERE
`current_member` = Y AND `pub_name` = Y ORDER BY last_name ASC
This
the if(,,)-statement of mysql or by using a union and two selects,
one for pub_email=n and the other for the rest.
Gesendet: Dienstag, 05. Februar 2013 um 15:49 Uhr
Von: cl c...@nimbleeye.com
An: mysql@lists.mysql.com
Betreff: SELECT subquery problem
De-lurking here.
I am trying to figure out
. Februar 2013 um 15:49 Uhr
Von: cl c...@nimbleeye.com
An: mysql@lists.mysql.com
Betreff: SELECT subquery problem
De-lurking here.
I am trying to figure out how to return results from a query. What I need to do
is to return 4 columns from a database. This is easy:
SELECT last_name, first_name, phone
Hi All.
I use:
# rpm -qa | grep -i percona-server-server
Percona-Server-server-55-5.5.28-rel29.3.388.rhel6.x86_64
My system:
# uname -a;cat /etc/redhat-release
Linux prbc01.mg.local 2.6.32-279.19.1.el6.centos.plus.x86_64 #1 SMP
Wed Dec 19 06:20:23 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
Red
Do not try to dump or reload information_schema. It is derived meta
information, not real tables.
-Original Message-
From: Rafał Radecki [mailto:radecki.ra...@gmail.com]
Sent: Monday, February 04, 2013 12:17 AM
To: mysql@lists.mysql.com
Subject: Mysqldump routines dump, problem
1 - 100 of 8646 matches
Mail list logo