Olivier-Wilson; mysql@lists.mysql.com
Subject: RE: MySQL Error#: 2002
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
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
Subject: MySQL Error#: 2002
Ignore that ... it's amazing how you can solve problems with enough
caffeine and enough time away from a computer screen .
On 9/20/2010 10:58 PM, Tim Thorburn wrote:
Hello,
A few days ago I ran into Error 1045 when attempting to add a new
database user to my development machine. The error
Hi,
On 21-9-2010 5:25, Tim Thorburn wrote:
Ignore that ... it's amazing how you can solve problems with enough
caffeine and enough time away from a computer screen .
It's also amazing how frustrating it is for those who are searching for
the problem you mentioned to only find threads with
Hi!
Machiel Richards wrote:
[[...]]
We received an error on a MySQL database this morning which
caused it to be unavailable for connections.
Error:
ERROR 1135 (0): Can't create a new thread (errno 11); if
you are not out of
of the amount of
connections though.
Machiel Richards
MySQL DBA
Relational Database Consulting
-Original Message-
From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com]
Sent: 30 June 2010 10:53 AM
To: mysql@lists.mysql.com
Cc: Machiel Richards
Subject: Re: Mysql error causing database
Note that some of the memory settings are per connection, if you have
63 connections, you may have up to 63 copies of the buffers, and you
have pretty huge buffers even with 30GB of memory. Join buffers close to
1 G, tmp_table_size of 2 G, 63 connections could mean upto 63 copies of
these,
@lists.mysql.com
Subject: Re: Mysql error causing database to not accept threads
Note that some of the memory settings are per connection, if you have
63 connections, you may have up to 63 copies of the buffers, and you
have pretty huge buffers even with 30GB of memory. Join buffers close to
1 G
If you do not want to use InnoDB at all, add this line to /etc/my.cnf under the
[mysqld] section
skip_innodb
Then do the following
service mysql stop
rm -f /var/lib/mysql/ibdata1 /var/lib/mysql/ib_logfile[01]
service mysql start
This will totally and cleanly disable InnoDB on the DB server
Per Jessen wrote:
It happened agaIn this morning, but slightly different:
[snip]
thd=0x7fe0140c7e00
Attempting backtrace. You can use the following information to find
out where mysqld died. If you see no messages after this, something
went terribly wrong...
Cannot determine thread,
Per Jessen wrote:
I have just discovered that my mysql server was restarted this
morning, which is what gave me the 2013. In the log I found this:
[snip]
It happened agaIn this morning, but slightly different:
[snip]
thd=0x7fe0140c7e00
Attempting backtrace. You can use the following
Per Jessen wrote:
This weekend we completed migrating a large(ish) mysql server from
5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively
smoothly, until this morning when I noticed an application had choked
on getting Error 2013 Lost connection to MySQL server during query.
I
Michael Dykman wrote:
It might be helpful if you could tell us how you affected your data
migration
Sorry, I'm not familiar with reporting problems in/on mysql.
The data migration was done with a full database dump (mysqldump) from
the 32bit system, then a reload on the new 64bit system.
just a thought: Did you run mysql_upgrade after the import?
On Mon, May 25, 2009 at 10:19 AM, Per Jessen p...@computer.org wrote:
Michael Dykman wrote:
It might be helpful if you could tell us how you affected your data
migration
Sorry, I'm not familiar with reporting problems in/on mysql.
Michael Steinfeld wrote:
just a thought: Did you run mysql_upgrade after the import?
No, I didn't - I didn't think of it as I really only moved the data
across.
best regards
Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Per Jessen wrote:
Michael Steinfeld wrote:
just a thought: Did you run mysql_upgrade after the import?
No, I didn't - I didn't think of it as I really only moved the data
across.
Okay, have done a mysqlcheck --check-upgrade - came back all clean. I
don't see a need to run
Have you tried running the offending SQL manually against you new
installation? Does it come back clean in the isolated case? Is there
anything else which runs against this database at night? crons?
Could you post the script that you are running to give some context to
the statement which winds
On Mon, May 25, 2009 at 11:19 AM, Per Jessen p...@computer.org wrote:
Per Jessen wrote:
Michael Steinfeld wrote:
just a thought: Did you run mysql_upgrade after the import?
No, I didn't - I didn't think of it as I really only moved the data
across.
I suspect that will solve your issue.
Michael Dykman wrote:
Have you tried running the offending SQL manually against you new
installation? Does it come back clean in the isolated case?
No, not manually, but the job/the SQL is run several times a day, maybe
2-3 times per hour.
Is there anything else which runs against this
Per Jessen wrote:
Michael Dykman wrote:
Have you tried running the offending SQL manually against you new
installation? Does it come back clean in the isolated case?
No, not manually, but the job/the SQL is run several times a day,
maybe 2-3 times per hour.
I've also just run the query
Given the new hardware, I'm now suspecting the RAID controller. I have
seen misconfigured RAIDs or bad RAID drivers take out a server in just
such a manner. I had a debian server connected to an EMC SAN.. As
debian isn't supported, we had this open-source driver which gave us
no end of problems.
Michael Dykman wrote:
Given the new hardware, I'm now suspecting the RAID controller. I have
seen misconfigured RAIDs or bad RAID drivers take out a server in just
such a manner. I had a debian server connected to an EMC SAN.. As
debian isn't supported, we had this open-source driver which
The issues that we saw only came to light under stress. The
application I am referring to ran under a fair bit of load at the best
of times but it was during sustained spikes that the flaws in our
driver made themselves apparent.
Mind you, we weren't using JFS, so I'm not sure how that would
Hi Per,
Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf
file. Are these queries appearing in your slow query logs?What is your
LOG_QUERY_TIMES set too?
Here are some other settings you may want to play around wtih
CONNECT_TIMEOUT
INTERACTIVE_TIMEOUT
WAIT_TIMEOUT
Darryle Steplight wrote:
Hi Per,
Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf
file. Are these queries appearing in your slow query logs?What is your
LOG_QUERY_TIMES set too?
Here are some other settings you may want to play around wtih
CONNECT_TIMEOUT
Hi Andrew,
I think he means re-install MySQL and provide a root password (you
said when you originally installed it that you didn't give it a
password.)
After you've done this, try mysql from the command-line explicitly
telling it to use the user root:
mysql --user=root --password
The
Alternatively you can try this if the box is unix/linux :
sudo mysqld_safe --skip-grant-tables --user=root
mysql -u root
Change your root password
Restart mysql after this.
Cheers
Sharad
Andy Shellam wrote:
Hi Andrew,
I think he means re-install MySQL and provide a root password
FYI,
I don't think this was sent to the list, forgive me if it was and I
didn't see it.
Andy
--
You probably don't have to reinstall it. If you never gave root a
password, just login as Andy says below and, when prompted for the
password, just press the ENTER key. Unless you gave root a
If you are desperate, you can also start mysqld with --skip-grant-tables
option.
Then use mysql, update root password using the update statement that Jim
wrote about.
-Paul
On Mon, 2008-08-18 at 17:25 +0100, Andy Shellam wrote:
FYI,
I don't think this was sent to the list, forgive me if it
Hi Andrew
As per your Question , you can test with the below solution :-
Try to reconfigure MySQL by providing the root password and then
try to run the
administer GUI. This should solve the problem.
CHAVA
On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL
How does one done this?
At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote:
Hi Andrew
As per your Question , you can test with the below solution :-
Try to reconfigure MySQL by providing the root password and then
try to run the
administer GUI. This should solve the problem.
Have you had any errors in the last 2 weeks? Have you restarted your
server in the last 2 weeks? Your problem might just be a symptom of
no problem at all.
- michael
On 8/20/07, Brown, Charles [EMAIL PROTECTED] wrote:
Hello all.
I noticed that the last entry in mysql error log was two
A common issue a lot of people have is this
rm logfile
if the mysql server is still accessing that file it will not continue to
write to that file again till mysql is restarted
if that was the case the proper way to clear a log and keep the server
running is
cp /dev/null logfile
On 8/20/07,
very wisely taken topic mysql error. ...
Ananda Kumar schrieb:
[...]
I cleared some old bin-logs and when i restart mysql using mysqld_safe
[...]
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock /data/mysql/ibdata1, error: 11
InnoDB: Check that you do not already have
Hi Sebastian,
I did not remove any ibdata files. They are present.
regards
anandkl
On 6/21/07, Sebastian Mendel [EMAIL PROTECTED] wrote:
very wisely taken topic mysql error. ...
Ananda Kumar schrieb:
[...]
I cleared some old bin-logs and when i restart mysql using mysqld_safe
[...]
max_allowed_packet is the maximum size of a single SQL statement.
It's a setting on the server, as well as for the mysql command line
interface.
See http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
I think 1 MB is the default; the maximum setting for MySQL 5 is 1 GB.
You can adjust
When a query exceeds the size of the maximum allowed packet, mysqld closes
the connection. It assumes something has gone wrong with the client. There
are two max_allowed_packet variables, one for the server and one for the
client. This is documented in section A.2.9 of the documentation
the (incorrect) socket?
Thank you.
Regards,
Rich
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 12, 2006 6:00 PM
To: mysql@lists.mysql.com
Subject: Re: MySql Error Number 1130
When you are trying to connect to port 3307, for example
Duzenbury, Rich wrote:
Wow, I found the problem! I think this may be a bug.
In my case, I've got three instances running on ports 3306, 3307, and
3320. On the local machine, I connect to them via
mysql -p --port-3306 --host=localhost
mysql -p --port-3307 --host=localhost
mysql -p
localhost means socket.
Hmm, I don't believe it does. localhost is a DNS shortcut to the IP
address of the local machine.
If that is how mysql wants to treat things, then it should issue an
error message on connect because --host=localhost and --port=anything
would then be mutually
Duzenbury, Rich wrote:
localhost means socket.
Hmm, I don't believe it does. localhost is a DNS shortcut to the IP
address of the local machine.
If that is how mysql wants to treat things, then it should issue an
error message on connect because --host=localhost and --port=anything
would
-Original Message-
From: Barry [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 13, 2006 9:41 AM
To: mysql@lists.mysql.com
Subject: Re: MySql Error Number 1130
Duzenbury, Rich wrote:
localhost means socket.
Hmm, I don't believe it does. localhost is a DNS shortcut
--- Duzenbury, Rich [EMAIL PROTECTED] wrote:
-Original Message-
From: Barry [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 13, 2006 9:41 AM
To: mysql@lists.mysql.com
Subject: Re: MySql Error Number 1130
Duzenbury, Rich wrote:
localhost means socket
Interesting. I have never heard of that option.
LX09:/home/rduz/backup # mysql -p -h. --port=3307
Enter password:
ERROR 2005 (HY000): Unknown MySQL server host '.' (1)
Perhaps it no longer functions?
Thanks.
Regards,
Rich
--
MySQL General Mailing List
For list archives:
When you are trying to connect to port 3307, for
example, are you specifying that port from your remote
machine? Or are you connecting to the mysqld listening on
port 3306?
You could try shutting down the server listening on port
3306, and then connecting to port 3307. See if the error
john simms wrote:
Hello MySQL!
Hello User!
At last! It has taken a couple of days - but, I have, at last, found you.
*hides* haha, you think so ...
You have invaded my computer without being requested, or invited.
Did i? Man, my schedules are really weird nowadays.
Whenever I try to
Hello.
MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE)
and (utf8_general_ci,IMPLICIT) for operation 'UNION' -- again
Check the character set of fields in you tables with
'SHOW CREATE TABLE' statement. I recommend you to test if
the problem remains in 4.1.14
From: S.Yousaf Shah [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: MySql error...
Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT)
Hi,
I have installed mysql on my system using tar file. But when i start mysql
it generates following error and shuts down.
Plz help me
Hi,
Have a look in the error file which is in mysql/data and called hostname.err
to have more information on why it is shutting down.
With that info you usually can find more help on the mysql website.
Good luck!
From: S.Yousaf Shah [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To:
@lists.mysql.com
Subject: RE: MySql error...
Hi,
Have a look in the error file which is in mysql/data and called hostname.err
to have more information on why it is shutting down.
With that info you usually can find more help on the mysql website.
Good luck!
From: S.Yousaf Shah [EMAIL PROTECTED]
Reply
list_php'; [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: RE: MySql error...
Hi,
I don't have an answer for you yet - but I encountered exactly the
same
situation with one of my systems last weekend. Unfortunately, the
error
file
sheds no light at all on the situation. In my case
-Original Message-
From: Kevin Cowley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 9:12 AM
To: mysql@lists.mysql.com
Subject: RE: MySql error...
If you're starting the process as a non-system user then the var
directory and anything under it should be owned/writable by that user
:[EMAIL PROTECTED]
Sent: 08 March 2005 17:40
To: Kevin Cowley; mysql@lists.mysql.com
Subject: RE: MySql error...
True. I forgot to mention, when doing the normal install from the tar,
the
files/databases for mysql and test both refused to create, although I
see
no
error message indicating
:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 9:12 AM
To: mysql@lists.mysql.com
Subject: RE: MySql error...
If you're starting the process as a non-system user then the var
directory and anything under it should be owned/writable by that user.
If you're starting it as root then the var
/Principal
intechgra
Database System Specialists
mailto:[EMAIL PROTECTED]
www.intechgra.com
-Original Message-
From: mel list_php [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 8:10 AM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: RE: MySql error...
Hi,
Have a look
Under UNIX/linux use syslog, for me /var/log/messages shows login/auth error
Mar 6 05:39:11 orion pdns[1865]: gmysql Connection failed: Unable to
connect to database: Access denied for user 'root'@'localhost' (using
password: NO)
Now for dropped sockets/connections you need to enable logging
You have mysql 4.1.8, but your php was built with the library for an earlier
version, which, as the error message says, doesn't support the new, more
secure authentication protocol. Your choices are to tell mysql to use the
older, less-secure protocol, or build a copy of php using your current
I am still new to the PHP scene could you tell me how I rebuild the
PHP with the client library...
On Mon, 07 Feb 2005 12:20:26 -0500, Michael Stassen
[EMAIL PROTECTED] wrote:
You have mysql 4.1.8, but your php was built with the library for an earlier
version, which, as the error message
I don't know much about the windows side of things so these are the only
resources I could find.
From the http://www.phpadmin.net site FAQ
[1.17a] I cannot connect to the MySQL server. It always returns the
error message, Client does not support authentication protocol
requested by server;
On Thursday 20 January 2005 13:47, Shahzad, Saleem might have typed:
Hi,
I am using egroupware and in the calendar on a specific day and event I
click on the link but MySQL gives me the following error
Database error: Invalid SQL: SELECT * FROM phpgw_links WHERE (link_app1 =
'calendar'
Database error: Invalid SQL: SELECT * FROM phpgw_links WHERE (link_app1 =
'calendar' AND link_id1 = '5') OR (link_app2 = 'calendar' AND link_id2 =
'5') ORDER BY link_lastmod DESC
mysql Error: 1146 (Table 'egroupware.phpgw_links' doesn't exist)
That would indicate to me 2 possibilities:
1)
Hello.
Such errors often occurs when you already have installed MySQL service.
freshm4n [EMAIL PROTECTED] wrote:
I got a mysql-4.1.8-win.zip,when installed,i got a error:Cannot create
Windows service for MySQL.Error:0~~How to solve?thanks~~ :) sorry for
my poor english~~
--
For
So I am guessing this is not a bug, and that I will have to modify the script myself?
-Original Message-
From: Luc Foisy
Sent: Monday, April 12, 2004 4:34 PM
To: Michael Stassen; MYSQL-List (E-mail)
Subject: RE: mysql error file
Michael wrote:
mm... Have you looked in /etc/rc.d/init.d
I changed mysql_safe to mysqld_safe and it is still sending the error output to
$HOSTNAME.err
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 07, 2004 11:17 AM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: Re: mysql error file
At 10:10 -0400 4/7/04
)
Subject: RE: mysql error file
I changed mysql_safe to mysqld_safe and it is still sending the error output to
$HOSTNAME.err
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 07, 2004 11:17 AM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: Re: mysql error
14712 pts/0S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/usr/data/mysql
--user=mysql --pid-file=/usr/data/mysql/mysql.pid
-Original Message-
From: Luc Foisy
Sent: Monday, April 12, 2004 9:12 AM
To: Paul DuBois; MYSQL-List (E-mail)
Subject: RE: mysql error file
I changed
Actually, that didn't change anything. Still writing to $HOSTNAME.err
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Monday, April 12, 2004 12:03 PM
To: Luc Foisy
Cc: Paul DuBois; MYSQL-List (E-mail)
Subject: Re: mysql error file
Note (see ps output) that you
, April 12, 2004 12:03 PM
To: Luc Foisy
Cc: Paul DuBois; MYSQL-List (E-mail)
Subject: Re: mysql error file
Note (see ps output) that you are using safe_mysqld, rather than
mysqld_safe, as you have mysql 3.23.58. Hence, you need to change
[mysqld_safe] to [safe_mysqld] in your my.cnf. See
http
Michael wrote:
mm... Have you looked in /etc/rc.d/init.d/mysql to see what, exactly, it
oes when you tell it to start?
Michael
I briefly looked in there. This is the same script it uses to start MySQL, and was
installed with the rpm of MySQL.
I would think it should come with all available
At 10:10 -0400 4/7/04, Luc Foisy wrote:
I have the following in my /etc/my.cnf
[mysqld]
datadir=/usr/data/mysql
pid-file=/usr/data/mysql/mysql.pid
socket=/usr/data/mysql/mysql.sock
user=mysql
[mysql_safe]
log-error=/usr/data/mysql/mysql.err
[client]
socket=/usr/data/mysql/mysql.sock
I tried
; [EMAIL PROTECTED]
Subject: Re: mysql error grant tables, help
Hi!
try to look at your my.cnf you haven't config it correctly!
At 05:54 p.m. 12/03/2004, Chris Sanchez wrote:
get this when i run scripts
-Original Message-
From: Victor Medina [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 13, 2004 10:37 AM
To: Chris Sanchez; [EMAIL PROTECTED]
Subject: Re: mysql error grant tables, help
Hi!
try to look at your my.cnf you haven't config it correctly!
At 05:54 p.m. 12/03/2004, Chris Sanchez
Hi!
try to look at your my.cnf you haven't config it correctly!
At 05:54 p.m. 12/03/2004, Chris Sanchez wrote:
get this when i run scripts/mysql_install_db. also tried mysqld --skip-grant
and got the same thing. how do i fix?
mysql-standard-4.0.18-sun-solaris2.8-sparc binary on SunOS ipdev1 5.8
Are you able to start the MySQL server? Is there anything being logged to
the hostname.err log?
Original Message
On 2/3/04, 7:23:50 PM, vincent.gueu [EMAIL PROTECTED] wrote
regarding Mysql error message:
I've installed mysql under Linux and what I do, I always have this
number of error
From: vincent.gueu [mailto:[EMAIL PROTECTED]
I've installed mysql under Linux and what I do, I always have this
number of error message :040204.
Please I need your help!
Thank u
I have no idea what your problem is, but I'd be amused if you had the number 040205
tomorrow (those being
Don,
the InnoDB text below is only a help message, not an error, and is not
dangerous. It is not associated with the timeout problems you have on
Fedora.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup -
Alex E.Wintermann [EMAIL PROTECTED] wrote:
MySQL 4.1.0-alpha-max-nt
phpMyAdmin 2.5.4
/* BEGIN DUMP */
CREATE TABLE `sp_tovar_vid` (
`id` int(11) NOT NULL auto_increment,
`id_tovar_vid` int(11) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`description` varchar(255)
Several possibilites:
1) Your password for user 'master2' is wrong;
2) master2 doesn't have the proper GRANT rights to do what you want;
3) master2 doesn't exist.
Check the mySQL manual.
Joshua Thomas
Network Operations Engineer
PowerOne Media, Inc.
tel: 518-687-6143
[EMAIL PROTECTED]
---
In
Thanks Josh,
I wish that were the case.. I am already inside phpMyAdmin and I can
manually edit and add new records. However when I try to add records
from a file I keep getting the same error.
If the user master2 did nto exist or have the required GRANT rights,
then I wud not have been
If the user master2 did nto exist or have the required GRANT rights,
then I wud not have been able to get into the database itslef in the first
place. Thanks again though. Any ideas ?
If you read the GRANT section of the mySQL manual
(http://www.mysql.com/doc/en/GRANT.html) you'll see that you
vikas kamble [EMAIL PROTECTED] wrote:
I Install R.H. 9.0 one dedicate pc but when i going restart mysql service or
access database it's given me
following error.
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
Please guide me what
I use a CPanel Shared hosting environment where MySQL user is not permitted
with FILE privilege. Please help me by telling what is the alternate
process to LOAD DATA from a text data file to MySQL table.
Thanks in advance
--
MySQL General Mailing List
For list archives:
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I use a CPanel Shared hosting environment where MySQL user is not permitted
with FILE privilege. Please help me by telling what is the alternate
process to LOAD DATA from a text data file to MySQL table.
You can use LOAD DATA LOCAL. In this case
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I am currently using MySQL 4.0.14-standard along with PHP 4.3.2 in Apache
1.3.28.
I have written following code to upload some data from the hosting
directory to database table. But LOAD DATA statement always fails. I have
checked the same SQL
I have managed to successfully run the following MySQL statement directly on the
server hoasting MySQL:
insert tblMealCounts set ProgramCode = '140', yymmdd = '030725', MealCode = '2',
MealCount = '11';
And, I can view the table afterwards and see the record ok. when I run it from an
On Friday 25 July 2003 1:05 pm, Kenneth Illingsworth wrote:
I cannot seem to find this in the MYSQL Reference. Are there other places I
should check?
It's a syntax error. A quick Google
(http://www.google.com/search?q=mysql+error+1064) would have found it for
you.
The message text in my
I streamlined the application so as to target the offending object more precisely for
testing purposes. And, now the error is 1602 with no text. I am currently still
looking for any error references.
Once again, thanks in advance for your time.
Kenneth Illingsworth [EMAIL PROTECTED] 07/25/03
I found the following by performing a google search:
1602 Btree unpacked page size (from header) does not match size loaded from disk
Not sure what this means, but still looking for a better error reference. The link
found in the google search was:
I found a syntax error which caused the 1602 error and corrected it. I am now back to
struggling with the '1064 - You have...' error. Unfortunately, I have been unable to
find any reference to this particular error.
---BeginMessage---
I streamlined the application so as to target the offending
I have managed to successfully run the following MySQL statement directly on the
server hoasting MySQL:
insert tblMealCounts set ProgramCode = '140', yymmdd = '030725', MealCode = '2',
MealCount = '11';
And, I can view the table afterwards and see the record ok. when I run it from an
# [EMAIL PROTECTED] / 2003-06-18 12:24:06 -0400:
[psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe
[5] 703
[psg:/usr/local/mysql] psgarcha% Starting mysqld daemon with databases
from /usr/local/mysql/data
030618 11:50:09 mysqld ended
[5]Done sudo
Create a symlink for mysqld.sock in /tmp.
ln -s /path/to/your/mysql.sock /tmp
This should resolve the problem in over 90% of the
cases.
once this is fixed it is likely that you have other
problems. but we'll discuss them when we get there ;-)
--- Mike [EMAIL PROTECTED] wrote:
Hi
Dhanashri,
ALTER TABLE `timesheet` ADD `phase_desc` VARCHAR( 50 )
Error on rename of '.\etime\timesheet.MYI' to
'.\etime\#sql2-64c-19.MYI'
(Errcode: 13)
I had the same kind of problem with ALTER TABLE and MySQL 4.0.5 under
Win2K. Errorcode 13 means it's a permission problem. I never solved
The error that you have is normally that MySQL in not running.
If it is running then MySQL client can not find the sock file.
I should not think you will have to reinstall.
Simon
-Original Message-
From: Daniel Florian [mailto:[EMAIL PROTECTED]]
Sent: 15 January 2003 13:11
To: [EMAIL
Clive Grigg wrote:
Hi.
I am new to this and can't get started because I receive the error message:
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061).
o/s : WindowsXP.
Any ideas?
Thanks,
Clive.
Hi,
I don't use MySQL on Windows so I can't really help you;
however,
At 13:15 +0300 10/11/02, Victoria Reznichenko wrote:
Abhi,
Thursday, October 10, 2002, 8:30:43 PM, you wrote:
A I am not able to connect mysql server after executing this command
A ./safe_mysqld -O key_buffer=64M -O table_cache=256 -O
A sort_buffer=4M -O read_buffer_size=1M
The
Abhi,
Thursday, October 10, 2002, 8:30:43 PM, you wrote:
A I am not able to connect mysql server after executing this command
A ./safe_mysqld -O key_buffer=64M -O table_cache=256 -O
A sort_buffer=4M -O read_buffer_size=1M
A [repository@shoggoth bin]$ ./mysql -u root
A ERROR 2002:
]; [EMAIL PROTECTED]
Sent: Thursday, September 26, 2002 12:28 AM
Subject: Re: Mysql Error
if I remember right, there is a php-mysql*rpm package for redhat which
corrects this problem.
Thomas
On Wed, 25 Sep 2002 23:23:07 +1000 Peter Goggin
[EMAIL PROTECTED] wrote:
The php is as installed
Hello,
Your Apache is OK, but you've got a PHP version that's not configured with the
--with-mysql option. You need to recompile PHP if you've installed from the
source.
Regards,
Iikka
On Wed, 25 Sep 2002, Peter Goggin wrote:
I have got apache and mysql running on my linux server. When
PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, September 25, 2002 10:30 PM
Subject: Re: Mysql Error
Hello,
Your Apache is OK, but you've got a PHP version that's not configured with
the
--with-mysql option. You need to recompile PHP if you've installed from the
source.
Regards,
Iikka
On Wed
1 - 100 of 147 matches
Mail list logo