RE: MySQL Secure Replication

2003-01-15 Thread Basil Hussain
with RedHat 7.x and above. Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] (filter bait: sql, query, queries, smallint) - Before posting, please check

RE: $Variables and Select statements

2002-12-18 Thread Basil Hussain
doesn't exist! In future, may I suggest you that post questions like this to the PHP mailing list, as this is nothing to do with MySQL. Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED

RE: Table gets wiped out!

2002-10-22 Thread Basil Hussain
. Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: MySQL / Firewall

2002-05-27 Thread Basil Hussain
' instead of 3306. Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual

RE: Another question of Date.

2002-04-11 Thread Basil Hussain
MONTH(dob) = MONTH(NOW()) AND DAYOFMONTH(dob) = DAYOFMONTH(NOW()); And, to see how old a person is, given their date of birth, you would do something like this: SELECT YEAR(NOW() - YEAR(dob) AS age FROM yourtable; Hope this helps. Regards, Basil Hussain

RE: Broken 'even number' rounding function

2001-09-18 Thread Basil Hussain
, this isn't a bug. It's MySQL just following the features of your system's C library. Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] - Before posting

RE: A question about load / queries pr second

2001-09-07 Thread Basil Hussain
and see what kind of numbers it turns up. :-) Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

Trying to build MySQL super-smack - failing...

2001-09-07 Thread Basil Hussain
file, but I thought making sure that I have the latest version of gcc (gcc-2.96-85), rather than downgrading to 2.95, would suffice. Is this the problem, or something else? Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED

RE: A question about load / queries pr second

2001-09-07 Thread Basil Hussain
= thread_cache_size=16 set-variable = thread_concurrency=4 set-variable = back_log=100 set-variable = max_allowed_packet=2M set-variable = wait_timeout=240 skip-locking Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED

RE: INET_ATON

2001-08-07 Thread Basil Hussain
in release 3.23.15 there is this: * Added functions INET_NTOA() and INET_ATON(). So, you need to upgrade your MySQL before you can use these functions. Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED

RE: Convert Outlook into MySQL

2001-08-06 Thread Basil Hussain
in the Contacts store are exported to the text file. Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

RE: Capture SHOW VARIABLES to fie

2001-08-01 Thread Basil Hussain
output formatting) consult the application's help, by entering: $ mysql --help Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] - Before posting

RE: mySQL, MS SQL and a push subscription?

2001-07-31 Thread Basil Hussain
-SQL will be able to export any data required via this ODBC connection to your MySQL server. Check out MyODBC here: http://www.mysql.com/downloads/api-myodbc.html Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED

RE: database server upgrade

2001-07-23 Thread Basil Hussain
: (234 / 97128) * 100 = 0.24% This is way less than one percent, so in this case it's no problem. But, I reckon that if you have more than several percent free space (say 10%) then you definitely need to optimise. Regards, Basil Hussain --- Internet Developer

RE: database server upgrade

2001-07-20 Thread Basil Hussain
query load consists of large quantities of small queries, as this is where row-level locking, etc. will help most. Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED

RE: database server upgrade

2001-07-20 Thread Basil Hussain
table to consolidate empty gaps. Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

RE: database server upgrade

2001-07-20 Thread Basil Hussain
' replication has whole load of issues that you need to tip-toe around carefully (such as auto-increment fields clashing values). Unless your environment has a high update load too, then you probably don't need to worry about distributing updates. Regards, Basil Hussain

RE: REPAIR TABLE question...

2001-07-17 Thread Basil Hussain
clarification. It only seems to talk about re-creating indexes... Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] - Before posting, please check: http

RE: terminal display width?

2001-07-17 Thread Basil Hussain
: 14562 *** 3. row *** category_code: 0 agent_code: 44114 3 rows in set (0.00 sec) This has the benefit of long text fields being wrapped on your display. Regards, Basil Hussain --- Internet Developer, Kodak

RE: [request] IP Address Functions

2001-06-25 Thread Basil Hussain
, 'Miscellaneous Functions', in the current MySQL manual: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html I assume you must also be using an old version of MySQL, as these functions were only added in version 3.23.15, so you should upgrade your installation of MySQL. Regards, Basil Hussain

RE: encrypt wierdness

2001-06-08 Thread Basil Hussain
)); Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: User variables

2001-06-08 Thread Basil Hussain
. Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: firewall

2001-05-11 Thread Basil Hussain
that the access privileges on your MySQL server allow you to connect from the IP of the firewall. Other than that, there is nothing else you need to do. Regards, Basil Hussain ([EMAIL PROTECTED

Re: MERGE Tables

2001-05-01 Thread Basil Hussain
entries for 3.23.38 - is there a new release imminent? Should I wait for this, or just upgrade to 3.23.37 now? Regards, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please

Re: Unix_TimeStamp()

2001-04-30 Thread Basil Hussain
timestamp if called without arguments. According to the manual, anyway: If called with no argument, returns a Unix timestamp... So, if it's not working as documented under Windows, then I think this counts as a bug, yes? Regards, Basil Hussain

Re: MERGE Tables

2001-04-30 Thread Basil Hussain
? Is it because I'm running only version 3.23.32 of MySQL? Do I need to upgrade? Any assistance would be appreciated, as no-one else seems to be able to help. Regards, Basil Hussain ([EMAIL PROTECTED

Re: show table status command in MySQL

2001-04-30 Thread Basil Hussain
up on disk, because you have your index file and table definition file too. I think the 'Index_length' field will tell you how big your indexes are too, though. Regards, Basil Hussain ([EMAIL PROTECTED

Error 1031 when altering merge table. Bug? (plus on-line manualcomment system broken)

2001-04-25 Thread Basil Hussain
would've made a comment in the manual, but the new account registration seems to be broken - you just get an Unknown column 'country_id' in 'field list' SQL error. Regards, Basil Hussain ([EMAIL PROTECTED

No results from query on merge table

2001-04-24 Thread Basil Hussain
, browser char(255) NOT NULL, KEY (bannerid), KEY (impression) ) TYPE=MERGE UNION=(eventlog_11, ...many other tables..., eventlog_81); Can anyone help me figure out what's going on here? Regards, Basil Hussain ([EMAIL PROTECTED

Strange output from EXPLAIN SELECT - explanation needed!

2001-04-23 Thread Basil Hussain
? Regards, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Merge Tables Oversight

2001-04-20 Thread Basil Hussain
if there is any particular reason why this can't be shown, or is it just an oversight? Regards, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com

Re: Merge Tables Oversight

2001-04-20 Thread Basil Hussain
, though... Regards, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: the quick and the dead...

2001-04-11 Thread Basil Hussain
/fullpapers/1921/com1921.htm Anyway, 405 queries per second is not so much if you have monster hardware. I seem to remember one of the MySQL developers mentioning one time that they had benchmarked a MySQL server at over 1,000 queries/sec. Regards, Basil

Re: Delete Again?

2001-03-30 Thread Basil Hussain
(missing, of course, the last one). Hope this gets you going. Also, if you have any more queries about your code, you'd be better off asking on the PHP mailing list, as this problem really isn't much to do with MySQL itself. Regards,

Re: importing data from FileMaker Pro to MySQL

2001-03-26 Thread Basil Hussain
in the MySQL command-line client. Regards, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: tmp_disk_tables vs. tmp_tables

2001-03-21 Thread Basil Hussain
, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

FW: potential vulnerability of mysqld running with rootprivileges (can be used as good DoS or r00t expoloit)

2001-03-20 Thread Basil Hussain
, Basil Hussain ([EMAIL PROTECTED]) -- From: "Pavlov, Lesha" [EMAIL PROTECTED] Organization: NN.ru Reply-To: [EMAIL PROTECTED] Date: Sun, 18 Mar 2001 21:32:37 +0300 To: [EMAIL PROTECTED] Subject: potential vulnerability of mysq

Re: Bug

2001-03-09 Thread Basil Hussain
, if you're talking about a third-party client application or about trying to do this from a PHP script (via the mysql_query() function) then I doubt it will be possible - definitely not possible in the case of PHP. Regards, Basil Hussain ([EMAIL

Get date from week number?

2001-03-08 Thread Basil Hussain
on for forthcoming revisions of MySQL - making sure that all currently present date/time functions have an equal function for converting back to a date or time data type. Regards, Basil Hussain ([EMAIL PROTECTED

Tuning thread_cache_size variable

2001-03-07 Thread Basil Hussain
read cache? * Should I be aiming to get my new threads per connections figure as low as possible? * What effect on memory usage would having a larger thread cache make? This is all on a RedHat Linux 6.2 server with 512Mb RAM and MySQL 3.23.32. Regards, ----

Re: yes/no

2001-03-02 Thread Basil Hussain
com/doc/E/N/ENUM.html Regards, -------- Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To requ

Re: Maximum Password length?

2001-03-01 Thread Basil Hussain
developers care to comment on this, just out of interest? Regards, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php

Re: Calculated Field

2001-03-01 Thread Basil Hussain
your data. You don't need to add any fields to your table to do this. Here's an example: SELECT ROUND((SessionTime + 30) / 60) AS Minutes FROM YourTable Regards, Basil Hussain ([EMAIL PROTECTED

Re: RDBMS question on coding expanding series-like fields

2001-02-27 Thread Basil Hussain
only ever useful for fields that will only ever contain one of a fixed set of values - like "Yes" and "No", for example. I never use Sets - they're evil. ;) Regards, Basil Hussain ([EMAIL PROTECTED]) -

Oddity with date subtraction - bug?

2001-02-22 Thread Basil Hussain
? Or is this not how I should be subtracting/adding dates? I'm using version 3.23.32-log, intstalled from official MySQL RPMs. Regards, Basil Hussain ([EMAIL PROTECTED]) - Before posting

Re: Oddity with date subtraction - bug?

2001-02-22 Thread Basil Hussain
t;95" supposed to represent? Can anyone explain the rational behind this? Anyway, this is clearly not gonna be suitable for subtracting/adding dates, so I suppose I'll have to resort to something ugly like converting each date to a timestamp before subtracting. Regards, --

Re: [problem with creating a user table ]

2001-02-20 Thread Basil Hussain
ntax error. Regards, -------- Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the li

Re: WISHLIST

2001-02-14 Thread Basil Hussain
, etc.). Just type "help" for details of all available commands. Regards, -------- Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/

Log File Reporting

2001-02-14 Thread Basil Hussain
, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

Re: phpMyAdmin

2001-02-14 Thread Basil Hussain
, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: How to get Query Execution Time

2001-02-13 Thread Basil Hussain
using time() instead. Regards, -------- Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this t

Re: Should I switch to SCSI HD for mysql?

2001-02-08 Thread Basil Hussain
RAID controllers, or one of the Promise or Adaptec PCI adapters if you don't want to change motherboards. Regards, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check

Re: Idea: Automated server tuning?

2001-02-02 Thread Basil Hussain
into 'sit-back-and-watch' mode, in order to compare performance after the event to what it was before. If it's worse, it dynamically restores the previous config - this might partially avoid the scenario I described earlier. Regards, Basil Hussain ([EMAIL

Re: Comments in a table

2001-02-02 Thread Basil Hussain
mation to be gleaned from SHOW TABLE STATUS, such as the type of table and date/time of creation of last update, etc. Unfortunately, you can't tag columns with comments, though. Regards, -------- B

Idea: Automated server tuning?

2001-02-01 Thread Basil Hussain
, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

MySQL - Filemaker Tip

2001-02-01 Thread Basil Hussain
: SELECT field FROM table WHERE something = 'foo' INTO OUTFILE '/path/to/whatever.txt' LINES TERMINATED BY 0x1d Then just transfer it to your Mac/PC and import this text file into the repeating field of the record you desire. Et voila! Regards, Basil

A few queries about optimising MySQL variables

2001-01-30 Thread Basil Hussain
Regards, -------- Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-m

Re: bug in 3.23.22-beta

2001-01-19 Thread Basil Hussain
, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Splitting Text Field into Table of Words?

2001-01-15 Thread Basil Hussain
blank. Can anyone offer any ideas (or maybe solutions) for my problem? Regards, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co