Have some problem with Ver 4.0.13

Hi. I used MySQL for over 2 years since ver 3.22 and now use ver 3.23.49 Z9bundle with RedHat 7.3) it work fine and now I decide to upgrade to ver 4 (as production cersion) I download ver 4.0.12 but when I will start to upgrade the new one 4.0.13 launch so I decide to up to 4.0.13 instead of 4

Re: mysql & ssh tunneling

On Sun, May 25, 2003 at 12:09:33PM +0200, Tobias Schittkowski wrote: > I established the tunneling connection, and a > mysql -h localhost -u foo -pbar mysql > connects me nicely to the server. > > However, if I use the > mysql_real_connect(...) > the host hangs. What host are you using? Try runn

Charset=latin1 problem

Hello I have two MySQL 4.1 servers installed. One at home and at my work. Both run WinXP. I used mysqldump to export my database at work and tried to import it at my home server, I am getting the following error in one of the - create table defintaion Error Code : 1064 You have an error in your

Utf-8 in 4.1

Hello, 4.1 version can use UTF-8 encoding, but as far I remember there is something wrong with this feature. Can you tell us when 4.1.1 version will be released and is it will be fixed. Best regards, Marek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

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 on

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

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 be

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.

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 whe

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 [ST

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 wh

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 = ?? > > > Hel

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 t

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 Subj

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

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

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 t

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 ta

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

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 "--

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

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 w

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

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. W

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

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

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'

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 l

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.

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

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 choke

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 > recomme

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 s

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 imaginab

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 solut

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

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 Fr

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 ari

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.

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 te

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] Sub

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 C

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

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

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

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:

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

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] > Su

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 da

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

Re: group by

On 27-May-2003 Jose Miguel Pérez wrote: > 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 a

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 th

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 PR

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 t

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 WHE

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

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

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

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

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]

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!