I would like to know how to create mysql.sock I destructed...
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:MySQL Server
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Hi Arjen,
- Original Message -
From: Arjen G. Lentz [EMAIL PROTECTED]
To: Tony Buckley [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, December 09, 2001 1:40 AM
Subject: Re: From Oracle to the MySQL Database Server
But eh, what are those gripes about transactions and locking?
Are
I would like to know how to create mysql.sock I destructed...
Restart mysqld
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please
Hello to everybody.
I have a problem with the Update method in the following simple VB6 code:
Dim MyConn as New ADODB.Connection
Dim MyRs As New ADODB.Recordset
MyConn.ConnectionString = DSN=test;uid=sa;pwd=;database=test
MyConn.Open
MyRs.CursorLocation = adUseClient
MyRs.Open lines, MyConn,
I'm trying to use the IN operator as described in my databases textbook
from college. This query:
select count(*) from user where user.ID in (select ID from user);
is supposed to evaluate to count the number of rows in the 'user' table
where the ID field is in the set of all ID field values
I'm trying to use the IN operator as described in my databases textbook
from college. This query:
select count(*) from user where user.ID in (select ID from user);
is supposed to evaluate to count the number of rows in the 'user' table
where the ID field is in the set of all ID field
Hi Bennett,
- Original Message -
From: Bennett Haselton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, December 09, 2001 12:31 PM
Subject: IN keyword supported?
I'm trying to use the IN operator as described in my databases textbook
from college. This query:
select count(*)
On RedHat 7.1 I have installed MySQL-3.23.46-1.i386.rpm and the client, but
mysqladmin does not install. Is there a fix for this?
Raymond
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Under Win98 (and NT for that matter), I've found it convenient to just
run WinMySQLAdmin. It starts the server (or service) automatically.
After installing mysql specifying nothing but defaults, I started
mysql without any parameters and then ran MYSQL TEST and received
the following error
I have a MySQL query that I want to draw an associative array from -
but I want the 'key' to the array to be the identifying element of
the row, and I'm stuck on how to get what I want.
For instance:
Each row in the result set contains an id number, a keyword and a
count related to that
Hi,
how can I check how much of the InnoDB data files are already taken?
Jens
(MySQL...)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hi,Sir:
I found the message shows that:
---
04 01:13:40 mysqld started
^G/usr/local/mysql/libexec/mysqld: File './host-bin.1'
not found (Errcode: 13)
04 1:13:40 Could not use host-bin for logging
(error 13)
InnoDB: Warning: operating system
Hi there,
Is it possible to have MySQLd create multiple unix sockets? Over and above
/var/run/mysql.sock. I'd like to have a socket in each of my chrooted file
systems.
Thanks,
Aragon
-
Before posting, please check:
Hi there,
Is it possible to have MySQLd create multiple unix sockets? Over and above
/var/run/mysql.sock. I'd like to have a socket in each of my chrooted file
systems.
Thanks,
Aragon
-
Before posting, please check:
Hi,Sir:
I found the message shows that:
---
04 01:13:40 mysqld started
^G/usr/local/mysql/libexec/mysqld: File './host-bin.1'
not found (Errcode: 13)
04 1:13:40 Could not use host-bin for logging
(error 13)
InnoDB: Warning:
On Monday 10 December 2001 00:36, you wrote:
I have a MySQL query that I want to draw an associative array from -
but I want the 'key' to the array to be the identifying element of
the row, and I'm stuck on how to get what I want.
For instance:
Each row in the result set contains an id
On Sunday 09 December 2001 12:26, Paul DuBois wrote:
At 3:19 PM -0800 12/8/01, Rob@TH wrote:
Hmm still nothing :/
Any other possibilities?
The suggestion offered below is a workaround that seems logical given
the lack of ORDER BY RAND() prior to MySQL 3.23. Unfortunately, it
doesn't work
How about a 2 dimensional array? If I understand you correctly wouldn't this
work:
$result = mysql_query(SELECT id, word, count FROM table, $db);
while ($return = mysql_fetch_array($result)) {
$id = $return['id'];
$row[$id]['word'] = $return['word'];
$row[$id]['count'] =
Hi. I am new to PHP/MySQL and this list.
Can I run MySQL on WinXP? I haven't been able to get it to work so far. Any help
would be appreciated.
--
Best regards,
Curt Kliewer
**
Hello,
We currently have two separate MySQL version running, one w/innodb and bdb
tables and the other w/o transaction table handlers. We normally
shutdown/restart the servers using the --defaults-file=/path/to/my.cnf
Now if I want to restart the server w/innodb and bdb tables, and do not want
Hi,
I've downloaded mysql 3.23.46 version and currenlty runnig
solaris 2.8 relase 10/00 on intel platform.
I'm getting the following error during the ./configure stage in
creating
my makefile.
checking size of char... 0
configure: error: No size for char type.
A likely cause for this
Hi,
-Original Message-
From: Stefano Vaccari [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 09, 2001 3:10 AM
To: [EMAIL PROTECTED]
Subject: VB6 ADO and UPDATE method
Hello to everybody.
I have a problem with the Update method in the following simple VB6 code:
Dim MyConn
Hello,
cut a'lot
them, will the command line over ride the settings in the my.cnf,
cut s'more
Manual sec. 4.1.2: Options specified on the command
line take precedence over options specified in any
option file.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk
Haven't tried it myself, but can't see why it shouldn't.
How about you try telling us the process you have been through so far and
any messages / errors that you may be getting.
-Original Message-
From: Curt Kliewer [mailto:[EMAIL PROTECTED]]
Sent: Monday, 10 December 2001 5:16
To:
Hello,
i have a question.
I will have to set up a MySQL Database which will have a hughe amount of
entries in a table. I did some tests and my select statements would need lot
of time.
I just wanna ask if there are some generally ways to speed up performance of
mysql statements?
thanx in
Hello,
Depending on what types of values are in your table, and the types of
selects that you are going to perform, you will most likely notice a speed
change if you were to INDEX some of your attributes...Just look up INDEX in
the mysql manual...
I notice the largest improvement when I INDEX
Hello,
Does anyone know where I should look on the http://www.mysql.com web site
or anywhere else I can find documentation for being able to SSH to the box
and setup additional databases as necessary using the MySQL command
line tools?
Scott
Scott
=
Hello,
i have a question.
Don't we all :-)
I will have to set up a MySQL Database which will have a hughe amount of
entries in a table. I did some tests and my select statements
would need lot
of time.
I just wanna ask if there are some generally ways to speed up
performance of
Try MySQLFront from www.mysqlfront.de, it has its limitations, but I
find it does 90% of what I need to do on a day-to-day basis.
Regards,
DOD.
Scott Johnson wrote:
Hello,
Does anyone know where I should look on the http://www.mysql.com web site
or anywhere else I can find documentation
Try MySQLFront from www.mysqlfront.de, it has its limitations, but I
find it does 90% of what I need to do on a day-to-day basis.
Regards,
DOD.
Scott Johnson wrote:
Hello,
Does anyone know where I should look on the http://www.mysql.com web site
or anywhere else I can find documentation
Hello,
Does anyone know where I should look on the http://www.mysql.com web site
or anywhere else I can find documentation for being able to SSH
to the box
and setup additional databases as necessary using the MySQL command
line tools?
http://www.mysql.com/doc/S/e/Secure_connections.html
Hi,
http://www.mysql.com/doc/m/y/mysqladmin.html
and
http://www.mysql.com/doc/C/o/Connecting.html
are a good start. If SSHing into a Unix box, you can also use man
mysqladmin and man mysql, and man mysqldump for more info.
-Joe
-Original Message-
From: Scott Johnson
hi,
I am new to PHP/mySQL.
When i connect to phpMyAdmin to work with my database I do not have any
problem of connection, but when I try to connect to my mySQL DB using this
script (http://www.utpala.net/query1.php), then I get the following error
message,
Does anyone see something wrong in
Thanks for reading this. I'm new to the whole world of linux, and MySql, but
I decided to get my hands dirty, and learn the whole thing.
I have just installed corel linux, and I'm quite happy that the whole thing
is working, and is visable on my network. Next I'm trying to get apache up
and
I have installed the necessary MySQL files onto the hard drive (under the folders
inetpub -- wwwroot -- mysql. Next, I set up a cnf file and called it my.cnf with
the path C:\Inetpub\wwwroot\mysql in it.
Then, using the command prompt, I keyed in the path to the mysql directory and keyed
in
Sounds like you need to add permission to connect from localhost.
You might want to check out:
http://www.mysql.com/doc/S/e/Secure_GRANT.html
or you might need to use the -u root option to mysql
-Original Message-
From: Curt Kliewer [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December
Hi,
You need to be running the server (mysqld.exe) before you can connect to it
from the command line. 10061 means that the TCP/IP service cannot be
contacted, either because the IP address isn't correct or that there is no
service on the requested port.
HTH
Quentin
-Original Message-
Hi,
Do I need to create users for the database, or does every user on the
system
have the right to create a table?
You need to create users within MySQL's authentication database. The manual
explains this beautifully.
Also, is it possible to connect to a MySQL
database using Access as a
Hi;
I have logging server (redundant) and I will store these logs on database (2
disks: one local and another remote using NFS).
When I receice the logs from my server I sent these logs to MySQL server
running on Linux. Normaly the database is on /var/lib/mysql/logging. can I
have another
Ok, thanks for the help, people. I finally got it to work. Was really quite simple.
(wish it were like this all the time heh). I just had to run the *clears throat*
winmysqladmin.exe and then everything went smooth as glass.
Again, thank you all for your help. :)
--
Best regards,
Curt
Hi!
Sergei == Sergei Golubchik [EMAIL PROTECTED] writes:
cut
Sergei Ok, mysqlimport uses LOAD DATA INFILE.
Yes, but they are simply convenient shortcuts to
myisamchk --keys-used=0 -rq
You can enable/disable keys from command line in 3.23.
Ok, what is the suggested usage?
create
Hi,
I compiled mysql 3.23.42 in SCO 5.05, sometimes in log file there'are
frequently mesaages: mysqld restarted, I don't know why.
Thank you for your any useful response !
Dick
_
Get your FREE download of MSN Explorer at
If I understand your core problem: it seems as if you can't start your
mysql daemon (mysqld) using the safe_mysqld wrapper.
Is it possible that you ran your mysql_install_db script as root? If
so then mysqld will have problems accessing the admin db files that
the script creates. (You can
Hi,
I am a newbie at this. I am running mysql 3.23.41 on my RedHat 7.2
linux box. I installed it using rpm.
I can start mysql but everytime I try to create a database, I keep
getting this error:
mysql create database guessbook;
ERROR 1044: Access denied for user: '@localhost' to database
Hi,
I am a newbie at this. I am running mysql 3.23.41 on my RedHat 7.2
linux box. I installed it using rpm.
I can start mysql but everytime I try to create a database, I keep
getting this error:
mysql create database guessbook;
ERROR 1044: Access denied for user: '@localhost' to database
All,
Now I want to design a database which contains more than 10G data to use. I
think the largest table in my db will contains more than 30 million records
and the amount of this kind of table will be up to 7 or 10. In my instance
there won't be so many clients connecting. normally, there are
I want to write an efficient query that will delete all records from one
table when they show up in another table (pending shipments -- shipped
shipments). I can't do it with this:
mysql DELETE from pending_2 WHERE pending_2.ordno = ordersearch_2.ordno;
because you can only refer to columns
I spent some time to do it w/ one query, but I couldn't figure out. So
I am throwing an example in Perl (the best way I could think of)
my $pending = $dbh-selectrow_arrayref(qq/
SELECT pending_2.ordno
FROM pending_2, ordersearch_2
WHERE
Thanks very much Paul,
Could you like to tell me what time spent in your querying ten thousands of
records from tables one time? In my test, when I query 10,000 records from a
table which contains 17 millions records total, it will cost less than 1
second of querying INDEX, or cost more than 30
Rory I want to write an efficient query that will delete all records
Rory from one table when they show up in another table (pending
Rory shipments -- shipped shipments). I can't do it with this:
mysql DELETE from pending_2 WHERE pending_2.ordno = ordersearch_2.ordno;
Rory because
On Saturday, December 08, 2001 at 21:46:52, Bojan IVANCIC wrote:
BI Hi:
BI Just a short Q:
BI - if I install MySQL through rpm is it possible with any sort of
BI postintallation to change the code page e.g. from Latin-1 to Latin-2.
BI Thanx and bye.
BI Bojan
Hi,
Try to add to my.cnf file
Hi,
I am a newbie at this. I am running mysql 3.23.41 on my RedHat 7.2
linux box. I installed it using rpm.
I can start mysql but everytime I try to create a database, I keep
getting this error:
mysql create database guessbook;
ERROR 1044: Access denied for user: '@localhost' to
52 matches
Mail list logo