On Thu, Mar 07, 2002 at 12:08:29AM -0500, Mr. Ozette Brown wrote:
>
> I'm in the process of converting all of my database tables from ISAM
> to MYISAM table format. I'll run the mysql_convert_table_format
> script which basically does an "Alter table". If during this
> conversion someone accesse
On Tue, Mar 05, 2002 at 12:13:25PM -0800, Jeremy Zawodny wrote:
> On Tue, Mar 05, 2002 at 09:19:35AM -0700, Sasha Pachev wrote:
> > On Tuesday 05 March 2002 01:17 am, Jeremy Zawodny wrote:
> > > When the machine is pounding away on updates (over 300/sec), it can
> > > take a long time to get a res
Wendell,
InnoDB writes a checksum to a database page when it is written to disk. If
the checksum does not correspond to the page contents when the page is read
back in, you get the below error. Below page 36819 in table
registrydb_tn/TBL_AllNames appears to be corrupt, like it says. The checksum
Today I migrated my system to RH7.1. I had been running mysql on Mandrake 7.2 but I
wanted to use the newer versions
which require kernel 2.4.x.
I experienced exactly the same problems as you with the RPM of mysql which came with
the RH distro. I looked at
everything and then some that had
I know how to inport a .sql file into mysql by using mysql -u username -p
password < filename.mysql(sql) but how do you import one that is made to go
into a database you already have created? Would the command by mysql -u
username -p password < dbname filename.sql(mysql)
Thanks,
Josiah Wallingfo
I'm in the process of converting all of my database tables from ISAM to
MYISAM table format. I'll run the mysql_convert_table_format script
which basically does an "Alter table". If during this conversion
someone accessed a web page which writes to the database (insert or
update), what will
On Wed, Mar 06, 2002 at 07:40:09PM -0800, Petro wrote:
[snip]
> We have 10 of the 3ware cards, and while the drive is GPLd and in
> the kernel, we have not been satisfied with the stability of the
> system
What were the stability problems?
> We haven't had a chance yet to qual t
I've been using MyISAM tables for a long time on a lot of machines and
(knock on wood) have basically never had a problem. Now though on a larger
server I decided we should use INNODB tables and am having problems. I
didn't realize until today that it's been 'crashing' and recovering
repeatedly fo
On Wed, Mar 06, 2002 at 04:11:30PM -0500, Theo Van Dinter wrote:
> On Wed, Mar 06, 2002 at 03:59:50PM -0500, Greg Freemyer wrote:
> > If you do get the 3Ware IDE RAID controller to work with XFS, please let me know.
> Works beautifully. Have RH7.2, XFS, LVM, and a 3Ware 7410 running the
> box tha
On Wednesday 06 March 2002 04:35 am, Michael Widenius wrote:
> Instead of disabling disk based temp tables, we could instead restrict the
> size of them which should be equally good. ?(By setting the disk size
> to 0 you would be able to disable them, but we should not recommend
> this setting).
Hi,
Im developing software using MySQL with DELPHI...
In my side, I use no ODBCODBC sucksit limits u from everything, so
if u plan to get it easy...then download the latest WINZEOS utility...a
component that exploit the use of TCP/IP connecting to your server...
goodluck
R.B.Roa
Tr
I've already installed MyODBC and configured the driver correctly
(accoriding a book I'm reading) at ODBC User DNS. But, when I run Database
Desktop and gonna make a "New Table" the option of MySQL does not appear
(according the book appear as show a figure).
Is there lefting something else?
Tha
Hi everyone,
I know some softwarehouses develop some components in orde to make esier
their project. So, folliwng the same steps I would lihe to do develop 4
component to make the 4 basisc operations in a DB:a INSERTER, UPDATER,
SELECTER and DROPPER.
Imagine the aplication has a class or an obje
With MySQL 3.23.38:
If you have a TIMESTAMP column with zero values, then
SELECT ts from table;
returns
00
But
SELECT min(ts) from table;
returns
0
This causes the JDBC driver to fall over when getting the timestamp value
from this query. Isn't this a formatting
Hi,
On Thu, 2002-03-07 at 08:20, bin cai wrote:
> I am encountering one problem. I am using mysql as the
> dabase for my application.
> I create a table like takeexam as following:create
> table takelabexam( sid varchar(10) not null,
> cid varchar(20) not null,
>
Doesn't version 4 support Unicode? - isn't this a solution or am I
missing something?
DA
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: 06 March 2002 14:48
To: [EMAIL PROTECTED]
Subject: Dual Languages??
bipin,
Wednesday, March 06, 2002, 9:56:53 AM,
To all: This is in response to a request for more information. I thought
others may find it useful.
> Thanks so much for your reply. It's good news to hear that
> someone is relying on MyODBC for an important purpose, much of the
> usage I've seen seemed rather small.
Like I said, we h
Christian,
> this is an obvious 'newbie' question, so please bare with me.
If you had ever seen me without my clothes on, you would not be asking
me to do this!
Pardon me for joking at the expense of your English, but I've seen this
wording/spelling so often on the lists...
Bare = unclothed.
Bea
Hi,
Trying to figure out how to convert Sybase ASA syntax to MySQL. Need to
select alpha ranges as in:
SELECT *
FROM table
WHERE name LIKE '[A-Z]%'
but this doesn't work.
Appreciate your help,
Erik Schwartz
Systems Engineer
InfoUSA
818-428-1040
[EMAIL PROTECTED]
---
Outgoing mail was sniffed
>
> Hello,
> I am encountering one problem. I am using mysql as
> the
> dabase for my application.
> I create a table like takeexam as following:create
> table takelabexam( sid varchar(10) not null,
> cid varchar(20) not null,
> marks integer
>
Im convertinga couple of fully functioning access databases to mysql,
however I had problems converting the data over using a number of tools
because of illegal characters especially a colon : in the table & column
names. Now I can change these names to import the data ok but all of the
queries &
Hello,
I am encountering one problem. I am using mysql as the
dabase for my application.
I create a table like takeexam as following:create
table takelabexam( sid varchar(10) not null,
cid varchar(20) not null,
marks integer
foreign
Also, I forgot these questions:
- What is Apache's http.conf value of MinSpareServers?
- What is Apache's http.conf value of MaxSpareServers?
Steven Roussey
Network54.com
sql,query
-
Before posting, please check:
http://w
If you can turn on the query log the amount of disk space it takes would be
well worth troubleshooting the problem.
Try and discern the last queries run on them, in order to help.
Perhaps do this twice and you could check for consitency. How much disk
space is in use on the drives related to it?
R
Anthony,
I'd be careful with the IDE Raid controller.
We just built a lab machine with a Promise IDE Raid controller and the assumption that
we could get it and XFS to co-exist.
I'm not doing the work, but the engineer that is tells me that the Promise Patch Kit
only works with a very limited
Hi Zengfa:
No. The operating system has nothing to do with it BUT there are
requirements for buying a license.
Visit http://www.mysql.com/support/arrangements.html for more details.
Thx,
Craig
At 12:17 3/6/02 -0800, you wrote:
>Hi,:
>
>I heard that when we use MySQL on windows, we need to
>p
All releases of MySQL were GPL'd, see article:
http://www.mysql.com/news/article-23.html
John
On Wednesday 06 March 2002 15:17, Zengfa Gao wrote:
> Hi,:
>
> I heard that when we use MySQL on windows, we need to
> pay fees. But I can't find anything on MySQL document
> to talk about this.
>
> Do
when you run mysqld -u root -p and it gives you the list of
default variables.
You can get this same message by typing mydqld --help, which might indicate
some error in the command line arguments.
This file also shows you configurations supplied on the command line as well
as configurations foun
At 16:10 2002-03-06, BadgerBay wrote:
>Hello,
>
>This is a good question for when you are sipping coffee or tea and are
>inspired to write some code. I require additional functionality for my SQL
>search:
>
>MY CURRENT SEARCH
>
>SELECT ID, Authors, Year, Title FROM libraryTable
>WHERE (Authors LIK
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#MySQL_server_licenses
On Wednesday 06 March 2002 1:17 pm, Zengfa Gao wrote:
> Hi,:
>
> I heard that when we use MySQL on windows, we need to
> pay fees. But I can't find anything on MySQL document
> to talk about this.
>
On Wednesday 06 March 2002 02:40 pm, Petro wrote:
> On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote:
> > Could someone, please, provide me with a link and/or facilitate some
> > suggestons for configuration of the following components for a new DB
> > server hosting MySQL 4.01MAX
Hi,:
I heard that when we use MySQL on windows, we need to
pay fees. But I can't find anything on MySQL document
to talk about this.
Do you know this problem?
Thanks a lot!
Zengfa
__
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest f
> When I execute mysqld -u root -p
> I am presented with the default variables.
Which are? How about showing what mysqld --user=root displays?
Also, you see linux-bin.* files? That indicates that mysqld was running
at some point (maybe nine times). Can you get the directory listings
with
ls
Sam Iam wrote:
>
> We have a very high volume site (3 million page views a day) that's run
> on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP with
> persistent connections. Each MySQL serves 8 web servers & is supposed to
> act as a failover machine for the other group of 8 web
Hi!
We have a fix for the problem that you have hit.
It is a temporary one. Final one will come in the nexe MySQL release:
*** tmp/libmysql.c Wed Mar 6 22:00:00 2002
--- tmp/fixed.c Wed Mar 6 21:59:34 2002
***
*** 737,743
*end=0;
Hello,
I am encountering one problem. I am using mysql as the
dabase for my application.
I create a table like takeexam as following:create
table takelabexam( sid varchar(10) not null,
cid varchar(20) not null,
marks integer
foreign
Hello,
In my application I would like to update a MySQL record where one
column
is the largest value. Do I have to create a separate SELECT sql query
statement
to get that value and then update it? Or, is there a function that
allows me to specify it as part of my WHERE clause. I scanned th
> We pay for MySQL support but haven't had much help from them.
You could pay me, I need work... :) Seriously...
> We have a very high volume site (3 million page views a day) that's
run
> on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP
with
> persistent connections. Each My
Fournier Jocelyn [Presence-PC] writes:
> I believe the problem occurs only when I execute the DELETE when someone is
> inserting a records at the same time.
> Perhaps the hash index is not updated properly whereas the data are deleted
> properly, which entails a mismatch between data and index ?
>
Perhaps you can create a function to serialize the array into text and
dump it into a blob in the DB, and have another field(s) with the data
you want to search on.. Then unserialize the array when you take it out.
-Original Message-
From: Hresko, Christian A. [mailto:[EMAIL PROTECTED]]
this is an obvious 'newbie' question, so please bare with me.
i'm parsing a lot of data from file, and a good deal of this data is in the
form of nested C structs. within any given struct, you might have an array
of 256 floats, or an array of 256 structs, with 256 floats, etc, etc.
i'd like to
On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote:
> Could someone, please, provide me with a link and/or facilitate some
> suggestons for configuration of the following components for a new DB server
> hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect
> "
We have a very high volume site (3 million page views a day) that's run
on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP with
persistent connections. Each MySQL serves 8 web servers & is supposed to
act as a failover machine for the other group of 8 web servers.
The failover
Victoria Reznichenko wrote:
> recu> small problem. I have a table set up like so. It has a number of entries
> recu> that were added on a certain date, I use TIMESTAMP to keep track of the date.
>
> recu> mysql> UPDATE deerfield SET version = '2.1' WHERE product = 'WinGate LITE';
>
> recu> and
Does anyone have any good tools for putting a trace on an MySql server. I
want to be able to see what is happening on the server.
Thanks,
Eddie
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On Wednesday 06 March 2002 01:37 pm, Ken Menzel wrote:
> http://www.mysql.com/doc/I/n/Installing_source_tree.html
Someone, replying earlier, mentioned that MySQL AB folks don't grant
permission to nightly stuff. I'll test it out, regardless.
Thank You,
Anthony
> - Original Message -
>
>
> MW> safe_mysqld --socket=/..path../mysql.socket.x --port=numberx &
>
> You may also add --datadir= ... to separate data directories.
>
Don't need to. Servers can work on the same datas.
( Obviously it is comon solution to separate)
> MW> and so on.
>
> "so on" - please, specify.
>
Ups. My eng
http://www.mysql.com/doc/I/n/Installing_source_tree.html
Ken
- Original Message -
From: "Anthony W. Marino" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 06, 2002 12:12 PM
Subject: MySQL Availability
> Where can I find most recent (ie; 4.0.2 builds ;Nightly/CVS) at?
The /var/lib/mysql contains the following files:
linux-bin.001
linux-bin.002
linux-bin.003
linux-bin.004
linux-bin.005
linux-bin.006
linux-bin.007
linux-bin.008
linux-bin.009
linux-bin.index
linux-bin.err
the directory mysql
the directory test
directory mysql contains
columns_priv.MYD
columns_p
Erminio Efisio Riezzo writes:
> Hello folks,
> I do not succeed to install the patch in order to compile the mysql++-1.7.9
> with the GCC-3.0.3.
> I use the command
>
> /usr/local/src/mysql++-1.7.9-patched# /usr/local/bin/patch -p0 -i
> mysql++-gcc-3.0.patch
>
>
> You can help me? Thanks in ad
Marek,
Wednesday, March 06, 2002, 4:19:28 PM, you wrote:
MW> (Debian 2.4.19, MySQL 3.23.49)
MW> I have problem with starting multiple servers on one machine.
MW> According documentation it is enough to start each another then first
MW> server using ex.:
MW> safe_mysqld --socket=/..path../mysql
> Starting mysqld daemon with databases from /var/lib/mysql
> 020305 17:46:10 mysqld ended
This is written by safe_mysqld. It seems that mysqld was never started
successfully. I've had this issue before. Every time it was a
permissions issue.
> > > When I execute mysqld -u root -p
> > > I am pr
"Ray" wrote:
>
> I have been going out of 'my' mind. I am trying to install mysql on a
> Macintosh OS X server. Can anyone give me instructions on how to do
> this? I have been to numerous sites with no luck. We run OS 10.1.2
> server, I have mySQL 3.23.49 running (from entropy). During the
> > deletes, and other) as is possible with the Com_ status variable
in
> > the later versions of MySQL (no documentation though..)?
>
> I've got a bunch of improvements planned now that I'm regularly using
> MySQL 4.x. Having all those counters is handy. :-)
The counters are in 3.23.47 as
mysql_row_seek().
On Wednesday 06 March 2002 10:26 am, JOUANNET, Rodolphe wrote:
> Can someone tell me how to find the previous record in C (with mySQL API
> function). I do a SELECT statement, read it with mysql_store_result(), read
> the first record with mysql_fetch_row(), the next record with
Hi.
I am using MySQL 3.23.44-max and InnoDB tables.
I also using foreign key in my tables.
I have problem, I couldn't alter my table and add any foreign keys.
SQL like this: alter table data_entry add FOREIGN KEY (data_task_id) REFERENCES
data_task(identity);
give me any error but key doesn't crea
Can someone tell me how to find the previous record in C (with mySQL API
function). I do a SELECT statement, read it with mysql_store_result(), read
the first record with mysql_fetch_row(), the next record with
mysql_fetch_row(), etc.. . But what about reading the previous record ?
(sorry for my
On Wed, 6 Mar 2002, Sergei Golubchik wrote:
> Hi!
>
> On Mar 06, Thomas Spahni wrote:
> >
> > My problems are: jokers appear not to work as expected in boolean
> > fulltext search ...
> >
> > mysql> SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('placi*' IN
> > BOOLEAN MODE);
> > Empty
hi,
the ncurses library is available as a solaris binary package at
sunfreeware, too. look for "ncurses-5.2".
Christopher Thompson wrote:
>
> This is not a MySQL question, it's a Solaris question. :) But anyway, you
> need to get and install ncurses (version 5). You can find more informati
Where can I find most recent (ie; 4.0.2 builds ;Nightly/CVS) at?
Thank You,
Anthony
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
gaouzief,
Wednesday, March 06, 2002, 6:28:01 PM, you wrote:
g> i get a strange "can't create table 'databasename\bigdata1.frm'
g> error 140" when i try to run the following create query:
g> DROP TABLE /*!32200 IF EXISTS*/ bigdata1;
g> CREATE TABLE /*!32300 IF NOT EXISTS*/ bigdata1 (
g> IDData
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
This is not a MySQL question, it's a Solaris question. :) But anyway, you
need to get and install ncurses (version 5). You can find more information
at:
http://www.gnu.org/software/ncurses/ncurses.html
On Wednesday 06 March 2002 8:57 am, Atif Faruqui wrote:
> Hello,
>
> I feel i am dea
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> gunzip < mysql-VERSION.tar.gz | tar -xvf -
shell> cd mysql-VERSION
shell> ./configure --prefix=/usr/local/mysql
Receiving message: ./configure: not found
Should this script be included in the unzipped directory. Or is it native
to t
Could someone, please, provide me with a link and/or facilitate some
suggestons for configuration of the following components for a new DB server
hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect
"THE" answer since all things are relative and I will have to further test
On Tuesday 05 March 2002 10:15 pm, Amit Lonkar wrote:
> hi
> Does Mysql support Transat SQL???
Assuming you mean Transact SQL, no. 'Transact SQL' is Microsoft's name for
their proprietary extensions to SQL. Only Microsoft SQL Server supports it.
But then again, MS SQL doesn't support MySQL's
hi
i get a strange "can't create table 'databasename\bigdata1.frm' error 140" when i try
to run the following create query:
DROP TABLE /*!32200 IF EXISTS*/ bigdata1;
CREATE TABLE /*!32300 IF NOT EXISTS*/ bigdata1 (
IDData bigint(20) unsigned NOT NULL auto_increment,
REFLang char(2) NOT NULL
Hello,
I feel i am dead in the water with this problem, it appears that
libncurses.so.5 is a linux library, i downloaded mysql-3.23.45
from sunfreeware and did pkgadd on it on Soalris 8 Sparc box, i was able to
start mysqld daemon and i can run mysqladmin commands but when i try to
connec
Does mysql jdbc driver support table quailified column names?
For example, this seems to work:
select id from people
But this doesn't:
select people.id from people.
Thanks.
Dave Ford
Smart Soft - The Developer Training Company
http://www.smart-soft.com
-
Thanks I have now five ways to try.
| Chuck Payne |
| Magi Design and Support |
| [EMAIL PROTECTED] |
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 10:43 AM
To
"Ireneusz Piasecki" <[EMAIL PROTECTED]> writes:
> Do you mean: You can forget upgrading on RH6.2 the glibc 2.1 to 2.2.
> Maybe one did it succesful, so now he has RH.6.2 with glibc 2.2.
> I still waiting for these persons.
Don't do it. You will do bad things to your system. If you want to
upgrad
I'm assuming your users arnt using a MySQL client directly to perform
the queries... And your using middleware like PHP or something.
So your PHP code can parse the users responses and then design your SQL
queries around your parsed data.
-Original Message-
From: BadgerBay [mailto:[EMAI
sorry. I made mistake. Cite should be like this:
" The MySQL RPMs are currently being built on a RedHat Version 6.2 system
but should work on other versions of Linux that support rpm and use
glibc." - from http://www.mysql.com/doc/L/i/Linux-RPM.html
I. Piasecki.
- Original Message -
If I create a temporary heap table from a select statement, does the new
table also inherit the indexes (indices?) from the original table. Or will
I have to add an index to the temporary table after it is created?
For example, if I use:
CREATE TEMPORARY TABLE tempstudents TYPE=HEAP SELECT s
At 7:46 -0500 3/6/02, Chuck \"PUP\" Payne wrote:
>Hi,
>
>I a seting up a php page that will let me delete a record from my mysql
>database, but I want it be able to match to fields before it will let a user
>delete that record. I know the basic sql command is
>
>DELETE FROM $table WHERE field
* Chuck "PUP" Payne
> I know the basic sql command is
>
> DELETE FROM $table WHERE field 1 = "$value"
>
> But I don't know how to write the state for a second field. Can some one
> tell, but one field seem to give too much choose and would make it to easy
> to delete the wrong record.
I think
Hello folks,
I do not succeed to install the patch in order to compile the mysql++-1.7.9
with the GCC-3.0.3.
I use the command
/usr/local/src/mysql++-1.7.9-patched# /usr/local/bin/patch -p0 -i
mysql++-gcc-3.0.patch
but the output is:
can't find file to patch at input line 17
Perhaps you used t
Hi.
Yopu wrote.
>You can find info about MySQL installation on Linux if you check
> the following links:
> http://www.mysql.com/doc/L/i/Linux-RPM.html
> http://www.mysql.com/doc/L/i/Linux.html
>
The section: linux-rpm.html it seems to bee out of date:
" The MySQL RPMs are cu
Hello,
This is a good question for when you are sipping coffee or tea and are
inspired to write some code. I require additional functionality for my SQL
search:
MY CURRENT SEARCH
SELECT ID, Authors, Year, Title FROM libraryTable
WHERE (Authors LIKE '%" + varAuthor + "%')
OR (Keywords LIKE '%" +
Yes thank you for these links. I have already read the documentation as
the first thing I did. The second thing I did was recompile. The third
thing I did was subscribe to the list.
I can write a php script like this:
I will run this. A lot of the time I wont get anything to the screen.
Oth
*mysql, to please stupid filter*
On Wed, 6 Mar 2002, Trond Eivind Glomsrød wrote:
> On Wed, 6 Mar 2002, Ireneusz Piasecki wrote:
>
> > Hi.
> > I have following rpm packages from redhat.com:
> > glibc-2.2.2-10.i386.rpm
> > glibc-2.2.2-10.i686.rpm
> > compat-glibc-6.2-2.1.3.2.i386.rpm
> > glibc-c
rob,
Wednesday, March 06, 2002, 2:19:01 PM, you wrote:
recu> small problem. I have a table set up like so. It has a number of entries
recu> that were added on a certain date, I use TIMESTAMP to keep track of the date.
recu> +-+---+--+-+-+--
Stephan,
Wednesday, March 06, 2002, 1:24:37 PM, you wrote:
SB> We are running a mysql database version 3.22.32.
SB> I have an simple table:
SB> id, int(10) unsigned, PRI, default 0, auto_increment
SB> usernummer, int(10) unsigned, default 0
SB> productcode, char(10), default ''
SB> monat, tinyin
Amit,
Wednesday, March 06, 2002, 6:38:30 AM, you wrote:
AL> What I want to do is import data from some other
AL> database to Mysql. For this the requirement is that,
AL> each record before being added to Mysql database,
AL> should pass through a loop say 5 times. This I want to
AL> do using only
Elissa,
Wednesday, March 06, 2002, 6:44:26 AM, you wrote:
E> I'm a newie to SQL, and to Linux, so please forgive my blaring blunders...
E> I know I have an x86 Linux machine, running Redhat 7.2, and I know that I
E> like RPMs better than binary installations
E> When I get to the Stable Ve
bipin,
Wednesday, March 06, 2002, 9:56:53 AM, you wrote:
bvc> I have a requirement of storing and retrieving data in 2 languages - namely
English and Arabic.
bvc> From what I have been able to understand, that would require me to have 2 MySQL
servers running simultaneously.
bvc> Can somebody
Adam,
Tuesday, March 05, 2002, 10:14:28 PM, you wrote:
A> I have compiled/rebuilt the MySQL 3.23.49 Source RPM under kernel
A> 2.4.17, and glibc 2.1.
A> Using gcc version 2.95.4 20010319 (prerelease). I had 2.96 on there and
A> headed the warnings and downgraded to 2.95.
A> Randomly I get the
When I grant privileges as follows, the slave gets updated:
GRANT FILE ON *.* to repl@'%' identified by 'some_password';
Could someone please tell me why I must grant the FILE privilege on all
databases for the repl (slave) to be able to update one particular database?
Thanks everyone.
Thi
--
Hi
I am running Mysql-3.23.38 on Slackware 8 with Kernel-2.4.17.
This morning I suddenly had a problem where when I start Mysql server at
startup it uses all cpu available and the machine freezes. To fix the
problem I had to remove the complete installation and install mysql from
scratch. Anyo
Dear group.
(Debian 2.4.19, MySQL 3.23.49)
I have problem with starting multiple servers on one machine.
According documentation it is enough to start each another then first
server using ex.:
safe_mysqld --socket=/..path../mysql.socket.x --port=numberx &
and so on.
And this is enough when th
try running safe_mysqld without any options
I wouldn't know why you would need to specify a user name to start the
daemon
-Original Message-
From: Intrex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 5:55 AM
To: [EMAIL PROTECTED]; 'Mysql'
Subject: Re: mysql on Linux
I know
Yes, I did flush the privileges when nothing else worked but that didn't do
the trick either. Thanks for trying.
-Original Message-
From: James Housley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 6:00 PM
To: Thi Cao
Cc: MySQL
Subject: Re: MySQL Database Replication
Thi Cao
Please ignore my original message. I was finally able to get it to work
using:
CC=gcc CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors
-fno-exceptions -fno-rtti" ./configure
--prefix=/usr/local/mysql-3.23.49
--with-low-memory --enable-assembler
Duncan
--
Duncan Salada | Titan |
Hi!
On Mar 06, Thomas Spahni wrote:
> Dear listmembers
>
> My problems are: jokers appear not to work as expected in boolean
> fulltext search and I can't figure out how to order results according to
> any relevance. I need someone to point me into the right direction.
>
> According to the Very
Maybe not. MySQL won't auto-maintain a date field.
I can't count the number of times that some unanticipated issue was solved
through having separate modifydate and createdate fields, with the
modifydate being maintained by MySQL (which means that I don't have to worry
about it going out of sync
Hello all,
I am having some problems with installing 3.23.49 from source. Below is the
output from mysqlbug with my additions to help explain the problem. Any
help would be great - my experience with this kind of stuff is not that
great.
>Description:
I am trying to upgrade from 3.20.3
Dear Sirs and Madams,
EMS HiTech company is announcing the next version (1.65) of MySQL
Manager -- A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
What's new in version 1.65
Hi,
I a seting up a php page that will let me delete a record from my mysql
database, but I want it be able to match to fields before it will let a user
delete that record. I know the basic sql command is
DELETE FROM $table WHERE field 1 = "$value"
But I don't know how to write the state fo
Dear listmembers
My problems are: jokers appear not to work as expected in boolean
fulltext search and I can't figure out how to order results according to
any relevance. I need someone to point me into the right direction.
I run MySQL 4.0.1:
> mysqladmin version
mysqladmin Ver 8.23 Distrib 4.
"[EMAIL PROTECTED]" wrote:
>
> Hi,
>
> small problem. I have a table set up like so. It has a number of entries
> that were added on a certain date, I use TIMESTAMP to keep track of the date.
>
> +-+---+--+-+-+--
> --+
> | Field
1 - 100 of 114 matches
Mail list logo
