Re: MacOS Server 5 problem after upgrade

> 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

Re: MacOS Server 5 problem after upgrade

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

Re: MacOS Server 5 problem after upgrade

> 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 >> -

Re: MacOS Server 5 problem after upgrade

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

MacOS Server 5 problem after upgrade

- 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

compile problem with newest version of mysql-server

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

Re: innodb log sequence problem

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

innodb log sequence problem

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

Re: innodb log sequence problem

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

Re: password problem

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

Re: password problem

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

Re: password problem

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

Re: password problem

/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

Re: password problem

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

Re: password problem

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

Re: password problem

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

Re: password problem

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

Re: password problem

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

Re: password problem

. 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

Re: password problem

. 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

password problem

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

RE: installation problem of MySQL on OS Lion

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

installation problem of MySQL on OS Lion

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

Re: Replication problem

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

Re: Replication problem

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

Re: Replication problem

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;

Re: Replication problem

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

Re: Replication problem

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 +--+--+--+--+ |

Re: Replication problem

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

Re: Replication problem

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:

Re: Replication problem

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%'; +-+---+

Re: Replication problem -solved

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

Re: Replication problem -solved

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

Re: Replication problem -solved

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 problem

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

Re: Replication problem

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

Re: Replication problem

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

Re: Replication problem

: 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

Problem with INSERT INTO and UPDATE queries

​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: access problem for a particular table

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:

access problem for a particular table

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

Re: access problem for a particular table

- 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

Mysql into outfile problem

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

Re: Mysql into outfile problem

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

Re: Mysql into outfile problem

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

Re: Mysql into outfile problem

- 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

Re: Mysql into outfile problem

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

Re: Mysql into outfile problem

- 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

Re: Mysql into outfile problem

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

RE: Problem with having

- 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

Re: Problem with having

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

Re: Problem with having

.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

Re: Problem with having

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

Re: Problem with having

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

Problem with having

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

Re: Problem with having

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

Re: Problem with having

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

Re: Problem with having

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

Re: Problem with having

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

Re: Problem with having

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

restore problem

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

Re: restore problem

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

Re: restore problem

. 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

Re: restore problem

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

Re: restore problem

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

Re: InnoDB problem.

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

Re: InnoDB problem.

- 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

RE: InnoDB problem.

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

Re: InnoDB problem.

-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.

: 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

InnoDB problem.

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

Re: InnoDB problem.

- 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

Edit MySQL Trigger in Workbench problem

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

Fwd: character set problem

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

Re: character set problem

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

Temporary Tables with Triggers Problem

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

Re: Temporary Tables with Triggers Problem

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

Re: Temporary Tables with Triggers Problem

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

Re: Temporary Tables with Triggers Problem

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;

Re: Temporary Tables with Triggers Problem

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

Re: Temporary Tables with Triggers Problem

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

Re: Temporary Tables with Triggers Problem

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

Re: Temporary Tables with Triggers Problem

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

Long integer constant problem in views

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

RE: Long integer constant problem in views

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

Re: Long integer constant problem in views

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

Please Help. selectcol_arrayref problem

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

Re: Please Help. selectcol_arrayref problem

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

Re: Please Help. selectcol_arrayref problem

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

Re: Please Help. selectcol_arrayref problem

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

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 CityName, which sounds like it should be a string. Fieldname

Re: PreparedStatement problem

- 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

答复: PreparedStatement problem

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

答复: 答复: PreparedStatement problem

: 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

RE: SELECT subquery problem

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:

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, email FROM `mydatabasetable` WHERE `current_member` = Y AND `pub_name` = Y ORDER BY last_name ASC This

Re: SELECT subquery problem

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

Aw: SELECT subquery problem

. 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

Mysqldump routines dump, problem with lock tables.

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

RE: Mysqldump routines dump, problem with lock tables.

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   2   3   4   5   6   7   8   9   10   >