Hello:
This is how i defined in conf file:
[mysqld_multi]
mysqld=/usr/bin/safe_mysqld
mysqladmin=/usr/bin/mysqladmin
user=multi_admin
password=multipass
[mysqld2]
socket=/var/lib/mysql/mysql.sock2
port=3308
pid-file=/var/run/mysqld/mysqld.pid2
datadir=/var/lib/mysql2
language=/usr/share/mysql/e
Not quite that easy, I'm afraid. Firstly, I think you misunderstand the
meaning of "localhost". "localhost" refers to the computer to which a
particular software (usually a server software) is running on. Or have I
misunderstood you and you are running the MySQL server on one PC and the Web
ser
At 2:17 PM -0400 6/1/01, Peter H. Burris wrote:
>I know that when it comes to deleting users from the user table, I could
>revoke all privileges and use an SQL 'delete from' command, but I wonder
>if there's an easier script/method for dropping a user? I've been combing
>the manual for a couple d
You probably don't need to revoke, just delete from the appropriate tables.
Sorry, I don't know of any other way. You could try mysqlgui but I don't
know as I've never tried it.
- Original Message -
From: "Peter H. Burris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June
At 10:13 PM -0400 6/1/01, daddius wrote:
>hello everyone... I am very new to mysql and I needed some help creating 1
>admin account for 4 computers.
>This is the error I keep getting.
>
> mysql> grant all on *.* to admin@% identified by "password";
> ERROR 1064: You have an error in
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 9:54 PM
To: [EMAIL PROTECTED]
Subject: ezmlm response
Hi! This is the ezmlm program. I'm managing the
[EMAIL PROTECTED] mailing list.
This is a generic help message. The message I receive
hello everyone... I am very new to mysql and I needed some help creating 1
admin account for 4 computers.
This is the error I keep getting.
mysql> grant all on *.* to admin@% identified by "password";
ERROR 1064: You have an error in your SQL syntax near '% identified by
"passwo
My mysql server is English but I have a chinese/english front end and users
type in both Chinese & English.
- Original Message -
From: "md" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 01, 2001 21:22
Subject: Unicode
> Does anybody use mysql with Chinese or other Unico
On Fri, Jun 01, 2001 at 03:50:30PM -0700, Florin Andrei wrote:
> On 01 Jun 2001 00:30:20 -0400, David Freeman wrote:
> >
> > My question is, what is the best OS for a heavy usage,
> > multi-processor mysql database driven web site. We could use
> > almost anything, but we would prefer to use a f
On Fri, Jun 01, 2001 at 12:28:17PM +0400, Ilya Martynov wrote:
>
> JZ> On Fri, Jun 01, 2001 at 01:45:24AM -0400, David Freeman wrote:
> >>
>
> JZ> Assuming you'll use Apache 2.x one day, I'd lean away from FreeBSD
> JZ> until the threading issues are resolved. I could envision you running
> JZ>
On 01 Jun 2001 00:30:20 -0400, David Freeman wrote:
>
> My question is, what is the best OS for a heavy usage, multi-processor
> mysql database driven web site. We could use almost anything, but we
> would prefer to use a free OS such as freebsd or Linux based OS.
Some people reported better pe
Thanks for your detailed and comprehensive response, Steve.
I should have mentioned that the RAID 5 array is provided by an A1000
RAID unit. It is configured to have one logical unit.
Both the MySQL data and temporary directories are on the A1000.
All 12 drives in the A1000 are 18 GB Seagates
Whoops...here is the file
- Original Message -
From: Glenn Emery
To: [EMAIL PROTECTED]
Sent: Friday, June 01, 2001 3:46 PM
Subject: Newbie Needs Help
Hi All,
I am not sure this is the correct list for this but here goes...If not
the correct list any idea where I might find some hel
- Original Message -
From: Glenn Emery
To: [EMAIL PROTECTED]
Sent: Friday, June 01, 2001 3:46 PM
Subject: Newbie Needs Help
Hi All,
I am not sure this is the correct list for this but here goes...If not
the correct list any idea where I might find some help?
I have a site that is
Hi there,
I have five tables in the database: customers, orders, ordercontents, products and
payments. The problem is that I should get a list which shows some kind of a ledger
list (shows who has paid and so on).
My first try looks like this:
SELECT orders.OrderID, customers.Name, SUM(orderco
Sinisa,
In the first case I was trying to connect to the Linux box using a MySQL
client on the Mac called MacSQL. This box is called malacoda.local.
I'm still getting the same error, trying to connect from a mysql client on
my NT system, called lucifer.local, to a server on Linux. I get Error 11
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello mysql,
Peter> Today I played a little bit with two different ways of backup -
Peter> first one is to use BACKUP TABLE (which works for myisam only) and
Peter> the second one is SAVE DATA/LOAD DATA.
Peter> In bo
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
> On Wed, May 30, 2001 at 11:32:16PM -0400, Michael Villalba wrote:
> >
> > I have a rather large MyISAM table (~230 million rows) running under
> > MySQL 3.23.30. It has 10 columns and 3 indices. The data and index
> > fil
I think your doing FAR more work than you need to. I'm also not getting
what you mean by it not paying attention to the initial query.
I suggest you combine those 3 queries into one, just like this:
SELECT somefield1, somefield2, DATE_FORMAT(EventStartDate, '%W %M %D %Y') AS
FormattedEventStartD
On Fri, Jun 01, 2001 at 03:08:53PM -0400, Longo, Joseph wrote:
>
> i want to import a series of text files into a MySQL database.. can
> anyone point in the direction of good documenation on this?..
Search for "LOAD DATA" in the manual:
http://www.mysql.com/doc/
Jeremy
--
Jeremy D. Zawodny,
Hi,
I was wondering if someone knew of a way to keep stats of records that
were being used from a Table in a DB.. i.e. I have a table with URL's in
them and when a search is done, it returns a certain number of records..
I want to know, which exact record the user click's on and uses, not the
que
Hi,
I've developed a simple search engine for a site I'm working on. Its
purpose is to display community events based on the users input criteria.
The problem is, if I use the DATE_FORMAT command to alter the appearance of
the events dates and times - then MySQL begins at the top of the list
i want to import a series of text files into a MySQL database..
can anyone point in the direction of good documenation on this?..
thanks in advance..
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
Thank you Steve, I appreciate your response :) I have considered modifying
MySQL to do what I have asked for, but I didn't want to do that until I
verified it wasn't already available somewhere. I'll bet this feature is
something that others would be interested in as well.
On the note of wha
Peter D Bethke writes:
> Hello all,
>
> I'm running MySQL on SuSE Linux 7.0.
>
> I've been unable to connect to MySQL from a client on a remote system (both
> systems behind the firewall) using a username/pw set up locally using the
> GRANT ALL ON *.* TO user@% identified by "password" command.
At 12:12 PM -0500 6/1/01, Jeff Davidson wrote:
>We have installed the mySQL binary onto Windows 2000 from a CD. (We
>think we installed it) What next?? We've messed around with dos
>commands with no luck. We are obviously missing something vital???
>What is it??? Help!!!
>Thanks
If you're
I know that when it comes to deleting users from the user table, I could
revoke all privileges and use an SQL 'delete from' command, but I wonder
if there's an easier script/method for dropping a user? I've been combing
the manual for a couple days and while I can create users and grant/revoke
pr
Friday June 01 2001 12:12, Jeff Davidson wrote to All:
JD> We have installed the mySQL binary onto Windows 2000 from a CD.
JD> (We
JD> think we installed it) What next?? We've messed around with
JD> dos
JD> commands with no luck. We are obviously missing something vital???
JD> What
On Fri, Jun 01, 2001 at 03:35:57PM +0800, Alice wrote:
> i have no idea on how to run mysqlhotcopy in the query tool or it is
> not suppose to run in query tool. is this correct ? mysqlhotcopy
> db_name '/downloads/backupDB/'
It's a stand-alone tool. If you run it without any command-line
argu
Hello all,
I'm running MySQL on SuSE Linux 7.0.
I've been unable to connect to MySQL from a client on a remote system (both
systems behind the firewall) using a username/pw set up locally using the
GRANT ALL ON *.* TO user@% identified by "password" command.
I know this is a big security hole t
On Fri, Jun 01, 2001 at 09:13:45AM -0400, Beverly Baird wrote:
> Tried that.
>
> mysql> ALTER TABLE Craft type=MYISAM;
> ERROR 1016: Can't open file: 'Craft.ISD'. (errno: 138)
>
> I have tried to run the mysql_convert_table_format script but I
> can't find any examples and I cannot get it to w
Kenneth Kopelson wrote:
> So, how do we get support in MySQL so that multiple instances of the mysqld
> daemon running on separate machines can all access the same database files
> located on a central server? I can see how the file system of the central
> database server could be exported throu
On Fri, 1 Jun 2001, Toth Dalibor wrote:
> I really need to know this: I have a column defined as char(2), default
> 'no', not null.
> When I create new entry into the table, I skip entering value into mentioned
> column
> because I expect to be filled with the default value, that is 'no'. Bu
Hi
Have you installed the service in the CSM (console service manager) yet ?
Go to the command prompt and type [mysql_dir]\bin\mysqld-nt --install
(mysqld-max-nt for MySQL MAX).
Afterwards start the service by either going to the CSM and starting it or
by typing "net start mysql" from the comma
What you are asking to do is not built into MySQL :(
Mysql matintains its own internal database locking that would not
be shared amongs the other computers, if you have multiple machines
reading a writing to the same database file you will corrupt it
in short order.
Your best bet in such an en
On Fri, Jun 01, 2001 at 12:12:47PM -0500, Jeff Davidson wrote:
>
> We have installed the mySQL binary onto Windows 2000 from a CD. (We
> think we installed it) What next?? We've messed around with dos
> commands with no luck. We are obviously missing something vital???
You are clearly missin
Hi Jeff
Can you give us a bit more step by step info
Then we will pont you the right way..
Simon
-Original Message-
From: Jeff Davidson [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 18:13
To: [EMAIL PROTECTED]
Subject: what's the problem
We have installed the mySQL binary onto W
On Fri, May 25, 2001 at 10:53:52AM +0200, Dorthe Luebbert wrote:
> Hi,
>
> I am looking for a script that reads a mysql-logfile, removes all
> non-sql-stuff (like the DB-INIT-Number) and creates a sql-file from
> it. The perfect tool could handle different databases stored in the
> mysql-logfile
We have installed the mySQL binary onto Windows 2000 from a CD. (We think we installed
it) What next?? We've messed around with dos commands with no luck. We are
obviously missing something vital??? What is it??? Help!!!
Thanks
I am hoping there are people who use MySQL for serious business
applications on this list. If so, please answer my question :) If not,
will someone please direct me to a source of expert information?
HERE IS MY QUESTION:
I have need for multiple servers to share the same database files. We
This may not be a bug, but rather a limitation, and should definitely be
added to section 7.38 of the manual dealing with comments. Scripts (or
commands entered interactively) contatining comments that contain a
backslash character are parsed as if the \ was a MySQL command.
For example,
/* \. d
Newby speaking here; I've just managed to get PHP and MySQL working, now
creating my first database. When I do that off-line ('localhost'), the data
are entered in a MySQL subdirectory \MySQL\data. Not on a localhost
subdirectory (where the php script is running). But I don't see a MySQL
subdi
At 7:19 PM +0530 6/1/01, Rohit Peyyeti wrote:
>hello all:
>
>how can i run multiple instances of mysql server? i also looked
>at mysqld_multi but i guess there is a problem with that too.
>here is the error what it gave:
>
>ABORT: Bad GNR: mysql2 See mysqld_multi --help
>
>i also defined GNR in /e
Hello, mysql:
Can anyone say if exist some function in the C API that do not store
all the requested rows before returning but it returns inmediatly for
each one and the storing be in the remote server.
Thanks a lot !
[EMAIL PROTECTED]
---
As soon as the new month rolled over, it happened again.
The problem went away sometime in mid-May. The only difference between
the current problems and the old is that we're now running 3.23.38.
Any ideas?
Chris
--
Forwarde
Boryniec Adam wrote:
>
> Hello,
>
> I have a following problem:
> I created two simple tables and a query that uses both of
> them. This works perfectly. See the example below.
> The question is: is the same query possible when the two
> tables are located in diffrent databases.
> What I mean: I
Hi!
At 05:44 PM 6/1/01 +0400, you wrote:
>Hello mysql,
>
> Today I played a little bit with two different ways of backup -
> first one is to use BACKUP TABLE (which works for myisam only) and
> the second one is SAVE DATA/LOAD DATA.
>
> In both cases if I'm not mistaken the file is wrote by m
does anyone setting up mysql with quotas?? i need it for hosting.
--
%whois -R NULL-RIPN
PGP: http://null.magelan.ru/null.asc
Pager: +7 095 974-0003, #30369
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi,
> Using PHP4 and Mysql
>
> After reading the manual and doing vaious searchs around
> the net, I'm damned if I can work out the syntax for
> mysql_info().
I'm looking at the manual for PHP4 here and there is no such mysql_info()
function! The only listed *_info() functions are:
mysql_get_c
Peter Zaitsev writes:
> Hello mysql,
>
> Today I played a little bit with two different ways of backup -
> first one is to use BACKUP TABLE (which works for myisam only) and
> the second one is SAVE DATA/LOAD DATA.
>
> In both cases if I'm not mistaken the file is wrote by mysqld server
Hi!
Redirection from www.innobase.fi to www.innodb.com now works from
my own computer. Please report to me if it does not work from your
computer.
The official InnoDB website is now www.innodb.com
My email address still stays the same [EMAIL PROTECTED],
but also that will probably change to [EMA
hello all:
how can i run multiple instances of mysql server? i also looked
at mysqld_multi but i guess there is a problem with that too.
here is the error what it gave:
ABORT: Bad GNR: mysql2 See mysqld_multi --help
i also defined GNR in /etc/my.cnf
Any idea why the error?
...Rohit
Hello mysql,
Today I played a little bit with two different ways of backup -
first one is to use BACKUP TABLE (which works for myisam only) and
the second one is SAVE DATA/LOAD DATA.
In both cases if I'm not mistaken the file is wrote by mysqld server
so there is no communication overh
Tried that.
mysql> ALTER TABLE Craft type=MYISAM;
ERROR 1016: Can't open file: 'Craft.ISD'. (errno: 138)
I have tried to run the mysql_convert_table_format script but I can't find
any examples and I cannot get it to work either. I'm quite sure it's
operator error in this case.
We have pulle
Hi.
I'm using the C API to access mySQL database (trying to reuse a lot of
existing
software, mixing an old database & mySQL, but it's not the point).
Due the way the old database (named Ideafix) run the keys sometimes the
translated
query produce too many rows (running out ot memory) although
Hi guys,
Are we talking about Symantec's ACT product?
Cheers,
Mikel
Rolf Hopkins wrote:
> I've never heard of ACT2 but if you can export the data to a delimited text
> file, you could import it into mysql. You may have to edit the file a bit
> though.
>
> - Original Message -
> Fr
Hi,
I donot think it is supposed to show the number of
rows deleted or it should not show anything at all.I
agree if it is not a bug,at least it is an unwanted
thing .
When it always shows the affected number of rows as
zero though it actually deletes a million records,it
must be removed or made o
D. Veerasamy writes:
> Dear Sir/ Madam
>
> Can you please help me with the GUI client running under linux.
> I'm having an error message saying:
> Can't connect to local MySQL server through socket " (111)
>
>
>
> Thanking you.
>
> -
Joseph Bueno writes:
> Hi,
>
> [EMAIL PROTECTED] wrote:
> >
> > I know this is bound to be something REALLY simple, but I can't seem to get
> > "safe_mysqld" to run in background (Solaris 7/MySQL 3.23.37)
> >
> > If I try, as the "root" user, to start "safe_mysqld" from the "/usr/local/mysql"
>
Roberto de Martin Serqueira writes:
> Hi
>
> I'm forwarding you the attached file MYSQL_3.23.38_FIXES.ZIP which contains files
>with some minor improvements
> and fixes done by me, updated to MySQL version 3.23.38, and presenting the following:
>
> - Directory \LIBMYSQL:
>
> - file ERRMSG
Sorry,
the website is now at www.innodb.com
It should redirect users from www.innobase.fi, but that does not
seem to work now.
Thank you for the notice.
Heikki
Innobase Oy
At 04:44 PM 5/31/01 -0700, you wrote:
>On Tue, May 22, 2001 at 07:26:40PM +0300, Heikki Tuuri wrote:
>> Hi!
>>
>> I wrot
Using PHP4 and Mysql
After reading the manual and doing vaious searchs around
the net, I'm damned if I can work out the syntax for
mysql_info().
Could anyone give me an example please?
feelin' a bit dumb
Howard Picken
(Server, SQL, Query... etc)
[EMAIL PROTECTED]
-
On Fri, Jun 01, 2001 at 09:26:08PM +1000, Howard Picken wrote:
> After reading the manual and doing vaious searchs around
> the net, I'm damned if I can work out the syntax for
> mysql_info().
>
> Could anyone give me an example please?
In what programming language?
Greetz, Peter.
After reading the manual and doing vaious searchs around
the net, I'm damned if I can work out the syntax for
mysql_info().
Could anyone give me an example please?
feelin' a bit dumb
Howard Picken
(Server, SQL, Query... etc)
[EMAIL PROTECTED]
---
We want to Configure MySQL database to JRUN as a jdbc datasource (Native).
If Anybody knows ,Please give reply.
_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com
--
Hello to all!
I'm useing MySql 3.23.33 for unknown-freebsdelf4.2
when i trt to select anything from command line
mysql> select * from base.table where name like '%%';
i resieve many unuseful results (all DB)
it happends with diferent words
it does not matter in what kind of encoding i do this
On Fri, 1 Jun 2001 11:38:05 +0200
Toth Dalibor <[EMAIL PROTECTED]> wrote:
> database,sql,query
> Hi!
>
> I really need to know this: I have a column defined as char(2), default
> 'no', not null.
> When I create new entry into the table, I skip entering value into mentioned
> column
> because I
database,sql,query
Hi!
I really need to know this: I have a column defined as char(2), default
'no', not null.
When I create new entry into the table, I skip entering value into mentioned
column
because I expect to be filled with the default value, that is 'no'. But that
doesn't happen!
Why?
Tha
Hello everybody,
I am learning sql but i am not new to programming.
I have a small problem, any help on this will be great. :)
I have table name category,..with the following details
SQL> desc category;
NameNull?Type
--- -
What OS?
>Where do you enter the commands to install mySQL?? I know it's a stupid question,
>but please, enlighten me.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
JZ> On Fri, Jun 01, 2001 at 01:45:24AM -0400, David Freeman wrote:
>>
>> The server is a quad xeon lh4, it will host a web site written in
>> php, and using a mysql database which holds 125,000 squ's and
>> descriptions. The server's only job is to host this site.
JZ> Assuming you'll use Apach
Hello,
I am working on RH Linux 7.0
MySql is not working at all.
My MySql files are under /usr/bin.
It gives the following error on running any mysql command
Can't connect to localMySql server through socket 'var/lib/mysql/mysql.sock'(111)
Please Help me.
Thank You
Sachin
i have no idea on how to run mysqlhotcopy in the query tool
or it is not suppose to run in query
tool.
is this correct ?
mysqlhotcopy db_name
'/downloads/backupDB/'
if i want it to backup in my c:\downloads\backupDB
folder ??
/---
Hello,
I have a following problem:
I created two simple tables and a query that uses both of
them. This works perfectly. See the example below.
The question is: is the same query possible when the two
tables are located in diffrent databases.
What I mean: Is it possible to write a crossdatabase
Hi,
Thx Rolf for your help I did setup the password
Now, I have installed the RPM called mysql-DBI-perl-bin...rpm
But when I want to install the MySQL-bench...rpm it asks me for the MySQL-DBI-perl..rpm
Can someone tell me how to solve this probem?
thx
JP
__
75 matches
Mail list logo
