Re: MySQL with InnoDB on a readonly filesystem.

Jeremy Cole wrote: Is it possible to run MySQL with InnoDB enabled on a readonly filesystem. We only intend to run some select query's on this server. I guess I can ask the obvious question. Why are you trying to use InnoDB, if your data/filesystem is read only? Why not use MyISAM

Re: mysql 4.1.14 suddenly does not see some data files!

Hello. Have a look here: http://dev.mysql.com/doc/refman/5.0/en/cannot-find-table.html Nathan Gross wrote: Hi; I have been running this server, 4.1.14 on Linux FC 4 for while, no problem= s. Yesterday I fiddled with my.cnf via the Administrator console to, tried some graphs, and

Image Storage -- Better to store them on the Filesystem or in the MySQL DB

Hey, we´ve large amount of Images ( nearly 2 GB ). And they will increase, cause or Editors will submit several articles a day where they´re allowed to upload some new pics. So, whats the better solution ? To store them in the filesystem ( with only the path in the db ) or to store them as

Re: Your message to MySQL AB (ID#863700)

Dear Sirs, This is my 3rd time I am writing to you. May be there is a problem! We want to buy some MySQL 5.0 licenses. What happens after 1 year expires - do we have to buy another licences or not?! Also we want to upgrade from 4.1.18. Do we need a license for this purpose?! Best Regards

Re: 4.1 password problem

On 24/11/2005, Lowell Allen wrote: but I'm looking for a way to convert the short hash values into comparable long hash values. This is (fortunately) *not* possible. Apparently the upgrade procedure can successfully convert short-to-long hash values for MySQL user passwords It doesn't.

Re: Your message to MySQL AB (ID#863700)

Dear George, THis is a public mailing list, not the MySQL sales channel;-). You may want to contact MySQL directly. Their contacts are written at their homepage http://www.mysql.org. Best regards Nils Valentin Quoting George Vanev [EMAIL PROTECTED]: Dear Sirs, This is my 3rd time I am

RE: urgent : PLEASE HELP - problems with back up and restore

Hi, Thanks Again. You are really helping me Well it get a lot of query ok, 0 rows affected 0.00 sec And one like this : query ok, 2 rows affected 0.01 sec Records: 2 Duplicates: 0 Warnings: 0 But it look like everything is in the Database now ? What is this Source Command ?

Using a Stored Procedure that returns a resultset

Hi there, I cannot figure out how to use a Stored Procedure that returns a resultset and I cannot find it in the documentation. For example: CREATE PROCEDURE P_Select() READS SQL DATA begin select * from enum_table; end I believe that CALL can only be used for output parameters, correct?

Re: Possible ways to sort numbers stored in a varchar column?

Thanks i also found the function CAST which works ok. So now i have three options: CAST LPAD Adding zero Any other sugestions are welcome! Quoting [EMAIL PROTECTED]: Test USER [EMAIL PROTECTED] wrote on 11/23/2005 07:36:43 PM: Is the only way to sort numbers stored in a varchar column to

Re: Using a Stored Procedure that returns a resultset

Martin CREATE PROCEDURE P_Select() READS SQL DATA begin select * from enum_table; end How would I get a resultset? No need for an OUT param, just call the sproc, you'll see. PB - Martijn Tonies wrote: Hi there, I cannot figure out how to use a Stored Procedure that returns a resultset

Re: Using a Stored Procedure that returns a resultset

CREATE PROCEDURE P_Select() READS SQL DATA begin select * from enum_table; end How would I get a resultset? No need for an OUT param, just call the sproc, you'll see. I tried that, but in Delphi with the particular component-set I'm using, this raises: mySQL Error Code: (1312)

Re: 4.1 password problem

Felix Geerinckx wrote: On 24/11/2005, Lowell Allen wrote: but I'm looking for a way to convert the short hash values into comparable long hash values. This is (fortunately) *not* possible. Apparently the upgrade procedure can successfully convert short-to-long hash values for MySQL user

Re: select command

- Original Message - From: asus77x [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, November 24, 2005 2:07 AM Subject: select command I have a command : SELECT * FROM reg_one WHERE 'varName' like 'varTmp' % This is made within dreamweaver mx. I think there must be a

How to compose index?

I have following query: SELECT SQL_NO_CACHE users.user_name assigned_user_name, accounts.* FROM accounts LEFT JOIN users ON accounts.assigned_user_id=users.id where (accounts.assigned_user_id='1') AND accounts.deleted=0 ORDER BY phone_office asc LIMIT 620300,20 In your opinion, what group

MyIsam Vs InnoDB

Hello List, When I do a bulk import into a MyIsam engine database, I can reach about 2-3 thousand records imported per second. However when I use the InnoDB engine, I am only importing about 30-50 records per second? Am I missing something here? its a P4 3 Ghz machine with 1024mb ram. running

Problem with mysql-administrator-1.1.5, s.o.

Hallo, ich have a problem with mysql-administrator-1.1.5 and mysql-query-browser-1.1.17 running under Windows NT Sp6. Starting the tools I get the error message, like procedure GetFileSizeEx not found in Kernel32.dll. Suppose you have to define #ifdef NT while compiling, or similar,

Re: How to compose index?

I have following query: SELECT SQL_NO_CACHE users.user_name assigned_user_name, accounts.* FROM accounts LEFT JOIN users ON accounts.assigned_user_id=users.id where (accounts.assigned_user_id='1') AND accounts.deleted=0 ORDER BY phone_office asc LIMIT 620300,20 In your opinion, what group

mysql_num_rows

Dear All I have a problem with mysql_num_rows if I execute it on a result returned by mysql_query,,, and that result is empty then I will get an error saying that this result is not a valid mysql result I am using count(*) and checking if my SQL statements will return more than

MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

Dear list, I'm considering programming a simple Search Engine for a website, to find Arabic/Persian data within a MySQL database. This database contains a huge amount of data, encoded with Unicode (UTF-8). The big deal is to ** reduce the response time ** to end-users. My

Re: MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

AmirBehzad Eslami [EMAIL PROTECTED] wrote on 24/11/2005 17:48:29: Dear list, I'm considering programming a simple Search Engine for a website, to find Arabic/Persian data within a MySQL database. This database contains a huge amount of data, encoded with Unicode(UTF-8). The

Re: Using a Stored Procedure that returns a resultset

Hi Martijn I tried that, but in Delphi with the particular component-set I'm using, this raises: mySQL Error Code: (1312) PROCEDURE test.p_Select() can't return a result set in the given context Ah, you're not the first to have that error message, eg see the discussions at

Re: Image Storage -- Better to store them on the Filesystem or in the MySQL DB

Hi Marco! I had a similar problem and was advised that the native filesystem is faster than doing lookups and some sort of rendering. So storing the link in the db will do it, and then just have the images at the pointed-to location. Cheers! -Warren - Original Message - From:

Re: MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

On 24/11/2005, Alec worte: I think this is your problem: MySQL does not properly support Unicode until version 4.1. I am successfully using FullText with MySQL 4.1 to sort UTF-8 encoded Japanese text. I see no reason why it should not work for Arabic - if you upgrade. Dear

Re: moving the datadir

Did you set the permissions on the new datadir? Ezra On 11/18/05, Rajesh Olafson [EMAIL PROTECTED] wrote: Hi, I'm on Solaris 9 with mysql 4.1. I've moved the datadir to a new location, and edited the mysql start script directly so that it now has the line: datadir=/export/www1/data The

Error with PHP: undefined function: mysql_connect()

Please help. Newbie running Centos 4.2 with mySQL PHP (binary RPM install) as per versions given below. Getting error in vegadns package (DJB TinyDNS GUI) : Fatal error: Call to undefined function: mysql_connect() in /home.www/html/vegadns/src/connect.php Some diagnostics I ran for info on

Re: select command

Hello. Becomes to like varName or varTmp ? Sorry, but I'm not completely understanding your question (may be because I'm not familiar with dreamweaver). What does it mean 'like varName or varTmp'? Do you want to change the name from reg_one to var_one? Or you want to be able dynamically

Re: Image Storage -- Better to store them on the Filesystem or in the MySQL DB

Hello. From my experience in most cases it is recommended to store images in files. ESV Media GmbH wrote: Hey, we´ve large amount of Images ( nearly 2 GB ). And they will increase, cause or Editors will submit several articles a day where they´re allowed to upload some new

Re: SELECT/JOIN performance on temporary tables depends on timing of index creation

Hello. I've checked this and found that ANALYZE table really doesn't work, but OPTIMIZE table made its work. In case it won't help you send to list complete definitions of you tables and queries. Allan Miller wrote: Hi Gleb, Thanks for the quick response. Unfortunately, ANALYZE

Re: Your message to MySQL AB (ID#863700)

Hello. Complete answer about licensing policy you can obtain only from [EMAIL PROTECTED] It means, that you should forward you message to this address. George Vanev [EMAIL PROTECTED] wrote: Dear Sirs, This is my 3rd time I am writing to you. May be there is a problem! We want

Re: mysql 4.1.14 suddenly does not see some data files!

Hello. I have a similar issue on FreeBSD, which I've solved by increasing the open-files-limit. Follow recomendations from: http://dev.mysql.com/doc/refman/5.0/en/not-enough-file-handles.html I needed to increase the system limits as well (kern.maxfilesperproc sysctl variable).

Re: moving the datadir

Thanks Gleb, Ezra. Fixing the root user was the trick. I've got it working now. ~mm On 11/24/05, Ezra Taylor [EMAIL PROTECTED] wrote: Did you set the permissions on the new datadir? Ezra On 11/18/05, Rajesh Olafson [EMAIL PROTECTED] wrote: Hi, I'm on Solaris 9 with mysql 4.1.

Re: moving the datadir

How did you accomplish that? Ezra On 11/24/05, Rajesh Olafson [EMAIL PROTECTED] wrote: Thanks Gleb, Ezra. Fixing the root user was the trick. I've got it working now. ~mm On 11/24/05, Ezra Taylor [EMAIL PROTECTED] wrote: Did you set the permissions on the new datadir? Ezra

Re: MyIsam Vs InnoDB

Hello. Without seeing at least your configuration it is difficult to say what's going on. Please, provide your config file. Andrew stolarz [EMAIL PROTECTED] wrote: When I do a bulk import into a MyIsam engine database, I can reach about 2-3 thousand records imported per second.

Re: Problem with mysql-administrator-1.1.5, s.o.

Hello. It doesn't run on Windows NT 4 and below. See: http://dev.mysql.com/doc/administrator/en/mysql-administrator-installation-windows.html Wolfgang Bogenrieder wrote: Hallo, ich have a problem with mysql-administrator-1.1.5 and mysql-query-browser-1.1.17 running

Re: Error with PHP: undefined function: mysql_connect()

Hello. From my experience on RH based systems you should install appropriative rpm (it is php-mysql-5.0.4-10.4 in Fedora, for example). Sanjay Arora wrote: Please help. Newbie running Centos 4.2 with mySQL PHP (binary RPM install) as per versions given below. Getting error in

Re: moving the datadir

Hi Ezra, I fixed the root user by following the instructions laid out at http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html . The root user was somehow corrupted. I started mysql with the mysqld_safe --datadir=/my/new/location ... plus the other parameters set out in the docs.

Re: MyIsam Vs InnoDB

hello, here are my current setttings: # MySQL Server Instance Configuration File # -- # Generated by the MySQL Server Instance Configuration Wizard # # # Installation Instructions #

Re: moving the datadir

Thanks. On 11/24/05, Rajesh Olafson [EMAIL PROTECTED] wrote: Hi Ezra, I fixed the root user by following the instructions laid out at http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html . The root user was somehow corrupted. I started mysql with the mysqld_safe

Re: MyIsam Vs InnoDB

Is your database connection auto-commit? MyISAM commits everything at once, where InnoDB you can commit whenever you want. You might want to commit at the end of your batch. Also, look at your indexes - indexes make selects fast, but slow down inserts and deletes, and can slow down updates

Problems with back up and restore mysql 5.0

Hi, Need your help in restoring mysqldump from version 4.1 to 5.0 We wanted to update our mysql server from version 4.1.0 to version 5.0, we took the mysqldump and upgraded it to version 5.0. But, when we tried to restored the database dump, it just cannot restore it back. We searched on the

Problems with back up and restore mysql 5.0

Hi, Need your help in restoring mysqldump from version 4.1 to 5.0 We wanted to update our mysql server from version 4.1.0 to version 5.0, we took the mysqldump and upgraded it to version 5.0. But, when we tried to restored the database dump, it just cannot restore it back. We searched on the

Problems with back up and restore mysql 5.0

Hi, Need your help in restoring mysqldump from version 4.1 to 5.0 We wanted to update our mysql server from version 4.1.0 to version 5.0, we took the simple mysqldump and when we tried to restored the database dump, it just failed. There is no error as such. The execution of dump command

Re: select command

You should not contact people on the MySQL list offline; all communication should be via the list so that everyone can benefit from the discussion. As I said earlier, your WHERE clause does not make sense the way you expressed it in your first email. I explained how it should look in my first

binlogs

Hi. I have a production server that has a whole series of -bin files. I want to get rid of them because they are consuming too much space. Can I safely delete them? Some date back to April of this year. I've seen the 'PURGE MASTER LOGS TO 'mysql-bin.0XX';' Thanks for any replies. Kind

RE: select command

Sorry forgot to isnert the list email address. Thanks for your help. I will search prepared statement in the manual. Will post again if have next/ other questions. Thanks a lot. -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: Friday, November 25, 2005 12:18 PM To: