Hey there!..Don!
The Problemo returns! :(
Let me be explicit this time with my query :
#1
mysql desc table A;
+-+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---+
| mId |
Hi
I have some problem with my OS system (DEC 0.4) when I ran commad
# CC=gcc CXX=gcc CXXFLAGS=-O3 ./configure --prefix=/usr/local/etc/mysql-3.23.39
error is
CC=gcc: Command not found.
Ummm I think it maybe not error of mysql but please help me to fix this error.
Thank
Hi
I have some problem with my OS system (DEC 0.4) when I ran commad
# CC=gcc CXX=gcc CXXFLAGS=-O3 ./configure
--prefix=/usr/local/etc/mysql-3.23.39
error is
CC=gcc: Command not found.
Ummm I think it maybe not error of mysql but please help me to fix
this error.
Thank
This is not a mysql error, Your paths are setup incorrectly or you
don't have GCC installed, set the environment variable `CC' to the
location of your gcc compiler,
CC=something; export CC
KFC wrote:
Hi
I have some problem with my OS system (DEC 0.4) when I ran commad
# CC=gcc
I tried to connect to my mysql server but there was
always an error message saying this host is not
allowed.
Anybody so kind to tell me, how can I define the
hostname/computer name in my mysql server to be
allowed connect to my database server and use my
kmysqladmin and kmysql software.
Thanks
On Mon, Jul 09, 2001 at 01:11:44AM -0700, Prabu Subroto wrote:
I tried to connect to my mysql server but there was always an error
message saying this host is not allowed. Anybody so kind to tell
me, how can I define the hostname/computer name in my mysql server
to be allowed connect to my
We have made up our mind to turn our Access 2000 database into a MySGL one.
Could you please explain us the path to follow and give us information about
it ?
Dominique Vellin
Business developement
Azentis Technology
Your Outsourcing Provider
Tel : 33 1 42 77 21 02
Hi,
is possible to create a mysql without tcp connection ???
i don't need connect via tcp only via unix socket (only from
localhost)
Michal Dvoracek[EMAIL PROTECTED]
-
Before posting, please
Have you filled out the tables
user, db
in mysql.
And after filling this tables
you must start mysqladmin reload.
Regards Gerlinde
At 01:11 09.07.01 -0700, Prabu Subroto wrote:
I tried to connect to my mysql server but there was
always an error message saying this host is not
allowed.
Anybody
I use Delphi 5 and MyODBC to access a MySQL database.
In my program, I've sometimes a tables locked and I don't understand why
! I am the only user on this database and I change records correctly (as I
do it for other programs on other databases).
Does somebody have this problem ?
Can you
Hi,
I wonder I someone can give me some advice about the following situation. I
have to install MySQL to be used with a website on a virtual server. This
gives the following restraints:
* MySQL must be installed in my user directory
/usr/local/WWW/www.mydomain.com/mysql
* I am only allowed to
Hi
I have error after use make command like this:# makeNo suffix list.cd include; make link_sourcesNo suffix list./sbin/cp ../config.h my_config.hecho timestamp linked_include_sourcescd libmysql; make link_sources.
(more output - you can see more details in attach file)
echo timestamp
After you've filled the user and db tables in the mysql database, just give
the command
mysql flush privileges;
The privileges will be reread. It's easier if you're tuning the whole story.
GRTNX,
Ton Geurts
-Oorspronkelijk bericht-
Van: Gerlinde Fischer [mailto:[EMAIL PROTECTED]]
On Mon, Jul 09, 2001 at 10:44:24AM +0100, Dvoøáèek Michal wrote:
Hi,
is possible to create a mysql without tcp connection ??? i don't
need connect via tcp only via unix socket (only from localhost)
I believe the --skip-networking option does just that.
Jeremy
--
Jeremy D. Zawodny, [EMAIL
You could store the data as XML and use XSL to transform it when you pull it
out of the database
-Original Message-
From: Chris Lott [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 08, 2001 7:39 PM
To: MySQL List (E-mail)
Subject: Storing multi-page texts
What kind of methods have any
Hi
I have error after make command like
# make
No suffix list.
cd include; make link_sources
No suffix list.
/sbin/cp ../config.h my_config.h
echo timestamp linked_include_sources
cd libmysql; make link_sources
(more output)
+ /sbin/ln -s ../libmysql/violite.c ./violite.c
echo
On 09-Jul-01 Asha Ramaiah wrote:
Hey there!..Don!
The Problemo returns! :(
Let me be explicit this time with my query :
mysql select * from table A;
+-++
| mId | tId |
+-++
| 1 | 1 |
| 2 | 1 |
| 2 |
I also think that is something with php , because i was checking the code on
my computer on windows with apache, php and mysql installed and it didn't
propmt such errors. I also have another database put on another server, but
the code thats providing data is on the same server where the first
Heikki Tuuri writes:
Hi!
Sun is shining and the weather is excellent in Helsinki :).
I will be on vacation July 9th to July 16th. I will read email
a couple of times.
Regards,
Heikki Tuuri
Innobase Oy
Have a nice vacation !!
--
Regards,
__ ___ ___ __
/ |/
Have a look
http://www.mysql.com/doc/R/e/Replication_Implementation.htmlat
It is all about what you would like to do.
Simon
-Original Message-
From: chen jun [mailto:[EMAIL PROTECTED]]
Sent: 09 July 2001 10:52
To: [EMAIL PROTECTED]
Subject: Need your helps!!!
Hi There:
I
Werner Stuerenburg writes:
_
Win98 4.10.98, AMD Duron, 128 MB RAM
MySQL 3.23.39 running on localhost
_
Query is
DELETE FROM staticStrings
WHERE ruri LIKE
Hi.
I have problems with MyODBC. I would like to use MyODBC with MonitorPRO
software.
During reading data from MySQL I got error: "SQLBindParameter not used for
all parameters...".
I CAN'T change MonitorPRO software code - I need help with configuring
MyODBC or another dirver (for Win NT).
No. That link is about one way Replication. A main server with backup
servers and if the main server dies, a backup can take over.
What was asked was if any one server is updated, all others are updated.
I'm also interested but I very much doubt it can be done because there is
nothing in the
The above behavour can be caused by corrupted table. If however, the
above DELETE always crashes our latest 3.23.39 binary, you should
prepare a repeatable test case and send it to [EMAIL PROTECTED]
Sorry, the bug was not about MySQL, but WinMySQLadmin 1.1
Write in the mail that you
Werner Stuerenburg writes:
prepare a repeatable test case and send it to [EMAIL PROTECTED]
Sorry, the bug was not about MySQL, but WinMySQLadmin 1.1
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683
It can be done but there are a lot of problems with keeping the data in both
or more data bases in line with each other.
But this should be part of the V4 release.
Simon
-Original Message-
From: Rolf Hopkins [mailto:[EMAIL PROTECTED]]
Sent: 09 July 2001 11:34
To: Simon Green;
The error : Server has gone away ...
is not WinMySQLAdmin error, but error on the server side.
True, but WinMySQLAdmin should not crash with a GPF, right? Or is
that an expected behaviour, even a feature?
--
Herzlich
Werner Stuerenburg
No. That link is about one way Replication. A main server with backup
servers and if the main server dies, a backup can take over.
What was asked was if any one server is updated, all others are updated.
I'm also interested but I very much doubt it can be done because there is
nothing in the
What do you send to MySQL? $query is just a string.
Sie schrieben am Montag, 9. Juli 2001, 12:45:48:
MySQL pops out a error message - "unable to save result set in example.php
on line xxx"
but the data gets put inside the database anyway...
Why should php try to save something into a file?
Werner Stuerenburg writes:
The error : Server has gone away ...
is not WinMySQLAdmin error, but error on the server side.
True, but WinMySQLAdmin should not crash with a GPF, right? Or is
that an expected behaviour, even a feature?
--
Herzlich
Werner Stuerenburg
What do you send to MySQL? $query is just a string.
well i send to you only a part of code, here is complete example of it:
[the login stuff]
$zapytanie = "INSERT INTO aktualnosci SET tytul='$tytul', przemd='$przemd',
przeml='$przeml', przemm='$przemm', polska='$polska', swiat='$swiat',
Hello,
we are running a mysql-3.23-39 server under Suse 7.1 which has to do a very
high number of insert-queries (somewhere around 600 queries/minute).
But since yesterday the server kepps on spawing processes which are
reported to belong to Unauthenticated user and in state Login. This
This is more like what we want to see and pointing us to which line causes
the error would help even more. But from this, you're mixing up your INSERT
and UPDATE statements for starters. What you have would be correct if you
replaced INSERT INTO with UPDATE. For INSERT, it is a comma delimited
The php code looks ok. What do you have in line xxx in example.php?
Usually, this is the key to the error. I never saw such an error
message, so I would like to see what php is supposed to do in
that line.
For spam filter usage: table
--
Herzlich
Werner Stuerenburg
Yes, looks like you're right, which means that the Introduction and Overview
chapters of Replication need to be reviewed as it gives the impression that
it can't be done.
- Original Message -
From: Simon Green [EMAIL PROTECTED]
To: 'Rolf Hopkins' [EMAIL PROTECTED]; Simon Green
[EMAIL
On 09-Jul-01 Mario Witte wrote:
Hello,
we are running a mysql-3.23-39 server under Suse 7.1 which has to do a very
high number of insert-queries (somewhere around 600 queries/minute).
But since yesterday the server kepps on spawing processes which are
reported to belong to
How do I build an SQL query which returns rows based on whether or
not strings in a column contain more than one word
eg.
SELECT name
FROM contacts
WHERE WORD COUNT(name)1
I am aware that such a query is bogus but it seems as if there must
be a straightforward way of doing this.
thanks
Anoop K Gupta wrote:
Hi,
I am first time user of MySQL.
My ISP has just been installed mysql...
I have connected to server through telnet and
access MySQL by following command.. and connected
successfully.
mysql -h myhostname -u root -p
password :-
mysq
If you are telnetted
Hi everybody
I am still having problem.. please help.
My ISP just had installed MySQL on remote Linux server.
I am able to connect to my remote mysql server
but fail to create, user any database ...
I let you know step by step.. what I have done
1. First I have connected to my remote server
Where do I find a complete documentation of all options and entries in my.cnf
and the mysqld start options? I searched the mysql.com site, but to no avail.
Neither does the online documentation doesn't seem to have a chapter on it.
s.m.
Qualimedic AG
Sascha
It's not real easy to find but it is in the manual at www.mysql.com.
It would be nice to have a chapter in the manual dedicated to the cnf file
both server and user. detailing each property that can be set there and what
it means.
Cal
*
* Cal Evans
* Senior Internet Dreamer
*
The path to the socket must be radable and searchable by the world.
The socket itself must be world writable.
Roberto Carlos Sánchez Barroso wrote:
I´ve already installed mysql, but i can only connect via TCP/IP, and
i can´t do it by socket. I´ve got all the permissions rigth and the
How about:
select position(' ' IN name) as fs from contacts having fs0;
On Mon, 9 Jul 2001, Tommy Beavitt wrote:
How do I build an SQL query which returns rows based on whether or
not strings in a column contain more than one word
eg.
SELECT name
FROM contacts
WHERE WORD
Cordialement,
We have made up our mind to turn our Access 2000 database into a MySGL one.
Could you please explain us the path to follow and give us information about
it ?
Dominique Vellin
Business developement
Azentis Technology
Your Outsourcing Provider
Tel : 33
You are going to have to write something to translate. I recently did a DBF
to MySQL migration. I wrote programs in Visual FoxPro to create .SQL files.
These files created the needed structure in MySQL and then did a butt-load
of insert's to populate the tables.
YMMV but it worked for me.
Cal
Hi, Renaming of the database is on the TODO list. Some comments
follow.
1) Renaming of the directory will work for table types of MyISAM and
BDB (with exceptions). This won't work for InnoDB types.
2) When renaming a directory make sure to shutdown the server and that
you have no pending
Hello,
I'm getting the error message above whenever I try to connect from a remote
host to a MySQL server. I issue the following command:
mysql --host=host_name -u user_name -ppass_word
and get the ERROR 2013 back as a response.
We have two servers, both running MySQL. I get the same message
on 7/9/01 8:07 AM, Anoop K Gupta at [EMAIL PROTECTED] wrote:
2. mysql -h mydomainname -u root -p
it prompts for password : it is blank so I just pressed enter. and Mysql
prompt appeared..
if there is no password, you don't need the -p switch
-- mike cullerton
Ton Geurts wrote:
Hi,
I wonder I someone can give me some advice about the following situation. I
have to install MySQL to be used with a website on a virtual server. This
gives the following restraints:
* MySQL must be installed in my user directory
Try looking for phpMyAdmin:
phpMyAdmin is intended to handle the
adminstration of MySQL over the web. Currently it can:
create and drop databases
create, copy, drop and alter tables
Bonjour Matthieu,
I would also suggest installing MyODBC (from the downloads page).
The you can just use SQL to create and populate new tables by setting
up an database through ODBC.
En autre si tu as l'intérêt il y a une liste de MySQL francophone à :
S'abonner: [EMAIL PROTECTED]
You find a list of converters on page
http://www.mysql.com/downloads/contrib.html#SEC596
for example
dbf2mysql-1.14.tar.gz Convert between `.dbf' files and MySQL
tables
exportsql.txt A script that is similar to access_to_mysql.txt,
except that this one is fully configurable, has better type
Hello ,
I meet in share ver. of MySQL different lang. driver but no where
UKRAINIAN.
AND now I ask - I wont translete errmsg.txt and errmsg.sys for
UKRAINIAN lang?
Waiting for ansver!
--
Best regards,
suh mailto:[EMAIL PROTECTED]
Hello,
I have a Question,
1. In which directory i can find the config file to config the log file
2. Where can i find the log file for mysql?
regards,
\\|//
(@ @)
---oOO---(_)---OOo
)(
( Krishna
Hi!
My problem is when I use group by concat(col1,col2) when col1 and col2
is primary keys and col1 is varchar(255):
SELECT col1,col2 FROM Table1 GROUP BY concat(col1,col2);
- return only one row - it is bad
SELECT col1,col2 FROM Table1 GROUP BY concat(col1,col1,col2);
- return 48 rows - it
Don't use the RPM in the 7.0 CD.
Roberto Carlos Sánchez Barroso wrote:
If somebody could help to, this is the message that is shown in the
/va//lib/mysql/[domain server name].err
010704 11:07:58 mysqld started
010704 11:07:58 /usr/libexec/mysqld: Table
Hi,
I need to create a table that have field names 'LEFT' and 'RIGHT'. I have tried the
following but it doesn't work:
CREATE TABLE WI_POSITION (
PICTUREFILE VARCHAR(200) NOT NULL,
PICFILEXT VARCHAR(5),
POSITIONNOVARCHAR(10) NOT NULL,
SEQUENCENOVARCHAR(3),
Thats a REALLY old version.
Jon Brookes wrote:
Hi,
I have been using mysql fine on a win32 box.. but have now also installed it on
Linux box. The version details are below:
Red Hat Linux release 6.0 (Hedwig)
Kernel 2.2.5-15smp
I am using this version of mySQL:
mysqladmin Ver
Bradley Jenkins wrote:
i get this error when starting MySQL
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
/var/lib/mysql/mysql.sock exists with srwxrwxrwx and user mysql.
I /var/lib/mysql at least mode 755?
Brad.
For Unix /etc/my.cnf
you then in the my.cnf say were you would like the logs!
Simon
-Original Message-
From: Krishna M [mailto:[EMAIL PROTECTED]]
Sent: 09 July 2001 16:27
To: [EMAIL PROTECTED]
Subject: Log files
Hello,
I have a Question,
1. In which directory i can
1. In which directory i can find the config file to config the log file
2. Where can i find the log file for mysql?
The log file will be in the data directory. In my case:
/usr/local/mysql/var
It has ending .err
You can place my.cnf in this dir also and some other places.
i read somewhere that in version 4. or whatever one of the next versions
will be, that they are talking about doing the ability for bi-directional
replication. i have been trying to do the same thing
- Original Message -
From: Rolf Hopkins [EMAIL PROTECTED]
To: Simon Green [EMAIL
I had a similar problem recently. Try checking the /etc/hosts file to see if
the hosts/IPs are matching the current config.
Regards,
Milos Rackov
-Original Message-
From: Kurt Hansen [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 4:58 PM
To: [EMAIL PROTECTED]
Subject: ERROR
I experience heavy trouble with a few tables and look for the
cause for some time without finding out anything. I'm not ready
to construct a bug report, though.
Now I migrated these 3 tables from ISAM to MYISAM, so that I can
CHECK TABLE from within the program and do a REPAIR TABLE when
I need to create a table that have field names 'LEFT' and 'RIGHT'. I have tried the
following but it doesn't work:
See http://www.mysql.com/doc/R/e/Reserved_words.html
Hint: use another laguage. In German, it is links and rechts for
left and richt.
--
Herzlich
Werner Stuerenburg
Hi Milos,
Thanks for responding!
I had updated the /etc/hosts files already, but went and checked it after
getting your message. Still no luck.
Any other troubleshooting clues?
Thanks!
Kurt Hansen
[EMAIL PROTECTED]
- Original Message -
From: Milos Rackov [EMAIL PROTECTED]
To: Kurt
JJ I need to create a table that have field names 'LEFT' and
JJ 'RIGHT'. I have tried the following but it doesn't work:
JJ [..skip..]
JJ But nothing works. How should I do?
Rename 'left' and 'right' to something else. They are reserved words.
--
Hello
On Tue, 19 Jun 2001, Sasha Pachev wrote:
If you have a spare development system, plug in 4.0 binary and try
to run your applications on it to see if it will crash.
I just tried it on Debian GNU/Linux for i386 with up-to-date testing
distro and up-to-date bk clone. The compile process
Hi everyone,
Replication has been working OK for me for the last month or
with mysql 3.23.38, however following a crash I am having a lot of problems.
This is happening constantly: replication will work for a while
and then stop with the following:
mysql show slave status;
| Master_Host
Hi
Is it possible to import a complete database from a server to another
one?
Thanks
Eugénio
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Easy as can be: for example
mysqld -O max_allowed_packet=2M
Alas, it does not. It shows a couple of variable settings, but not the syntax
for tha various logging options and the like. So the question for a complete
options syntax of my.cnf remains open.
--
Herzlich
Werner Stuerenburg
For example if I want a copy of products named products1?
Sincerely Victor
query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Hi
Please visit the following link for the work around solution, else you can wait
till the next release version of the MyODBC.
http://lists.mysql.com/cgi-ez/ezmlm-cgi?9:mss:10849:200106:lglmnlcggpoehpijkfol
Hope this helps you.
Best Regards
Venu Anuganti
Mateusz Rudyk wrote:
Hi.
I have
I changed IP numbers on the Cobalt RAQ i have mysql on. I no longer have
access to the databases. I think i have lost access as root. Is there a
way to restore the root user password and/or change it to something else
manually? I have many websites with many 'access denied' errors.
Any help
For example if I want a copy of products named products1?
Sincerely Victor
query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
mysqldump databasename | gzip databasename.sql.gz
transfer that file to the other server
mysqladmin create databasename
zcat databasename.sql.gz | mysql databasename
Hi
Is it possible to import a complete database from a server to another
one?
Thanks
Eugénio
At 10:33 AM 7/9/01 +0200, Dominique Vellin wrote:
We have made up our mind to turn our Access 2000 database into a MySGL one.
Could you please explain us the path to follow and give us information about
it ?
Dominique Vellin
Business developement
I don't know how much this will help, but I've
If both are using mySql, just use mysqldump to dump to a file and then
import it from the file.
It might be fun, just for grins and giggles to:
mysqldump databasename mysql newDatabaseName
and see if that works.
Obligatory warning: if you do this and it trashes your server and wrecks
your car,
mysqldump products products.sql
grep s/products/products1/ products.sql products1.sql
mysql products1.sql
Assuming that nothing else in the database is named products. (i.e. you
don't have any fields or tables named products) If you did have fields or
tables, you would most likely have to
We saw a problem simlar to this caused by a browser add-on.
I believe flyswat was behind it, but it was that quickclick
browser add on that one of the tv networks is pushing.
Mike
On Wed, 4 Jul 2001 11:27:24 -0500
Rob Donat [EMAIL PROTECTED] wrote:
Thanks for the note, I will determine if
Is there a way to update random records?
I have a database of 5.6 million records and I want to pull out 5000
records and mark a field in the database that I've pulled these so that I
don't pull the same 5000 again.
I know I can select the records by doing:
SELECT * FROM 5600k WHERE picked IS
copy a table:
mysqldump database table_name table.sql
or to copy the whole db:
mysqldump database db.sql
- Original Message -
From: Victor Spång Arthursson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 09, 2001 12:51 PM
Subject: Easiest way to create a duplicate of a db?
I recently downloaded the latest MYSQL version 2.23.39a (from page
http://www.mysql.com/downloads/mysql-3.23.39a.zip), and installed it as
directed by the instructions:
* install directory: c:/mysql,
* datadir: c:/mysql/data,
* and created the config file: c:/my.cnf (see
Cal Evans wrote:
If both are using mySql, just use mysqldump to dump to a file and then
import it from the file.
It might be fun, just for grins and giggles to:
mysqldump databasename mysql newDatabaseName
That should be:
mysqladmin create newDatabaseName
mysqldump --opt databasename |
On 09-Jul-01 Daren Cotter wrote:
I have two fields, sex, and age, which are both ENUM types. I'm building
some statistical reports, using stuff like:
DISTINCT(sex) ... GROUP BY sex ...
and
DISTINCT(age) ... GROUP BY age ...
Now I want a report that shows me a breakdown by both
At 6:41 PM +0200 7/9/01, Sascha Mantscheff wrote:
Alas, it does not. It shows a couple of variable settings, but not the syntax
Something that may be of help are the sample .cnf files that are included in:
/usr/local/share/mysql/
(on my system at least)
Look for my-small.cnf, my-big.cnf,
Title: Blank
I have found a large number of files which
have names like this
www-bin.040 www-bin.041
www-bin.042 www-bin.043
www-bin.044
which are using up huge amounts of disk
space on my server.
It looks to me like they are logs all of the
queries that are run with a certain
At 5:10 PM +0200 7/9/01, Werner Stuerenburg wrote:
It's so easy, you won't think of it: start mysqld with parameter
-h (=help):
mysqld -h
shows all parameters and current settings
Isn't that:
mysqladmin variables
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services |||
I don't think this will work as you expect. You will have to mark
those that you picked from those you haven't picked (and marked)
before.
SELECT * FROM 5600k WHERE picked IS NULL ORDER BY rand() LIMIT 5000;
But what I really want to do is:
UPDATE 5600k SET picked=1 WHERE picked IS NULL
Hi,
I wanted to take a union of two SQL queries for one of the front end
screen. I searched help documents for UNION and did not find much. Do
MySQL support UNION SQL statement?
Thanks,
Nutan Pandit
Attronica Computers, Inc.
301-212-1355 (Ext 254)
We do a few large daily and monthly downloads from an Oracle database
server. Is there a way to exclude these specific queries from the
update/binary log??
-
Before posting, please check:
http://www.mysql.com/manual.php
On Monday 09 July 2001 10:51, Tibor Simko wrote:
Hello
On Tue, 19 Jun 2001, Sasha Pachev wrote:
If you have a spare development system, plug in 4.0 binary and try
to run your applications on it to see if it will crash.
I just tried it on Debian GNU/Linux for i386 with up-to-date
On 08-Jul-01 Jeremy Zawodny wrote:
mytop - a `top' clone for MySQL
http://public.yahoo.com/~jzawodn/mytop/
Thanks Jeremy, been using 0.5 (FreeBSD ports).
I've got a couple of spare hours coming up, mind if i take
a whack at getting [mytop] into the my.cnf(s) files ?
Regards,
--
Don
On Mon, Jul 09, 2001 at 04:03:00PM -0500, Don Read wrote:
On 08-Jul-01 Jeremy Zawodny wrote:
mytop - a `top' clone for MySQL
http://public.yahoo.com/~jzawodn/mytop/
Thanks Jeremy, been using 0.5 (FreeBSD ports).
Oh, yeah. I forgot that someone made a port for it. Cool. :-)
Hi,
I am pretty new to mySql. (In fact just built a
databse and started working on it).
I want to do keyword search on a column (clob). It
may contain millions of records. How do I write query
so that it is efficient.
Thanks in advance for your time,
Puru.
Done, an email is now sent after an order is submitted. This is what it
I have found a large number of files which have names like this
www-bin.040
www-bin.041
www-bin.042
www-bin.043
www-bin.044
which are using up huge amounts of disk space on my server.
It looks
We do a few large daily and monthly downloads from an Oracle database
server. Is there a way to exclude these specific queries from the
update/binary log??
If the queries only affect one table or database, use the replication ignore
options listed here:
sorry im a mysql newbie...how do you bind mysql to two particular ip
addresses? i have it bound to my loopback but would like to bind it a
private ip but it doesn't seem to like the bind-address directive
more than once.
Run two separate mysql daemons with a different --bind-address
http://www.mysql.com/udmsearch/search.php?q=UNION
finds 31 documents
Sie schrieben am Montag, 9. Juli 2001, 22:17:49:
Hi,
I wanted to take a union of two SQL queries for one of the front end
screen. I searched help documents for UNION and did not find much. Do
MySQL support UNION
On Mon, Jul 09, 2001 at 03:18:14PM -0600, Chris Bolt wrote:
We do a few large daily and monthly downloads from an Oracle database
server. Is there a way to exclude these specific queries from the
update/binary log??
If the queries only affect one table or database, use the
replication
1 - 100 of 135 matches
Mail list logo