Procedure error handling Best Practice

Long time Oracle PL/SQL coder but new to MySQL. I have an error handler that looks like this ... declare continue handler for sqlexception begin get diagnostics condition 1 @p3 = returned_sqlstate, @p4 = message_text; set v_there_was_an_error_while_inserting_a_lead_summary := true

Re: Optimize fails due to duplicate rows error but no duplicates found

. *From:* shawn l.green <shawn.l.gr...@oracle.com> *Sent:* 13 February 2018 09:51:33 PM *To:* mysql@lists.mysql.com *Subject:* Re: Optimize fails due to duplicate rows error but no duplicates found Hello Machiel, On 2/13/2018 3:02 AM, Machiel Richards

Re: Optimize fails due to duplicate rows error but no duplicates found

mysql@lists.mysql.com Subject: Re: Optimize fails due to duplicate rows error but no duplicates found Hello Machiel, On 2/13/2018 3:02 AM, Machiel Richards wrote: > Good day guys, > > > I am hoping this mail finds you well. > > > I am at a bit of a loss here... >

Re: Optimize fails due to duplicate rows error but no duplicates found

ql.com Subject: Re: Optimize fails due to duplicate rows error but no duplicates found Hello Machiel, On 2/13/2018 3:02 AM, Machiel Richards wrote: > Good day guys, > > > I am hoping this mail finds you well. > > > I am at a bit of a loss here... > > > W

Re: Optimize fails due to duplicate rows error but no duplicates found

Hello Machiel, On 2/13/2018 3:02 AM, Machiel Richards wrote: Good day guys, I am hoping this mail finds you well. I am at a bit of a loss here... We are trying to run optimize against a table in order to reclaim disk space from archived data which has been removed.

Optimize fails due to duplicate rows error but no duplicates found

Good day guys, I am hoping this mail finds you well. I am at a bit of a loss here... We are trying to run optimize against a table in order to reclaim disk space from archived data which has been removed. However, after running for over an hour , the optimize fails stating

Error 1837

Hi, On a fresh new master-slave very simple setup with just a Magento 1.5 DB under MySQL 5.6.35, I'm getting this error with a memory table: 2017-05-03 07:08:37 1109 [Note] Slave I/O thread: connected to master 'replica@10.0.15.183:3306',replication started in log 'FIRST' at position 4 2017-05

Re: Mystery error in GRANT statement

> Date: Monday, October 03, 2016 23:18:14 -0700 > From: James Moe > > On 10/03/2016 08:16 PM, Richard wrote: >> If you want/need to use it I believe you need to use the >> "backtick" to quote the name >> > Yes, that worked. Thank you. > Is there an easy way to rename a

Re: Mystery error in GRANT statement

On 10/03/2016 08:16 PM, Richard wrote: > If > you want/need to use it I believe you need to use the "backtick" to > quote the name > Yes, that worked. Thank you. Is there an easy way to rename a database? -- James Moe moe dot james at sohnen-moe dot com 520.743.3936 Think. signature.asc

Re: Mystery error in GRANT statement

e name: > > MariaDB [sma-v4-01]> GRANT ALL ON 'sma-v4-01'.* TO > ''@'sma-station14l' IDENTIFIED BY 'xx'; > > ERROR 1064 (42000): You have an error in your SQL syntax; check the > manual that corresponds to your MariaDB server version for the right &g

Re: Mystery error in GRANT statement

use v42.1 linux 4.1.31-30-default x86_64 10.0.26-MariaDB I have a database named "sma-v4-01". The GRANT statement does not like that database name: MariaDB [sma-v4-01]> GRANT ALL ON 'sma-v4-01'.* TO ''@'sma-station14l' IDENTIFIED BY 'xx'; ERROR 1064 (42000): You have

Mystery error in GRANT statement

opensuse v42.1 linux 4.1.31-30-default x86_64 10.0.26-MariaDB I have a database named "sma-v4-01". The GRANT statement does not like that database name: MariaDB [sma-v4-01]> GRANT ALL ON 'sma-v4-01'.* TO ''@'sma-station14l' IDENTIFIED BY 'xx'; ERROR 1064 (420

Mystery error in GRANT statement

opensuse v42.1 linux 4.1.31-30-default x86_64 10.0.26-MariaDB I have a database named "sma-v4-01". The GRANT statement does not like that database name: MariaDB [sma-v4-01]> GRANT ALL ON 'sma-v4-01'.* TO ''@'sma-station14l' IDENTIFIED BY 'xx'; ERROR 1064 (420

... ERROR! The server quit without updating PID file

for a while but then aborted with the message “... ERROR! The server quit without updating PID file” As I understand it, the start and stop operations for MySQL server on the Mac changed between Yosemite and El Capitan. So it seems plausible to me that the server shut down according to one

Re: Workbench MySQL Enterprise Backup Error

The beauty of running enterprise versions is that you have support from Oracle. I would gently point you in their direction if not to get what you paid for but also because most of us in this list are unequipped to help you because we don't use the software you have problems with. Good luck On 22

Workbench MySQL Enterprise Backup Error

Hello all, I have not run across this problem where Workbench will not let me access the "Online Backup" link and claims that my version of MySQL Enterprise Backup is 0.0.0 (it is 4.0.0). I had backups running and scheduled through Workbench previously. Yesterday I changed my data files to

Re: Renaming a table that has a trigger, then attempting to drop that trigger results in 'table doesn't exist' error.

Hello Michael, On 1/6/2016 12:51 PM, Michael Vaughan wrote: If you execute the script below, you will get the following error: 'Error Code: 1146. Table 'testschema.TestRenamed' doesn't exist" delimiter // CREATE TABLE Test( id int not null primary key auto_increment, name varcha

Renaming a table that has a trigger, then attempting to drop that trigger results in 'table doesn't exist' error.

If you execute the script below, you will get the following error: 'Error Code: 1146. Table 'testschema.TestRenamed' doesn't exist" delimiter // CREATE TABLE Test( id int not null primary key auto_increment, name varchar(255) )// CREATE TRIGGER TEST_TRIGGER BEFORE INSERT ON Test FOR

MySQL error to syslog

HI, I am running MySQL 5.5.31 on FreeBSD 9.2. I have a web server with a miss-configured service that generates faulty connections. After a while, MySQl blocks any connection from the web server. At some stage, I had set-up a script that would browse syslog log and look for a string like Host

Re: INTO OUTFILE ERROR...

On 9/19/2014 10:59 AM, Don Wieland wrote: On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote: the target folder don't matter that is clearly a *MySQL error* that your *MYSQL user* lack the needed permissions Yes i figured that - so the question is, how do I give full permissions to that user

Re: INTO OUTFILE ERROR...

Am 22.09.2014 um 12:44 schrieb william drescher: On 9/19/2014 10:59 AM, Don Wieland wrote: On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote: the target folder don't matter that is clearly a *MySQL error* that your *MYSQL user* lack the needed permissions Yes i figured that - so

Re: INTO OUTFILE ERROR...

Check permission of user 'teal1dwd_teal' DK Sent from Phone On 19-Sep-2014, at 8:13 pm, Don Wieland d...@pointmade.net wrote: Hi gang, Trying to generate a CSV file using mySQL and I keep getting this error below. The target folder has full permissions to write (777). I am

INTO OUTFILE ERROR...

Hi gang, Trying to generate a CSV file using mySQL and I keep getting this error below. The target folder has full permissions to write (777). I am not certain why this is happening. Any answers? Thanks! Database_Class error: DATABASE_ERROR: Access denied for user 'teal1dwd_teal'@'localhost

Re: INTO OUTFILE ERROR...

Am 19.09.2014 um 16:43 schrieb Don Wieland: Trying to generate a CSV file using mySQL and I keep getting this error below. The target folder has full permissions to write (777). I am not certain why this is happening. Any answers? Thanks! the target folder don't matter that is clearly

Re: INTO OUTFILE ERROR...

On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote: the target folder don't matter that is clearly a *MySQL error* that your *MYSQL user* lack the needed permissions Yes i figured that - so the question is, how do I give full permissions to that user? I did go to my cPanel and delete

Re: INTO OUTFILE ERROR...

Am 19.09.2014 um 16:59 schrieb Don Wieland: On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote: the target folder don't matter that is clearly a *MySQL error* that your *MYSQL user* lack the needed permissions Yes i figured that - so the question is, how do I give full permissions

Re: INTO OUTFILE ERROR...

Thanks Reindl, Yes I stubbled upon this page last night. I try running that query: grant all privileges on teal1dwd_teal.* to 'teal1dwd_teal'@'localhost' identified by 'my_user_pw'; I get this error: #1044 - Access denied for user 'teal1dwd'@'localhost' to database 'teal1dwd_teal

Re: INTO OUTFILE ERROR...

Hi there, Le 19/09/2014 17:19, Don Wieland a écrit : grant all privileges on teal1dwd_teal.* to 'teal1dwd_teal'@'localhost' identified by 'my_user_pw'; I get this error: #1044 - Access denied for user 'teal1dwd'@'localhost' to database 'teal1dwd_teal' I think you are trying

Re: INTO OUTFILE ERROR...

Le 19/09/2014 18:00, Christophe a écrit : Hi there, Le 19/09/2014 17:19, Don Wieland a écrit : grant all privileges on teal1dwd_teal.* to 'teal1dwd_teal'@'localhost' identified by 'my_user_pw'; I get this error: #1044 - Access denied for user 'teal1dwd'@'localhost' to database

Re: INTO OUTFILE ERROR...

On Sep 19, 2014, at 9:11 AM, Christophe wrote: Don't you have root access to MySQL instance ? I guess not, I am using a managed server VPSLatch. I chatted with them and they are going to GRANT the permissions I need…at least that is what the tech said. I waiting with baited breath ;oP

Re: INTO OUTFILE ERROR...

Maybe you need to grant access from localhost to the user? On Fri, September 19, 2014 16:59, Don Wieland wrote: On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote: the target folder don't matter that is clearly a *MySQL error* that your *MYSQL user* lack the needed permissions Yes i figured

ERROR in syntax...

Can anyone tell me why this query is generating an ERROR: DROP TRIGGER rtsadven_development.content_assets_after_insert_subtypes; CREATE TRIGGER `rtsadven_development`.`content_assets_after_insert_subtypes` AFTER INSERT ON `rtsadven_development`.`content_assets` FOR EACH ROW BEGIN

Re: ERROR in syntax...

2014/09/06 09:06 -0700, Don Wieland Can anyone tell me why this query is generating an ERROR: Which error? The first IF statement is not properly ended? it isn't. (A series of equality tests against the same variable is done more conveniently with CASE ... END CASE.) -- MySQL General

Re: 1045 Error accessing mysql db

system change (CentOS 5 to CentOS 6), my Python script could no longer connect with mysql database. I get the following error... mysql_exceptions.OperationalError: (1045, Access denied for user 'foo'@ 'localhost ' (using password: YES)) I have granted all on all databases

Re: Getting error while launching mysqld

, Somnath somnath_baner...@mentor.com: Hi, We are getting following error while launching mysqld_safe in local machine. Any help would be appreciated. -- connect to address 127.0.0.1 port 544: Connection refused connect to address 127.0.0.1 port

RE: Getting error while launching mysqld

Thanks a lot. I changed rsh to ssh and things worked ! -somnath From: shawn l.green [shawn.l.gr...@oracle.com] Sent: Friday, September 05, 2014 8:21 PM To: mysql@lists.mysql.com Subject: Re: Getting error while launching mysqld Hello Somnath, On 9/4/2014

Getting error while launching mysqld

Hi, We are getting following error while launching mysqld_safe in local machine. Any help would be appreciated. -- connect to address 127.0.0.1 port 544: Connection refused connect to address 127.0.0.1 port 544: Connection refused trying

Re: 1045 Error accessing mysql db

no longer connect with mysql database. I get the following error... mysql_exceptions.OperationalError: (1045, Access denied for user 'foo'@ 'localhost ' (using password: YES)) I have granted all on all databases to this user. I attempted to run mysql_upgrade. I am stymied because

Re: 1045 Error accessing mysql db

an operating system change (CentOS 5 to CentOS 6), my Python script could no longer connect with mysql database. I get the following error... mysql_exceptions.OperationalError: (1045, Access denied for user 'foo'@ 'localhost ' (using password: YES)) I have granted all on all databases

1045 Error accessing mysql db

After an operating system change (CentOS 5 to CentOS 6), my Python script could no longer connect with mysql database. I get the following error... mysql_exceptions.OperationalError: (1045, Access denied for user 'foo'@ 'localhost ' (using password: YES)) I have granted all on all databases

sql syntax error

hello, i am working on my personal website wih php 5.4.16 / mysql 5.6.12 (my system : windows 7 / wampserver 2). i have a bug when i am running my connection to database webpage. My error message is the following : Erreur SQL : You have an error in your SQL syntax; check the manual

Re: sql syntax error

- Original Message - From: florent larose florent.lar...@hotmail.com Subject: sql syntax error near ''membres2' WHERE [...] FROM 'espace_membre2'.'membres2' WHERE You were on the right path - mysql is wibbly about quotes. Either remove the quotes entirely ( espace_membre2

Re: sql syntax error

Hi, Le 08/08/2014 17:48, Johan De Meersman a écrit : As your code is french, I'll assume you're on Azerty; the backtick is Alt-Gr plus the rightmost key (right next to return) on the middle row. Enjoy spraining your fingers :-p /johan Alt-GR plus '7' for French keyboard layout ;)

alter table modify syntax error

model; And I'm getting the following error: 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 'after model' at line 1 I'm just wondering what I'm doing wrong here, because the syntax looks correct

Re: alter table modify syntax error

car_table modify column color after model; And I'm getting the following error: 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 'after model' at line 1 Try: alter table car_table modify

Re: alter table modify syntax error

with the following command: mysql alter table car_table modify column color after model; And I'm getting the following error: 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 'after model' at line 1

Re: alter table modify syntax error

Hey guys, Sorry to hit you with one more. But I'm trying to use a positional statement in a column move based on what you all just taught me: mysql alter table modify column color varchar(10) sixth; But I am getting this error: ERROR 1064 (42000): You have an error in your SQL syntax; check

RE: alter table modify syntax error

Hi Tim, -Original Message- From: Tim Dunphy [mailto:bluethu...@gmail.com] Sent: Sunday, 29 June 2014 03:45 Cc: mysql@lists.mysql.com Subject: Re: alter table modify syntax error Hey guys, Sorry to hit you with one more. But I'm trying to use a positional statement in a column

Re: alter table modify syntax error

The syntax sixth is not a supported syntax. You should use the syntax AFTER column_name where you replace column_name with the column name you want to position the modified column after. Oh thanks. That's actually what I ended up doing after I got frustrated with that error. I was following

RE: alter table modify syntax error

Hi Tim, -Original Message- From: Tim Dunphy [mailto:bluethu...@gmail.com] Sent: Sunday, 29 June 2014 10:09 To: Jesper Wisborg Krogh Cc: mysql@lists.mysql.com Subject: Re: alter table modify syntax error The syntax sixth is not a supported syntax. You should use the syntax

Re: alter table modify syntax error

Wisborg Krogh Cc: mysql@lists.mysql.com Subject: Re: alter table modify syntax error The syntax sixth is not a supported syntax. You should use the syntax AFTER column_name where you replace column_name with the column name you want to position the modified column after. Oh

Re: error 29, file not found (errcode: 13)

I followed the manpage for mysqlimport: thufir@dur:~$ thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test ERROR 1045 (28000): Access denied for user 'thufir'@'localhost' (using password: NO) thufir@dur:~$ thufir@dur:~$ thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT

Re: error 29, file not found (errcode: 13)

have access to /tmp?... ERROR 29 (HY000): File '/tmp/make_year_model.csv' not found (Errcode: 13) then file not found is bullshit these days computers can distinguish between not exist and no permissions and should reflect that in the messages they give to humans signature.asc Description

Re: error 29, file not found (errcode: 13)

I think it's apparmor: thufir@dur:/tmp$ thufir@dur:/tmp$ nl /etc/apparmor.d/usr.sbin.mysqld 1 # vim:syntax=apparmor 2 # Last Modified: Tue Jun 19 17:37:30 2007 3 #include tunables/global 4 /usr/sbin/mysqld { 5#include abstractions/base 6#include

error 29, file not found (errcode: 13)

Apparently this error is because MySQL can't read my home directory? Fair enough, but I don't quite follow. Where would be a good location for the CSV file, then? thufir@dur:~$ thufir@dur:~$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g

Re: error 29, file not found (errcode: 13)

On Mon, Jun 23, 2014 at 10:52 AM, thufir hawat.thu...@gmail.com wrote: Apparently this error is because MySQL can't read my home directory? Fair enough, but I don't quite follow. Where would be a good location for the CSV file, then? thufir@dur:~$ thufir

Re: error 29, file not found (errcode: 13)

Often, one uses /tmp or set up an appropriately premoissioned folder under /var On Mon, Jun 23, 2014 at 10:52 AM, thufir hawat.thu...@gmail.com wrote: Apparently this error is because MySQL can't read my home directory? Fair enough, but I don't quite follow. Where would be a good location

Re: error 29, file not found (errcode: 13)

to read. Scott Helms Vice President of Technology ZCorum (678) 507-5000 http://twitter.com/kscotthelms On Mon, Jun 23, 2014 at 10:52 AM, thufir hawat.thu...@gmail.com wrote: Apparently this error is because MySQL can't read my

Re: error 29, file not found (errcode: 13)

Sol :- Change file owner to mysql.mysql OR Change folder and file mode to 777 DK Sent from Phone On 23-Jun-2014, at 8:22 pm, thufir hawat.thu...@gmail.com wrote: Apparently this error is because MySQL can't read my home directory? Fair enough, but I don't quite

Re: error 29, file not found (errcode: 13)

TERMINATED BY ',' LINES TERMINATED BY '\n'; ERROR 29 (HY000): File '/tmp/make_year_model.csv' not found (Errcode: 13) mysql mysql quit Bye thufir@dur:/tmp$ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL UUID_SHORT() gives error Out of range value for column

2014/06/20 11:31 +0100, Neil Tompkins I'm using MySQL 5.6.17 on Amazon Web Services RDS and when calling SELECT UUID_SHORT() I'm getting a number bigger than 9223372036854775807. For example the number I get is 12057145185130250250 help uuid_short Name: 'UUID_SHORT' Description: Syntax:

MySQL UUID_SHORT() gives error Out of range value for column

12057145185130250250 I get the error MySQL 22003 'MySQL 22003 Out of range value for column '' at row 1' If I run SELECT UUID_SHORT() on our test server which is MySQL 5.6.11 (running on Windows 2008 64x) the result is as follows; 23526798209843216 I changed the column I'm trying to save my number

Re: mysql Access denied error

the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. My operation is follows: [hadoop@master ~]$ mysql -h localhost -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.5.37-log

Re: mysql Access denied error

2014-05-05 4:17 GMT+02:00 EdwardKing zhan...@neusoft.com: I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. My operation is follows

Re: mysql Access denied error

Am 05.05.2014 08:34, schrieb Manuel Arostegui: % doesn't match localhost so if you don't specify it you will be attempting to connect via Unix Socket. If you don't want to specify -hlocalhost all the time, just do the grant with @localhost instead of @% nonsense % matches *any host*

Re: mysql Access denied error

2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net: Am 05.05.2014 08:34, schrieb Manuel Arostegui: % doesn't match localhost so if you don't specify it you will be attempting to connect via Unix Socket. If you don't want to specify -hlocalhost all the time, just do the grant

Re: mysql Access denied error

Am 05.05.2014 10:19, schrieb Manuel Arostegui: 2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net: Am 05.05.2014 08:34, schrieb Manuel Arostegui: % doesn't match localhost so if you don't specify it you will be attempting to

Re: mysql Access denied error

.* to 'hadoopuser'@'%' identified by '123456'; flush privileges; Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) mysql # mysql -uhadoopuser -p123456 ERROR 1045 (28000): Access denied for user 'hadoopuser'@'localhost' (using password: YES) # mysql -uhadoopuser -p123456

Re: mysql Access denied error

Hi, On 5-5-2014 10:57, Reindl Harald wrote: Am 05.05.2014 10:19, schrieb Manuel Arostegui: 2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net: Am 05.05.2014 08:34, schrieb Manuel Arostegui: % doesn't match localhost so if you don't

Re: mysql Access denied error

Am 05.05.2014 11:12, schrieb Jigal van Hemert: On 5-5-2014 10:57, Reindl Harald wrote: Am 05.05.2014 10:19, schrieb Manuel Arostegui: 2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net: Am 05.05.2014 08:34, schrieb Manuel Arostegui:

Re: mysql Access denied error

- Original Message - From: Reindl Harald h.rei...@thelounge.net i know that, but it does not change the fact that here Either you didn't know that but have trouble admitting it; or you did but conciously chose to be rude and condescending instead of helpful. Your choice. In the

Re: mysql Access denied error

Am 05.05.2014 15:26, schrieb Johan De Meersman: - Original Message - From: Reindl Harald h.rei...@thelounge.net i know that, but it does not change the fact that here Either you didn't know that but have trouble admitting it; or you did but conciously chose to be rude and

Re: mysql Access denied error

On 2014-05-04 9:17 PM, EdwardKing wrote: I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. The command sequence ... mysql create

mysql Access denied error

I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. My operation is follows: [hadoop@master ~]$ mysql -h localhost -u root -p Enter

[5.1 Vs 5.5 ] ERROR 1045 (28000): Access denied for user 'testuser'@'Serv1.corp.domain.in' (using password: YES)

| testuser | *FJHHEU5746DDHDUDYDH66488 | +---++---+ and skip_networking is OFF *Mysql Version : 5.1.58-log* root@Serv1:~# mysql -utestuser -p@8AsnM0! -h $(hostname) ERROR 1045 (28000): Access denied for user

error - ould be looked up with ./bin/resolveip

hi I am facing the following : mac:mysql-5.6.16-linux-glibc2.5-x86_64 ericomtx$ sudo scripts/mysql_install_db --user=mysql sh: ./bin/my_print_defaults: cannot execute binary file FATAL ERROR: Neither host 'mac.local' nor 'localhost' could be looked up with ./bin/resolveip Please configure

Re: error - ould be looked up with ./bin/resolveip

Hi Érico, mac:mysql-5.6.16-linux-glibc2.5-x86_64 ericomtx$ sudo scripts/mysql_install_db --user=mysql sh: ./bin/my_print_defaults: cannot execute binary file FATAL ERROR: Neither host 'mac.local' nor 'localhost' could be looked up with ./bin/resolveip Please configure the 'hostname

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2014/1/7 h...@tbbs.net 2014/01/06 17:07 +0100, Reindl Harald what about look in the servers logfiles most likely max_allowed_packet laughable low Is this then, too, likly when the server and the client are the same machine? I left this out, that it only then happens when the client has

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2014/01/06 17:07 +0100, Reindl Harald what about look in the servers logfiles most likely max_allowed_packet laughable low Is this then, too, likly when the server and the client are the same machine? I left this out, that it only then happens when the client has been idle, and right

ERROR 2013 (HY000): Lost connection to MySQL server during query

Now that I installed 5.6.14 on our Vista machine, when using mysql I often see that error-message, which under 5.5.8 I never saw. What is going on? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

Am 06.01.2014 15:36, schrieb h...@tbbs.net: Now that I installed 5.6.14 on our Vista machine, when using mysql I often see that error-message, which under 5.5.8 I never saw. What is going on? what about look in the servers logfiles most likely max_allowed_packet laughable low

InnoDB error 5

Had a system crash this morning and I can't seem to get mysql back up and running. This is the error: InnoDB: Progress in percent: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58

Re: InnoDB error 5

2013/11/21 Reindl Harald h.rei...@thelounge.net Am 21.11.2013 13:51, schrieb Paul Halliday: Had a system crash this morning and I can't seem to get mysql back up and running. This is the error: InnoDB: Progress in percent: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Re: InnoDB error 5

at 9:46 AM, Manuel Arostegui man...@tuenti.com wrote: 2013/11/21 Reindl Harald h.rei...@thelounge.net Am 21.11.2013 13:51, schrieb Paul Halliday: Had a system crash this morning and I can't seem to get mysql back up and running. This is the error: InnoDB: Progress in percent: 1 2 3 4 5

Re: InnoDB error 5

What is the best way to backup your database. Which are the files that I need to store on a usb disk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: InnoDB error 5

Hello Nick, On 11/21/2013 10:32 AM, Nick Cameo wrote: OOoopppsss! I do mean for recovery/continual backup. I will do it manually, but basically get all the data on a USB disk and be able to recover/move it (the data) on another machine, the same machine etc.. I hope I did not just open up a

Re: InnoDB error 5

Am 21.11.2013 13:51, schrieb Paul Halliday: Had a system crash this morning and I can't seem to get mysql back up and running. This is the error: InnoDB: Progress in percent: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

Re: InnoDB error 5

OOoopppsss! I do mean for recovery/continual backup. I will do it manually, but basically get all the data on a USB disk and be able to recover/move it (the data) on another machine, the same machine etc.. I hope I did not just open up a can of worms. We just went live and this post gave me a

Re: InnoDB error 5

Am 21.11.2013 13:51, schrieb Paul Halliday: Had a system crash this morning and I can't seem to get mysql back up and running. This is the error: InnoDB: Progress in percent: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

ERROR : client option 'secure_auth' enabled

Hi guys, today i have installed mysql 5.6.13 tar binary distribution, on redhat5 machine. i have started the server with skip-secure-auth, server started successfully. when i am trying to shutdown the server, it throwing the following error, can any one please let me know why

Re: ERROR : client option 'secure_auth' enabled

the following error, can any one please let me know why it is happening. /mysql5613/bin/mysqladmin: connect to server at 'localhost' failed error: 'Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)' try a [mysqladmin] section in my.cnf

Re: ERROR : client option 'secure_auth' enabled

5.6.13 tar binary distribution, on redhat5 machine. i have started the server with skip-secure-auth, server started successfully. when i am trying to shutdown the server, it throwing the following error, can any one please let me know why it is happening. /mysql5613/bin/mysqladmin: connect

Why ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72' (111)?

hi all: I'm a new one. I have a mysql server in 192.168.27.72 , and a mysql client in 192.168.23.73. I use this way: mysql -h 192.168.27.72 -u root -p the ERROR message is: ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72' (111

Re: Why ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72' (111)?

Assuming Linux, check where it's listening using netstat -lptn. lx lxlenovos...@gmail.com wrote: hi all: I'm a new one. I have a mysql server in 192.168.27.72 , and a mysql client in 192.168.23.73. I use this way: mysql -h 192.168.27.72 -u root -p the ERROR message is: ERROR 2003 (HY000

ERROR 1005 (HY000): Can't create table 'user_database.user_table' (errno: 157)

this error: *ERROR 1005 (HY000): Can't create table 'user_database.user_table' (errno: 157)* Can you guys please help me in this . And when I ran *mysql show engines; *I get

Re: error-log aging

/MySQL/MySQL%20Server%205.5/HELP/programs.html#mysqladminmysqladmin flush-logs and file:///C:/Program%20Files/MySQL/MySQL%20Server%205.5/HELP/programs.html#mysqldmysqld is writing the error log to a file (for example, if it was started with the file:///C:/Program%20Files/MySQL/MySQL%20Server%205.5

Re: error-log aging

- Original Message - From: h...@tbbs.net Subject: Re: error-log aging man logrotate Not Unix! So get unix :-) In any case, I take this to mean that this is not done within MySQL, right? Half and half - rename the file, then issue flush logs in mysql to close and reopen

Re: error-log aging

Am 05.04.2013 11:16, schrieb Johan De Meersman: - Original Message - From: h...@tbbs.net Subject: Re: error-log aging man logrotate Not Unix! So get unix :-) In any case, I take this to mean that this is not done within MySQL, right? Half and half - rename the file

Re: error-log aging

Am 04.04.2013 23:08, schrieb h...@tbbs.net: Is there somewhere within MySQL means of aging the error log, that it not indefinitly grow big, or is that done through the OS and filesystem on which mysqld runs? man logrotate signature.asc Description: OpenPGP digital signature

error-log aging

Is there somewhere within MySQL means of aging the error log, that it not indefinitly grow big, or is that done through the OS and filesystem on which mysqld runs? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

  1   2   3   4   5   6   7   8   9   10   >