>>>> 2013/04/04 23:18 +0200, Reindl Harald >>>>
> 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
<<<&l
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
Assuming you copied and pasted the error, it looks like the host made a typo in
the config file:
'/var/lib/myswl/mysql.sock'
Should probably be mysql, not myswl.
-Original Message-
From: Rick James [mailto:rja...@yahoo-inc.com]
Sent: Monday, March 18, 2013 3:32 PM
T
r via
Dreamweaver, the error message is: MySQL Error#: 2002
Can't connect to local MySQL server through socket
'/var/lib/myswl/mysql.sock'(111).
I have one site that uses a different IP number that that site is ok. My static
sites, ie, no database inclusion, are ok.
Any ideas wh
Check directory permissions, and check out the 'answers' in here:
http://forums.mysql.com/read.php?10,284776,284936
> -Original Message-
> From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
> Sent: Monday, March 18, 2013 12:05 PM
> To: mysql@lists.mysql.com
servers running 5.1.66-
>> version. But i need to try Mysql 5.6 latest version.
>>
>> I configured a slave with Mysql 5.6.10 running but when i am trying start
>> slaves in 5.1 Master it shows me below error :
>>
>> *Last_IO_Error: Got fatal error 1236 from mast
unning 5.1.66-
> version. But i need to try Mysql 5.6 latest version.
>
> I configured a slave with Mysql 5.6.10 running but when i am trying start
> slaves in 5.1 Master it shows me below error :
>
> *Last_IO_Error: Got fatal error 1236 from master when reading data from
> binary
erted from binary to decimal and displayed to only two decimal places, but
the underlying values may be "!=".
> -Original Message-
> From: Trimurthy [mailto:trimur...@tulassi.com]
> Sent: Saturday, December 29, 2012 4:26 AM
> To: mysql@lists.mysql.com
> Subject:
Hi
To me it looks like quantity is being multiplied by the price and then added to
total.
Try something like this
SELECT total,(quantity*price) as QP from sales where total !=QP AND salesid=122
On 2012-12-29, at 7:25 AM, Trimurthy wrote:
> hi,
> i am working with mysql 5.1.36 and i wro
hi,
i am working with mysql 5.1.36 and i wrote the following query.
select total,quantity*price from sales where total != quantity*price and
salesid=122;
OUT PUT:
totalquatity*price
330.46 330.46
here quantity is 15.5 and price is 21.32
both the values and
- Original Message -
> From: "Néstor"
>
> I spoke to soon!!!
> Here is the error about 1.5 hours after replication has started.
> 121205 16:39:51 [ERROR] Slave: Error 'Duplicate entry '3468897'
> for
Yes, that's what yo
Yes that's correct.
it needs to be added on the slave side under [mysqld] section usually
close to the place where you define your replication settings (for
convenience only).
The reason why server failed to start difficult to guess without error log.
this will prevent all tables
> You don't have errors in your mysql.err log. Those are notes saying that
>> you started IO and SQL replication threads after you skipped an replication
>> error and run start slave command.
>>
>> I wouldn't run SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; command e
In regards to the second part of your email.
You don't have errors in your mysql.err log. Those are notes saying that
you started IO and SQL replication threads after you skipped an
replication error and run start slave command.
I wouldn't run SET GLOBAL SQL_SLAVE_SKIP_COUNTER =
I spoke to soon!!!
Here is the error about 1.5 hours after replication has started.
121205 16:39:51 [ERROR] Slave: Error 'Duplicate entry '3468897' for
key 1' on query. Default database: 'parallax'. Query: 'INSERT INTO watchdog
(uid, type, message,
,
Igor
On 06/12/12 21:59, Néstor wrote:
I spoke to soon!!!
Here is the error about 1.5 hours after replication has started.
121205 16:39:51 [ERROR] Slave: Error 'Duplicate entry '3468897' for
key 1' on query. Default database: 'parallax'. Query: 'INSERT INT
I was about to reply with a long message of all the steps I followed to
create replication but I did my steps about an hour ago and I have not
seen the replication fail so far.
BTW, I created my replication following the info on this web page:
http://crazytoon.com/2008/01/29/mysql-how-do-you-set-u
2012/11/30 Néstor
> I am trying to set up mysql replication on 2 systems but Once I get it
> going, I get the following an error 1062,
>
>
> I have re-installed the database on the slave also to see if this fixes the
> problem
> but after a few minutes I get the same er
- Original Message -
> From: "divesh kamra"
>
> slave-skip-errors=1062 ---> in my.cnf and restart mysql
Really? Just like that? Without even knowing what it does or what the problem
is?
If you have replication errors, this kind of stuff is only going to break it
further. "It e
Hi
first check this thought application end
or
There is another way
slave-skip-errors=1062 ---> in my.cnf and restart mysql
On Sat, Dec 1, 2012 at 4:30 AM, Reindl Harald wrote:
>
>
> Am 30.11.2012 23:52, schrieb Rick James:
> > Possible causes:
> > * Someone is writing to the Slave
>
Am 30.11.2012 23:52, schrieb Rick James:
> Possible causes:
> * Someone is writing to the Slave
that is why the option "read-only" exists for my.cnf
> * The Slave was not in synch with the Master.
> * Schemas are different between Master and Slave
should not happen if the slave is properly clo
CREATE TABLE (for a table that is in trouble)
> -Original Message-
> From: Néstor [mailto:rot...@gmail.com]
> Sent: Friday, November 30, 2012 1:24 PM
> To: mysql@lists.mysql.com
> Subject: MySQL Replication Error
>
> I am trying to set up mysql replication on 2 syst
I am trying to set up mysql replication on 2 systems but Once I get it
going, I get the following an error 1062,
which is a duplicate entry and my 'slave status' shows:
Slave_IO_Running: Yes
Slave_SQL_Running: No
And this is the error on my mysql.err file:
12113
_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
mysqldump: Got error: 1034: Incorrect key file for table 'table1'; try to
repair it when using LOCK TABLES
root@falcon:~#
I'm trying
On 11/19/2012 10:27 AM, walter harms wrote:
hi List,
i get occasionally the following error:
ERROR 2013 (HY000): Lost connection to MySQL server at 'sending authentication
information', system error: 32
$ perror 32
OS error code 32: Broken pipe
Just to start.
If you want help
mysql:mysql $datadir
I honestly cannot think of a scenario where the datadir should be
permissioned any other way.
On 2012-10-29 6:26 AM, "javad bakhshi" wrote:
Hi,
I get an Unknown database error when I am trying to connect to mysql using
C API.
I have created the database in mysql prom
Hi,
I get an Unknown database error when I am trying to connect to mysql using C
API.
I have created the database in mysql prompt as root:
CREATE DATABASE Lr0;
I am pretty sure that the problem is a ownership issue, because when I do
ls -l in my datadir I get:
[javad64@udbl64 data]$ ls -l
st one data node and was never
> successful.
>
> ndb_mgm -e "START BACKUP WAIT COMPLETED"
>
> Did anyone have this kind of error before? I tried searching on web but
> could not find a solution.
>
> Here is the error I received.
>
> Connected to Management Server at:
cluster is almost an
empty database, but backup is crashing at least one data node and was never
successful.
ndb_mgm -e "START BACKUP WAIT COMPLETED"
Did anyone have this kind of error before? I tried searching on web but
could not find a solution.
Here is the error I received.
Co
crashing at least one data node and was never
successful.
ndb_mgm -e "START BACKUP WAIT COMPLETED"
Did anyone have this kind of error before? I tried searching on web but
could not find a solution.
Here is the error I received.
Connected to Management Server at: localhost:1186
W
hi!
I am hoping someone has experienced this before or knows how we can resolve
this. I am running into an innodb assertion error (see below) and cannot
reproduce it. It has happened 3-4 times, MySQL crashes and sometimes
recovers and other times it is unable to recover (MySQL repeatedly
humm... I bet he have just run of space...
Some thing like tht...
On Tue, Oct 16, 2012 at 10:43 PM, Dehua Yang wrote:
> Hi
> There many reasons to lose connection to MySQL server.
> And what's more , the important thing is that you should provide the error
> code to us.
&
can let your application auto
> > repair this problem.
> > Just like this :
> > When your application catch this error information , run check table xxx.
>
> oh no, do not write useless code in the application
> for things the server is able to do
>
> my.cnf:
>
gt;
>> <mailto:rja...@yahoo-inc.com>>**> wrote:
>>
>> SELinux ?
>>
>> > -Original Message-
>> > From: Lixun Peng [mailto:pengli...@gmail.com
>>
is problem.
> Just like this :
> When your application catch this error information , run check table xxx.
oh no, do not write useless code in the application
for things the server is able to do
my.cnf:
myisam-recover = "FORCE"
signature.asc
Description: OpenPGP digital signature
MyISAM storage tables also have this kind of problem.
I have try serval solutions for this problem , but can't work very well.
If your application isn't very import , you can let your application auto
repair this problem.
Just like this :
When your application catch this error i
ent server from the web interface i get the below
> error . What can be the reason and how can i repair it ?
>
> Regards
>
>
> Mysql_error: Table ./x/y ' is marked as crashed and should be repaired
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mys
Looks like a MYISAM table... MYISAM is not a crash safe storage engine
and an instance crash could corrupt the tables. You should run CHECK
TABLE ; and REPAIR TABLE ; to repair this.
On 10/19/2012 11:52 AM, a bv wrote:
Hi on a log management server from the web interface i get the below
error
Hi on a log management server from the web interface i get the below
error . What can be the reason and how can i repair it ?
Regards
Mysql_error: Table ./x/y ' is marked as crashed and should be repaired
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
The reason this is significant is because we are speaking about INFILE
use. The server processes infile commands assuming the file is already
stored on the server. LOCAL INFILE tells mysql that file is local to the
mysql client and must be moved to the server before processing. I suspect
that thi
<mailto:pengli...@gmail.com <mailto:pengli...@gmail.com>>]
> Sent: Tuesday, October 16, 2012 9:03 PM
> To: kalin
> Cc: Michael Dykman; mysql@lists.mysql.com
<mailto:mysql@li
;mailto:rja...@yahoo-inc.com>> wrote:
>>
>> SELinux ?
>>
>> > -Original Message-
>> > From: Lixun Peng [mailto:pengli...@gmail.com
>> <mailto:pengli...@gmail.com>]
>> > Sent: Tuesday, October 16, 2012
alin
> Cc: Michael Dykman; mysql@lists.mysql.com
<mailto:mysql@lists.mysql.com>
> Subject: Re: error 13
>
> Hi,
>
> you can switch to mysql user "su - mysql", and then stat this
file.
> if you can&
gt;
>> > -Original Message-
>> > From: Lixun Peng [mailto:pengli...@gmail.com]
>> > Sent: Tuesday, October 16, 2012 9:03 PM
>> > To: kalin
>> > Cc: Michael Dykman; mysql@lists.mysql.com
>> > Subject: Re: error 13
>> >
>> >
> Cc: Michael Dykman; mysql@lists.mysql.com
> > Subject: Re: error 13
> >
> > Hi,
> >
> > you can switch to mysql user "su - mysql", and then stat this file.
> > if you can't access, mysql user have not permissions.
> >
> > On Wed, O
SELinux ?
> -Original Message-
> From: Lixun Peng [mailto:pengli...@gmail.com]
> Sent: Tuesday, October 16, 2012 9:03 PM
> To: kalin
> Cc: Michael Dykman; mysql@lists.mysql.com
> Subject: Re: error 13
>
> Hi,
>
> you can switch to mysql user "su - my
Hi,
you can switch to mysql user "su - mysql", and then stat this file.
if you can't access, mysql user have not permissions.
On Wed, Oct 17, 2012 at 11:49 AM, kalin wrote:
>
>
>
> On 10/16/12 10:49 PM, Michael Dykman wrote:
>
>> is your mysql client on the same host as the mysql server? if not
On 10/16/12 10:49 PM, Michael Dykman wrote:
is your mysql client on the same host as the mysql server? if not, google
the docs for 'local infile'
yes. my laptop.
On 2012-10-16 10:45 PM, "Lixun Peng" wrote:
Hi,
What's the dir permissions?
For example, if we have a file in /a/b/file,
when i do:
mysql> load data infile '/path/to/file' etc...
i get:
ERROR 13 (HY000): Can't get stat of '/path/to/file' (Errcode: 13)
ls -al /path/to/file
lists the file...
so why do i get errcode 13?!
i'm on os x.
thanks.
Hi
There many reasons to lose connection to MySQL server.
And what's more , the important thing is that you should provide the error
code to us.
If you got the error code , you can check it by perror X
Anymore detail information would be appreciate !
On Wed, Oct 17, 2012 at 10:32 A
is your mysql client on the same host as the mysql server? if not, google
the docs for 'local infile'
On 2012-10-16 10:45 PM, "Lixun Peng" wrote:
Hi,
What's the dir permissions?
For example, if we have a file in /a/b/file, dir a is 644, even though file
is 777, we can't access file, too.
On
Hi,
What query is running? Is web server and DB server in the same server? Have
something in error.log of MySQL?
On Wed, Oct 17, 2012 at 10:32 AM, ad...@canadianinvestors.com <
ad...@canadianinvestors.com> wrote:
> Hi,
>
> I run www.canadianinvestors.com and am getting thi
s root on the command line cleint. trying to load data infile
> '/path/to/file'
>
> file is owned by mysql and it has 777 permissions. the directory where the
> file is is also owned by mysql.
>
> when i do:
> mysql> load data infile '/path/to/file' e
Hi,
I run www.canadianinvestors.com and am getting this error message.
Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL
server during query in
/var/www/domains/x.canadianinvestors.com/docs/common/library/db_connect.inc
on line 15
Lost connection to MySQL server
ile '/path/to/file' etc...
i get:
ERROR 13 (HY000): Can't get stat of '/path/to/file' (Errcode: 13)
ls -al /path/to/file
lists the file...
so why do i get errcode 13?!
i'm on os x.
thanks...
--
MySQL General Mailing List
For list archives: http://lists.mysq
uebernehmen.
> Date: Sun, 23 Sep 2012 12:40:17 -0500
> Subject: Re: Mysql cluster installation error
> From: aast...@gmail.com
> To: mdyk...@gmail.com
> CC: mysql@lists.mysql.com
>
> Thanks!
> And how do i connect the cluster from the remote host.
> When i try to connect
If your remote host is not configured as a sql node to your cluster, you
don't need to just to import the schema. Run mysqldump on any client
machine specifying any of your configured sql nodes via -host=.
On 2012-09-23 1:40 PM, "Aastha" wrote:
Thanks!
And how do i connect the cluster from th
Thanks!
And how do i connect the cluster from the remote host.
When i try to connect one of the SQL node through remote host it says
access denied.
WHile the same is working fine from local host.
Kindly help.
Thanks!
On Sun, Sep 23, 2012 at 12:35 PM, Michael Dykman wrote:
> If all you need to tr
If all you need to transfer is schema, do it the same way you would any
other table type: use mysqldump with the - - no-data option.
On 2012-09-23 1:29 PM, "Aastha" wrote:
Thanks Nitin.
I specied the location of my.ini while starting the SQL node and it worked
fine.
I have anothe rquestion :
Ho
ts.mysql.com
> Sent: Sunday, September 23, 2012 7:51 AM
> Subject: Mysql cluster installation error
>
> Hello,
>
> I am trying to install MySQL cluster on three physical machines.
> Management Node on one machine.
> Data Node on two machines.
> SQL node on the same ma
uster installation error
Hello,
I am trying to install MySQL cluster on three physical machines.
Management Node on one machine.
Data Node on two machines.
SQL node on the same machine as Management Node.
Management node started
Data Nodes started
*SQL node started but not connected to Manag
error *
C:\mysql\bin>ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
-
[ndbd(NDB)] 2 node(s)
id=8@172.16.56.8 (mysql-5.5.25 ndb-7.2.7, Nodegroup: 0, Master)
id=9@172.16.56.9 (mysql-5.5.25 ndb-7.2.7, Nodegroup: 0)
[ndb_mgmd(
AM
To: 'Aastha'; mysql@lists.mysql.com
Subject: RE: Error starting data node
Unable to connect with connect string: nodeid=10,172.17.3.66:1186
There's a comma between 10 and 172 instead of a period.
-Original Message-
From: Aastha [mailto:aast...@gmail.com]
Sent: Tuesda
Unable to connect with connect string: nodeid=10,172.17.3.66:1186
There's a comma between 10 and 172 instead of a period.
-Original Message-
From: Aastha [mailto:aast...@gmail.com]
Sent: Tuesday, August 07, 2012 6:20 PM
To: mysql@lists.mysql.com
Subject: Error starting data node
Helo,
I am receiving error when trying to start the data node. The configuration
seems ok. Kindly help.
*C:\mysql\bin>ndbd*
*Unable to connect with connect string: nodeid=10,172.17.3.66:1186*
*Retrying every 5 seconds. Attempts left: 12 11 10 9 8 7 6 5 4 3 2 1,
failed.*
*2012-08-07 18:19
t
work.
Thanks again
On Tue, Jul 31, 2012 at 5:36 AM, Michael Widenius wrote:
>
> Hi!
>
> >>>>> "Fred" == Fred G writes:
>
> Fred> Thanks Dhaval. Putting the join condition before INTO outfile
> doesn't seem
> Fred> to work, either.
>
Hi!
>>>>> "Fred" == Fred G writes:
Fred> Thanks Dhaval. Putting the join condition before INTO outfile doesn't
seem
Fred> to work, either.
Fred> When I try to use the same outfile name 'test123.csv' I get Error Code:
Fred> 1086 File '
Thanks!
On Thu, Jul 26, 2012 at 12:05 AM, wrote:
> 2012/07/26 06:52 +0530, Dhaval Jaiswal
> SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ','
> ENCLOSED BY '"' LINES TERMINATED BY '\n'
>
> as above give your join condition before INTO OUTFILE.
>
> Right
2012/07/26 06:52 +0530, Dhaval Jaiswal
SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ','
ENCLOSED BY '"' LINES TERMINATED BY '\n'
as above give your join condition before INTO OUTFILE.
Right: MySQL server writes into some directory where it is, not where
Thanks Dhaval. Putting the join condition before INTO outfile doesn't seem
to work, either.
When I try to use the same outfile name 'test123.csv' I get Error Code:
1086 File 'test123.csv' already exists. But then when I try to find the
csv file on my computer, there i
mp_id;
>
> The query without exporting the file works fine, in about 12 sec/77 sec. I
> read online how to export MySQL queries into csv's, and I'm not sure what I
> am doing wrong. I keep getting the error:
> Error Code: 2013. Lost connection to MySQL server during query,
ery without exporting the file works fine, in about 12 sec/77 sec. I
read online how to export MySQL queries into csv's, and I'm not sure what I
am doing wrong. I keep getting the error:
Error Code: 2013. Lost connection to MySQL server during query, where the
duration/fetch values
Joey, you've over allocated the cache. MySQL is telling you that it has
corrected the allocation.
Check out the docs for the meaning behind the numbers.
On Mon, Jun 4, 2012 at 2:01 PM, Reindl Harald wrote:
>
>
> Am 04.06.2012 14:45, schrieb Joey L:
> > Can you explain this further ?
> > Sorry a
Am 04.06.2012 14:45, schrieb Joey L:
> Can you explain this further ?
> Sorry a little slow ?
>
>> table count * expected connections
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_table_cache
signature.asc
Description: OpenPGP digital signature
Can you explain this further ?
Sorry a little slow ?
> table count * expected connections
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Am 04.06.2012 14:39, schrieb Joey L:
> i am getting this wierd error in the mysql log:
> 120604 8:31:32 [Warning] option 'table_cache': unsigned value
> 536870912 adjusted to 524288
>
> I have 28G of ram in my server, can anyone tell me what this value
> should be s
i am getting this wierd error in the mysql log:
120604 8:31:32 [Warning] option 'table_cache': unsigned value
536870912 adjusted to 524288
I have 28G of ram in my server, can anyone tell me what this value
should be set to ?
what is the syntax - i have tried different syntax -- ge
; socket = /var/run/mysqld/mysqld.sock
> > > socket = /var/run/mysqld/mysqld.sock
> > > socket = /var/run/mysqld/mysqld.sock
> > >
> > > root@devel:~# /etc/init.d/mysql restart
> > > Stopping MySQL database server: mysqld.
> > > Sta
ld/mysqld.sock
> > socket = /var/run/mysqld/mysqld.sock
> > socket = /var/run/mysqld/mysqld.sock
> >
> > root@devel:~# /etc/init.d/mysql restart
> > Stopping MySQL database server: mysqld.
> > Starting MySQL database server: mysqld . . . . . . . . . . .
topping MySQL database server: mysqld.
> Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
> root@devel:~# mysql -u root -p
> Enter password:
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock'
Il 11/04/2012 10:51, Ganesh Kumar ha scritto:
Hi Guys,
I am using debian squeeze it's working good, I am trying to install
mysql-server. mysql-server installation successfully but didn't start
root@devel:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL databa
may be following will solve:
a. create file '/var/lib/mysql/mysql.sock' if not exist, i mean verify
path.
b. check permission of mysql dir, logfile and other files. /var/lib/mysql
c. check the error log it will show you more details about error..
2012/4/5 Peter Boros
> Hi,
>
Hi,
What are the parameters you are trying to change? What does the error
log say?
Peter
On Thu, 2012-04-05 at 14:40 +, Manivannan S. wrote:
>
> I am not facing the MySQL server problem during installation. I have
> installed those two rpm packages in my machine suc
]
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
I can't go with any other installable packages by keeping the same
package I have to solve this issue. Please give some ideas to resolve this
problem.
-
@lists.mysql.com
Subject: Re: Error in starting MySQL service on LINUX
boah do not top-post!
this was a typo - seems you did not understand my question WHY are you
downloading random binaries instead using packages from your linux distribution
which are tested and preconfigured?
Am 05.04.2012 12
Hi,
In 64-bit Linux(Centos/Red Hat) machine when I am trying to
start the MySQL service by using service mysql start command , I am getting the
following error
Ø Starting MySQL.Manager of pid-file quit without updating file [FAILED]
If I try to stop the MySQL service I am
Am 05.04.2012 12:27, schrieb Manivannan S.:
> Hi,
>
> In 64-bit Linux(Centos/Red Hat) machine when I am trying to
> start the MySQL service by using service mysql start command , I am getting
> the following error
>
>
> I have installed
>
>
boah do not top-post!
this was a typo - seems you did not understand my question
WHY are you downloading random binaries instead using
packages from your linux distribution which are tested
and preconfigured?
Am 05.04.2012 12:39, schrieb Manivannan S.:
> Hi,
>
> If I execute "service myqsl
Hi,
If I execute "service myqsld start" its saying
mysqld: unrecognized service
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Thursday, April 05, 2012 4:05 PM
To: mysql@lists.mysql.com
Subject: Re: Error in star
very is set to 6 !!!
120315 17:17:51 [Note] Event Scheduler: Loaded 0 events
120315 17:17:51 [Note] /usr/sbin/mysqld: ready for connections.
Version: '*5.1.61-0ubuntu0.10.04.1*' socket:
'/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
120315 17:17:52 [ERROR] Cannot
.04.1*' socket:
'/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
120315 17:17:52 [ERROR] Cannot find or open table ois/metadata from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgott
It sounds like InnoDB itself might have failed to start, but there is
not enough information to know for sure. Please check the server's
error log.
On Thu, Mar 15, 2012 at 2:01 AM, Adarsh Sharma wrote:
> Dear All,
>
> Is there any way to recover data or only schema of co
cos |
| categories |
| groups |
| metadata|
| page_content|
| projects|
| results |
| users |
| website_internalurl |
+-+
12 rows in set (0.00 sec)
mysql> show create table metadata;
ERROR 1146
gt; involved upgrading its database. After the upgrade, the following error
> started appearing:
>
> mysqldump: Got error: 1034: Incorrect key file for table 'notes'; try to
> repair it when using LOCK TABLES
>
>So i tried doing lock and repair:
>
> mysql&g
If you did not work directly on mysql server (login
by mysql command), please try this.
Using script (PHP, ...) may lose connection, as my experience.
Best
--- On Mon, 3/5/12, Singer X.J. Wang wrote:
> From: Singer X.J. Wang
> Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL
egards,
> Javad Bakhshi,
>
>
>
> From: "mail...@securitylabs.it"
> To: mysql@lists.mysql.com
> Sent: Thursday, March 1, 2012 11:09 AM
> Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during
> query
>
> Il 01/03/2012 11:03, javad bakhshi ha sc
, 2012 11:09 AM
Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during query
Il 01/03/2012 11:03, javad bakhshi ha scritto:
> Hi,
>
> I am trying to load data into my table from a very large file but after some
> time I get this error:
>
> ERROR 2013 (HY000)
Il 01/03/2012 11:03, javad bakhshi ha scritto:
Hi,
I am trying to load data into my table from a very large file but after some
time I get this error:
ERROR 2013 (HY000): Lost connection to MySQL server during query
My file size is around 4G and I have 220M lines in my file which have to be
Hi,
I am trying to load data into my table from a very large file but after some
time I get this error:
ERROR 2013 (HY000): Lost connection to MySQL server during query
My file size is around 4G and I have 220M lines in my file which have to be
loaded in to my table.
I have 10 of these
On 02/28/2012 03:34 PM, Shafi AHMED wrote:
pls assist
- please give more information (OS, ...)
- you can search the web with
-- "ulimit more memory"
-- "mysql you-os increase memory"
-- "mysql you-os increase memory ulimit"
-- "mysql configuration memory"
-- ...
--
RMA.
--
MySQL General Mail
101 - 200 of 6579 matches
Mail list logo