Hi all and Good Morning.
I have been struggling with this code: I was wondering if someone could
lend me a hand.
I am working with this code and can't get the error to disappear.
After running I get
|-|
|
On Sunday 17 March 2002 16:38, Daniel Negron/KBE wrote:
Hi all and Good Morning.
I have been struggling with this code: I was wondering if someone could
lend me a hand.
I am working with this code and can't get the error to disappear.
After running I get
Hi mailing list,
I can't start mysqld-nt as I get the eror message 1067. If I start
winmysqladmin.exe there is no server visible.
The manual tell me in part 2.4 Post-installation Setup and Testing that I
should start the script ./scripts/mysql_install_db but this script is not
availabale (at
From: Andreas Dau [EMAIL PROTECTED]
Well, it's not really a mysql topic, but it's a bit connected to it. I
have a website that uses frames. My php script retrieves data from a
mysql database and displays it. My problem now is: each time that
specific page loads it first displays a white
Hi all,
Could you please tell me how to unsubsribe from the mysql list?
Thanks,
Li Bing
_.._
.' '-. `.
__/__(-. `\ \
/o `o \ \\ \
_\__.__/ ))|| ;
.--;
Hi everyone
Maybe somebody can help me with what seems like a tricky
subselect-avoidance question?
In a MySQL database, there are two tables - 'reports' and
'reports_signup'. 'reports' has two columns, 'id' and 'report_name'.
'reports_signup' has three columns - 'id', 'report_id' and
Hello,
He didn't name a column 'column', he named a table 'column'. This may
have seemed reasonable given his application.
In any case, bad idea or not, his point is well-taken. It worked in one
place but not another. While column is a reserved word, the directions at
Placed At :
Hi ...
I have a database having 30 tables..i run mysql-4.0.0 with innodb..updates and
delete on one paritcular table fail ..when i run the query the prompt jus t
hangs and i get the following error..
ERROR 1030: Got error 101 from
hi
1. I was wondering if there is any way to backup MySQL information other
than MySQLDump?
2. MySQLDump seems to overload the system. Is there a way to use
MySQLDump without overloading?
thanks
Sincerely
berber
Visit http://www.weberdev.com/ Today!!!
To see where PHP might take you
how about just change the WHERE clause to :
WHERE reports_signup.user_id != '2' (or whatever user_id)
ie: does not equal.
That should grab all reports they are not signed up for and the left join
will include all reports that nobody is signed up for (left-overs).
Another issue is that you're
Ack .. ignore the part of my last post re the original query not working :)
... it will as the user_id column will be null for reports notbody has and
this will fail the where clause my mistake. the LEFT join is redundant,
however, and the replacement I posted will also work ...
Anyway -
From: Boaz Yahav [EMAIL PROTECTED]
1. I was wondering if there is any way to backup MySQL information other
than MySQLDump?
In some cercomstances, you can simply copy the database file, but this can possese
real problems. Are you running your backups durring peak hours, or in the middle of
USING NOT IN will exclude reports that nobody has ... which I'm not sure is
the outcome he was after - It was my first thought as well but the actual
solution (assuming reports someone isn't signed up for includes reports that
nobody is signed up for) is quite simple I think - just change the
We worked around the problem by using safe_mysqld. (We were just running
mysqld directly.) What safe_mysqld does is to launch mysqld and then
hang around in the background. If mysqld ever dies unexpectedly, it
immediately restarts it. If mysqld is explicitly killed, e.g., with
mysqladmin
Kannan,
error 101 used to mean a lock wait timeout. In 4.0.1 and later 3.23
versions that has been replaced by a new clear-English error code.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the
Nico,
-Original Message-
From: Nico Sabbi [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date: Friday, March 15, 2002 1:42 PM
Subject: Innodb replication and Database renaming question
Hi,
I'm still using Mysql 3.23.46 because, as far as I remember, in .47 was
reintroduced the
Alex,
-Original Message-
From: Varshavchick Alexander [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date: Friday, March 15, 2002 8:00 PM
Subject: Extending tablespace for innodb
Hello,
How can I increase the size of the tablespace for innodb tables? Can you
say if this is a
Hello,
I have problem, I can't delete user, this is what I do:
shell mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25 to server version: 3.22.32
Type 'help' for help.
i installed mysql-3.23.36 (*.rpm) on my redhat linux 7.1 (kernel 2.4.2-2 on
an
i686) and ran mysql_install_db script. then i tried to start the server:
[root@localhost]# safe_mysqld enter
[1] 1360
[root@localhost]# Starting mysqld daemon with databases from /var/lib/mysql
020317 hh:mm:ss
Hi all,
Please excuse any ignorance I may show with this question - as I am not a
programmer and I am trying to do something that is out of my experience. I
feel truly out of my element in this and am hoping that the list expertise
will help me. I have looked at the manual - but still am
Hi Aleksander,
Seems to be a problem to get MySQL started.
= but no one of the advanced users/admins in this newsgroup
is interested in helping other users out :-(
Can't help you with your problem but probably will find it out together.
Did you get error messages like mine too?
Note: I am temporarily unsubscribed from this list, so please Cc me at
[EMAIL PROTECTED] if you reply to this message.
Moodss (a modular monitoring application, graphical and daemon) fully
supports the MySQL database and great efforts are made in collaboration
with the MySQL AB developer Sinisa
A lot of us here use simple techniques for troubleshooting. For errors, I
first look in the log file for mysql. But almost always, I google it.
Google turned up A LOT of results for a 1067, with tons of fixes.
The query I used was mysqld-nt 1067
The first results it pulled were from mysql's site,
-Original Message-
From: Dan Vande More
Sent: Sunday, March 17, 2002 10:20 AM
To: [EMAIL PROTECTED]
Subject: RE: problem running the mysql server!
A lot of us here use simple techniques for troubleshooting. For errors, I
first look in the log file for mysql. But almost always, I
Wow some help ;-)
Thank you Dan for your long explanatory mail :-)
Somethimes it's really good to SHOUT LOUD - so some folks out there DO HEAR
you.
I installed MySQL yesterday night and all went wrong, so frustation is
obvious.
Good idea, try to find some solutions by searching google this way
So, you can see that I didn't delete him. Why?
What I am doing wrong? How can I delete this user?
Why do you want to delete an user by delete command from the users table?!
For setting or deleteting permissions use GRANT/REVOKE commands
instead.
But How should I use Grant
I am hoping this reaches the right place, I was sure I had sent it but
didn't see it come to list...
I have two problems I am hoping to solve.
1) Is it possiblt to combine two update queries into one. So something
like UPDATE table SET field=value WHERE field=value2 which makes up one
Hey Don,
I read the whitepaper and it have come to the conclusion that when MS used
the words mySQL, they were not referring to MySQL, which is the list you are
on. They were referring to mySQL as my SQL just the same as myconnection and
Myemptywallet.
You see, most of us come here to get away
You would have a hard time removing the privileges using GRANT, I would
suggest using revoke:
http://www.mysql.com/doc/G/R/GRANT.html
-Original Message-
From: Marcin Pyla [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 17, 2002 11:28 AM
To: [EMAIL PROTECTED]
Subject: Re: Delete User
ORIGINAL SUBJECT:HELLO (PLEASE READ THE ENTIRE EMAIL
BEFORE DECIDING TO CHUCK IT, I DO GET TO MY QUESTION)
GOOD AFTERNOON
I THOUGHT I'D TRY MY LUCK AND ASK YOU A QUESTION,
IF YOU CAN'T (OR WON'T) HELP MY I UNDERSTAND. I HAVE
BEEN VISITING YOU SITE A LOT LATELY BECAUSE I HAD A
Try turning the CAPs off first... Makes it easier to read...
Second...
You are using ADOB to connect to mySQL? Is that what you are doing?
Using ASP? Try using PHP, easier to learn and is much more compatible
with mySQL. ASP/mySQL can be used, but its a pain, plus ASP has its
limitation
Dear Wheeler,
I forgot the authorization code o mysql list. I need it to usubscribe. How
can I do?
Thank so much!
Li Bing
- Original Message -
From: Alfred Wheeler [EMAIL PROTECTED]
To: Li Bing [EMAIL PROTECTED]
Sent: Sunday, March 17, 2002 9:08 AM
Subject: Re: How to unsubsribe from
Is there a way to spam control caps? Like if 75% or more of the content is
Capitalized, them ditch it rather then having to delete it manually?
Sql , query
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 17, 2002 12:19 PM
To: [EMAIL
From: Todd Williamsen [EMAIL PROTECTED]
Try turning the CAPs off first... Makes it easier to read...
I second that motion. :)
Second...
You are using ADOB to connect to mySQL? Is that what you are doing?
Using ASP? Try using PHP, easier to learn and is much more compatible
with
Hello,
This is a classical problem ... when you install mysql into an other
path than c:/mysql/ , you remove it and reinstall into an other directory.
At first you must verify the my.ini file into c:/winnt/ .
If mysql has been installed into an other directory than c:/mysql/ you
can verify
-Original Message-
From: denonymous [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 17 March 2002 8:2 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: IS THIS BETTER?
From: Todd Williamsen [EMAIL PROTECTED]
Try turning the CAPs off first... Makes it easier to read...
I
Hello,
We use mysql to store outgoing email headers from our users and do throttling
on users that appear to be spamming based on some simple queries to this
table. We use the Communigate mail server and this throttling script is a PERL
program implemented as a content filter. More information
I might be wrong, but this may get you going in the right direction:
select count(subject) as count, subject from outgoing where auth='USER'
group by subject order by timestamp desc limit 50
This would tell you each subject ever sent by the user, and how many times
that subject has been sent.
On Sun, 17 Mar 2002, Dan Vande More wrote:
You would have a hard time removing the privileges using GRANT, I would
suggest using revoke:
http://www.mysql.com/doc/G/R/GRANT.html
Will it delete user from table mysql.user ?
But How should I use Grant command to delete user from MySQL?
Ditch the Limit 50 in those queries I wrote, they won't work, they only
limit the result set, not the searched set. I don't know what I was
thinking. If you need to searched set to be limited by the last 50 of the
user, I cannot think of anything at this time, perhaps after a few more cups
of
Found a solution by searching google 'mysql-nt 1067'
... don't ask me why it is working ...
= deleted the my.ini in c:\winnt (or where ever)
and the server will start up!
Strange, isn't it?
So long A:lex
-Ursprüngliche Nachricht-
Von: Alexander Hampel [mailto:[EMAIL
-Original Message-
From: denonymous [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 17, 2002 10:40 AM
To: [EMAIL PROTECTED]
Subject: Re: white background
From: Andreas Dau [EMAIL PROTECTED]
Well, it's not really a mysql topic, but it's a bit connected to it.
I
have a
On Sun, 17 Mar 2002, Daniel Negron/KBE wrote:
$sql= SELECT * FROM cd_list WHERE $searchstring LIKE '%searchstring%'
ORDER BY artist ASC;
How about:
SELECT * FROM cd_list WHERE searchstring LIKE '%{$searchstring}%'
Then again, do you actually have a column called searchstring in your
Be sure to separate your command with semi-colon(;)
Besides...i havent seen here your script...just try and add it...
R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel.No. (088) 858-1028
Mobile No. (0919) 30856267
-Original Message-
From: Steven Gearhart
When I try to run the mysqld or safe_mysql, I get connot connect to local
MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'. Check that
mysql is running and that the socket : '/var/lib/mysql/mysql.sock' exists!
This file does not exist. Where does it come from or how do you create
Art,
Do you mean, whenever you try to run the 'mysql' client you get that error? That
usually happens because you are trying to connect to the mysql server using the
mysql client running on the same machine i.e. localhost. It's because the mysql
client uses a socket file when connecting locally
Description:
Locking tables seems to be broken for non-root mysql users,
giving the following error:
ERROR 1142: select command denied to user: 'foo@localhost' for
table 'bog'
Works fine for root. This is using the standard Linux
mysql-4.0.1
How can I update the values of a column in one table from the values in a
second table where there is are matching columns in the two tables using
mysql. Table1
has columns DonorID and DonorPhone. Table2 has columns PersonID and
PersonPhone. I want to sent Table1.DonorID = Table2.PersonID where
Found the file there, guess I missed it or it got created after I looked
before
If I run ./safe_mysqld --user=mysql
I get Starting mysqld-max daemon with databases from /var/lib/mysql
020317 16:48:10 mysqld ended.
I run mysqladmin u root -p piccolo 'new-password'
Enter password:
I then get
That's because you get this:
'020317 16:48:10 mysqld ended.'
It means there was an error, and the database server is no longer running.
Check your mysql log files to find out why.
Does the user, 'mysql' have permissions to write into the directory mysql is
using, normally /var/lib/mysql
Who is
I get
drwxr-xr-x 4 mysqldaemon 540 Mar 17 17:44 mysql
Art
-Original Message-
From: Dan Vande More [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 17, 2002 5:27 PM
To: [EMAIL PROTECTED]
Subject: RE: mysql.sock
That's because you get this:
'020317 16:48:10 mysqld ended.'
Hi Viraj,
You can do it using temporary table.
Create temporary table tmp select subject from outgoing where auth='USER'
order by timestamp desc limit 50;
Select count(distinct subject) from tmp group by subject;
drop table tmp;
If the result of the second query is 1 all the last 50 messages
- "Cannot add new record set to the database
Error Description: Current Recordset does not support
updating. This may be a limitation of the provider, or
of the selected locktype.
Error Number: 3251
Error Source: ADODB.Recordset
Better than what?
SHOUTING better than not shouting?
Hi there
I am busy evaluating InnoDB to decide whether to use it in our live
environment, simultaneously (which proberly isn't the best thing) I am
making changes to my code (I am using Visual Basic), to stream line my
transactions and make full use of the transaction facility.
My question to
Hi Alexander,
I use the PHPDEV compilation for local PHP/mySQL development work
(http://www.firepages.com.au/devindex.htm for a no-brainer approach to
getting PHP/mySQL/Apache up and running in seconds!)
Anyway, for me
start c:\phpdev\mysql\bin\mysqld-nt.exe --standalone
kicks mySQL off on
Hi Pierre,
Thanks, for your help.
That's what I exaclty do and this is for '--standalone' fine.
But the point ist, I want to start mysqld-nt as NT service -
and this is the problem - it wouldn't let me start it as service:
C:\net start mysql
System error 1069
Could not start service
The service
Hi,
What version of MySQL are you trying to get up and running ? If this version
is the mysql max, You will have to run the standalone first in order to
create the InnoDB datafiles, then it should start as a service.
I have had this exact same issue and it seemed to go away once I have run
the
Hello!
I'm not a very experienced SQL user and I cam accross a problem. But first I
will explain the database structure. There are two tables: mieszkania whis
contains some fields, one of them being miasto_id of int type, and the
other called miasta with the same firld name joining these two
I have checked all the configurable parameters, but still is wondering
what controls the number of processes started on the mysql startup.
I am especially interested in bin/mysqld Ver 3.23.48-max for
pc-linux-gnu on i686
Even with small configuration, I have 4 processes without and addition 7
Hi
We have problem with moving data to new server. We dumped
database with mysqldump on old server and used
mysql dbname db.sql syntax for database import.
When mysql imports one of our biggest table, then the import fails and
after some minutes gives an error message:
ERROR 1030 at line
60 matches
Mail list logo
