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
.
*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
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...
>
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
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.
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
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
> 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
, 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
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
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
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
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
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
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
- 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
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 ;)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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
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
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
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*
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
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
.* 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
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
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:
- 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
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
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
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
| 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
/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
- 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
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
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
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 - 100 of 6326 matches
Mail list logo