In the last episode (Oct 30), Mark said:
MySQL 4.0.22, a new version of the popular Open Source/Free
Software Database Management System has been released. It is now
available in source and binary form for a number of platforms from
our download pages at http://dev.mysql.com/downloads/ and
Hi!
InnoDB is the MySQL table type that supports FOREIGN KEY constraints,
row-level locking, Oracle-style consistent, non-locking SELECTs, multiple
tablespaces (in 4.1), and a non-free online hot backup tool.
Release 4.0.22 is mainly a bugfix release of the stable 4.0 series. This
release
On Oct 29, 2004, at 6:26 AM, [EMAIL PROTECTED] wrote:
I think it may be because of your mixed left and right joins. There
are several bugs listed that show that the optimizer mishandles
certain combinations of left and right joins.
SELECT
Hi.
You may read:
http://dev.mysql.com/doc/mysql/en/JOIN.html
http://dev.mysql.com/doc/mysql/en/SELECT.html
There is a good description.
Searching in more than two tables (3 in my example) may be done
in such way:
select t1.* from t1,t2,t3 where t1.a=t2.a and t1.b=t3.b
But
I'm running MySQL 4.0.21
In order to use Foreign Keys, I'm trying to convert a table Type to INNODB. I
issue a statement of the form
Alter Table TblName Type=INNODB;
This statement appears to execute correctly. I would expect this to affect the
Show Create Table output, but when I say
Show
Fortunately there is function COALESCE() that will return the first
argument
that is not NULL. In case of NULL values you can use a default value for
an
expression: COALESCE( `col`*2, 14) will produce 14 if `col` is NULL.
FWIW, IFNULL() does the same thing, with a clearer (to me) name,
Why not simply recreate it with the InnoDB table type?
If there's data in it, rename the old table, recreate the
table and pump the data.
All done!
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server.
Upscene Productions
On Saturday 30 October 2004 09:35 am, Martijn Tonies wrote:
Why not simply recreate it with the InnoDB table type?
If there's data in it, rename the old table, recreate the
table and pump the data.
All done!
Certainly that *COULD* be done, but it shouldn't be necessary (according to
the
Michael,
All your e-mails come as an attachment in my mailbox
instead of plain e-mail.
Why not simply recreate it with the InnoDB table type?
If there's data in it, rename the old table, recreate the
table and pump the data.
All done!
Certainly that *COULD* be done, but it shouldn't be
My database got hosed last night due to some version
upgrade.
Anyway an older copy was restored on the server. I
have a more recent backup on my local machine.
However, when I have done the data transfers I have
found that the table names were convereted to all
lower case.
I'm assuming when I
I apologize for the missing information.
First the server was on 4.0.20 now on 4.0.22. Apache
1.3.x not sure of the linux
The local machine is windows xp with mysql v. 4.0.20a
I did the data transfer running Navicat, so that may
not be so clear to anyone, but the only options that
were enabled:
At 9:24 -0500 10/30/04, Michael Satterwhite wrote:
I'm running MySQL 4.0.21
In order to use Foreign Keys, I'm trying to convert a table Type to INNODB. I
issue a statement of the form
Alter Table TblName Type=INNODB;
This statement appears to execute correctly. I would expect this to affect the
On Saturday 30 October 2004 10:58 am, Paul DuBois wrote:
What output does the following statement produce?
SHOW VARIABLES LIKE 'have_innodb';
If YES, the ALTER TABLE statement should have worked.
If NO, your server doesn't have InnoDB support built in.
If DISABLED, your server supports
At 11:06 -0500 10/30/04, Michael Satterwhite wrote:
On Saturday 30 October 2004 10:58 am, Paul DuBois wrote:
What output does the following statement produce?
SHOW VARIABLES LIKE 'have_innodb';
If YES, the ALTER TABLE statement should have worked.
If NO, your server doesn't have InnoDB support
Ok - feeling a bit embarrassed and sheepish really
In my rush to try out 4.1.7 I did the typical techie thing - I didn't
bother RTFM before starting installing, other than the bit that says you
have to uninstall earlier versions mySQL.
So I've got 4.1.7 all up and running on my dev machine
Stephen Moretti (cfmaster) wrote:
Ok - feeling a bit embarrassed and sheepish really
In my rush to try out 4.1.7 I did the typical techie thing - I didn't
bother RTFM before starting installing, other than the bit that says you
have to uninstall earlier versions mySQL.
So I've got 4.1.7 all
Hi.
Also check the value of lower_case_table_names.
Stuart Felenstein [EMAIL PROTECTED] wrote:
My database got hosed last night due to some version
upgrade.
Anyway an older copy was restored on the server. I
have a more recent backup on my local machine.
However, when I have done
Hi.
I think you should upgrade to MySQL 4.0.22.
Michael Satterwhite [EMAIL PROTECTED] wrote:
[-- text/plain, encoding quoted-printable, charset: us-ascii, 23 lines --]
I'm running MySQL 4.0.21
In order to use Foreign Keys, I'm trying to convert a table Type to INNODB. I
issue
Hi.
I installed MySQL 5.0.1 (snapshot) and PHP 5.0.2 (compiled
--with-mysql=../mysql-debug-5.0.1-alpha-pc-linux-i686
--with-mysqli=../mysql-debug-5.0.1-alpha-pc-linux-i686/bin/mysql_config).
Your code really doesn't work when I used
$mysqli=mysqli_connect('localhost',
Hi.
How did you backed up the data?
Stuart Felenstein [EMAIL PROTECTED] wrote:
My database got hosed last night due to some version
upgrade.
Anyway an older copy was restored on the server. I
have a more recent backup on my local machine.
However, when I have done the data
Hi.
Windows filesystem is not case sensitive.
See:
http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html
Stuart Felenstein [EMAIL PROTECTED] wrote:
I apologize for the missing information.
First the server was on 4.0.20 now on 4.0.22. Apache
1.3.x not sure of the linux
Hi.
MySQL replication currently does not support any locking protocol between master and
slave to guarantee the atomicity of a distributed (cross-server) update.
See:
http://dev.mysql.com/doc/mysql/en/Replication_FAQ.html
Eko Budiharto [EMAIL PROTECTED] wrote:
Hi,
I a facing a
Dan Nelson wrote:
In the last episode (Oct 30), Mark said:
MySQL 4.0.22, a new version of the popular Open Source/Free
Software Database Management System has been released. It is now
available in source and binary form for a number of platforms from
our download pages at
While discussing the hazards of having an open mysql port, it occurred
to me that I have never seen any mention of defenses against password
guessing attacks, such as slow response to failed authentication, or
shutting of a particular remote IP that seems to be issuing unsucessful
requests.
Is
Hi,
How do I add a new function to MySQL SQL statement list.
What I mean is AVG(), MIN() or MAX() is a ready function isnt it? Is there a
way to add new functions without compiling all server?
Regards...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
No, it is not true.
After repeated failed connection attempts from a host that host will be blocked until
a flush hosts command is executed. The number allowed before this blocking is
specified by the variable max_connect_errors.
See http://dev.mysql.com/doc/mysql/en/Blocked_host.html
John
26 matches
Mail list logo