On 12/27/2011 12:13 PM, Mark Haney wrote:
I've had a DEVIL of a time with this problem and I'm sure it's something
simple, but I can't find it anywhere in the documentation or online what the
problem is. Let me explain.
I cannot get any WHILE loop to work from either a CLI or a script on MySQ
2011/12/27 18:13 +, Mark Haney
So, what the heck is going on here? I'm at the end of my wits.
I suspect that you have to make the block delimiter something other than
semicolon, and set the block in a routine or trigger.
Semicolon terminates SQL routine statements, after
Hi !
Jittinan Suwanrueangsri wrote:
Hi all
If you know how to fix these problems please tell me.
System details
1.OS=Linux localhost.localdomain 2.6.25-14.fc9.i686 #1 SMP Thu May 1
06:28:41 EDT 2008 i686 i686 i386 GNU/Linux
2.tar = tar (GNU tar) 1.19
3.gcc =gcc (GCC) 4.3.0 20080428 (Red Hat
Does the client loose the MySQL connection completely? Or is there just an error
in receiving the responding packet back?
Here is an idea:
You can do a ping to test the connection.
Fist ping the connection to verify you can send and receive on that connection.
Then send the SQL Command.
If you
John wrote:
I am getting this error when installing a db:
An error occurred while trying to build your MySQL
database tables. The errors were: 'Invalid default
value for 'AttachmentID'
Invalid default value for 'MapID'
Invalid default value for 'ServerSendID''. Click on
the "Try Again" button be
Ah, it was an orphaned table due to a bad shutdown. Thanks.
David
On Mar 18, 2006, at 12:50 AM, Heikki Tuuri wrote:
David,
- Original Message - From: "David Felio" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 16, 2006 11:31 PM
Subject: Errors 1005 and
David,
- Original Message -
From: "David Felio" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 16, 2006 11:31 PM
Subject: Errors 1005 and 1025 - but not foreign keys
I got an error 1025 trying to rename an InnoDB table. When I go to
look in the database
David:
Microsoft has a converter for Works files at
http://www.microsoft.com/downloads/details.aspx?FamilyID=b9e11e83-f51b-4977-b572-8c042df802c1&displaylang=en
I did'nt see any online documentation
HTH,
Martin
- Original Message -
From: "David Blomstrom" <[EMAIL PROTECTED]>
To: <[EMAIL PR
When I meant I deleted all the obvious files I meant I went to the
mysql folder and deleted the folder, plus the mySQL sock file in temp/
I then ran ps from the prompt which stated there was a process running.
What I really want to know is that are there files located anywhere
else that are part
At 21:43 + 11/22/03, Rob Snow wrote:
OK
Some development with the initial problem.
I have two OS X OS's running 10.2.6
My main one I installed the mySQL on and am having trouble with is
still not working.
As a test I installed mySQL on my second on and went through the
configuration straight
OK
Some development with the initial problem.
I have two OS X OS's running 10.2.6
My main one I installed the mySQL on and am having trouble with is
still not working.
As a test I installed mySQL on my second on and went through the
configuration straight after installation. Everything this time
Hi
With connection to my problem I ran the phpinfo.php, and found this
under the mysql section:
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.39
MYSQL_MODULE_TYPE builtin
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE
MYSQL_LIBS
Directive
Hi Rob,
My guess would be you did not see this in the Fine Manual
http://www.mysql.com/doc/en/Post-installation.html
or this
http://www.mysql.com/doc/en/Starting_server.html
Hope this helps,
Ken
- Original Message -
From: "Rob Snow" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thur
I installed all the stuff as root, so /home/mysql and beyond are root owner
and group. Should I have to change to mysql user and group?
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 09, 20
"Jose Rojas" <[EMAIL PROTECTED]> wrote:
>
> I have installed Mysql 2.23.56 in Linux (Cobalt), but when it is started shows the
> next messages in the ../var/*.err file:
>
> mysqld started
> /home/mysql/libexec/mysqld: File './dns1-bin.1' not found (Errcode: 13)
> 031008 15:18:16 Could not use
"Datatal AB - Gauffin, Jonas" <[EMAIL PROTECTED]> wrote:
>
> I often get these errormessages. Why?
If you often get table coruption, you can make a test case. Here you can find
instruction how to do it:
http://www.mysql.com/doc/en/Reproduceable_test_case.html
>
> * X clients is using o
Jonas,
Can you check the mysql.err log and see if anything has been written
their?
-Original Message-
From: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 7:36 AM
To: [EMAIL PROTECTED]
Subject: RE: errors
Im pretty sure that the server
uffin, Jonas; [EMAIL PROTECTED]
> Ämne: [iHateSpam] RE: errors
>
>
> Jonas,
> Are you getting these messages when you run a check tables?
> These errors can be caused when the database is not `cleanly`
> shutdown.
>
>
>
> -Original Message-
> From: Data
Jonas,
Are you getting these messages when you run a check tables? These errors can
be caused when the database is not `cleanly` shutdown.
-Original Message-
From: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 7:22 AM
To: [EMAIL PROTECTED]
Subjec
Rudolphe,
I saw your posting on the website:
[EMAIL PROTECTED] List Archive
at :
http://www.jsw4.net/info/list-archives/mysql/02-wk41/index.html#00206
We are experiencing the same sort of problem.
Did you ever get a response and/or solve this problem?
Cristl G. Weckenmann
Senior Software E
red fraggle wrote:
The file mysqlqui-win32-static-1.7.5-2.zip with file size of 37k
downloaded from http://www.mysql.com/downloads/gui-mysqlgui.html is
corrupt. Is there a mirror with a compiled windows xp compatible version
somewhere?
Pres. Cliff Murphy
Hyperactive Media Group
"Static is for th
Hi!
- Original Message -
From: "Yasaswi Pulavarti" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, March 03, 2003 7:19 PM
Subject: Re: Errors on ALTER table in InnoDB
> I don't know the answer. But I get similar errors when I use Erwin
> (
Beauford,
Saturday, November 09, 2002, 8:21:26 PM, you wrote:
B> MySQL must be the owner of the data dir. Check the owner of MySQL data
B> dir.
B> It was, but I have since changed it to root and it works fine now. Any
B> idea why this would be?
If you run MySQL server under mysql:mysql, it shoul
4096 Nov 9 05:39 var/
TIA
-Original Message-
From: Victoria Reznichenko [mailto:victoria.reznichenko@;ensita.net]
Sent: November 9, 2002 11:28 AM
To: [EMAIL PROTECTED]
Subject: re: Errors stating Mysql server
Beauford,
Saturday, November 09, 2002, 8:27:58 AM, you wrote:
B>
Beauford,
Saturday, November 09, 2002, 8:27:58 AM, you wrote:
B> I just reinstalled Slackware and now have the unenviable task of getting
B> Mysql working. What a major pain in the ***. Anyway, here are the
B> errors. I have read manuals, searched the web, as well as the
B> newsgroups, and still c
Philippe,
Friday, November 08, 2002, 10:51:14 AM, you wrote:
PD> I downloaded mysql and i try to install it now (on slackware)
PD> It's unpacked, i did everything as root.
PD> But ./configure ends with mysql ended and ./bin/mysqld & ends also because
PD> it can't write to a file (or more).
PD> No
;,'Y','Y','Y','
Y');
My RH is 7.2 - when I try to connect via telnet I get "Connection Closed by
Foreign Host"
When you say install "your binaries" are you talking about the one's I have
installed or are there some others.
Thanks
Kevin Passey wrote:
Hi Mark,
Thanks for your response, my problem is that I've done that. It works on a
windows machine running mysql, I've set my Linux machine up the same
and it
doesn't work.
The only difference is that I am running MSQL 3.23.51-nt on my windows
machine and the latest rpm's
on my Linux machine.
I thought there may be some known issues with these rpm's - that's why I
asked the question.
Thanks anyway.
Kevin
-Original Message-
From: Mark Matthews [mailto:mark@;mysql.com]
Sent: 30 October 2002 12:30
To: Kevin Passey
Cc: Mysql (E-mail)
Subject: Re: Err
Kevin Passey wrote:
Hi all
I have downloaded the latest rpms and added records to HOST,DB,and USER
files in the mysql database.
I am trying to access the database from a web page using a tomcat server
running on the same machine.
I get the following message : Server configuration denies access
Toby:
Wrong forum. Go to php.net and search around there.
Off the top of my head, my guess is the provider has a global include that sends
headers before your page gets a chance to do so. You could try creating a page
called woka-woka.php containing the following and see what it looks like:
Hi.
On Wed 2002-08-14 at 06:15:22 +, [EMAIL PROTECTED] wrote:
> hi guys
>
> this is a weired problem .
>
> my site s almost done and workin fine on my machine
>
> ive just uploaded it and it AINT worin on the host
> i confirmed php and mysql support
> ve made all the tables and everyth
Make sure mysql owns its database files and directories.
[EMAIL PROTECTED] wrote:
>>Description:
>>
> I was getting a read-only error on one of my many databases. So, I tried doing
>mysqladmin restart and now I'm getting "Can't find file: './Belzon/jobs.frm' (errno:
>13). I've tried look
jcapp,
Monday, May 13, 2002, 6:30:54 PM, you wrote:
j>Description:
j> I was getting a read-only error on one of my many databases. So, I tried
doing mysqladmin restart and now I'm getting "Can't find file: './Belzon/jobs.frm'
(errno: 13). I've tried looking
j> up this error online and t
Frederic Dhorne wanted to know
> How do I re-generate the catalog (errmsg.sys)?
Well, I had a similar question about the Japanese error messages. It seems
the tool mentioned in the manual was not in the binary distribution, and
wasn't in the MSWindows source distribution, either. I happened to
You probably either need to increase the ulimit on file descriptors for that
process, or increase the total number of file descriptors for the kernel.
> 020206 15:11:47 mysqld started
> /usr/pkg/libexec/mysqld: ready for connections
> 020207 1:02:00 Error in accept: Too many open files
Oops i was a bit hasty, this problem occurs after the mysql has been running
for a little while, kill the mysql and restart it and it can run just fine
again for a while.
Terkel
> -Original Message-
> From: Terkel Olsen
> Sent: 7. februar 2002 09:24
> To: '[EMAIL PROTECTED]'
>
You probably either need to increase the ulimit on file descriptors for that
process, or increase the total number of file descriptors for the kernel.
> 020206 15:11:47 mysqld started
> /usr/pkg/libexec/mysqld: ready for connections
> 020207 1:02:00 Error in accept: Too many open files
Oops i was a bit hasty, this problem occurs after the mysql has been running
for a little while, kill the mysql and restart it and it can run just fine
again for a while.
Terkel
> -Original Message-
> From: Terkel Olsen
> Sent: 7. februar 2002 09:24
> To: '[EMAIL PROTECTED]'
>
On Thu, 20 Dec 2001, Duncan Crawford wrote:
> We are having the following error when installing mysql on open unix 8.
> We are installing from the open unix 8 skunkware 8 cd
Please try the binary on www.mysql.com. You have to have the libraries
and linker installed. Also there are a few patches
15:06
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: errors 2006 and 2000
>
> create table saveMovie (
> -> id int not null auto_increment,
You attempted to create a table without telling MySQL which database to use
(or without creating a database in the first place). Eit
PROTECTED]
Subject: RE: errors 2006 and 2000
>
> create table saveMovie (
> -> id int not null auto_increment,
You attempted to create a table without telling MySQL which database to use
(or without creating a database in the first place). Either:
\u MyDatabaseName
>
> create table saveMovie (
> -> id int not null auto_increment,
You attempted to create a table without telling MySQL which database to use
(or without creating a database in the first place). Either:
\u MyDatabaseName
-OR-
create database MyDatabaseName;
\u MyDatabaseName;
before t
Anthony E. wrote:
> okay, I'm having problems here, probably something
> very simple I'm overlooking:
>
>
>
> ../configure --prefix=/usr/local/mysql
> --prefix=/usr/local \
> --localstatedir=/usr/local/mysql/data
> make
> make install
> mkdir /usr/local/mysql/data
> mkdir /usr/local/mysql/tm
On Tue, 3 Jul 2001 12:57, help wrote:
> I fixed the other errors, however I am still getting
> other errors. This database is tied into PHP. I want
> to be able to have an admin screen so I can make
> changes but it is not working for me. The errors I am
> getting on the Index page are :
>
> War
German and a bunch more.
Dig in a learn my friend
M ;-)
-Original Message-
From: Gary Huntress [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 02, 2001 9:26 PM
To: help; [EMAIL PROTECTED]
Subject: Re: Errors on Mysql page
1) I left my ESP in my other pants, so I can't really debug your
1) I left my ESP in my other pants, so I can't really debug your code.
2) Somebody will probably tell you that this isn't the appropriate group
for questions like this. You might try news://news.php.net or a site like
http://www.phpdeveloper.org or http://www.phpbuilder.com for tutorials.
R
Hi Richard,
In order for people to help you you will need to be more specific.
As specific as possible. Many of us here run FreeBSD and could help
you with more information. Possibly the problem is you are running
FreeBSD-current instead of FreeBSD-stable? Or FreeBSD 4.3? The
output from una
Sorry, it appears to be _not_ a bug in mysql 3.23.34 but a conflict with the
apache module mod_auth_mysql.
It's still weird since i only noticed after installing 3.23.34, and had no
problems herefore.
Downgrading to a earlier version however did not solve the problem!
My collegue installed the mo
49 matches
Mail list logo
