mySQL on Windows CE

Hi, Is this supported? I mean I just look at the FAQ and find it is on the list of supported platform (Handheld: Windows CE), but I hardly see any article mention about it. I have downloaded two connector (.NET and ODBC), but which one should I use for Windows CE development? Could someone help

Re: repair table priv

up Bgs wrote: Does this silence mean that nobody knows?!? :) I've been trying to find what privilege is needed to 'REPAIR TABLE'. I couldn't find any usefull hint on the net or in the archives. Could anyone help me out? -- MySQL General Mailing List For list archives:

Re: repair table priv

I think you need to have root privileges (ALL) on the table to run REPAIR TABLE since this is a disaster recovery sql command. It works only for MyISAM tables in MySQL. I don't think it is supported for all tables. Logically a repair table command would update, insert, delete and alter the

Re: repair table priv

Hi, I think you need to have root privileges (ALL) on the table to run REPAIR TABLE since this is a disaster recovery sql command. It works only for MyISAM tables in MySQL. I don't think it is supported for all tables. I need it because I got a server with big load that sometimes has db

MySQL and x86-64

Hi! It seems that I need to buy a 64bit server and have some questions regarding the two architectures from AMD (Opteron) and Intel (Xeon with EM64T). Am I right if I say an Opteron based server is the better choice for MySQL because of the more advanced and faster bus system? Is there anywhere

Re: MySQL and x86-64

Hey, 1. We just installed a very large MySQL installation on a dual opteron 2ghz system with 16GB of memory and it -flies-. That's pretty subjective, so check: http://www6.tomshardware.com/cpu/20030422/opteron-17.html http://www.infoworld.com/article/04/09/17/38FE64shootout2_1.html Definately,

Re: MySQL and x86-64

Hi, Dylan Neild schrieb: 1. We just installed a very large MySQL installation on a dual opteron 2ghz system with 16GB of memory and it -flies-. That's pretty subjective, so check: http://www6.tomshardware.com/cpu/20030422/opteron-17.html

Re: Full Text Search - Limits?

Eric, the column type will limit the number of characters per row. A column of type TEXT will hold up to 65,535 characters but with LONGTEXT you can put up to 4,294,967,295 charcters into one row. I have an application with Texts of up to 200 pages in one column. Full-Text Search is handling this

Definition of password hashing algorithm in 4.1.7

I've been looking into what algorithm MySQL 4.1.7 uses for password hashing/encryption, with a view to ascertaining how secure it is. Does it conform to any combinations of published Specs e.g. MD5/SHA-1/etc? I had a look at com.mysql.jdbc.Util#newHash() and #newCrypt() in Connector/J 3.0, but

Cannot connect to local server problem

Hi, i built an application which uses MySQL 4.0.17 using Windows XP Professional. Tomorrow, i need to present the application to my client, so i preparing my enviroment in a laptop, which runs Windows 2000. When i installed MySQL 4.0.17 and tried to run the client from command line, i got the

RE: Cannot connect to local server problem

Did you reboor after install? -Original Message- From: Leandro Melo [mailto:[EMAIL PROTECTED] Sent: woensdag 15 december 2004 14:51 To: lista mysql Subject: Cannot connect to local server problem Hi, i built an application which uses MySQL 4.0.17 using Windows XP Professional.

Re: Cannot complete database transfer

Did you install MySQL on the other box? It sounds like you took a snapshot of the data but have not installed the executables yet. James Sherwood wrote: I am trying to transfer a database from one linux box to another, both using redhat. On one I performed a mysqldump and it worked fine. On the

Re: Cannot complete database transfer

I keep getting 'command not found'. This error indicates that your shell cannot find the mysql file to execute (or that it is not executable for some reason... bad permissions). This can be caused by mysql (client) not being installed or by the client not being on a path that your user can

RE: Definition of password hashing algorithm in 4.1.7

Mike, The newest MySQL uses SHA1 in combo with random generated 20 byte session hash values. The procedure is irreversible and therefore why it is not possible to obtain the original password. MySQL is thus very secure and only vulnerable to a bruteforce attack. You can partially secure

Re: Cannot complete database transfer

It seems like the database installed fine(it is up and running, but I use a manager from a windows box to manipulate it) but maybe the client messed up on install? If so is there a way to just install the mysql client? James - Original Message - From: Jason McKnight [EMAIL PROTECTED]

ERROR 1044 (42000): Access denied for user 'root'

Hi, As the root user I created a DB a populated with tables... but when I want to create a user to handle that DB i get this error message: mysql grant all on db.* to [EMAIL PROTECTED] identified by 'password'; ERROR 1044 (42000): Access denied for user 'root' What could be the reason??? I

Re: To use Quotes or not to, that's the question.

On Wednesday 15 December 2004 15:38, Dave Juntgen might have typed: Hi! Could someone please explain to me why the second query below is faster then the first query? The only difference between the two is that ext_doc_id's value is quoted. Index and column information follow and the table

To use Quotes or not to, that's the question.

Hi! Could someone please explain to me why the second query below is faster then the first query? The only difference between the two is that ext_doc_id's value is quoted. Index and column information follow and the table being queried contains approximately 3.5 million rows. Thanks!

Re: text retrieval functions

Thx for your interest.. The type of my question is for learning what to choose. I would use what u suggest me.. The only information i can provide u is that i am running linux.. If u can suggest me the version of mysql and the appropriate function and after i will continue searching... I am

Re: Cannot complete database transfer

Yes, there are other databases on that mysql installation. The only thing is, I recently upgraded it to the latest release of mysql. James - Original Message - From: Victor Pendleton [EMAIL PROTECTED] To: James Sherwood [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December

Re: Full Text Search - Limits?

EP [EMAIL PROTECTED] wrote on 15/12/2004 15:44:15: Thomas Spahni [EMAIL PROTECTED] wrote: the column type will limit the number of characters per row. A column of type TEXT will hold up to 65,535 characters but with LONGTEXT you can put up to 4,294,967,295 charcters into one row. I

Re: To use Quotes or not to, that's the question.

Query caching? The second response probably came from the cache. To be absolutely sure (a.k.a overkill) that you have no cached results, you can restart the server between each query. Or, you can use the RESET QUERY CACHE command to clear your cache without the restart.

Re: Definition of password hashing algorithm in 4.1.7

Mark Matthews wrote: [ ... ] Mike Moran wrote: I've been looking into what algorithm MySQL 4.1.7 uses for password hashing/encryption, with a view to ascertaining how secure it is. Does it conform to any combinations of published Specs e.g. MD5/SHA-1/etc? [ ... ] Mike, MySQL-4.1.7 uses SHA-1.

Re: text retrieval functions

You mention nothing about your environment. What OS are you using? What version MySQL (server and client) are you using? How do you intend to interact with your database? Will you be using one of the many tools available to directly interact with a MySQL server or will you be writing a

RE: ERROR 1044 (42000): Access denied for user 'root'

Ed, It sounds like root doesn't have the GRANT permission for the localhost. You can check by querying the User table in mysql. --Dave David W. Juntgen Medical Informatics Engineering Inc. Phone: 260.459.6270 Fax : 260.459.6271 -Original Message- From: Guru Vai Kernel-Hacker!!!

RE: To use Quotes or not to, that's the question.

ext_doc_id is a CHAR type, which means that you may have two rows, 0412625, and 412625, both of which match the expression WHERE ext_doc_id=412625. MySQL can't use an index because it has to convert each field to a number before doing the comparison. Your second query is doing a direct

Help getting mysqld to read my my.cnf on start from init.d on mandrake 10.1 and mysql 4

Hello, I am building a new DB box. The box is mandrake 10.1 and mysql 4.0.20 All my other boxes are RH9 and mysql 3 The one problem I am having is they appear to do the my.cnf differently There was no my.cnf in the /etc dir, so I created one from my-huge.cnf and placed it in the /etc But the

Re: Help getting mysqld to read my my.cnf on start from init.d on mandrake 10.1 and mysql 4

At 11:02 -0600 12/15/04, Randy Paries wrote: Hello, I am building a new DB box. The box is mandrake 10.1 and mysql 4.0.20 All my other boxes are RH9 and mysql 3 The one problem I am having is they appear to do the my.cnf differently There was no my.cnf in the /etc dir, so I created one from

Relative efficiency (in terms of disk io) between REPLACE and UPDATE w/InnoDB

I'm currently doing a large number of REPLACE queries, I know that these evaluate as if doing a DELETE/INSERT pair, and I'm wondering if this is true on a disk io level as well with extra io occuring for the delete, and then re-insertion, vs what would occur with an UPDATE. The way it works

RE: Help getting mysqld to read my my.cnf on start from init.d on mandrake 10.1 and mysql 4

At 11:23 -0600 12/15/04, Randy Paries wrote: So I tried $bindir/mysqld_safe --defaults-file=/etc/my.cnf --datadir=$datadir --defaults-file=/etc/my.cnf --pid-file=$pid_file /dev/null I get the error:: 041215 11:15:11 mysqld started /usr/sbin/mysqld: ERROR: unknown variable

Re: Relative efficiency (in terms of disk io) between REPLACE and UPDATE w/InnoDB

On Wed, 2004-12-15 at 11:46 -0600, gerald_clark wrote: John McCaskey wrote: I'm currently doing a large number of REPLACE queries, I know that these evaluate as if doing a DELETE/INSERT pair, and I'm wondering if this is true on a disk io level as well with extra io occuring for the

Auth Problem

Hi there im running a Server with several domains on it. i installed a shop today and i got problems with the user i made for the database. its possible to login with root account also the other accounts are working but not this one. i get this well known error message: *Warning*:

Re: To use Quotes or not to, that's the question.

In the last episode (Dec 15), Dave Juntgen said: ext_doc_id is a CHAR type, which means that you may have two rows, 0412625, and 412625, both of which match the expression WHERE ext_doc_id=412625. MySQL can't use an index because it has to convert each field to a number before doing the

Re: Double conversion error

Hello, The create table statement is as follows: CREATE TABLE `call` ( `call_id` int(10) unsigned NOT NULL auto_increment, `init_lband` int(10) unsigned NOT NULL default '0', `chan_assign_sec` tinyint(3) unsigned default NULL, `adn_time_sec` tinyint(3) unsigned default NULL, `setup`

Re: YOUR EMAIL ADDRESS HAS BEEN ADDED TO MY WHITE LIST

[EMAIL PROTECTED] wrote: Your email address has been added to my Spam Fighter White List. Adding your address to the White List ensures that I will always receive email you send to me. How do I unsubscribe from your Spam Figher White List spam?! :) Kevn -- Use Rojo (RSS/Atom aggregator).

Restart of Mysql and tomcat error

Hello Since that list is wonderfull to solve my problem, I will try again. But this might not be the best place since the problem concerns mysql access througt tomcat (jakarta-tomcat-5.0.28). The java application we have, when start after a mysql restart (night backup) , will give an error

Re: Restart of Mysql and tomcat error

Duhaime Johanne wrote: Hello Since that list is wonderfull to solve my problem, I will try again. But this might not be the best place since the problem concerns mysql access througt tomcat (jakarta-tomcat-5.0.28). The java application we have, when start after a mysql restart (night backup) ,

Re: No connect to mysql

Hi, I have the following permission: #ls -l /var/lib/ drwxr-xr-x 4 mysql root .. mysql .. in the mail.err: /usr/sbin/mysqld: Cant't open file: 'host:MYI'. (errno: 142) Fatal error: Can't open privilege tables: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) and: #ls -l

RE: Restart of Mysql and tomcat error

Johanne, There are numerous questions about connection methods, pooling etc that would be better asked in the tomcat list and would require work in your web application. However, putting on my pragmatic system integrator hat, could you get round this by simply doing a request to your application

unions will full column names won't work in 4.1.7

Not sure if this is a bug... probably should be. On 4.1.18 I can run: (SELECT * FROM FOO WHERE ID = 1) UNION (SELECT * FROM FOO WHERE ID = 2) ORDER BY FOO.COL_A Which will work just fine However when I use this query on 4.1.7 I get ERROR 1250 (42000): Table 'ARTICLE' from one of the SELECTs cannot

Re: unions will full column names won't work in 4.1.7

At 16:23 -0800 12/15/04, Kevin A. Burton wrote: Not sure if this is a bug... probably should be. On 4.1.18 I can run: 4.1.18? I assume you mean 4.0.18. Anyway, what you describe is according to the documentation: http://dev.mysql.com/doc/mysql/en/UNION.html (SELECT * FROM FOO WHERE ID = 1) UNION

Re: unions will full column names won't work in 4.1.7

- Original Message - From: Kevin A. Burton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 15, 2004 7:23 PM Subject: unions will full column names won't work in 4.1.7 Not sure if this is a bug... probably should be. On 4.1.18 I can run: (SELECT * FROM FOO WHERE

Using Multiple Selects

A quick question on the performance of the SELECT statement. I have a table with a set of 50 products, each product has about 10 attributes associated with it. The user will select certain aspects of a product (height, weight, colour, length etc.), and many products may display a particular

Re: Relative efficiency (in terms of disk io) between REPLACE and UPDATE w/InnoDB

Hi, On Wednesday, December 15, 2004, at 12:51 PM, John McCaskey wrote: On Wed, 2004-12-15 at 11:46 -0600, gerald_clark wrote: John McCaskey wrote: I'm currently doing a large number of REPLACE queries, I know that these evaluate as if doing a DELETE/INSERT pair, and I'm wondering if this is

table types

How do I find out what table type is associated with each of the tables in MYSQL? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: text retrieval functions

Alaios [EMAIL PROTECTED] added: Thx for your interest.. The type of my question is for learning what to choose. I would use what u suggest me.. The only information i can provide u is that i am running linux.. If u can suggest me the version of mysql and the appropriate function and

Re: Trying to download database

Julie - Please specify which database binaries you are downloading. If you could provide us with the url's that would be much appreciated in helping you troubleshoot this. For Windows binaries, I would refer to the HTTP / FTP mirror links listed at the bottom of this page:

RE: moving DB from one box to another.

Sorry, When I do the mysql dbname oldbox.sql I get the error message It creates mysqldump dbname -h oldbox oldbox.sql fine Thanks -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 15, 2004 11:25 PM To: Randy Paries; [EMAIL PROTECTED] Subject:

text retrieval functions

Hi... I need some function and the appropriate type field s of a table that are able to search and store big texts (such as books,magazines,articles) Thx a lot __ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search.

Error 1064: type mismatch

Hello list. I'm new to MySQL but so far I like it a lot. I have it running on WinNT4 w/SP6a and I use MySQL Admin. I'm having trouble running an application from a third party, this application launches but whenever I try a query, I get a message that says Type mismatch for field field

Re: Cannot connect to local server problem

Have you verified that the MySQL server is currently running? Was this installed as service to automatically start up? Leandro Melo wrote: Hi, i built an application which uses MySQL 4.0.17 using Windows XP Professional. Tomorrow, i need to present the application to my client, so i preparing my

Cannot complete database transfer

I am trying to transfer a database from one linux box to another, both using redhat. On one I performed a mysqldump and it worked fine. On the other I created the database using a manager and tried the 'mysql username password database filename.sql' command The problem is, I cannot seem to get

find all records with more than one occurrence

Hi, How can I check all duplicated rows out from a large table? The values are not keys so they may have more than one occurrence. Thanks for your help. Regards, CHAN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Cannot complete database transfer

What do you get when you do a `which mysql` from the command line? James Sherwood wrote: Yes, there are other databases on that mysql installation. The only thing is, I recently upgraded it to the latest release of mysql. James - Original Message - From: Victor Pendleton [EMAIL PROTECTED]

Re: Definition of password hashing algorithm in 4.1.7

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mike Moran wrote: I've been looking into what algorithm MySQL 4.1.7 uses for password hashing/encryption, with a view to ascertaining how secure it is. Does it conform to any combinations of published Specs e.g. MD5/SHA-1/etc? I had a look at

RE: find all records with more than one occurrence

Hi, How can I check all duplicated rows out from a large table? The values are not keys so they may have more than one occurrence. Thanks for your help. Regards, CHAN Chan, what about using DISTINCT in the select? .. or am I missing something? Kind Regards SciBit MySQL Team

Re: find all records with more than one occurrence

At 08:49 AM 12/15/2004, you wrote: Hi, How can I check all duplicated rows out from a large table? The values are not keys so they may have more than one occurrence. Thanks for your help. Regards, CHAN Try something like: select count(*) num, colvalue from table1 group by colvalue having num 1

YOUR EMAIL ADDRESS HAS BEEN ADDED TO MY WHITE LIST

Your email address has been added to my Spam Fighter White List. Adding your address to the White List ensures that I will always receive email you send to me. If you aren't using All-in-One SECRETMAKER, I recommend that you examine this powerful freeware. I recommend All-in-One SECRETMAKER

Re: To use Quotes or not to, that's the question.

In the last episode (Dec 15), Dave Juntgen said: Could someone please explain to me why the second query below is faster then the first query? The only difference between the two is that ext_doc_id's value is quoted. Index and column information follow and the table being queried contains

Re: Full Text Search - Limits?

Thomas Spahni [EMAIL PROTECTED] wrote: the column type will limit the number of characters per row. A column of type TEXT will hold up to 65,535 characters but with LONGTEXT you can put up to 4,294,967,295 charcters into one row. I have an application with Texts of up to 200 pages in one

Re: MySQL Query Browser

Hassan Shaikh wrote: The MySQL Query Browser online documentation clearly mentions that it runs on 32-bit Windows operating systems, including Windows 95, 98 and Me. However, while installing it on WinME, I get the following error: The Operating System is not adequate for running MySQL Query

Re: Relative efficiency (in terms of disk io) between REPLACE and UPDATE w/InnoDB

John McCaskey wrote: I'm currently doing a large number of REPLACE queries, I know that these evaluate as if doing a DELETE/INSERT pair, and I'm wondering if this is true on a disk io level as well with extra io occuring for the delete, and then re-insertion, vs what would occur with an UPDATE.

RE : Mysql client that does export and import

Thank you everybody for the answers. Finally I downloaded SQLyog and it works fine for import /export Johanne -Message d'origine- De : Karam Chand [mailto:[EMAIL PROTECTED] Envoyé : 14 décembre 2004 22:32 À : Duhaime Johanne Cc : [EMAIL PROTECTED] Objet : Re: Mysql client that does

Re: MySQL Query Browser

YOu could try the free version of SQLyog. It works on my Win98. www.webyog.com Karam --- Chris [EMAIL PROTECTED] wrote: Hassan Shaikh wrote: The MySQL Query Browser online documentation clearly mentions that it runs on 32-bit Windows operating systems, including Windows 95, 98 and

Delete or Update on Import

Once each day I have a PHP application that reads a legacy dBase format file and updates a customer table in a MySQL database. The PHP script reads each dBase record, searches for it in the table, updates the field values if they have changed, or creates a new record in the MySQL database if one

Repeat records on results

I sort of know why this is happening. Just not sure how to correct it. My query: SELECT Reg.firstname,Reg.lastname, Profiles.ProfileName FROM Profiles INNER JOIN Reg ON (Profiles.LID = Reg.RegID) INNER JOIN PSkicerts ON Profiles.ProfileID = PSkicerts.ProfileID) where Profiles.Status != 2

Upgrading from 3.23 to 4.1

Hi all, I have installed FC3 on a system which supposed to act as Database server on a small LAN. MySQL server version 3.23 (I think) and all its parts has been installed. How can I upgrade it to MySQL 4.1 (latest version). Can anyone guide me step by step ? Here is some critical information

Re: No connect to mysql

J.R. Bullington wrote: Make sure that you have run `#/usr/local/mysql/bin/safe_mysqld ` ..when I try: #/usr/bin/safe_mysqld [1] #Starting mysqld daemon with database from /var/lib/mysql STOPPING server from pid file /var/lib/mysql/mail.pid 041215 23:56:46 mysqld ended and:

moving DB from one box to another.

hello, I have built a new DB box. Orig db is mysqld Ver 3.23.58 New DB is mysqld Ver 4.0.20 I want to move the data from one box to another. I have a couple of really large tables with longtext fields. This data is a bunch of HTML My plan was to do a mysqldump dbname -h oldbox oldbox.sql then

Re: moving DB from one box to another.

At 23:21 -0600 12/15/04, Randy Paries wrote: hello, I have built a new DB box. Orig db is mysqld Ver 3.23.58 New DB is mysqld Ver 4.0.20 I want to move the data from one box to another. I have a couple of really large tables with longtext fields. This data is a bunch of HTML My plan was to do a

MySQL load balancing...

Was curious what people on the list are using for load balancing.. there are a number of techniques here but it would be interesting if people could share some real-world experiences HTTP load balancing is pretty well understood but there's not a bunch out there on MySQL load balancing

koi8r dbd::mysql

Hello! redhat 2.3 as DBD-mysql-2.9004 perl 5.8.0 MySQL-server-4.1.7-0.i386.rpm from mysql.org [EMAIL PROTECTED] start]# cat /etc/my.cnf [client] default-character-set=koi8r [mysqld] default-character-set=koi8r [mysql] default-character-set = koi8r From mysql command line all select's work ok,