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 *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 wrote: Good day guys, I

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

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

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

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 again

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

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 t

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&#x

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 database? See the do

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 De

Re: Mystery error in GRANT statement

[sma-v4-01]> GRANT ALL ON 'sma-v4-01'.* TO > 'xxxx'@'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 &

Re: Mystery error in GRANT statement

efault 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 'xxxx'@'sma-station14l' IDENTIFIED BY 'xx'; ERROR 1064 (42

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

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

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

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 anothe

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_incre

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 BEFOR

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

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 neede

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

Re: INTO OUTFILE ERROR...

Check permission of user 'teal1dwd_teal' DK Sent from Phone > On 19-Sep-2014, at 8:13 pm, Don Wieland 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).

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

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 Thanks

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 

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 data

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'

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

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

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 tha

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

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 s

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 IF

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

Re: Getting error while launching mysqld

Hello Somnath, On 9/4/2014 3:33 AM, Banerjee, Somnath wrote: 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

Re: Getting error while launching mysqld

, Somnath : > 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

Re: 1045 Error accessing mysql db

t; Mobile: +55.31.8654.9510 >> E-mail: m...@wagnerbianchi.com >> Twitter: @wagnerbianchijr >> >> >> 2014-09-04 11:05 GMT-03:00 Divesh Kamra : >> >> > check weather there any space in localhost >> > 'localhost >> > ' >>

Re: 1045 Error accessing mysql db

at 6:53 AM, Augori wrote: > > > 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 'f

Re: 1045 Error accessing mysql db

y 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

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

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 hav

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

Re: sql syntax error

- Original Message - > From: "florent larose" > Subject: sql syntax error > > near ''membres2' WHERE > [...] > FROM 'espace_membre2'.'membres2' WHERE You were on the right path - mysql is wibbly about quotes. Either

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 that

Re: alter table modify syntax error

> 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

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"

Re: alter table modify syntax error

> > The syntax "sixth" is not a supported syntax. You should use the syntax > "AFTER " where you replace 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

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 tryi

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 synta

Re: alter table modify syntax error

--+--+-+-++ >> 7 rows in set (0.03 sec) >> >> I am trying to position the 'color' column after the 'model' column with >> the following command: >> >> mysql> alter table car_table modify column color af

Re: alter table modify syntax error

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

alter table modify syntax error

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 I'm just wondering

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 -

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 4 /usr/sbin/mysqld { 5#include 6#include 7#include 8#

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

t; > Huh, maybe the daemon doesn't 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

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

/tmp/make_year_model.csv' INTO TABLE vehicles.vehicles FIELDS 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: 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 wrote: > > Apparently this error is because MySQL can't read my home directory? Fair > enough, but I don't quit

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

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 wrote: Apparently this error is because MySQL can't read my home directory?

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

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

On Mon, Jun 23, 2014 at 10:52 AM, thufir 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:~$ &g

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 wi

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

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

g a number 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 colum

Re: mysql Access denied error

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 >

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

Re: mysql Access denied error

Am 05.05.2014 15:26, schrieb Johan De Meersman: > - Original Message - >> From: "Reindl Harald" >> >> 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 in

Re: mysql Access denied error

- Original Message - > From: "Reindl Harald" > > 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 second scenario, I

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 >> >: >>> >>> Am 05.05.2014 08:34, schrieb Manuel Arostegui: >>> >

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

Re: mysql Access denied error

using > host specific permissions > Good for you. I might be working somewhere bigger than that. Here is what I am talking about: mysql> grant all on hadooptest.* to 'hadoopuser'@'%' identified by '123456'; flush privileges; Query OK, 0 rows affected

Re: mysql Access denied error

Am 05.05.2014 10:19, schrieb Manuel Arostegui: > 2014-05-05 10:00 GMT+02:00 Reindl Harald >: > > 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 So

Re: mysql Access denied error

2014-05-05 10:00 GMT+02:00 Reindl Harald : > > > 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 "@

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 hos

Re: mysql Access denied error

2014-05-05 4:17 GMT+02:00 EdwardKing : > 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 follo

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)

%.corp.domain.in| testuser | *FJHHEU5746DDHDUDYDH66488 | +---++---+ and skip_networking is OFF *Mysql Version : 5.1.58-log* root@Serv1:~# mysql -utestuser -p@8AsnM0! -h $(hostname) ERROR 1045 (28000): Acces

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

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

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

2014/1/7 > 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 th

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

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_

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

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

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 rude

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

Re: InnoDB error 5

2013/11/21 Reindl Harald > > 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 1

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 can

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

at 9:46 AM, Manuel Arostegui wrote: > 2013/11/21 Reindl Harald > >> >> 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: >> > >> >

Re: InnoDB error 5

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

Re: ERROR : client option 'secure_auth' enabled

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

Re: ERROR : client option 'secure_auth' enabled

o shutdown the server, it throwing 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

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

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

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.

Re: error-log aging

of Windows' idiosyncracies - I hope the damn thing allows you to rename a file that's being held open by a program. If not, well... see above. <<<<<<<< No, as Reindl answered, but in 5.5.8 there is this: If you flush the logs using FLUSH LOGS or mysqladmin flush

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

ield10 varchar(100)) max_rows=1000 engine=ndbcluster partition by key(ycsb_key); I get this error: *ERROR 1005 (HY000): Can't create table 'user_database.user_table' (errno:

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

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 cas

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

  1   2   3   4   5   6   7   8   9   10   >