About the source code
I just recently downloaded the source code and compiled it. It worked fine. But I am lost when I tried to read through it. Could anyone give me any explaination of the sttucture of the code. Or any reference about it? Thanks Erming __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Auto decrement
Does anyone know if there is a way of setting an auto numbered field that starts at say 2,000,000 and decreases by one on each insert? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Recreate index not working.
Hi, I have some MyISAM tables that have backups only of the FRM and MYD files (the MYI files are huge). Yesterday I needed to restore some of them. To recreate the indexes I followed the procedures under section 4.4.6.9 How to Repair Tables of MySQL manual. I read and tried everything before the Stage 3: Difficult repair but in the end this stage is the one meant for my situation as my index files were missing. For my most unpleaseant surprise, it didn't work. When I got to the mysql TRUNCATE TABLE log_admin_2002; step I got the following error: ERROR 1017: Can't find file: 'log_admin_2002.MYD' (errno: 2) The file exists, it is the the right place, under my temp database directory, both the database directory and the files have the correct permissions and owners, i.e, the same as all my other database directories and tables files. What is happening? BTW, my imediate problem is already solved as I recreated the tables from the definition I had in another server as Stage 4: Very difficult repair suggests and them manage to get my indexes recreated. The problem is that I believe the procedures described in Stage 3: Difficult repair should work. I bet I found a bug in MySQL but is there some advice available for my situation? TIA, Rodrigo Severo Some system info: Conectiva Linux 8 with kernel 2.4.19 gcc version 2.95.3 20010315 (release) MySQL 3.23.56 compiled inhouse GCC: Reading specs from /usr/lib/gcc-lib/i386-conectiva-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-O6 -march=i686 -fomit-frame-pointer' CXX='g++' CXXFLAGS='-O6 -march=i686 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Oct 11 2002 /lib/libc.so.6 - libc-2.2.4.so -rw-r--r--1 root root 1249256 Jan 29 2002 /lib/libc-2.2.4.so -rw-r--r--1 root root 178 Jan 29 2002 /usr/lib/libc.so Configure command: ./configure '--enable-assembler' '--with-debug' '--prefix=/usr/local/mysql' '--with-client-ldflags=-all-static' '--with-mysqld-ldflags=-all-static' '--enable-thread-safe-client' '--with-charset=latin1' '--with-extra-charsets=none' '--with-innodb' 'CFLAGS=-O6 -march=i686 -fomit-frame-pointer' 'CXXFLAGS=-O6 -march=i686 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' -- Rodrigo Severo Fábrica de Idéias Fone: +55(61)321 1357 Fax: +55(61)223 1712 SCS - Quadra 2 - Ed. Empire Center - Sala 1301 Brasília/DF - Brasil CEP: 70.070-904 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
multiple unique updates
Hi, Does anyone know a way to do multiple unique updates in one query, the way you can in an insert query? I have a table with several thousand records. Periodically every record in this table needs one field to be updated. Slows down the process if each record is updated with a separate query. mysql Andrew Hazen, O.C.P. E-Commerce Developer Jatech Solutions Inc. www.jatech.ca Specializing in OSCOMMERCE applications and PHP/MySQL programming.
computed columns
I'm new to mySQL, but like what I see so far. I'm converting several databases from other products to mySQL 4.0.12 for improved speed and reliability. But I'm having trouble with computed columns. I don't see how to define them. Can't find it in the manual.pdf. I need 2 computed columns, 1st takes the columns fName and lName and appends them together with a space between. 2nd column, numDays, takes sDat (contract start date) and eDat (end date) and calculates eDat-sDat+1. Can someone please help me figure out how to define these columns. Thanks. Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Auto decrement
Does anyone know if there is a way of setting an auto numbered field that starts at say 2,000,000 and decreases by one on each insert? Well, if you know the starting number you can use a normal autoinc field and retrieve the value you want by substracting: 2,000,000 - AutoIncField Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to write this query pls?
Ways around inner select statments Select ID, Sum(CASE WHEN phone.PHN = NULL THEN 1 ELSE 0 END) as PHNCount from person left outer join phone on ID where PHNCount = 0 GROUP BY phone.ID; The alias in the WHERE clause is illegal; it would have to be SELECT persons.ID, Sum( CASE WHEN phone.type = 'PHN' THEN 1 ELSE 0 END ) AS PHNCount FROM persons LEFT OUTER JOIN phone USING ( ID ) GROUP BY phone.ID HAVING phncount = 0; which on this machine is up to ten times slower than SELECT * FROM persons pe LEFT JOIN phone ph ON pe.ID = ph.ID AND ph.type = 'PHN' WHERE ph.type IS NULL; PB [mysql] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to secure a MySQL database from people with physical acce ss
-Original Message- From: mos [mailto:[EMAIL PROTECTED] I could encrypt certain table fields, but this will make writing the front end a pain because all SQL statements will now need to be changed any time a new column is encrypted. It also won't help you any, because the software will have to contain everything needed to do the decryption. Unless you can somehow prevent a hypothetical attacker from getting this software, your encryption is only going to keep a casual attacker out. All he has to do is decompile the software enough to figure out your encryption routine. Generally there's very little you can do to protect data from someone with physical access to the machine -- unless you can keep it in encrypted form, and only decrypt it elsewhere, so that the decryption key never passes through the vulnerable machine. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to fill an Blob with binary data
Hi, I would like to fill an Blob with binary data thru SQL-statements or any other MySQL tools and don't know how!? Are there suggestions? Thanks, Thomas Hoelsken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Semi-Solved- Mixed up versions!!
Petre Agenbag schrieb: DOH! After some RTFM'ing, which is your 'really_little_part' in the great game called 'open-source' I found that the /etc/my.cnf was holding the info for the data dir and the sock, also, the old mysql client worked fine when using that as it was looking for the sock in the right place... I would however be interested to know how I could configure the new version to read it's own my.cnf file and thus not interfere with the old version at all. $ grep my.cnf /etc/rc.d/init.d/mysqld # config: /etc/my.cnf # /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf /dev/null 21 /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf /dev/null 21 -- shrek-m -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: group by
On 27-May-2003 Jose Miguel Pérez wrote: snip SELECT CASE WHEN age 15 THEN 1 WHEN age BETWEEN 15 AND 29 THEN 2 WHEN age BETWEEN 30 AND 45 THEN 3 WHEN age 45 THEN 4 END AS age_range, name, COUNT(*) as how_many FROM test GROUP BY age_range, name Note that in the above SELECT, we feed the GROUP BY a number representing the age range (age_range). The SELECT will produce the following result, as close as possible to what you stated: age_range NameHow_Many --+---+-- 1 | James |1 1 | John |2 3 | John |1 3 | Rob |3 4 | John |2 (Please Note the lack of the age_range number 2: 15-29). SELECT ELT(1+ (age/15), '0-14', '15-29', '30-44', '45-59') AS age_range Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to fill an Blob with binary data
Search the mailing list archives for this... There is a link to this article: http://www.php4.com/forums/viewtopic.php?t=6 I wonder if the mailinglist search was powered by google more people would use it? On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, I would like to fill an Blob with binary data thru SQL-statements or any other MySQL tools and don't know how!? Are there suggestions? Thanks, Thomas Hoelsken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to fill an Blob with binary data
I know MySQL CC can place a text or image blob into the database, might be worth a look. Mike Hillyer www.vbmysql.com -Original Message- From: Thomas Hoelsken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 10:54 AM To: [EMAIL PROTECTED] Subject: How to fill an Blob with binary data Hi, I would like to fill an Blob with binary data thru SQL-statements or any other MySQL tools and don't know how!? Are there suggestions? Thanks, Thomas Hoelsken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to fill an Blob with binary data
Hi, isn't there any other solution instead of using PHP just for filling an Blob!? I don't need php and would prefer any other way! Thanks, Thomas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 6:56 PM To: [EMAIL PROTECTED] Subject: Re: How to fill an Blob with binary data Search the mailing list archives for this... There is a link to this article: http://www.php4.com/forums/viewtopic.php?t=6 I wonder if the mailinglist search was powered by google more people would use it? On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, I would like to fill an Blob with binary data thru SQL-statements or any other MySQL tools and don't know how!? Are there suggestions? Thanks, Thomas Hoelsken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to fill an Blob with binary data
Mascon can do it .. it's a win32 app.. On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, isn't there any other solution instead of using PHP just for filling an Blob!? I don't need php and would prefer any other way! Thanks, Thomas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 6:56 PM To: [EMAIL PROTECTED] Subject: Re: How to fill an Blob with binary data Search the mailing list archives for this... There is a link to this article: http://www.php4.com/forums/viewtopic.php?t=6 I wonder if the mailinglist search was powered by google more people would use it? On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, I would like to fill an Blob with binary data thru SQL-statements or any other MySQL tools and don't know how!? Are there suggestions? Thanks, Thomas Hoelsken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to fill an Blob with binary data
I am in need of help with the same question (sent late last night, but apparently got passed over). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Thomas Hoelsken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:11 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Hi, isn't there any other solution instead of using PHP just for filling an Blob!? I don't need php and would prefer any other way! Thanks, Thomas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 6:56 PM To: [EMAIL PROTECTED] Subject: Re: How to fill an Blob with binary data Search the mailing list archives for this... There is a link to this article: http://www.php4.com/forums/viewtopic.php?t=6 I wonder if the mailinglist search was powered by google more people would use it? On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, I would like to fill an Blob with binary data thru SQL-statements or any other MySQL tools and don't know how!? Are there suggestions? Thanks, Thomas Hoelsken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: silly old hostname help?
In the last episode (May 27), [EMAIL PROTECTED] said: Rebuilding my (Mac OS X Server 10.2.x) server and installing MySQL again, I have forgotten how to fix this, which I've seen long ago: %mysql_install_db Sorry, the host 'rogers' could not be looked up. Please configure the 'hostname' command to return a correct hostname. If you want to solve this at a later stage, restart this script with the --force option I believe my hostname *is* in all the right places? e.g., it's in the 'hostconfig' file; if I type %hostname, I get: 'rogers'. hostname should return a FQDN; i.e. rogers.domain.com -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to fill an Blob with binary data
Like I said, for Image and text blobs, use MyCC and it should work. Mike Hillyer www.vbmysql.com -Original Message- From: Adam Clauss [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:18 AM To: [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data I am in need of help with the same question (sent late last night, but apparently got passed over). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Thomas Hoelsken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:11 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Hi, isn't there any other solution instead of using PHP just for filling an Blob!? I don't need php and would prefer any other way! Thanks, Thomas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 6:56 PM To: [EMAIL PROTECTED] Subject: Re: How to fill an Blob with binary data Search the mailing list archives for this... There is a link to this article: http://www.php4.com/forums/viewtopic.php?t=6 I wonder if the mailinglist search was powered by google more people would use it? On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, I would like to fill an Blob with binary data thru SQL-statements or any other MySQL tools and don't know how!? Are there suggestions? Thanks, Thomas Hoelsken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to fill an Blob with binary data
On 27 May 2003 at 19:10, Thomas Hoelsken wrote: isn't there any other solution instead of using PHP just for filling an Blob!? Of course there is, but if you need more specifics you need to give us more details. How are you executing your SQL statements? It's just a matter of getting your data from wherever it comes from, escaping it properly, and putting it into your INSERT or UPDATE. Whatever language you're using should be able to do that. Or maybe you're looking for the LOAD_FILE() function? http://www.mysql.com/doc/en/String_functions.html -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to fill an Blob with binary data
Thanks, FreeMascon is able to do it und it works fine. If anyone knows
another solution, I'm interested in!
Thomas
---
_
/ __// __// ___/Thomas Hoelsken [EMAIL PROTECTED]
/ /_ / __// /_ / IT-Coordinator
/___//_/ // Operations Control FRA HE/I
Condor Flugdienst GmbH Tel: +49-6107-939-8304
Am Gruenen Weg 3 Fax: +49-6107-939-145
65451 KelsterbachSITA: FRAH2DE
GERMANY
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 7:14 PM
To: Thomas Hoelsken
Cc: [EMAIL PROTECTED]
Subject: RE: How to fill an Blob with binary data
Mascon can do it .. it's a win32 app..
On Tue, 27 May 2003, Thomas Hoelsken wrote:
Hi,
isn't there any other solution instead of using PHP just
for filling
an Blob!?
I don't need php and would prefer any other way!
Thanks,
Thomas
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 6:56 PM
To: [EMAIL PROTECTED]
Subject: Re: How to fill an Blob with binary data
Search the mailing list archives for this... There is a
link to this
article:
http://www.php4.com/forums/viewtopic.php?t=6
I wonder if the mailinglist search was powered by google
more people
would use it?
On Tue, 27 May 2003, Thomas Hoelsken wrote:
Hi,
I would like to fill an Blob with binary data thru
SQL-statements or
any other MySQL tools and don't know how!?
Are there suggestions?
Thanks,
Thomas Hoelsken
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql? [EMAIL PROTECTED]
--
MySQL General
Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to fill an Blob with binary data
In my case, its neither. Some random binary data. Could be ANY kind of file... (I'm doing mine programmatically). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:23 PM To: Adam Clauss; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Like I said, for Image and text blobs, use MyCC and it should work. Mike Hillyer www.vbmysql.com -Original Message- From: Adam Clauss [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:18 AM To: [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data I am in need of help with the same question (sent late last night, but apparently got passed over). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Thomas Hoelsken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:11 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Hi, isn't there any other solution instead of using PHP just for filling an Blob!? I don't need php and would prefer any other way! Thanks, Thomas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 6:56 PM To: [EMAIL PROTECTED] Subject: Re: How to fill an Blob with binary data Search the mailing list archives for this... There is a link to this article: http://www.php4.com/forums/viewtopic.php?t=6 I wonder if the mailinglist search was powered by google more people would use it? On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, I would like to fill an Blob with binary data thru SQL-statements or any other MySQL tools and don't know how!? Are there suggestions? Thanks, Thomas Hoelsken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to fill an Blob with binary data
What is the source of the binary data you want to use to fill the blob? -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:23 PM To: Adam Clauss; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Like I said, for Image and text blobs, use MyCC and it should work. Mike Hillyer www.vbmysql.com -Original Message- From: Adam Clauss [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:18 AM To: [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data I am in need of help with the same question (sent late last night, but apparently got passed over). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Thomas Hoelsken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:11 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Hi, isn't there any other solution instead of using PHP just for filling an Blob!? I don't need php and would prefer any other way! Thanks, Thomas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 6:56 PM To: [EMAIL PROTECTED] Subject: Re: How to fill an Blob with binary data Search the mailing list archives for this... There is a link to this article: http://www.php4.com/forums/viewtopic.php?t=6 I wonder if the mailinglist search was powered by google more people would use it? On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, I would like to fill an Blob with binary data thru SQL-statements or any other MySQL tools and don't know how!? Are there suggestions? Thanks, Thomas Hoelsken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to fill an Blob with binary data
In what language? Mike Hillyer www.vbmysql.com -Original Message- From: Adam Clauss [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:30 AM To: Mike Hillyer; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data In my case, its neither. Some random binary data. Could be ANY kind of file... (I'm doing mine programmatically). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:23 PM To: Adam Clauss; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Like I said, for Image and text blobs, use MyCC and it should work. Mike Hillyer www.vbmysql.com -Original Message- From: Adam Clauss [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:18 AM To: [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data I am in need of help with the same question (sent late last night, but apparently got passed over). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Thomas Hoelsken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:11 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Hi, isn't there any other solution instead of using PHP just for filling an Blob!? I don't need php and would prefer any other way! Thanks, Thomas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 6:56 PM To: [EMAIL PROTECTED] Subject: Re: How to fill an Blob with binary data Search the mailing list archives for this... There is a link to this article: http://www.php4.com/forums/viewtopic.php?t=6 I wonder if the mailinglist search was powered by google more people would use it? On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, I would like to fill an Blob with binary data thru SQL-statements or any other MySQL tools and don't know how!? Are there suggestions? Thanks, Thomas Hoelsken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to fill an Blob with binary data
Copied from my original message: I am writing a database that will contain a blob field for some binary data. My question is, what is the most efficient way to load this binary data in? I could turn it into a string and pass it into an INSERT/UPDATE statement, but I am afraid that problems will arise when it is converted into a string (with newlines, nulls, etc). I considered saving it to a file, and then using LOAD_FILE, but: a) that ALSO invovles turning it into a string, but since MySQL is doing it, it might end up OK. b) I'm not sure how the performance will be when I have to save it to a file, then have MySQL read it back in. The app is using the C++ API and I was wondering if there was any other way to directly 'stream' the data in? Thanks, Adam Clauss [EMAIL PROTECTED] -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:31 PM To: Adam Clauss; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data In what language? Mike Hillyer www.vbmysql.com -Original Message- From: Adam Clauss [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:30 AM To: Mike Hillyer; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data In my case, its neither. Some random binary data. Could be ANY kind of file... (I'm doing mine programmatically). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:23 PM To: Adam Clauss; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Like I said, for Image and text blobs, use MyCC and it should work. Mike Hillyer www.vbmysql.com -Original Message- From: Adam Clauss [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:18 AM To: [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data I am in need of help with the same question (sent late last night, but apparently got passed over). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Thomas Hoelsken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:11 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Hi, isn't there any other solution instead of using PHP just for filling an Blob!? I don't need php and would prefer any other way! Thanks, Thomas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 6:56 PM To: [EMAIL PROTECTED] Subject: Re: How to fill an Blob with binary data Search the mailing list archives for this... There is a link to this article: http://www.php4.com/forums/viewtopic.php?t=6 I wonder if the mailinglist search was powered by google more people would use it? On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, I would like to fill an Blob with binary data thru SQL-statements or any other MySQL tools and don't know how!? Are there suggestions? Thanks, Thomas Hoelsken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: User Variables doesn't work?
Not just MySQLFront. PhpMyAdmin chokes on it, too. - - Original Message - From: ML To: [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 9:08 AM Subject: Re: User Variables doesn't work? You are right, I tried from command line and it works, the problem occurs with MySQL Front v2.5. This is strange because I love this software and this is a strange bug... Regards. I'm using User Variables, I tried it with the query found in the mysql manul: SELECT @t1:=(@t2:=1)[EMAIL PROTECTED]:=4,@t1,@t2,@t3; But I receive this error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(@t2NULL1)[EMAIL PROTECTED],@t1,@t2,@t3' at line 1 I have MySQL v4.0.12 Worked perfect for me. Did you execute the above query from command-line client or what client did you use? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to fill an Blob with binary data
Depending on size of data there are a few different methods... Just like what most people do.. use plain insert statements with the data properly escaped and shouldn't have any problem going in. Pulling data out is pretty quick .. I can stream binary data out of my mysql storage servers via our ftp gateway at speeds about 40MB/sec (~ 4000k/sec) which is pretty quick for the crappy development server I've got.. You mention streaming in.. I've got a ftpgateway to mysql storage that I use.. it's written in java.. but you could also implement one in C++ On Tue, 27 May 2003, Adam Clauss wrote: Copied from my original message: I am writing a database that will contain a blob field for some binary data. My question is, what is the most efficient way to load this binary data in? I could turn it into a string and pass it into an INSERT/UPDATE statement, but I am afraid that problems will arise when it is converted into a string (with newlines, nulls, etc). I considered saving it to a file, and then using LOAD_FILE, but: a) that ALSO invovles turning it into a string, but since MySQL is doing it, it might end up OK. b) I'm not sure how the performance will be when I have to save it to a file, then have MySQL read it back in. The app is using the C++ API and I was wondering if there was any other way to directly 'stream' the data in? Thanks, Adam Clauss [EMAIL PROTECTED] -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:31 PM To: Adam Clauss; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data In what language? Mike Hillyer www.vbmysql.com -Original Message- From: Adam Clauss [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:30 AM To: Mike Hillyer; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data In my case, its neither. Some random binary data. Could be ANY kind of file... (I'm doing mine programmatically). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:23 PM To: Adam Clauss; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Like I said, for Image and text blobs, use MyCC and it should work. Mike Hillyer www.vbmysql.com -Original Message- From: Adam Clauss [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:18 AM To: [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data I am in need of help with the same question (sent late last night, but apparently got passed over). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Thomas Hoelsken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:11 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Hi, isn't there any other solution instead of using PHP just for filling an Blob!? I don't need php and would prefer any other way! Thanks, Thomas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 6:56 PM To: [EMAIL PROTECTED] Subject: Re: How to fill an Blob with binary data Search the mailing list archives for this... There is a link to this article: http://www.php4.com/forums/viewtopic.php?t=6 I wonder if the mailinglist search was powered by google more people would use it? On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, I would like to fill an Blob with binary data thru SQL-statements or any other MySQL tools and don't know how!? Are there suggestions? Thanks, Thomas Hoelsken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to fill an Blob with binary data
Hello
I prefer SQLyog at http://www.webyog.com/sqlyog
Its FREE, extremely fast and very easy to use. Runs
only on Windows though. Should give a try!!!
Karam
--- Thomas Hoelsken [EMAIL PROTECTED] wrote:
Thanks, FreeMascon is able to do it und it works
fine. If anyone knows
another solution, I'm interested in!
Thomas
---
_
/ __// __// ___/Thomas Hoelsken
[EMAIL PROTECTED]
/ /_ / __// /_ / IT-Coordinator
/___//_/ // Operations Control FRA HE/I
Condor Flugdienst GmbH Tel: +49-6107-939-8304
Am Gruenen Weg 3 Fax: +49-6107-939-145
65451 KelsterbachSITA: FRAH2DE
GERMANY
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 7:14 PM
To: Thomas Hoelsken
Cc: [EMAIL PROTECTED]
Subject: RE: How to fill an Blob with binary data
Mascon can do it .. it's a win32 app..
On Tue, 27 May 2003, Thomas Hoelsken wrote:
Hi,
isn't there any other solution instead of using
PHP just
for filling
an Blob!?
I don't need php and would prefer any other way!
Thanks,
Thomas
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 6:56 PM
To: [EMAIL PROTECTED]
Subject: Re: How to fill an Blob with binary
data
Search the mailing list archives for this...
There is a
link to this
article:
http://www.php4.com/forums/viewtopic.php?t=6
I wonder if the mailinglist search was powered
by google
more people
would use it?
On Tue, 27 May 2003, Thomas Hoelsken wrote:
Hi,
I would like to fill an Blob with binary data
thru
SQL-statements or
any other MySQL tools and don't know how!?
Are there suggestions?
Thanks,
Thomas Hoelsken
--
MySQL General Mailing List
For list archives:
http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General
Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
__
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to fill an Blob with binary data
OK question then - when I use LOAD_FILE, does it automatically put escape characters in front of anything that needs it? I am in development on an SMTP server with an SQL backend rather than simply a filesystem. My concern is regarding file attachments which could be pretty much anything imaginable. Adam Clauss [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:53 PM To: [EMAIL PROTECTED] Cc: Adam Clauss Subject: RE: How to fill an Blob with binary data Depending on size of data there are a few different methods... Just like what most people do.. use plain insert statements with the data properly escaped and shouldn't have any problem going in. Pulling data out is pretty quick .. I can stream binary data out of my mysql storage servers via our ftp gateway at speeds about 40MB/sec (~ 4000k/sec) which is pretty quick for the crappy development server I've got.. You mention streaming in.. I've got a ftpgateway to mysql storage that I use.. it's written in java.. but you could also implement one in C++ On Tue, 27 May 2003, Adam Clauss wrote: Copied from my original message: I am writing a database that will contain a blob field for some binary data. My question is, what is the most efficient way to load this binary data in? I could turn it into a string and pass it into an INSERT/UPDATE statement, but I am afraid that problems will arise when it is converted into a string (with newlines, nulls, etc). I considered saving it to a file, and then using LOAD_FILE, but: a) that ALSO invovles turning it into a string, but since MySQL is doing it, it might end up OK. b) I'm not sure how the performance will be when I have to save it to a file, then have MySQL read it back in. The app is using the C++ API and I was wondering if there was any other way to directly 'stream' the data in? Thanks, Adam Clauss [EMAIL PROTECTED] -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:31 PM To: Adam Clauss; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data In what language? Mike Hillyer www.vbmysql.com -Original Message- From: Adam Clauss [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:30 AM To: Mike Hillyer; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data In my case, its neither. Some random binary data. Could be ANY kind of file... (I'm doing mine programmatically). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:23 PM To: Adam Clauss; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Like I said, for Image and text blobs, use MyCC and it should work. Mike Hillyer www.vbmysql.com -Original Message- From: Adam Clauss [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:18 AM To: [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data I am in need of help with the same question (sent late last night, but apparently got passed over). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Thomas Hoelsken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:11 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Hi, isn't there any other solution instead of using PHP just for filling an Blob!? I don't need php and would prefer any other way! Thanks, Thomas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 6:56 PM To: [EMAIL PROTECTED] Subject: Re: How to fill an Blob with binary data Search the mailing list archives for this... There is a link to this article: http://www.php4.com/forums/viewtopic.php?t=6 I wonder if the mailinglist search was powered by google more people would use it? On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, I would like to fill an Blob with binary data thru SQL-statements or any other MySQL tools and don't know how!? Are there suggestions? Thanks, Thomas Hoelsken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives:
replication - master and slave on the same computer
Hi list, I have a question about replication in MySQL. I have mysql 4.0.12 (master and slave) on windows 2000. Can I make master and slave on the same computer? If I have the master on disk c, and the slave on disk d: 1) When do I put the my.ini file of the slave? 2) How can I stop and start the slave server? If I run the command NET STOP Mysql it stop the server on disk c.. Thanks very much Inbal --8 I think it should be possible. Trying the same thing here under linux with a config like this: [mysqld_multi] mysqld = /usr/bin/safe_mysqld mysqladmin = /usr/bin/mysqladmin user = user password = pass [mysqld1] datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock port= 3306 pid-file= /var/lib/mysql/hostname.pid skip-locking skip-innodb set-variable= max_connections=300 set-variable= key_buffer=512M set-variable= max_allowed_packet=1M set-variable= table_cache=384 set-variable= sort_buffer=128M set-variable= join_buffer_size=64M set-variable= record_buffer=512M set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=256M log-bin server-id = 1 [mysqld2] datadir = /var/lib/mysqlrep socket = /var/lib/mysqlrep/mysql.sock port= 3307 pid-file= /var/lib/mysqlrep/hostname.pid skip-locking skip-innodb set-variable= max_connections=300 set-variable= key_buffer=512M set-variable= max_allowed_packet=1M set-variable= table_cache=384 set-variable= sort_buffer=128M set-variable= join_buffer_size=64M set-variable= record_buffer=512M set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=256M master-host = localhost master-user = repl master-password = password master-port = 3306 server-id = 2 replicate-do-db = nuria replicate-ignore-db = mysql [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid HOWEVER, although it seems to try and replicate there must still be something with this config, because i can run both daemons but not at the same time. E.g. mysqld_multi start 1 works fine but when I start the second the errorlog shows me this: 030527 17:26:14 mysqld started /usr/libexec/mysqld: ready for connections 030527 17:26:14 Slave thread: error connecting to master: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) (0), retry in 60 sec mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=536866816 record_buffer=536866816 sort_buffer=134217720 max_used_connections=0 max_connections=300 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 4193097 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0x4001f40c, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x80e345c 0x4007d618 0x 0x80e3a5b 0x400782b6 0x420de407 New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash Number of processes running now: 0 Still looking into it.. Let me know when you find out anything.
RE: Catching Exceptions
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 3:16 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Catching Exceptions I noticed that the exceptions were being caught by pointer. I recommend that you catch them by const reference, as you always should. It might make a difference with the MSVC++ compiler. *Looks for cliff to go jump off of* Why? LOL... I KNEW that. Yet it totally had me lost. Thanks... Although... Why const reference? I've typically just done it by value. Adam Clauss [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: User Variables doesn't work?
MySQLFront 2.5 had so many bugs that I had to leave it. I prefer SQLyog now. Its FREE !!! and has all the features ( plus some realy cool extra features ). You can try SQLyog at http://www.webyog.com/sqlyog Karam --- Peter Brawley [EMAIL PROTECTED] wrote: Not just MySQLFront. PhpMyAdmin chokes on it, too. - - Original Message - From: ML To: [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 9:08 AM Subject: Re: User Variables doesn't work? You are right, I tried from command line and it works, the problem occurs with MySQL Front v2.5. This is strange because I love this software and this is a strange bug... Regards. I'm using User Variables, I tried it with the query found in the mysql manul: SELECT @t1:=(@t2:=1)[EMAIL PROTECTED]:=4,@t1,@t2,@t3; But I receive this error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(@t2NULL1)[EMAIL PROTECTED],@t1,@t2,@t3' at line 1 I have MySQL v4.0.12 Worked perfect for me. Did you execute the above query from command-line client or what client did you use? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: About the source code
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Tue, 27 May 2003, Erming Zheng wrote: I just recently downloaded the source code and compiled it. It worked fine. But I am lost when I tried to read through it. Could anyone give me any explaination of the sttucture of the code. Or any reference about it? Thanks Have a look at internals.texi (now part of the mysqldoc BK tree) for more details: http://mysql.bkbits.net:8080/mysqldoc/src/Docs?nav=index.html|src/. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE+06rvSVDhKrJykfIRAjAMAJ9b8wMU1fEQAne047jp6KuizdPNZwCeMvQU VBcfh/DH+n+r1sCE/XJEoPM= =8rie -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: replication - master and slave on the same computer
You need to start 2 instances of mysqld both on different ports and different datadirs. I recommend reading Paul Dubois MySQL second Edition- The definitive guide to using, programming, and administering mysql 4 databases. He has a section on replication + running multiple instances of mysqld. ---Original Message- --From: Vico Timmermans [mailto:[EMAIL PROTECTED] --Sent: Tuesday, May 27, 2003 8:51 AM --To: [EMAIL PROTECTED] --Subject: replication - master and slave on the same computer -- -- --Hi list, --I have a question about replication in MySQL. --I have mysql 4.0.12 (master and slave) on windows 2000. -- --Can I make master and slave on the same computer? -- --If I have the master on disk c, and the slave on disk d: --1) When do I put the my.ini file of the slave? --2) How can I stop and start the slave server? If I run the command NET --STOP --Mysql it stop the server on disk c.. -- --Thanks very much --Inbal -- 8 -- --I think it should be possible. Trying the same thing here --under linux with a config like this: -- --[mysqld_multi] --mysqld = /usr/bin/safe_mysqld --mysqladmin = /usr/bin/mysqladmin --user = user --password = pass -- --[mysqld1] --datadir = /var/lib/mysql --socket = /var/lib/mysql/mysql.sock --port= 3306 --pid-file= /var/lib/mysql/hostname.pid --skip-locking --skip-innodb --set-variable= max_connections=300 --set-variable= key_buffer=512M --set-variable= max_allowed_packet=1M --set-variable= table_cache=384 --set-variable= sort_buffer=128M --set-variable= join_buffer_size=64M --set-variable= record_buffer=512M --set-variable= net_buffer_length=8K --set-variable= myisam_sort_buffer_size=256M --log-bin --server-id = 1 -- --[mysqld2] --datadir = /var/lib/mysqlrep --socket = /var/lib/mysqlrep/mysql.sock --port= 3307 --pid-file= /var/lib/mysqlrep/hostname.pid --skip-locking --skip-innodb --set-variable= max_connections=300 --set-variable= key_buffer=512M --set-variable= max_allowed_packet=1M --set-variable= table_cache=384 --set-variable= sort_buffer=128M --set-variable= join_buffer_size=64M --set-variable= record_buffer=512M --set-variable= net_buffer_length=8K --set-variable= myisam_sort_buffer_size=256M --master-host = localhost --master-user = repl --master-password = password --master-port = 3306 --server-id = 2 --replicate-do-db = nuria --replicate-ignore-db = mysql -- --[mysql.server] --user=mysql --basedir=/var/lib -- --[safe_mysqld] --err-log=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid -- -- -- -- --HOWEVER, although it seems to try and replicate there must still --be something with this config, because i can run both daemons but --not at the same time. E.g. mysqld_multi start 1 works fine but --when I start the second the errorlog shows me this: -- -- --030527 17:26:14 mysqld started --/usr/libexec/mysqld: ready for connections --030527 17:26:14 Slave thread: error connecting to master: Access denied --for user: '[EMAIL PROTECTED]' (Using password: YES) (0), retry in 60 sec --mysqld got signal 11; --This could be because you hit a bug. It is also possible that this binary --or one of the libraries it was linked against is corrupt, improperly --built, --or misconfigured. This error can also be caused by malfunctioning --hardware. --We will try our best to scrape up some info that will hopefully help --diagnose --the problem, but since we have already crashed, something is definitely --wrong --and this may fail -- --key_buffer_size=536866816 --record_buffer=536866816 --sort_buffer=134217720 --max_used_connections=0 --max_connections=300 --threads_connected=0 --It is possible that mysqld could use up to --key_buffer_size + (record_buffer + sort_buffer)*max_connections = 4193097 --K --bytes of memory --Hope that's ok, if not, decrease some variables in the equation -- --Attempting backtrace. You can use the following information to find out --where mysqld died. If you see no messages after this, something went --terribly wrong... --Cannot determine thread, fp=0x4001f40c, backtrace may not be correct. --Stack range sanity check OK, backtrace follows: --0x80e345c --0x4007d618 --0x --0x80e3a5b --0x400782b6 --0x420de407 --New value of fp=(nil) failed sanity check, terminating stack trace! --Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and --follow --instructions on how to resolve the stack trace. Resolved --stack trace is much more helpful in diagnosing the problem, so please do --resolve it --The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains --information that should help you find out what is causing the crash -- --Number of processes running now: 0 -- -- -- --Still looking into it.. Let me know when you find out anything. -- MySQL General Mailing List For list
Re: replication - master and slave on the same computer
At 17:51 27/5/2003 +0200, Vico Timmermans wrote: Hi, Hi list, I have a question about replication in MySQL. I have mysql 4.0.12 (master and slave) on windows 2000. Can I make master and slave on the same computer? Yes. Assuming that you want the master on drive C and the slave on drive D, the lines begin # are my comments: # set the service for master: mysqld-max-nt --install or mysqld-max-nt --install-manual # the commands above installs a service called MySQL # set the service for slave mysqld-nt --install myslave or mysqld-nt --install-manual myslave # the commands above installs a service called myslave now using the same \winnt\my.ini file [mysqld] basedir=c:/mysql datadir=c:/mysql/data port=3306 [myslave] #notice that the server group is the same of the service name basedir=c:/mysql datadir=d:/mysql/data port=3307 #follow the complementary instructions how to set a master and a #slave locating the set keys for master under [mysqld] and the #set keys for the slave under [myslave]. #Run and stop the services using the name mysql for master and #myslave for the slave. If I have the master on disk c, and the slave on disk d: 1) When do I put the my.ini file of the slave? 2) How can I stop and start the slave server? If I run the command NET STOP Mysql it stop the server on disk c.. -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ São Paulo - Brazil /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: computed columns
On Tue, 27 May 2003 12:18:13 -0400, David Shelley wrote: I'm new to mySQL, but like what I see so far. I'm converting several databases from other products to mySQL 4.0.12 for improved speed and reliability. But I'm having trouble with computed columns. I don't see how to define them. Can't find it in the manual.pdf. You don't see how to define them because I don't think that MySQL (or any SQL engine) has them. Plus, I would bet that using calculated columns violates some type of data normalization, and would also probably slow down MySQL considerably. It sounds like you are trying to convert some FileMaker data tables. Off the top of my head it's the only system that lets (actually forces) you to do calculated values in the data table. (It's my biggest pet complaint about FMP along with repeating values.) I need 2 computed columns, 1st takes the columns fName and lName and appends them together with a space between. 2nd column, numDays, takes sDat (contract start date) and eDat (end date) and calculates eDat-sDat+1. Can someone please help me figure out how to define these columns. You can do what you want on retrieval (or for that matter on INSERTion) with: SELECT CONCAT(fName, ' ', lName) as FullName, (TO_DAYS(eDat) - TO_DAYS(sDat) + 1) as DaysDuration FROM mytable; But, then you probably already knew that. grin --- Listserv only address. Jeff Shapiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Errno: 2013
In our production environment, we are receiving sporadic but constant 2013 errors from one of our mysql dbs. The production environment consists of 5 servers running RH 6.2/apache 1.3.27/php 4.0.6, load balanced with a foundry server iron. Each app box queries a central db box, using pconnect, (rh 8.0/mysql 4.0.12) primarily for reads (roughly 80% of a script's db transactions) and another db box for writes (rh 6.2/mysql 4.0.12). Logic is in place to log any mysql errors on each app box from either mysql server. Over the past month, well pretty much since logging was enabled, the 'read' server returns quite a few 2013 errors. We log the 'suspect' query and the queries are valid. Not every query results in an error, but enough where we get up to 50 an hour from every box. During peak times we average around 500 qps. The db server in question is pretty robust and hardly ever carries a load above 1.0. We are using a pretty standard 'huge' version of my.conf, except for the following changed lines: skip-innodb skip-name-resolve set-variable=thread_stack=256k set-variable=wait_timeout=60 set-variable=thread_cache_size=40 From scanning previous posts related to errno 2013, we have adjusted 'thread_stack' to above value as well as the 'wait_timeout'. Nothing so far seems to correct the problem. There seems to be no rhyme or reason as to what causes the errors, many scripts are executed during the day. In fact nobody in our office has even experienced the error first-hand, but logs indicate that it does occur and quite frequently Thanks in advance. Kevin A. Miller -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: computed columns
Actually it's not FileMaker that the old database is in, it's R:Base. I was hoping mySQL supported calculated columns because they're mentioned a couple of times in the manual.pdf for version 4.0.3. Thanks for the suggestion on select concat ... I realize I could do that but I was hoping to make the conversion to mySQL with as few code changes as possible to ensure cross compatability with various databases. I could also solve this with triggers and/or stored procedures if they were supported. Or I could recode the inserts and updates but that would also involve code changes. Dave -Original Message- From: Jeff Shapiro [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 2:53 PM To: [EMAIL PROTECTED] Cc: mySQL Subject: Re: computed columns On Tue, 27 May 2003 12:18:13 -0400, David Shelley wrote: I'm new to mySQL, but like what I see so far. I'm converting several databases from other products to mySQL 4.0.12 for improved speed and reliability. But I'm having trouble with computed columns. I don't see how to define them. Can't find it in the manual.pdf. You don't see how to define them because I don't think that MySQL (or any SQL engine) has them. Plus, I would bet that using calculated columns violates some type of data normalization, and would also probably slow down MySQL considerably. It sounds like you are trying to convert some FileMaker data tables. Off the top of my head it's the only system that lets (actually forces) you to do calculated values in the data table. (It's my biggest pet complaint about FMP along with repeating values.) I need 2 computed columns, 1st takes the columns fName and lName and appends them together with a space between. 2nd column, numDays, takes sDat (contract start date) and eDat (end date) and calculates eDat-sDat+1. Can someone please help me figure out how to define these columns. You can do what you want on retrieval (or for that matter on INSERTion) with: SELECT CONCAT(fName, ' ', lName) as FullName, (TO_DAYS(eDat) - TO_DAYS(sDat) + 1) as DaysDuration FROM mytable; But, then you probably already knew that. grin --- Listserv only address. Jeff Shapiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mailing Labels from MySQL database on web
I have a club roster database set up on our web site in which the underlying data is in a MySQL database. I am using PHP to access the data and display it on a web page as a phone list, e-mail list, directory etc. Now what I need it to give the club secretary a way to print mailing labels. What is the best way to approach this? As a temporary measure, I used an auxiliary program (MySQL-Front running on a PC) to create a CSV file on my PC which I e-mailed to the secretary along with instructions on how to use the file in mail merge document in MS Word to create labels. I thought about writing PHP code to create a CSV formatted output on a web page which the secretary could copy and paste into a document for the mail merge, but it seems there should be a better way. Any suggestions? -Landy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to secure a MySQL database from people with physical acce ss
At 02:22 PM 5/27/2003, you wrote: -Original Message- From: mos [mailto:[EMAIL PROTECTED] Correct, which is why I have a means of compressing and *encrypting* the .exe file. I don't understand how this helps... The EXE file has to contain a complete decryption routine or it can't be executed. So all the person has to do is decompile the decryption routine, and then run the reverse-engineered routine against the program. Alternatively, they can use a debugger and put a breakpoint in at the end of the decryption routine. This sort of stuff does help against a casual attacker, but you always have to keep in mind that you aren't really making the software secure, just raising the energy barrier. It's a bit like the door locks on your car. They'll keep curious people out, but a determined thief will just break a window. The software encryption resists attacks like that. It may not be 100% effective, but it will make it a tough nut to crack. Yes, I am raising the bar. Most people know how to copy files onto diskettes, or email them to a friend. Not that many know how to hack an encrypted program or an encrypted database. So if I eliminate 99.9% of the attackers, I've eliminated a large portion of the threat. Over 50% of computer break-ins are done by internal employees, and by securing the software and database it will greatly reduce the number of successful attacks. It's a bit like the door locks on your car. They'll keep curious people out, but a determined thief will just break a window. Exactly. Do you lock your car when it is on the street? Why? If you're right, someone will only break the window and drive off with it anyway. So leave it unlocked and the keys in it. That way the thief won't rip out the ignition or break a window. After all, he's going to get in anyway, right? Well, the more barriers there are for the thief (or snoop) to overcome, the more likely he will go somewhere else. Mike P.S. Where'd you say you parked your car? :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to secure a MySQL database from people with physical acce ss
At 11:36 AM 5/27/2003, you wrote: -Original Message- From: mos [mailto:[EMAIL PROTECTED] I could encrypt certain table fields, but this will make writing the front end a pain because all SQL statements will now need to be changed any time a new column is encrypted. It also won't help you any, because the software will have to contain everything needed to do the decryption. Unless you can somehow prevent a hypothetical attacker from getting this software, your encryption is only going to keep a casual attacker out. All he has to do is decompile the software enough to figure out your encryption routine. Correct, which is why I have a means of compressing and *encrypting* the .exe file. I can also lock it to the person's machine (or server) so it won't fall into the wrong hands. Generally there's very little you can do to protect data from someone with physical access to the machine -- unless you can keep it in encrypted form, and only decrypt it elsewhere, so that the decryption key never passes through the vulnerable machine. Other databases that use encryption will decrypt the information when a row is accessed, so there is no unencrypted data lying on the hard drive. It is extremely fast and I don't notice a speed difference between encrypted and unencrypted files. Indexes and blobs are encrypted. Anyone trying to access the data outside of my application will see only gibberish. Anyone trying to decompile my application will see only gibberish and it would take a great deal of effort to crack it. MySQL relies on OS security and that can be easily circumvented, at least on a Windows box. I'm sure there are some good hacks for Linux as well. And putting sensitive data on a shared MySQL ISP site gives me shivers.g Even a dedicated MySQL box has its problems if it is located at an ISP outside of my control. Working with MySQL after working with encrypted databases is a lot like living in a house with no doors and windows. You pretty much have to trust everyone in your neighborhood. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: computed columns
On Tue, 27 May 2003 15:23:28 -0400, David Shelley wrote: Actually it's not FileMaker that the old database is in, it's R:Base. I haven't heard of R:Base in YEARS. I was hoping mySQL supported calculated columns because they're mentioned a couple of times in the manual.pdf for version 4.0.3. What the manual is referring to as calculated columns are the columns in a select statement (like the ones mentioned below). Which isn't what you are wanting. Thanks for the suggestion on select concat ... I realize I could do that but I was hoping to make the conversion to mySQL with as few code changes as possible to ensure cross compatability with various databases. I could also solve this with triggers and/or stored procedures if they were supported. Or I could recode the inserts and updates but that would also involve code changes. Well, off hand. I'd say that you are going to have to do some recoding. Hopefully, someone else will have a better idea. snip snip . You can do what you want on retrieval (or for that matter on INSERTion) with: SELECT CONCAT(fName, ' ', lName) as FullName, (TO_DAYS(eDat) - TO_DAYS(sDat) + 1) as DaysDuration FROM mytable; --- Listserv only address. Jeff Shapiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql_fix_privilege_tables behaves odd, explain this
Well this is very interesting At the start of the script they have root_password=$1 host=localhost user=root I added in just below the above echo -- echo $root_password echo -- Then if you try sh mysql_fix_privilege_tables -p somepassword Guess what you get... -- -p somepassword -- So it seems the script takes the whole argument... sh mysql_fix_privilege_tables my_root_pass Works fine Is this standard behavior? The Script says echo If you get 'Access denied' errors, you should run this script again echo and give the MySQL root user password as an argument! Does not really tell you there is some special way to do it. What is the heck is $1 anyway? And why is it a literally quoted value? - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mailing Labels from MySQL database on web
3 things I can think of. None of them really good. 1: VERY BAD Use PHP to generate VBScript to control MS Word. I've actually done this with Excel and while it works, it's not the best solution. (Not by a long shot) 2: BETTER Use PHP to build a PDF on the server in the proper Avery label format and then serve it up through the web server. If you get this working, make sure you share how you did it. 3: Better Use a reporting package. There are several reporting packages for MySQL. Check freshmeat.net or sourceforge.net to find the one best for you. Finally, if the user is local, simply output the labels to the proper LPR/LPD or CUPS device. =C= * Cal Evans * http://www.christianperformer.com * Stay plugged into your audience * The measure of a programmer is not the number of lines of code he writes but the number of lines he does not have to write. * - Original Message - From: Landy Atkinson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 2:25 PM Subject: Mailing Labels from MySQL database on web I have a club roster database set up on our web site in which the underlying data is in a MySQL database. I am using PHP to access the data and display it on a web page as a phone list, e-mail list, directory etc. Now what I need it to give the club secretary a way to print mailing labels. What is the best way to approach this? As a temporary measure, I used an auxiliary program (MySQL-Front running on a PC) to create a CSV file on my PC which I e-mailed to the secretary along with instructions on how to use the file in mail merge document in MS Word to create labels. I thought about writing PHP code to create a CSV formatted output on a web page which the secretary could copy and paste into a document for the mail merge, but it seems there should be a better way. Any suggestions? -Landy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AuthentiX/MySQL/ASP Question
I'm having trouble pulling a response.redirect to an IP located in a Group table. The
user logs in ok, the currentUser variable is dim'ed and stores the data fine.
The problem is matching the currentUser to the user.username stored in MySQL, and
redirecting to the associated IP from the Group table. Here's what I have, although
nothing I do seems to avoid the expected ')' or syntax error messages.
dim currentUser %
% currentUser = AuthX.CurrentUserName(Request.ServerVariables(LOCAL_ADDR),
Request.ServerVariables(SCRIPT_NAME), Request.ServerVariables(HTTP_AUTHORIZATION))
If (1) Then
Set MyConn = Server.CreateObject(ADODB.connection)
dbname=(/dbs/test/test.mdb)
MyConnect=DRIVER={MySql};PROVIDER={mysqld-4.0.12-nt};
MyConnect=MyConnect server.mappath(dbname) ;
MyConn.Open DSN=local
set rstemp = MyConn.execute(SELECT group.hostip FROM test.group, test.user WHERE
group.grouid = user.groupid AND (user.username = currentUser))
response.Redirect(i rstemp /i)
Else response.Write(failed)
response.End
End If %
I'm new at this, so please be kind in your helpful suggestions.
Thanks,
Reuben
Re: Practical samples for table types
Dear Edward, Thank you for the reply. I appreciate your informaton. Do you have by chance also any practical samples ? f.e Until which table size might it be better to use f.e MyISAM and when would you use another format (Heap or a TST table ? f.e When you have have mostly read only access to data and the amount fits into the memory easily than you could think about using a HEAP type etc. How big should the query cache be compared to the table size ? I believe that what I am looking for is practical samples - or some rough guidelines whats known to work good. Best regards Nils Valentin Tokyo/Japan - MyISAM is the default MySQL table type. This is the table type of choice for tables whose primary activity comes from SELECT statements. There is no need for transaction-safe tables unless INSERT, UPDATE, and/or DELETE actions will be performed frequently. Remember that with transaction-safe tables comes an increase in the amount of system resources needed to use those table types. BDB table type is a usable, transaction-safe table type, but it is not the most optimized table type in the mix. BDB tables support the basic elements of transactions as well as the AUTOCOMMIT variable, but are not as popular or as developed as the InnoDB or Gemini types. InnoDB is the more popular and stable transaction-safe table type in open-source MySQL and was designed specifically for high performance with large volumes of data, as well as overall CPU efficiency. Like BDB, support for it did not appear until v3.23.34. Gemini tables are available only in NuSphere's Enhanced MySQL and not in the open source version of MySQL. All of the above is paraphrased from SAMS Teach Yourself MySQL in 24 Hrs. Who knew that book would actually come in handy. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, 27 May, 2003 03:58 Subject: Practical samples for table types Hello mysql fans ;-), This time I have a question which sounds simple, but I believe the answer might not be so easy. I would appreciate to hear from anybody some really good samples of which table type would be good for which occasion. I tried to look for some information perhaps a case study or something like this on the internet but I did not find anything like this. Either I looked for the wrong information or it doesnt exist yet. I understand that ISAM tables are OS dependent and obsolete since MyISAM replaced them. That still leaves 7 formats open. (MyISAM, Merge Tables, HEAP, BDB, InnoDB, GEMINI) I would appreciate a omparison chart or soemthing similar showing the features for each table type etc. I want to figure out f.e. if I can modify HEAP tables or perhaps even use them as slaves in a replication system. What will happen when transformin Innodb tables into BDB or Gemini format. Would that be a good idea or not (and why) ? While this is a complex topic I am approaching I dont expect a simple answer or anybody to know everything I am trying to get a more complete understanding of the tables disadvantages and advantages. While the documentation lists up all options for each table I believe it doesn't necessary describe for which purpose they are useful. Perhaps anybody around who was just thinking the same ? -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp/staff/nils 82-0024 4-6-1 7F Phone: 0424-40-7912 Fax: 0424-40-7913 URL: http://www.knowd.co.jp -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp/staff/nils 182-0024 4-6-1 7F Phone: 0424-40-7912 Fax: 0424-40-7913 URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
help with load from file
Hi, I have a text file where lines look like this: 3 Mac Performa6300CD 338211 LOV 109 \ \ \ 4 Mac G3BT/266350755 LOV 003 \ 9.1 104.103 Except they are not wrapped like in this email! Each column is separated by a 'tab' (at least I think so). The \ character represents data I don't know (null). I have created a db and a table where I would like to upload the data; the table has 9 filelds; the data in the rows, like row 3 and row 4 above (3 4 is also part of the data, the record_id), are in the same order as the fields occur in the table. The table fields are setup with types and so on. How do I get this data in there? I think I am missing somethings? (I'm trying to do it with phpMyAdmin but I can do it from CLI if someone would be so kind as to show me?) Thank you, Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to secure a MySQL database from people with physical access
I have some doubts on how to secure a MySQL database (MyISAM InnoDb) against people who have physical access to the machine. Here are a few scenarios. 1) Let's say I want to use MySQL with my vertical market software but I don't want the customer to have access to my data outside of my application. I also don't want him to have access to my schema or be able to unload the data from the database. If the database is running on the customer's machine, he has root access and therefore can get the passwords and do anything he wants. My competitor could easily buy the software under an assumed name or get a copy from a mutual customer, and then be able to reverse engineer my database. Host the data on a network and make your customers access your machine. Encryption might be another option, but it would take careful planning to make sure your application could get the real data while keeping it away from the customer. 2) The database is installed at an ISP and contains valuable data. Someone at the ISP could make some easy money if he could unload the data or the schema and sell it to my competitor. Heck, my competitor could even open an account with the ISP to add some pressure or incentive to the night staff to make a few bucks on the side. If the database was on a virtual server, he could probably hack into the database without any help from the night staff. The problem is I would never know this has happened. So maintain your own servers. Again, encryption could help, with careful planning. 3) Someone breaks into my office and makes off with my database server. If the server is running Win2k, it is pretty easy to circumvent the administrator passwords in just a few minutes whether it is encrypted by the OS or not. Well, don't use MSW2k. Or, if you have to use it, use real encryption. (MSWindows is not Win, by the way. Why help Microsoft water-up another false trademark?) I could encrypt certain table fields, but this will make writing the front end a pain because all SQL statements will now need to be changed any time a new column is encrypted. No, that's not the way to design the thing. Encryption must be decoupled from both the database and the application, or you just end up with obfuscation. I also don't know how encrypting index fields and large memo's are going to affect performance. Properly decoupled, the only impact should be the encryption time, and possibly some tuning issues with MySQL's index generation functions. Ergo, your application passes queries to the encryption layer, and the encryption layer munges the vital data and passes it with the query to MySQL. MySQL does its thing, then gives the (encrypted) results to the encryption layer, which un-munges the vital data and gives it back to you. I could see playing games with fake character set libraries (with MD-5 or something instead of static conversion tables) or with some other aspect of MySQL's C API, to functionally bury the encryption layer inside MySQL, but you would have to be very careful, or you would just end up with a little bit more difficult version of the protect-your-passwords problem. Trying to provide parsing functions for the encrypted fields (in other words, for regular expression searches) would be likely to leave the barn door open for crackers, of course. Any special parsing on the encrypted fields should be done on the application side, and that might slow things down (An encrypted index of the un-encrypted data is just another clue for the crackers, unless you use a separate method (or separate key, for the stronger methods) for the index. Of course, even if you implement the encryption as a layer between the connection driver and mysql, you would still have to be careful to avoid just building another password puzzler. Is there a transparent solution that will solve these problems? TIA Good question. Let's see what the nearest search engine has to say about it. http://www.google.com/search?hl=enie=ISO-8859-1q=encryption+mysql You might have to dig in a couple of pages, or maybe try a different set of search keys. (That's probably not much help, ...) -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help with load from file
Ted- check out http://www.mysql.com/doc/en/LOAD_DATA.html (go to mysql prompt and issue command LOAD DATA INFILE) keeping attention to format for INFILE Hth, Martin - Original Message - From: [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 9:25 PM Subject: help with load from file Hi, I have a text file where lines look like this: 3 Mac Performa6300CD 338211 LOV 109 \ \ \ 4 Mac G3BT/266 350755 LOV 003 \ 9.1 104.103 Except they are not wrapped like in this email! Each column is separated by a 'tab' (at least I think so). The \ character represents data I don't know (null). I have created a db and a table where I would like to upload the data; the table has 9 filelds; the data in the rows, like row 3 and row 4 above (3 4 is also part of the data, the record_id), are in the same order as the fields occur in the table. The table fields are setup with types and so on. How do I get this data in there? I think I am missing somethings? (I'm trying to do it with phpMyAdmin but I can do it from CLI if someone would be so kind as to show me?) Thank you, Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Select name, email where birthday = ??
Hello, I have a date field in my database Format is -MM-DD Once a day at 12:01AM a script is going to run that will Select name, email from users where birthday = ?? And the ?? Is where I am stuck, I don¹t care about the year at all, I just need to match on the month and day, how would I do this? - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Select name, email where birthday = ??
Where MONTH(birthday)=MONTH(now()) AND DAYOFMONTH(birthday)=DAYOFMONTH(now()) Adam Clauss [EMAIL PROTECTED] -Original Message- From: Scott Haneda [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 9:21 PM To: MySql Subject: Select name, email where birthday = ?? Hello, I have a date field in my database Format is -MM-DD Once a day at 12:01AM a script is going to run that will Select name, email from users where birthday = ?? And the ?? Is where I am stuck, I don¹t care about the year at all, I just need to match on the month and day, how would I do this? - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help with load from file
I also have it prepared like this: 1,Mac,SE30,314784,LOV,115,,, 2,Mac,Performa6300CD,338211,LOV,109,,, Also, I did have all the \ as \N previously. But what about at the end of lines. What I had with \N wouldn't take so I was hoping someone might out what the error might be coming from by looking a few of my lines? And to Martin: I actually, for once, DID look at the manual there before I wrote. I was really hoping someone could show me just one proper line and the syntax to upload it. :-( Thanks, Ted p.s. writing a script for me is not simple! ;-) I only this one with about 100 entries and I'm done, I do want to learn by it though and get it in there using some kind of text file. On Tuesday, May 27, 2003, at 09:32 PM, Steve Gums wrote: I know I will get ridiculed for this but you could write a rather simple awk script to print this data comma delimited with for strings and turn the \ into \N for MySQL and that should import rather well. But like I said I am sure someone out there has a much better solution then the one I mentioned. Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 7:26 PM To: MySQL List Subject: help with load from file Hi, I have a text file where lines look like this: 3 Mac Performa6300CD 338211 LOV 109 \ \ \ 4 Mac G3BT/266350755 LOV 003 \ 9.1 104.103 Except they are not wrapped like in this email! Each column is separated by a 'tab' (at least I think so). The \ character represents data I don't know (null). I have created a db and a table where I would like to upload the data; the table has 9 filelds; the data in the rows, like row 3 and row 4 above (3 4 is also part of the data, the record_id), are in the same order as the fields occur in the table. The table fields are setup with types and so on. How do I get this data in there? I think I am missing somethings? (I'm trying to do it with phpMyAdmin but I can do it from CLI if someone would be so kind as to show me?) Thank you, Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help with load from file
Yes, I simply don't understand this: === LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY '\t'] [[OPTIONALLY] ENCLOSED BY ''] [ESCAPED BY '\\' ] ] [LINES [STARTING BY ''] [TERMINATED BY '\n'] ] [IGNORE number LINES] [(col_name,...)] == Help? Ted On Tuesday, May 27, 2003, at 09:35 PM, Martin Gainty wrote: Ted- check out http://www.mysql.com/doc/en/LOAD_DATA.html (go to mysql prompt and issue command LOAD DATA INFILE) keeping attention to format for INFILE Hth, Martin - Original Message - From: [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 9:25 PM Subject: help with load from file Hi, I have a text file where lines look like this: 3 Mac Performa6300CD 338211 LOV 109 \ \ \ 4 Mac G3BT/266 350755 LOV 003 \ 9.1 104.103 Except they are not wrapped like in this email! Each column is separated by a 'tab' (at least I think so). The \ character represents data I don't know (null). I have created a db and a table where I would like to upload the data; the table has 9 filelds; the data in the rows, like row 3 and row 4 above (3 4 is also part of the data, the record_id), are in the same order as the fields occur in the table. The table fields are setup with types and so on. How do I get this data in there? I think I am missing somethings? (I'm trying to do it with phpMyAdmin but I can do it from CLI if someone would be so kind as to show me?) Thank you, Ted
Re: Select name, email where birthday = ??
Try: select name, birthday from atable where month(birthday)=month(now()) and dayofmonth(birthday)=dayofmonth(now()); Marcel - Original Message - From: Scott Haneda [EMAIL PROTECTED] To: MySql [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 10:20 PM Subject: Select name, email where birthday = ?? Hello, I have a date field in my database Format is -MM-DD Once a day at 12:01AM a script is going to run that will Select name, email from users where birthday = ?? And the ?? Is where I am stuck, I don¹t care about the year at all, I just need to match on the month and day, how would I do this? - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Practical samples for table types
In the meanwhile I found a bit information which goes into the direction what I look for. http://www.mysql.de/newsletter/2002-12/a91.html www.nusphere.com/products/library/gemini.pdf (page 11) I still would appreciate any feedback or additonal information from experienced MySQL users. Best regards -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp/staff/nils 182-0024 4-6-1 7F Phone: 0424-40-7912 Fax: 0424-40-7913 URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: what is the best data format to start with when importing data into mysql?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 27 May 2003 11:17:34 +0200, Emiliano Rustighini wrote: I can ask for the data in any data format, but I would like to get some advice on what is best to ask for. I have found text format to be the most flexible method for transferring between systems. It bypasses big-/little-endian problems, you can floating point as accurate as you want, etc. Its only downside is the increase in size, approximately 1.5x, over using binary formats. If you have some suggestions about the connection tool as well it would be grand. Since you gave no clue which systems you are using, it's hard to suggest anything. - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP SIGNATURE- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE+1EC9sxxMki0foKoRAlrLAJ0dcg2Wf4qyNW4dkmaIDc1IDB7wKwCgnmOA qSjWb8sEhPA2mOypLz53+zw= =a3p6 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Select statement driving me crazy
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 27 May 2003 16:33:45 +0200, Anthony Ward wrote: SELECT userid,subject,date,code FROM testing WHERE userid=testid Use only single quotes. - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP SIGNATURE- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE+1EHdsxxMki0foKoRAnfLAKCHZ0ttOIhwVUoWMPMm1Cu4/8AEMwCgkqQn hjOxuSVRqdMutpH1UB/S7q8= =R0p8 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Big Insert query problem
Hi, I have FreeBSD 5.1beta with mysql 4.0.13. When I try to insert 18MB data into myisam table using command mysql emls big_query, it says Error 1030 (Got error 12 from table handler). After that myisam table crashes and I have to run mysqlcheck command to fix the index. The query is only one insert query with 18MB of data. Can somebody suggest me the solution for this? Thanks in advance, Ganbold -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
