An update - it also occurs in 4.1.19
Bug filed here:
http://bugs.mysql.com/bug.php?id=19978
Cheers,
Richard.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am running MySQL with hMailServer on Windows 2000 Pro. I was forced to
hard reboot the machine this morning, and this is now the result of running
mysqld-nt with --console:
060520 21:38:23 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Startin
On 21.05.2006 00:38 (+0100), paul rivers wrote:
> - Inspect the 'show status' variable of Ssl_accepts after a connection
> attempt on an otherwise quiet mysql instance.
I have no such status variable in my server.
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
http://beta.unclassified.de – My
At 22:10 +0100 20/5/06, Keith Roberts wrote:
Probably the most efficient place to do this sort of field
checking would be using javascript in the browser. That
would stop the bad addresses even being sent down the line
to the server in the first place.
Sure, but if you're being conscientious ab
And of course just as I send this to a public list, I realize there is also
Ssl_version and Ssl_verify_mode, which seem to be session level counters to
give us the information we are after here. *sheepish*
-Original Message-
From: paul rivers [mailto:[EMAIL PROTECTED]
Sent: Saturday, May
I've wrestled with the same question. The only options I came up with were:
- Do as you suggest and require SSL for the account.
- Inspect the 'show status' variable of Ssl_accepts after a connection
attempt on an otherwise quiet mysql instance.
- Sniff the traffic between client and server, but
Hello,
I'm using MySQL Query Browser on Windows XP to connect to a remote MySQL
4.0 and 5.0 database server, both on Linux. In Query Browser, I can
check the options "Use SSL if available" but how do I know if it is
available and used? I couldn't find any SQL command to show me the
encryption statu
Probably the most efficient place to do this sort of field
checking would be using javascript in the browser. That
would stop the bad addresses even being sent down the line
to the server in the first place.
Keith
In theory, theory and practice are the same;
in practice they are not.
On Sat,
You need to use a stronger edit to check email addresses.
This is what I use. Note the dns mx domain name check.
$len = "0,45";
if (empty ($email))
{ $errors[] = "You didn't enter a Email
Address."; }
elseif (!ereg("^([[:alnum:]\.\_\-]+)([EMAIL PROTECTED]:alnum:]\.\-]+\.+)",
$email))
Yesmin Patwary wrote:
Dear All,
My contact table has email field which contains many invalid email addresses. I find them using following php function. Is there a way to do that check in MySQL query?
function emailValidate ($str)
{
$reg = "^([a-zA-Z0-9._-]+)@([a-zA-Z0-9-])+
mos wrote:
At 10:10 AM 5/20/2006, Keith Roberts wrote:
http://www.phpmyadmin.net/home_page/index.php
I think phpmyadmin will allow you to make changes to
multiple columns at once.
Sorry, I should have mentioned I was looking for a MySQL Administrator
running on Windows. Going through PHP see
mos wrote:
Sorry, I should have mentioned I was looking for a MySQL Administrator
running on Windows.
Have you tried the MySQL Query Browser free download from mysql.com? I
use it and it lets me change records and does not reload the table
unless I tell it to. I'm not sure if it has any li
At 10:10 AM 5/20/2006, Keith Roberts wrote:
http://www.phpmyadmin.net/home_page/index.php
I think phpmyadmin will allow you to make changes to
multiple columns at once.
Sorry, I should have mentioned I was looking for a MySQL Administrator
running on Windows. Going through PHP seems like a ro
Well, mysql has support for regex matching. The thing is
though, why store invalid email addresses in you database?
I think what you are doing is the right approach.
Check the email address validity first in php BEFORE saving
it to the database. At least you then know you are only
storing vali
http://www.phpmyadmin.net/home_page/index.php
I think phpmyadmin will allow you to make changes to
multiple columns at once.
For any major changes to a database such as you describe, if
you have the disk space, I would advise copying the database
and performing your changes on the copy, just i
I'm looking for a MySQL administrator for 4.x/5.x that will allow me to
make multiple changes to a table structure without reloading the data after
each change. The problem is I may have to change 5 columns on a 10 million
row table. As it stands now with the administrator I'm using, it will
re
Dear All,
My contact table has email field which contains many invalid email addresses.
I find them using following php function. Is there a way to do that check in
MySQL query?
function emailValidate ($str)
{
$reg = "^([a-zA-Z0-9._-]+)@([a-zA-Z0-9-])+(\.[a-zA-Z0-9-]+)+$";
i
>It depends on what the data is being used for. If you want to know
>what address an order was shipped to then you need the historical
>address info. If all you need is the current customer address,
>because, say, you're sending out holiday cards, then you might not
>need to keep an old address.
Hi Daniel.
Distribute it under the CC license?
http://creativecommons.org/about/licenses/index_html
Keith
In theory, theory and practice are the same;
in practice they are not.
On Fri, 19 May 2006, Daniel Orner wrote:
> To: mysql@lists.mysql.com
> From: Daniel Orner <[EMAIL PROTECTED]>
> Subj
19 matches
Mail list logo
