Hello.
We want only mysql 4.1.8 client version
RPMs with 4.1.8 client programs for Linux on x86, IA64, AMD64 are aviable from:
http://downloads.mysql.com/archives.php?p=mysql-4.1v=4.1.8
But MySQL Server 4.1.9 would be a better choice.
sirisha gnvg [EMAIL PROTECTED] wrote:
[--
Hello.
You may tell the slave to replicate updates only for the certain database
or table. See:
http://dev.mysql.com/doc/mysql/en/Replication_Options.html
Eben Goodman [EMAIL PROTECTED] wrote:
I am considering setting up replication for a loaded database that has
to perform
Hello.
Does mysql stores queries? If so where?
MySQL server can log the queries in log files. See:
http://dev.mysql.com/doc/mysql/en/Log_Files.html
Jerry Swanson [EMAIL PROTECTED] wrote:
Does mysql stores queries? If so where?
--
For technical support contracts, goto
hai,
Give sequence of steps to install mysql client 4.1.8 alone in windows
xp?
thanks in advance..
Yahoo! India Matrimony: Find your life partneronline.
On Solaris 8, how can I force configure to not use /usr/lib/libcrypt.so
without renaming that file? I changed config.h to undefine
HAVE_LIBCRYPT, but configure just puts it back to defined and changes
the Makefiles to include -lcrypt.
Thanks, Alex
--
MySQL General Mailing List
For list
Hi,
Can anyone tell me how to optimize the following sql statement?
$sql_1 = SELECT t.prodcode 'Product Code',
t.prodname 'Product Name',
ROUND(avg(t.salesvolume),2) 'PastSales Quantity',
ROUND(avg(tt.salesvolume),2) 'Sales
sam wun wrote:
Hi,
Can anyone tell me how to optimize the following sql statement?
$sql_1 = SELECT t.prodcode 'Product Code',
t.prodname 'Product Name',
ROUND(avg(t.salesvolume),2) 'PastSales Quantity',
Hello,
It seems it is possible to get ride of accent problems in fulltext
search (but I don't know how to). I am using 4.1.8a version of mysql and
I am not enable to find any accentuated word from its non-accent version
(says 'siecle' for 'siècle'). For example :
SELECT * FROM table WHERE
I just upgraded from 4.0.8 to 4.1.9.
On MySql 4.1.9 my default collation seems to be latin1_swedish_ci.
I need to support french accents. Right now, not sure if it's MySQL or PHP.
But all accented caracters in the database are coming out wrong.
I'm thinking I should just use utf8_general_ci but
Christopher,
InnoDB tables are in ibdata files. I hope that you have not deleted them
inadvertently.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
Hi!
I am totally lost here and I know this is a no brinier. I do not know what
I am doing wrong:
I can access from the command line by mysql -u gjw -p then use club and
I can do anything I want.
I am trying to access by Perl:
# line 6 following
my $dbh=DBI-connect( 'DBI:mysql:gjw:club',
According to the help message, the --type option is for specifying the
table type that you want to convert the tables *to*. So it should be
--type=MyISAM, I think.
You could also execute this statement for each table that you want to
convert:
ALTER TABLE tbl_name ENGINE=MyISAM;
Both of
At 19:41 -0600 1/22/05, Bagus wrote:
According to the help message, the --type option is for specifying the
table type that you want to convert the tables *to*. So it should be
--type=MyISAM, I think.
You could also execute this statement for each table that you want to
convert:
ALTER
At 13:28 -0800 1/22/05, Gerald Preston wrote:
Hi!
I am totally lost here and I know this is a no brinier. I do not know what
I am doing wrong:
I can access from the command line by mysql -u gjw -p then use club and
I can do anything I want.
I am trying to access by Perl:
# line 6 following
my
Hi,
I was trying to optimize a sql (for INNER JOIN) by spliting the sql into
2 temporary tables.
But I got error with the following sql:
mysql CREATE TEMPORARY TABLE pastsales_tab_3141604663377652915968
SELECT c.salescode,c.type, c.custcode, i.basename, i.vendorname,
t.salesvolume, t.netsales,
Actually I was just trying to see why the same code to mySql is
so much slower than SQL Server. I tried the same code using the
data provider from CoreLabs and found the connections occur
4 times faster than the mySQL AB connector. The slowness
just seems to be in the connector.
Now I know my
Attempt to connect to mysql via ip address, and make sure on the mysql box
that that you add the connecting boxes to your hosts file. Your problem
should go away then.
Donny
-Original Message-
From: Larry Lowry [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 22, 2005 9:25 PM
To:
SHOW ENGINES says no support for ISAM.
So that explains it. Which other server would you suggest I try installing?
Do you mean I should try installing an earlier version of mysql? Where
should I find one?
I'm worried about messing up my new installation by installing an old one.
Is there an
We are looking for buying a new server for running
MySQL database. The database is around 50-70G and
individual tables run to 5 - 15 GB. There wont be any
frequent updates instead we need maximum select
performance. There will be multiple table joins to
perform our query. I hope your experience
Hi list,
can any one suggest a good PHP/mysql based library manager to manage
books,magazines, documents, cds etc .
I tried libman .. but i am having problem with that .
many thanks in advance ...
with love
gowtham
--
MySQL General Mailing List
For list archives:
I have two different databases they both have an auto-increment PK field
and while they are different databases with different names, they do
have tables with the same names. What I find is that the auto-crement
integer number remembers what it is across these databases. So if I
insert in the 1st
Hi,
How can I see all temporary tables that created by Create Temporary
Table command in mysql 5.01?
thanks
Sam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
22 matches
Mail list logo