Running 4.0.20-standard-log on Fedora Core 1 on two boxes. Running with a
largely untouched my-huge.cnf - innodb configs uncommented.
Followed
http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.html
to setup replication. On the master I see:
mysql> show master status;
+-+
On May 27, 2004, at 11:16 PM, Jake Johnson wrote:
I was wondering when or will views be supported?
http://dev.mysql.com/doc/mysql/en/ANSI_diff_Views.html
-- greg willits
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PR
Hello,
I was wondering when or will views be supported?
--
Jake Johnson
http://www.plutoid.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On May 27, 2004, at 10:17 PM, mos wrote:
As most people already know, MySQL has FullText indexing built into
it, so why is mysql.com using MnoGoSearch? (There is an icon "Powered
by MnoGoSearch" on the search page.)
1) Is there something wrong with MySQL's FullText search for handling
a lot of
As most people already know, MySQL has FullText indexing built into it, so
why is mysql.com using MnoGoSearch? (There is an icon "Powered by
MnoGoSearch" on the search page.)
1) Is there something wrong with MySQL's FullText search for handling a lot
of data?
2) Is MnoGoSearch better?
3) Why is
On Thu, May 27, 2004 at 03:59:46PM -0400, Bono, Saroj AA R62 wrote:
> I am going to use mysql_query() and want to find out if a certain
> database exists. If mysql_real_connect() fails there are many errors
> that could account for this. The database may exist , and I cant take
> the error return
>Description: Using the GRANT command causes the password to be
deleted until 'FLUSH PRIVILEGES' is executed. This is a security
problem.
>How-To-Repeat:
New 4.1 BINARY install; installed as noted in instructions.
No users except root exist.
Execute MySQL> GRANT SELECT ON bugg.* TO 'cwolf'@'%';
WOuld the following scenario be possible
I currently have about 1.2 Tb of data that i need to transform into
mysql and be able to server a very high amount of pages from a
discussion board. would i be able to place the mysql/data directory in a
main server with huge storage and then have several
Ok, I found the cause which caused the problem. I wiped out the whole
installation directory but the c:\my.cnf file was modified incorrectly.
Sine I would like to use innoDB, I had to created database subdirectories
manually. I did that but I specified datadir by mistake:
datadir = e:/mysql411/d
If I understand the docs correctly, I can use a config file on my client machine for
the given mysql client apps such as the mysql command line tool.
What if I'm using a 3rd-party app? Will the libraries somehow know to read the config
file or would the app have to take manual steps to do it?
fr0g wrote:
Good evening all.
I'm facing a problem with a specific table and the uniques that it has.
I have a table, hosting data of peoples names.
Some of it's columns are, name_english, surname_english,
name_original, surname_original, name_greek, surname_greek.
I have as unique each combinatio
hi all,
i'm building MySQL-4.0.20 from source on OSX 10.3.3
fwiw, my build env includes:
gcc (GCC) 3.3 20030304 (Apple Computer, Inc. build 1640)
autoconf --verautomake (GNU automake) 1.8.2
autoconf (GNU Autoconf) 2.59
ltmain.sh (GNU libtool) 1.5.6 (1.1220.2.94 2004/04/1
Good evening all.
I'm facing a problem with a specific table and the uniques that it has.
I have a table, hosting data of peoples names.
Some of it's columns are, name_english, surname_english, name_original,
surname_original, name_greek, surname_greek.
I have as unique each combination of columns
>Description:
make v3.77 (and same with 3.8) aborts with these errors
make[2]: Entering directory `/usr/local/mysql-4.0.20/readline'
rm -f libreadline.a
false cru libreadline.a readline.o funmap.o keymaps.o vi_mode.o parens.o rltty.o
complete.o bind.o isearch.o display.o signals.o util.o
I am going to use mysql_query() and want to find out if a certain
database exists. If mysql_real_connect() fails there are many errors
that could account for this. The database may exist , and I cant take
the error returned from the failed query to mean the db isnt there and
should be created. S
nevermind mates, it is.
--- Carlos Sunden <[EMAIL PROTECTED]> wrote:
> Hello
> Libraries and header files RPM download at
> http://dev.mysql.com/downloads/mysql/4.0.html
> is the mysql-devel package, right?
> Thanks!
> Carlos
>
>
> -
> Do you Yahoo!?
Well, my "hack" (which is sort of like what you suggest) is to change my
primary key from just an auto_increment 'id' field to a combination of two
other fields (mac/scanner_id) that I know must be unique. Then I rely upon
the fact that mySQL will not allow a duplicate PK. (I did say it was a
hack)
Dear All,
The mysql client & mysql-devel packages did it.
Was able to change the password which I did with a
very easy one. Now when I want to change the existing
password & it fails. It does not let me.
Thanks agaiN!
--- Carlos Sunden <[EMAIL PROTECTED]> wrote:
> Ok.
> So far I got advises to in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.0.13, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.0.13 is a bugfix release for the production tree that is
suitable for use with any MySQL version including MySQL-4.1 or MySQL-5.0.
At 11:02 AM 5/27/2004 -0700, you wrote:
Hi,
I am sure all FreeBSD users are sick and tired of saying this. USE 4.10
Lots of people blindly follow version numbers but 5.x is a lot different
than 4.x in ways I don't yet feel comfortable with using on production
machines. Only one of those issue
"Robinson, Eric" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I included the following statement in my.ini:
>
>log=3Dc:\log.txt
>
> I then executed some queries.
>
> The file log.txt only shows the following:
>
> MySql, Version: 4.0.13-nt-log, started with:
> TCP Port: 3306, Named Pipe: MySQL
Err... I guess I owe Jeremy Zawodny an apology for mistyping his name. I
promise next time I won't type without reading.
His site is at http://jeremy.zawodny.com/. And I really recommend his
book "High Performance MySQL".
Sorry for the typo, Zawodny!
RV Tec
--
MySQL General Mailing List
For li
hi mark,
What happens if you explicitly specify the table character set to be
'utf-8'? (i.e. you're relying on the database default character set to
take care of that for you right now)...
'CREATE TABLE foo CHARACTER SET utf8'
the same.
All I can say is that with the testcase I posted, it is shown
Eric,
> I am sure all FreeBSD users are sick and tired of saying this. USE
> 4.10
> Lots of people blindly follow version numbers but 5.x is a lot different
> than 4.x in ways I don't yet feel comfortable with using on production
> machines. Only one of those issues is with benchmark numbers
"MYSQL" <[EMAIL PROTECTED]> wrote:
> Is it possible to write a SELECT statement that will select all columns but 1 or 2
> certain
> ones?
Nope.
>
> I know I can do SELECT Col1,Col2,Col3 etc. but if there are a few columns, I would
> like to
> be able to do somehting like SELECT * (NOT Col12,Col
Hi,
I am sure all FreeBSD users are sick and tired of saying this. USE 4.10
Lots of people blindly follow version numbers but 5.x is a lot different than 4.x in
ways I don't yet feel comfortable with using on production machines. Only one of those
issues is with benchmark numbers, but that i
JG,
> I am a FreeBSD user, but after having run benchmarks for
> the past 2 weeks, I think you'll be surprised when you see
> the results from Linux.
>
> Linux will outperform *BSD by nearly double when it comes to
> MySQL.
That's what I expect and hope for. Although, I thought that FreeBSD
wou
Hi,
Is it possible to write a SELECT statement that will select all columns but 1 or 2
certain ones?
I know I can do SELECT Col1,Col2,Col3 etc. but if there are a few columns, I would
like to be able to do somehting like SELECT * (NOT Col12,Col13), if that makes any
sense.
Thanks
I will try that.
Thanks.
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'Haplo '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: "'Paul '" <[EMAIL PROTECTED]>
Sent: Thursday, May 27, 2004 1:28 PM
Subject: RE: Textfile to table
> How is the data delimited? You may be
How is the data delimited? You may be able to use the LOAD DATA INFILE
command.
-Original Message-
From: Haplo
To: [EMAIL PROTECTED]
Cc: Paul
Sent: 5/27/04 12:23 PM
Subject: Textfile to table
Hi,
I am trying to add this info into a table and I know there is a way to
do it without using t
Facing this new scenario, I am going to give Linux a shot --
definitively, this one is going to outperform OpenBSD. Using the same
hardware, and the same options (as possible).
Does anyone have a hint for this?
Again, thanks a lot!
Best regards,
RV Tec
I am a FreeBSD user, but after
Hi,
I am trying to add this info into a table and I know there is a way to do it without
using the insert command on every line of data.
201 200 NJ Jersey City
INSERT INTO categories VALUES ('201', '200', 'NJ', 'Jersey City');
there are way too many lines to do by manual inserts.
Any com
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
robert kuzelj wrote:
> hi mark,
>
>> If you specify UTF-8 as the characterEncoding connection property, then
>> that is the transform that is used from client -> server. The transform
>> that is used from server -> client is whatever character set the
hi mark,
If you specify UTF-8 as the characterEncoding connection property, then
that is the transform that is used from client -> server. The transform
that is used from server -> client is whatever character set the column
in the table is set to when you created the table (or conversely if you
us
Hi,
I included the following statement in my.ini:
log=c:\log.txt
I then executed some queries.
The file log.txt only shows the following:
MySql, Version: 4.0.13-nt-log, started with:
TCP Port: 3306, Named Pipe: MySQL
Time Id CommandArgument
040527 9:31:57 1 C
On Tue, May 25, 2004 at 03:36:08PM -0600, Sarix wrote:
> Cause when I do my web end to all this life
> is easy cause I can do $name = $row['Name'] and it works for PHP so I
> figured there has to be an API that would do that.. But I can't seem to find
> it in the documention. Is there something tha
In C API, after running mysql_query(), I want to stop
this query by mysql_kill(). But I can not get the
specific process (query) ID. How could I solve this
problem?
mysql_list_processes() return a list of all processes
(quries) running on the server. But it is possible
that different user may runn
Hello
Libraries and header files RPM download at
http://dev.mysql.com/downloads/mysql/4.0.html
is the mysql-devel package, right?
Thanks!
Carlos
-
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
Hi,
I was running the test-select under the /usr/local/mysql/sql-bench dir and was
wondering if someone could help break it down for me ( Or at least the "Testing big
selects on the table" section ) Thanks :
[EMAIL PROTECTED] sql-bench]# perl test-select --password='d'
Folks,
Following some advices, I have decided to give FreeBSD a shot. So, I got
one test machine (P4 2.0GHz, 512MB), installed FreeBSD 5.2.1 on one
disk, and OpenBSD 3.5 on the other (both 40GB 7200RPM IDE disks) -- so I
could compare the results.
MySQL (4.0.20) is compiled from source, u
Something I have done in the past (with another DB system) was to put
indexes on my temp tables. I have just gone over my copy of the MySQL docs
and I don't see where that is NOT allowed so I think its fair game to try
it.
You have two options to do this:
Create the temp tables then populate them
I wished to use MySQL clustering for application development that is Windows-based.
Since the binaries aren't available as yet, I tried using the source distribution
(tried to build using cygwin) but it gave a number of errors.
Is there any other way of installing MySQL 4.1 with Windows ( that ha
I didn't think you could have a DEFAULT of NOW() because it's not a true
static value. Seems I read that in one of Paul DuBois' books.
Jim Winstead wrote:
On Wed, May 26, 2004 at 06:20:22PM -0700, Scott Haneda wrote:
I have a field in mysql 4, using InnoDB
Field is timestamp 14 and defualt is se
Hi,
> > Why not? What's wrong with this:
> >
> > BORROWER
> > BorrowerID
> >
> > BOOKS
> > BookID
> > BorrowerID (nullable)
> >
> > FK from Books.BorrowerID to Borrower.BorrowerID
> >
> > I haven't checked, but this _should_ be possible.
> >
> > With regards,
>
> Its a foreign key, you can not nul
http://dev.mysql.com/doc/mysql/en/INSERT.html
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)]
VALUES ({expr | DEFAULT},...),(...),...
[ ON DUPLICATE KEY UPDATE col_name=expr, ... ]
If you specify the ON DUPLICATE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 27 May 2004 03:00 am, Martijn Tonies wrote:
> Why not? What's wrong with this:
>
> BORROWER
> BorrowerID
>
> BOOKS
> BookID
> BorrowerID (nullable)
>
> FK from Books.BorrowerID to Borrower.BorrowerID
>
> I haven't checked, but this _should_
Ok.
So far I got advises to install the MySQL-client package & the mysql-devel RPM.
Will do that & report back.
I wouldn't think all that was needed when the MySQL-server-rpm was installed. The
functionality to assign a password should be there.
I'm such a newbie at this, thanks to all again!
Ca
You could create a special "borrower" account to signify that it is not
loaned out and assign that to the book. If this is for a library system
(multiple branches) you could create one account for each branch. That way
you would know where the book is at all times, "borrowed" or not ;-)
Shaw
Only constant values are allowed as default values. If this is the first
timestamp column it will be updated on insert and with every update.
-Original Message-
From: Scott Haneda
To: MySql
Sent: 5/26/04 8:20 PM
Subject: Defaul of NOW()
I have a field in mysql 4, using InnoDB
Field is tim
David Blomstrom wrote:
I'm working on an add/edit form, illustrated by the
screehnshot at http://www.geoworld.org/addedit2.gif
I decided to arrange the rows by ID, rather than
alphabetically. So I opened the table in phpMyAdmin,
clicked Operations, then changed "Order by" from a
field named SCode t
Did you change the permissions for the files to include
read/write/change for the user/account MySQL uses on your system? This
doesn't require deleting, as far as I recall Windows permissions...
Oh, can you verify that the file host under directory mysql DOES exist?
If so, it's really most like
Since the database I created was not critical, I could simply throw it away.
Therefore,
delete the whole MySql installation directory and unzip the alpha release
zip file again
to create the installation directory tree. However, the following error
persists:
Fatal error: Can't open privileg
Thanks for all the feedback. Here's my latest attempt:
SELECT @start:=NOW();
SELECT @date1:=DATE_SUB( CURDATE(), INTERVAL 1 MONTH);
SELECT @date2:=CURDATE();
LOCK TABLES rptPricingTEST READ, rptPricingTEST a READ;
CREATE TEMPORARY TABLE tmpLatestDates
SELECT
commodity,
MAX(PricingDt)
Joshua J. Kugler wrote:
There is one instance in which it is *not* convenient to store in seperate
files: when you are exporting to another machine (maybe a sub set of data
from an internal server to an external web server) or doing replication.
Very true. We use MySQL to store our blobs for
I'm working on an add/edit form, illustrated by the
screehnshot at http://www.geoworld.org/addedit2.gif
I decided to arrange the rows by ID, rather than
alphabetically. So I opened the table in phpMyAdmin,
clicked Operations, then changed "Order by" from a
field named SCode to ID. When I clicked t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 27 May 2004 02:56 pm, Victoria Reznichenko wrote:
> OPTION is a reserved word in MySQL:
> http://dev.mysql.com/doc/mysql/en/Reserved_words.html
>
> Use backticks to quote column names: `option`.
>
>
> --
> For technical support contra
Check permissions on the mysql\data directory and files/folders below
for the MySQL process/user (sorry for not knowing the right Windows
terminology, I'm not a Windows user).
HTH,
Robert J Taylor
[EMAIL PROTECTED]
michael_wu[§d§»¹F] wrote:
Hello,
I run into a problem after re-installing myS
Mauricio Pellegrini <[EMAIL PROTECTED]> wrote:
> I'm using MySql 4.0.18 on Linux (SuSE 8.2)
> and I'm getting this error
>
> ERROR 2013: Lost connection to MySQL server during query
>
> a few seconds after launching
> the following command
>
> LOAD DATA LOCAL INFILE '/root/hc.
I'm working on an add/edit form, illustrated by the
screehnshot at http://www.geoworld.org/addedit2.gif
I decided to arrange the rows by ID, rather than
alphabetically. So I opened the table in phpMyAdmin,
clicked Operations, then changed "Order by" from a
field named SCode to ID. When I clicked t
There is one instance in which it is *not* convenient to store in seperate
files: when you are exporting to another machine (maybe a sub set of data
from an internal server to an external web server) or doing replication.
j- k-
On Wednesday 19 May 2004 01:01 pm, Greg Willits said someth
Carlos Sunden <[EMAIL PROTECTED]> wrote:
>
> Installed the MySQL-server-4.0.20-0.i386.rpm on a RHL8 system
>
> Initialized the grant tables and then did:
> /usr/bin/mysqladmin -u rt password ACTUALPASSWORD
> And got:
> -bash: /usr/bin/mysqladmin: No such file or directory
>
> What gives mates?
>
Hello,
I run into a problem after re-installing mySQL 4.1.1 today. When I
tried to start the service on my Windows2K, I got the following error:
040527 15:37:49 Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
Can some one tell me how to solve the pro
Hi,
> On Wednesday 26 May 2004 11:22 pm, [EMAIL PROTECTED] wrote:
> > Hi, I am trying to use the foreign key constraints from InnoDB
> > and creating indexes is a requirement for foreign key.
> > The problem is that by creating index for my foreign key,
> > it does not allow my foreign key to have
Fajar Priyanto <[EMAIL PROTECTED]> wrote:
>
> Hi all,
> I'm trying to move my Mambo (content management) database from one server into
> another.
>
> In the old server, the mysql version is 4.0.13, while in the new one it's
> 4.0.15.
>
> The error was when restoring:
> ERROR 1064 at line 141: Yo
[EMAIL PROTECTED] wrote:
Hi, I am trying to use the foreign key constraints from InnoDB
and creating indexes is a requirement for foreign key.
The problem is that by creating index for my foreign key,
it does not allow my foreign key to have null or blank values which my records will have.
For eg.
"Abdul Aziz" <[EMAIL PROTECTED]> wrote:
>
> How can we optimize MySQL queries, plz define easy method
> comparing as well as better performance for data retrieval.
>
The following chapter of the manual will be helful to you:
http://dev.mysql.com/doc/mysql/en/Query_Speed.html
--
For t
[EMAIL PROTECTED] wrote:
Hi, I am trying to use the foreign key constraints from InnoDB
and creating indexes is a requirement for foreign key.
The problem is that by creating index for my foreign key,
it does not allow my foreign key to have null or blank values which my records will have.
For eg.
try using explain
>
>
> Hi All,
>
> How can we optimize MySQL queries, plz define easy method
> comparing as well as better performance for data retrieval.
>
> Regards:
> aaziz
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://l
68 matches
Mail list logo