That's great but... do you know there is some FREE products to manage MySQL
DB.
I propose MySQL Front, you can find it at http://www.anse.de/mysqlfront/
Hope This Help All Folks
theOtherOne
- Original Message -
From: "Igor Brynskich" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tues
Hi,
I have install mysql-RPM 3.23.38 on red hat linux 6.2 machine,
which was running properly for more than 3 months .
recently , It started restarting after every 30 min.
I am trying to find the problem but, error file shows stack trace
which I could not understand.
I have upgr
My apologies, what I said in this previous post is incorrect.
It appeared as if the time was UTC (except for daylight savings)
to me, but it was mearly because of the format string
As Paul DuBois quite rightly pointed out is that %h in
select FROM_UNIXTIME(UNIX_TIMESTAMP(),
Hi,
I need to know that MySQL has any compression method when it store
data? If the answer is Yes, How the different compression between MySQL
and other tools (zip, gzip)? I asked this question because I need to store
some text file for future used (at least 1 Mbyte per day). I was u
Hi bob,
I have do everything you need but may be a little diff. I have MS
SQL 6.5 on NT, MySQL 3.23.47 on Linux and using PHP / VB 6 for client. The
first thing you must define some role of usage and other, how to manipulate
your data. I have PHP update routing in some project (tran
>Description:
When issuing a command containing both a GROUP BY and an ORDER BY clause, the server
is returning no results. This issue has
arisen since upgrading from 3.23.47 to 4.0.1
>How-To-Repeat:
Table Creation:
CREATE TABLE statarchive (uid INT unsigned NOT NULL AUTO_INCREMENT, referal
At 14:10 06/02/2002 +1100, WG4- Cook, Janet wrote:
Hi,
> > What is the best or easiest client to set up on my NT4 workstation so I
> > can connect to the MySql server
> > and create tables, etc via scripts? I tried downloading one or two from
> > the MySql site but none of them seem
> > to have
Hi list,
I'd like to generate arrays into a field for the result-set
by means of grouping...
myTable >> ( MySQL 3.23.33 / MyISAM table )
++--+
| id| type |
++--+
| 002 | 'CD' |
| 002 | 'LP' |
| 011 |'DVD' |
| 081 |
If you want to get the most out of MySQL, then you really need to learn to
use the command line tools. MySQL has the easiest to use tools and language
of any database I've used. SQL allows you to do really powerful things
easily.
Download the Windows version and install it. You can use the mys
> Hi,
>
> I am used to using Microsoft SQL or Sybase servers where there is a simple
> client setup mechanism or I can connect using
> DBArtisan etc. (this is from previous employment)
>
> What we have is MySql and PHPadmin setup on a Linux Box (done by someone
> else). Its only just been setu
hello,
This is my problem and question:
I installed mysql-3.23.36 when I installed the RedHat7.1, but now I want to
install mysql-3.23.47 to the platform and I hope the two versions are both useful. How
should I configure the parameters when I configure? I want mysql supporting t
Running Kernel 2.4.17 gcc-2.95.3 glibc-2.2.5
I read through the manual for hints and searched the mailing list
archives but couldn't find a similar report.
Here's the build output:
c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr\""
-DDATADIR="\"/var
Hi there,
I have installed MySQL 3.23.37-sun-solaris2.7-sparc.
Some times the server starts and when i try to connect it using my
password it hangs. It doesn't allow me in. Neither does it say anything
about the password or about the connection.
How do i solve this.
This is the second time it is
Oh well worth a try
Thanks
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
-
I would like to authenticate my IntrAnet users against our Microsoft Active
Directory database. Has someone done this before?
How would I connect MySQL to the AD?
Thanks
-Allen
---
[This E-mail has been scanned for viruses and is clean]
---
On 5 Feb 2002, at 15:11, Dan Nelson wrote:
> I assume var1 is a float in the first case? Due to rounding
> issues, the "=" operator will almost never work on fractions.
> Use the primary key to select which record to delete, or use a
> number range (var1 BETWEEN 1000.009 AND 1000.1001).
Matth
Try:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
C:heers!
-Original Message-
From: Cindy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 1:59 PM
To: [EMAIL PROTECTED]
Subject: mysql.sock
Sorry, I know this is documented somewhere, because I've seen it,
but I
I have a site using PHP & Mysql. About a month ago to now one of the tables
gets corrupted with the message Got Error 127... I fix it and everything
works OK, except every time I loose 1 record.
Today I could obtain mysql.err from the machine and I could see whenever an
error is produced by date,
Hi All,
I'm glad to inform you that the new (1.51) version of EMS MySQL Manager has
been released today. In this version we've included the fixes of all bugs
which had been found by our users. Many thanks to all who sent us their bug
reports. Also a lot of small improvements was added, which will
hi forks,
I try to save image to MySQL and I create table with
longblob field. but i failed with following two ways:
1. use appendchunk and getchunk which are succeful in
MS SQL but failed in MySQL
2 insert a bmp file(size is 54k) into table with
load_file and get data from table using select i
>When I try to connect to the mysql server (mysql -u root -p ),
>I get an error about /tmp/mysql.sock.
>
>Anyway, what is the problem here? Do I have to take it down and start
>it up again? I'm pretty sure the problem is that the file has been
>deleted, probably a cron job, but I can't remember
hi,forks,
Now I try to save image to MySQL, I create a table
with longblob field, i try two ways as follows but
both did not work
1. use appendchunk, i succeed in saving image to MS
SQL with this funtion. but i can't save image to MySQL
with it.
2. using Load_File insert a bmp file (size is 102
Sorry, I know this is documented somewhere, because I've seen it,
but I can't find it now, nor remember exactly what it said.
When I try to connect to the mysql server (mysql -u root -p ),
I get an error about /tmp/mysql.sock.
I've searched both http://lists.mysql.com/ and
http://www.mysql.co
Hi;
I get this error when I try to access a database as root:
mysql> use antigo;
Can't read dir of './antigo/' (Errcode: 13)
What does this mean and how do I fix it?
TIA,
BenO
-
Before posting, please check:
http://www.mys
When using the LOCAL option to the LOAD DATA INFILE query, does the
client program read in the file or does the server read in the file?
I'm asking because I'm hoping that there is a way to disable the LOCAL
option or make it so that the File_priv will even apply to the LOCAL
option. Right
On Tuesday 05 February 2002 13:03, Matthias Hoffmann wrote:
> dear all.
>
> I have a problem using mysql(occured at using phpMyAdmin):
> i send the query:
> DELETE FROM test WHERE user = "test" AND timestamp = "2002-02-05
> 21:42:53" AND var1="1000.1" LIMIT 1
> and 0 effect.
> but when var1 has a
We've built MySQL 3.23.46 on Solaris 8/SPARC as a 64-bit executable
using the Sun C compiler. Everything built OK. We built against
ncurses, readline, and zlib, all built as 64-bit libraries. Are there
any special settings to get MySQL to work properly in this environment
or should things work as
In the last episode (Feb 05), Matthias Hoffmann said:
> dear all.
>
> I have a problem using mysql(occured at using phpMyAdmin):
> i send the query:
> DELETE FROM test WHERE user = "test" AND timestamp = "2002-02-05 21:42:53"
> AND var1="1000.1" LIMIT 1
> and 0 effect.
> but when var1 has a (INT)
dear all.
I have a problem using mysql(occured at using phpMyAdmin):
i send the query:
DELETE FROM test WHERE user = "test" AND timestamp = "2002-02-05 21:42:53"
AND var1="1000.1" LIMIT 1
and 0 effect.
but when var1 has a (INT) value there's no problem:
DELETE FROM test WHERE user = "test" AND ti
Bob,
I've posted this back onto the list because there are others here who will be much
more able to assist.
> Clarification:
>
> I currently have 22 NT workstation that send data to various tables in a
> SQL7 database running on a NT sever. The visual basic front end organizes
> this data in t
We are running an extremely large instance of mysql version 3.23.46 on
Solaris 2.8. We are attempting to use a software version compiled 64 bit
and have been experiencing memory related server crashes.
The behavior suggests that we are still unable to use more than 4G of
memory.
If the server
hello again,
still learning ...
i'm experiencing some unusual behaviors from the daemon. it stops
immediately.
[localhost:/usr/local/mysql] root# sudo ./bin/safe_mysqld --user=mysql &
[localhost:/usr/local/mysql] root# Starting mysqld daemon with databases
from /usr/local/mysql/data
020205 1
I downloaded the following file from mysql.com.
mysql-3.23.47-sun-solaris2.8-sparc.tar
I untarred it into /mysql, then I have the following
files.
Look here:
# ls
bin include scripts sql-bench tests
data lib share support-files
#
Then I went into /mysql/bin and tried running mysql
like so:
Hi Bob,
> Hi, I currently have a very large MS SQL7 database that I need to put on the
> web. My plan is to use PHP and MySQL to accomplish this. Currently I have a
> Visual Basic front end on the MS SQL7 Server. I would like to have my VB
> program write The MS SQL7 server data to a MYSql databa
Hi all,
I want to connect a MySQL client from Windows NT to SUN Solaris 2.6.
How can I do this? I need some services running in the Server (in my case, SUN
Solaris). What means the message:
"Host is not allowed to connect to this MySQL server" ??
Thanks in advance
After reviewing the MySQL documentation about the available privileges and
what
they would be used for, I still was not able to find my answer.
Can another user, besides root, use the replication commands?
What would be the minimum set of privileges that could use SLAVE START,
SLAVE STOP, SHOW SL
At 16:00 04/02/2002 +, Neil Freeman wrote:
Hi!
I did the test in my small network and works. The only care I
did is to mapped the network drive, assign a letter (in my case
F). Please take a look if effectively you had mapped the drive
X (trying to access the X drive with an DOS prompt).
Reg
Hi, I currently have a very large MS SQL7 database that I need to put on the
web. My plan is to use PHP and MySQL to accomplish this. Currently I have a
Visual Basic front end on the MS SQL7 Server. I would like to have my VB
program write The MS SQL7 server data to a MYSql database and then have
MySQL: DATETIME vs. INT
http://forums.devshed.com/showthread.php?s=&threadid=29754&forumid=4
C:heers!
-Original Message-
From: DL Neil -- Sent: Tuesday, February 05, 2002 1:28 AM
Checking the MySQL manual (6.3.4 Date and Time Functions)
UNIX_TIMESTAMP()
UNIX_TIMESTAMP(date)
...returns
hello,
following the instructions for resetting a password (
http://www.mysql.com/doc/R/e/Resetting_permissions.html ),
i was not able to find the .pid file. is it possible to continue the process
without killing it?
what would be the command to restart the daemon using the
--skip-grant-tables o
Neil,
Tuesday, February 05, 2002, 11:19:35 AM, you wrote:
NF> That's a bit of a pain :) Any idea if this will be supported at some point?
Apparently it will not be supported. Disk file system differs
from networking file system. MySQL will not work via networking file system.
NF> Cheers, Neil
Hi Peter,
> I am working on a search logging script to count the most popular word or
> phrases searched for.
>
> Table
>
> I could add a line for each search, and aggregate the results for reports,
> but I was wondering about the following which would keep table sizes down.
>
> | search word
Whoops! Forgive me, I meant to say a CGI environment. This should be a
lesson to me to proofread no matter the time restraints. :)
- Original Message -
From: "Dave Mittner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 05, 2002 10:37 AM
Subject: Using SQL in a C Prog
Most of my experience with SQL comes from an SQL environment in which the
program will run through and end fairly quickly. I'm now up against a
constantly running C program which utilizes the database on a regular basis.
In this case, is it better practice to only open the connection for the
durat
Hi
I am working on a search logging script to count the most popular word or
phrases searched for.
Table
I could add a line for each search, and aggregate the results for reports,
but I was wondering about the following which would keep table sizes down.
| search word | count |
=
jeremy,
Tuesday, February 05, 2002, 6:40:29 PM, you wrote:
jr> hello,
jr> i made the mistake of changing my root password manually in the mysql
jr> database. after doing so, i 'flushed privileges'.
jr> now i'm unable to log on using the root. i've tried to log on using the new
jr> password a
On Tuesday 05 February 2002 9:59 am, Barry J. Wiegan wrote:
> Hi,
>
> I'm trying to build a query to solve a fairly simple problem.
> I have two tables (A and B) linked by a common ID. I want to
> locate a specific record in A that is linked to two or more
> records in B based on second field in B
Hi,
I'm trying to build a query to solve a fairly simple problem.
I have two tables (A and B) linked by a common ID. I want to
locate a specific record in A that is linked to two or more
records in B based on second field in B matching certain criteria.
I've tried every type of inner, outer, left
Hello, I have two tables in my database as such:
CREATE TABLE `skill_names` (
`id` bigint(20) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
);
CREATE TABLE `skills` (
`skills_id` int(11) NOT NULL auto_increment,
`member_id` int(11) NOT NULL defaul
sreedhar,
Tuesday, February 05, 2002, 6:42:51 AM, you wrote:
s> How can I create InnoDB table. If I tried create a InnoDB Table on my RedHat
s> Linux MySQL 3.23.26 . Can any body give details that how can I create InnoDB
s> table.
You can find info about it in the manual:
http://www.mysql.com/
Dave,
Monday, February 04, 2002, 10:08:04 PM, you wrote:
DM> I'm currently trying to install MySQL in my home directory on a server which
DM> I do have root access to. I follow the steps outlined in O'Reilly's
DM> 'MySQL&mSQL' book and I get through the first several steps before problems
DM> oc
hello,
i made the mistake of changing my root password manually in the mysql
database. after doing so, i 'flushed privileges'.
now i'm unable to log on using the root. i've tried to log on using the new
password a number of times, but i'm always denied access. strangely enough,
other users (tha
> - use of mysql_pconnect (introduced in Novemeber)
> - use of fsockopen($Primary, 3306, &$errno,&$errstr,5) (closed by
> fclose()) to test if connection possible before attempting connection
> (introduced last week)
> - much high web activity causing recycling of httpd processes
You're putting m
I have problems with starting mysqld. When i put down command:
./safe_mysql
it returns message:
Starting mysqld deamon with databases from /usr/local/mysql/var
020205 15:07:03mysql ended
I've instaled latest mysql from source distribution on Linux Slackware
8.0.
Lp
jure
--
Steve <[EMAIL PROTECTED]> writes:
> I'm trying to pick the best path, but between this older K62 and the
> warning about gcc 2.96, I'm having trouble :)
>
> (I'll be using a K62 with RH7.1)
The rpms here
http://people.redhat.com/teg/mysql/
should work just fine (they're built in a RHL 7.2 env
On Tue, Feb 05, 2002 at 08:34:34AM -0700, Randy Arabie wrote:
> You mention that, mysqld AND mysql. You will note above that when I checked mysqld
>with fstat,
> there were only 64 files open. That, coincidentally, is the default
>proc.curproc.rlimit.descriptors.soft
> setting.
>
> Does mysq
Hello,
I'm relatively new to mysql and I've come
across a problem while trying to insert
values from
multiple tables into a single, existing
table. Here's the syntax that I'm using:
insert into table1 (col1,col2,col3,col4)
select Foo.col1, Foo.col2, Bar.col3,
Bunk.col4 from table2 as
Foo,
On Tue, 5 Feb 2002, Manuel Bouyer wrote:
> On Tue, Feb 05, 2002 at 07:59:20AM -0700, Randy Arabie wrote:
> > On Mon, 4 Feb 2002, Randy Arabie wrote:
> >
> > > Right. Like this:
> > >
> > > mysql -u someuser -p -D somedatabase < ./data.sql
> > >
> > > No. I didn't raise the shell limits, I r
alter table your_table add unique index (path_id,word) ;
-Message d'origine-
De : Jon Shoberg [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 5 février 2002 16:40
À : [EMAIL PROTECTED]
Objet : Spam Filtered - Re: Making Unique Pairs ??
HUH ?
Oh well lets try again, please read below ...
SQ
Hi
The I have noticed that the number of Aborted Clients and Aborted
Connections has increased sharply recently on our two production
servers, but not on our development server.
Yesterday we started getting a number of blocked host errors, which we
had to clear up with flush hosts.
http://ww
HUH ?
Oh well lets try again, please read below ...
SQL = SELECT help FROM mysql.list WHERE spam NOT LIKE 'bounce%'
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in you
At 04:21 AM 2/5/2002 , you wrote:
>Dear all,
>Which of the following SQL queries is faster and better
>"select thefield from thetable group by thetable"
>Or
>"select distinct thefield from thetable"?
>and WHY?
>
>Best Regards
>Hayan
Hayan,
I believe the "Select Distinct.." gets translate
On Tue, Feb 05, 2002 at 07:59:20AM -0700, Randy Arabie wrote:
> On Mon, 4 Feb 2002, Randy Arabie wrote:
>
> > Right. Like this:
> >
> > mysql -u someuser -p -D somedatabase < ./data.sql
> >
> > No. I didn't raise the shell limits, I rose the kernel maxfiles and
> > the mysqld process proc.p
> On Mon, 4 Feb 2002, Manuel Bouyer wrote:
>
> > What a minute ... you're loading the tables to a 'mysqld' process, using
> > the 'mysql' command, rigth ?
> > Maybe it's just the mysql command which runs out of files descriptors ?
> > Did you try to raise the limit of the shell before starting i
Stuart,
Monday, February 04, 2002, 7:36:39 PM, you wrote:
SO> some stupid fool has deleted the mysql.sock file from our redhat server
SO> system. (me!)
SO> How do I regenerate one?
You should restart your MySQL server.
SO> thanks a mil
SO> StuartO
--
For technical support contracts, goto
Yes MySQL supports transaction.
But you have to use certain table types : for example InnoDB or BDB (and not
MyISAM).
I use InnoDB ; read the following section of the manual :
http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#I
nnoDB
it will tell you which options you may
Dear Members,
How can I get the no. of disk accesses & main memory used to execute a
particular query in mysql ?
Plz reply asap.
Thanx in advance.
Praveen Sirupa
-
Before posting, please check:
http://www.mysql.com/manual
On Tue, 2002-02-05 at 10:18, Vishakha Mali_Wagh wrote:
> Now I need to sort a field of varchar type. But the filed values are like...
> b1,b2,b3,b4,b5,b6,b7,b8,b9,b10,b11,b12
> meaning thereby, an integer prefixed by some character.
> Is there any straight way to frame the query?
OK, if the
On Tue, 2002-02-05 at 02:42, Joe Villari wrote:
> I'm hoping I can get some help here, I'm trying to get MySQL running
> on YellowDog Linux 2.4.17 kernel. I've installed the mysql,
> mysql-server and mysql-devel-3.23.32-1.7a rpms from my install CD.
> Ran mysql_install_db then changed the group
hi,
is mysql support transaction?
how to setup it?
please help
thx
felik
__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
-
Before
Dear Hayan,
> Which of the following SQL queries is faster and better
> "select thefield from thetable group by thetable"
> Or
> "select distinct thefield from thetable"?
> and WHY?
=if you use the MySQL command line to issue a query, a summary report follows any
output giving number of rows
a
Hello there,
I use MySQL (4.0.1) with InnoDB tables with binary logging on.
I see that the
BEGIN and COMMIT statements that wrap my queries are
not written to the binary log. I perfectly understand this if
I have one server. But assume I have a master server, and a
slave server that replicates
Erin,
Tuesday, February 05, 2002, 12:37:33 AM, you wrote:
EL> Hi, this is Erin Lilly, I've used support before with you all for
EL> bodyconsultant.com and you were extremely helpful. I'm installing mysql on
EL> erinlilly.net and have run into that common /tmp/mysql.sock (111) error
EL> version:
Kinney,
Monday, February 04, 2002, 9:06:45 PM, you wrote:
KB> Hi,
KB> I'm playing with PHP/MySQL for the first time having used Perl and MySQL
KB> for years.
KB> In one of my first update scripts, PHP is automatically escaping quotes and
KB> such, which I assumed was a good thing.
KB> However,
hi again,
Now I need to sort a field of varchar type. But the filed values are like...
b1,b2,b3,b4,b5,b6,b7,b8,b9,b10,b11,b12
meaning thereby, an integer prefixed by some character.
Is there any straight way to frame the query?
thanx in advance for your time,
regards,
-vishi
-
Dear all,
Which of the following SQL queries is faster and better
"select thefield from thetable group by thetable"
Or
"select distinct thefield from thetable"?
and WHY?
Best Regards
Hayan
Get your own "800" number
Voicemail, fax, email, and a l
On Mon, Feb 04, 2002 at 08:01:39PM -0700, Matthew Walker wrote:
> I need to find a text editor for Linux that doesn?t load the whole file
> into memory. I need to edit a 1.5 gig text flatfile to add two lines.
> But I don?t have enough ram to open it in most programs. Can anyone
> recommend someth
Hi,
What is the alternative in mysql for ROWNUM of Oracle?
Thanks,
Rama Raju
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Hi, all MySQL team
Thanks for your former help. Here is another question:
As MySQL support multiple instances, each instance will
run with different socket file and tcp/unix port number.
I want to know when using MySQL client programs like
mysqladmin to connect different instances, are both
socke
Oliver,
It's early in the morning over here, so that's my excuse for feeling confused...
> >> select FROM_UNIXTIME(UNIX_TIMESTAMP(),
> >> '%Y %D %M %h:%i:%s %x');
> >> UNIX_TIMESTAMP() returns the number of seconds since '1970-01-01
> 00:00:00' GMT
> >> Convert this to a dat
Hi,
We use
Red Hat Linux release 7.1 (Seawolf)
Kernel 2.4.3 on a 2-processor i686
Only around 5000 of the rows match out of the 58,000,000.
As I understand it, we do have single indexes on each of the columns.
Given the replies below, I feel that mysql is not getting the optimisation
correct.
That's a bit of a pain :) Any idea if this will be supported at some point?
Cheers, Neil
Victoria Reznichenko wrote:
> Neil,
>
> Monday, February 04, 2002, 6:00:18 PM, you wrote:
> NF> Hi,
>
> NF> Ideally I wish to keep all of my database files on a network drive
> NF> (X:\). Using WinMySQLAdmi
Dear Members,
How can I know the no. disk acesses and the main memory used to execute a
particular query in mysql ?
Plz mail me asap.
in anticipation
Praveen Sirupa
-
Before posting, please check:
http://www.mysql.com/ma
Hi!
You have not created an index on your foreign key. From
http://www.innodb.com/ibman.html :
...
An example:
CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id),
FOREIGN KEY (parent_id
Hi,
I work with a rel. 3.23.36 of MYSQL and I have found this problem:
I have two tables named t_payments and t_payment_lang; these are their
descriptions and data:
t_payments (description):
+-+---+--+-+-+
+
| Field | Type
Eric,
"Eric Mayers" wrote in message ...
>I have an application that stores a large (up to 6gb) database in an
>InnoDB table. I'm using an InnoDB table to have concurrent inserts and
>selects and to get beyond the 2gb limitation.
>
>I have to allow read-only remote database connections and canno
86 matches
Mail list logo
