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 24
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
p
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 tw
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
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 serv
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 Wi
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
On Mon, Mar 11, 2002 at 09:30:27AM -0500, Dan Patnaude wrote:
> Hi-
>
> We are running mysql version 3.23.33, along with resin. The tables
> we are using are large, but not overly so. We also, for reasons I
> cannot comprehend, but for which my manager thinks is a good idea,
> have index files th
hi all,
since i haven't got any suggestion to the following problem, i'm
wondering if anyone could point me to a source where i could seek help
(i can't get my boss to pay for the support contract...)
thanks a lot.
Sammy Lau wrote:
>
> hi all,
>
> i've got a mysql server running around 100 qu
> -> "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 shou
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 h
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.'
It
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 the
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 con
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
T
>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 alph
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 a
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 i
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
> -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
>
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 PROTEC
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 coff
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 fro
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. Suc
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 is
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
> -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 r
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 base
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
>
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 PROTECTED]
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
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 that
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
PROBL
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 probl
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 fro
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
stateme
> > > 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
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
-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 google
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
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 M
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?
Incl
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 confus
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 & <<>>
[1] 1360
[root@localhost]# Starting mysqld daemon with databases from /var/lib/mysql
020317 hh:mm:ss my
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.
mys
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
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
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 online
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 shutdown
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 wher
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 o
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 - hav
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 o
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 tomorrow.
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
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
> http://www.mys
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 'user
Hi all,
Could you please tell me how to unsubsribe from the mysql list?
Thanks,
Li Bing
_.--"""--._
.' '-. `.
__/__(-. `\ \
/o `o \ \\ \
_\__.__/ ))|| ;
.-
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 whi
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 all
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 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
|-|
| W
62 matches
Mail list logo