Limit on the expression length?

Is there a limit on the expression length in a full text search? I have a situations where users might want to use over 100 words in a full-text search. (Yes, it's ridiculous.) Thanks in advance! -- Avi

Update Debian 2.0 (mysql 3.21 to 3.22)

Hi. I need to update a debian 2.0 linux box with mysql 3.21.31 to some of the last version of mysql 3.22. I tried to use the binaries from www.mysql.com (3.22.32), but when I launch mysql services with the script mysql.server in the log appeared: mysqld started on Thu Jul 21 10:25:56 CEST

Re: random rows selection

Privet! But this query can return empty results, if we use it with WHERE: Yes, it can. However, we're able to change the technique and obtain one random record with WHERE condition in query. With several iterations it is possible to get several random records. First we should get the

Re: random rows selection

Michael Monashev wrote: How to select 5 random rows from big table with WHERE clause? Maybe something like this: SELECT col1, col2 FROM table WHERE col3=123 AND (id_col=RAND() OR id_col=RAND() OR id_col=RAND() OR id_col=RAND() OR id_col=RAND()) the problem is that there is the (low)

Re: Bit keeper download problem ?

Hello! Surendra Singhi wrote: Hello, When I am trying to download mysql from the repository, I am running into some problem. Earlier about a month back, it was working fine, but its only recently I am facing this problem. Anyone can please shed some light on it? Thanks. This is the command

Re: optimize a sql statement

Thank you SGreen.But i can'optimize the sql statement like your way because this query must describe in one sql statement.So i think i maybe optimize this sql statement through creating high efficiency index or describe this sql statement in other method. Rewrite this sql statement must in one

Re: SQLyog Enterprise

Lol, I'm trying to find the BEST product around. Looks like after for a long while, I consider myself still a 'newbie'. I thought I saw something better until then up to the point that David Griffiths refered me to a site and I'm eyeing at this product *EMS MySQL Manager Professional

Re: SQLyog Enterprise

Thanks. I will try those trailwares. On 7/21/05, David Griffiths [EMAIL PROTECTED] wrote: Also check out EMS MySQL Manager. I looked at every MySQL tool I could get my hands on, and ended up buying a license of this. Main site is here: http://sqlmanager.net/products/mysql/manager/

mysql_config doesn't exist

Hi I'm trying to install something on SuSe Linux that requires mysql_config (DBD::mysql to be precise). I have mysql installed but nowhere is there anything called mysql_config. The server version is something called 4.1.12-Max, a version of MySQL I've never used before. Does this version not

MySQL 4.1.13 has been released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.1.13, a new version of the popular Open Source Database Management System, has been released. The Community Edition is now available in source and binary form for a number of platforms from our download pages at

Urgent Pls....

Dear Sir/Madam, I'm totally strugling on choosing the mysql distribution for my RedHat Linux9.0. My system config is as follows. 1.Pentium 4 and Intel845 Chipset (Intel Original Board) 2.gcc version - (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5) I'm trying to develop the client programs.

Re: Mac OS PrefPane

I've had the same experience. Although I don't really use it since I was taught early on in my career to always know how to do everything via the command line. As I recall, it seemed to better reflect the running status after restarting the computer. On Jul 20, 2005, at 7:33 PM, David Lowe

Re: mysql_config doesn't exist

Hello. mysql_config is usually shipped with binary and source distributions or devel rpms (for SuSE on x86 it is SuSE Linux Enterprise Server 9 (x86) - Headers and libraries). See: [EMAIL PROTECTED] mysqls]$ rpm -qlp MySQL-devel-standard-4.1.12-0.sles9.i586.rpm |grep mysql_config

Re: temp table cannot be created?

Hello. See: http://dev.mysql.com/doc/mysql/en/temporary-table-problems.html http://bugs.mysql.com/bug.php?id=10105 Jason Pyeron [EMAIL PROTECTED] wrote: any ideas on this? google has not helped. can temp tables be innodb? can they have fk? mysql mysql

Re: Group by Month

Hello. Please, provide more information about your data structure and what would you want to get from the query. These manual pages might be helpful: http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html http://dev.mysql.com/doc/mysql/en/group-by-functions.html

Re: copying rows from one MySQL server to another

Hello. Think about SELECT... INTO OUTFILE and LOAD DATA INFILE (or mysqlimport utility). If you accept the possibility to run MySQL version 5.0.x beta, you could use FEDERATED storage engine. See: http://dev.mysql.com/doc/mysql/en/federated-storage-engine.html Les Schaffer [EMAIL

More information from mysqld_safe

Hi Now I'm having trouble getting the server started! Again, suse linux, mysql 4.1.12-Max. My MySQL server was running before, now it's not. I don't remember changing anything apart installing DBD::mysql from source... Anyway, data dir is /var/lib/mysql and all the ownerships are correct

Which Engine to use...

I'm now trying to learn engines in MySQL. When I migrated from M$ SQL to MySQL to learn the migration process and executed the following: SELECT * FROM QA LEFT JOIN Batch ON Batch.QAID=QA.ID LEFT JOIN QAErrors ON QAErrors.ID=Batch.QEID WHERE QA.ID http://QA.ID BETWEEN '106805' AND

RE: More information from mysqld_safe

OK, I have more information - I am getting the error message: Fatal error: Can't open privilege tables: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2) WTF???! -Original Message- From: michael watson (IAH-C) Sent: 21 July 2005 14:39 To: mysql@lists.mysql.com

Re: Which Engine to use...

At 09:39 AM 7/21/05, Scott Hamm wrote: M$ SQL executed and brought up result in 2 seconds where MySQL took 801 seconds and where Batch datalength is around 18.5 MB, QAErrors is around 464KB and QA is around 3.5MB Did you create an index? -- MySQL General Mailing List For list archives:

Re: temp table cannot be created?

Thanks. On Thu, 21 Jul 2005, Gleb Paharenko wrote: See: http://dev.mysql.com/doc/mysql/en/temporary-table-problems.html this page I have read before, but no mention of this problem. http://bugs.mysql.com/bug.php?id=10105 now this was right on target. it lead me to use the

[ANN] DBTools Manager Professional 3.1.0 Released

DBTools Software is proud to announce the release of the awaited DBManager Professional 3.1.0 version. This version brings new and improved features, see a short list below. NEW FEATURES - Added support for Sybase 11.9 (*) - Added support for Oracle (*) - Added support for ODBC (*) - Updated the

innodb_file_per_table table status

Hi, I've just converted my databases so they are using per_table tablespaces. When I do a show table status in that database the Comment line still shows the amount free, but I assume this doesn't mean anything now ?? It doesn't make sense ? *** 1. row

Re: Won't launch after uninstall and install on OS X

[EMAIL PROTECTED] wrote: Michael, here are some snippets from the error log that look relevant, from three times I tried to start: 050719 20:29:41 mysqld started 050719 20:29:46 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive

Re search and replace in large text fields

Hi all... Please could you advise me my MySql, is a bit shacky. I need to capture about 700 web pages to a large text column in my database, the search for all the links in the pages within the column and replace them with new relative links .. to the pages now stored in the data base .. so how

RE: Re search and replace in large text fields

[snip] Please could you advise me my MySql, is a bit shacky. I need to capture about 700 web pages to a large text column in my database, the search for all the links in the pages within the column and replace them with new relative links .. to the pages now stored in the data base .. so how do I

Re: Urgent Pls....

Hello. Use Linux x86 RPM downloads for 4.1.13: Server, Client programs, Libraries and header files, Dynamic client libraries. See: http://dev.mysql.com/doc/mysql/en/which-version.html Ashok Kumar [EMAIL PROTECTED] wrote: Dear Sir/Madam, I'm totally strugling on choosing the

Re: More information from mysqld_safe

Hello. See: http://dev.mysql.com/doc/mysql/en/problems-with-character-sets.html michael watson (IAH-C) [EMAIL PROTECTED] wrote: OK, I have more information - I am getting the error message: Fatal error: Can't open privilege tables: File

Re: More information from mysqld_safe

Hello. Starting mysql daemon with databases from /var/lib/mysql 050721 14:36:05 mysqld ended These lines were put by mysqld_safe program. You should find mysqld's error log. Usually it's located in data directory and called host_name.err. See:

Re: Update Debian 2.0 (mysql 3.21 to 3.22)

Hello. For me it is hard to say what's wrong with all these old stuff. But the general way of solving such issues is described at: http://dev.mysql.com/doc/mysql/en/crashing.html Why are you going to use 3.22.xx and not for example 4.1? [EMAIL PROTECTED] wrote: Hi. I need to

OSX messed up installation

Sorry for appearing like a dummy but I am not a Unix person ! I installed MySQL on an OSX client ­ stumbling around the administrator app ­ all I wanted to do was to create a database ­ I inadvertently deleted what looked like a blank user ­ and now I cannot connect to MySQL at all ­ ok I will

Re: OSX messed up installation

MySQL is actually started using a little program called mysqld_safe, which monitor MySQL and restarts it if it crashes. You first need to kill the mysqld_safe process. I assume you have no data so the easiest route is to just kill it and reinstall. You may have deleted the admin user. In

avoiding conversion during insert?

Hi, Is there a way to insert binary data representing numbers directly into (preferably MyISAM) table. We are trying to avoid conversion from ASCII to float/double/int... Thanks, Jacek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: OSX messed up installation

Brent Thanks for your reply - that all sounds like good advice but... Cannot see any process other than mysqld running - is there a way to kill a process from the terminal command line ? When you say 'easiest route is to just kill it and reinstall' do you mean to remove it and reinstall, or kill

mysql bug

SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: maurizio To: mysql@lists.mysql.com Subject: [Cannot start mysql] Description: 1. I have installed the six packages (see

Mysql +events

Greetings, I am currently using Mysql 3.23.52. I am looking for events (when a record is added, mod'd or deleted from a table, and event is sent to each client connected to the DB. Firebird can do this, but before I port my application to firebird, I was wondering if Mysql had something similar

port fwding connection

Hi, I have a MySQL server running on a machine, say A, and I want to access the DB from another machine B. Now A has blocked port 3306. So I fwded port 3306 on B to 3306 on A using SSH. This works just fine. I can access Mysql fom local machine's port 3306 and no problems there. Problem is it

Saving a whole txt file in a database

Hi all How does one save a whole txt file in a largetext column ? Ihave found l lots on delimited filesbut non on saving a whole text file . Many thanks -- Gregory Machin [EMAIL PROTECTED] [EMAIL PROTECTED] www.linuxpro.co.za Web Hosting Solutions Scalable Linux Solutions www.iberry.info

Re: OSX messed up installation

Well I followed your very clear examples and I was happily able to stop the processes (after changing to root user) and I then removed the mysql directory. I reinstalled MySQL but still when I connect the MySQL Adminsitrator I can (and always have been able to) conenct as localhost and root with

Re: Saving a whole txt file in a database

what you mean by whole txt the entire contents of the file or the actual file itself? to load the contents in it: LOAD DATA INFILE '/path/to/data.txt' INTO TABLE tb1 (col1,col2,...); otherwise the column has to be blob type, using normal insert query: INSERT INTO table VALUES (data...)

Questions about backups, InnoDB tables, etc.

I'm trying to get a handle on MySQL backups and hot backups using MyISAM and InnoDB tables together. We plan to switch from SQL Server to MySQL soon. How are you guys handling full-backups of databases with mixed MyISAM and InnoDB tables? From what I've read (and I've been reading a lot), if we

Re: Questions about backups, InnoDB tables, etc.

Hello RS I'm trying to get a handle on MySQL backups and hot backups using MyISAM RS and InnoDB tables together. We plan to switch from SQL Server to MySQL RS soon. Did you see it: http://solutions.mysql.com/search.php?pc=0%2C0q=backuplevel=0 ? Sincerely, Michael, http://xoib.com/

Re: Which Engine to use...

it is because of the dollar sign that it works so much quicker. Scott Hamm wrote: I'm now trying to learn engines in MySQL. When I migrated from M$ SQL to MySQL to learn the migration process and executed the following: SELECT * FROM QA LEFT JOIN Batch ON Batch.QAID=QA.ID LEFT JOIN

Re: Saving a whole txt file in a database

the example i just showed you doesn't need to use delimited syntax. it will load the entire contents of the file into the column you specify.. try it a test: CREATE TABLE `table_test` ( `content` mediumtext NOT NULL ) ENGINE=MyISAM; create a txt file 'data.txt' with some text, then run

Re: Questions about backups, InnoDB tables, etc.

Ryan Stille wrote: I've been doing some testing and came across something I don't understand. I filled my test InnoDB formatted table with a lot of data so mysqldump will take a while to complete. Then I start mysqldump on this database with the --single-transaction option. While that is

Re: optimize a sql statement

I analyzed the query plan again. --- 1, 'PRIMARY', 'orders', 'range', 'PRIMARY', 'PRIMARY', '4', '', 348660, 'Using where; Using temporary; Using filesort' 1, 'PRIMARY', 'order_line', 'ref',

Re: optimize a sql statement

wow consider a different font when posting.. gives me a headache reading that. 王 旭 wrote: I analyzed the query plan again. --- 1, 'PRIMARY', 'orders', 'range', 'PRIMARY', 'PRIMARY', '4', '', 348660, 'Using where; Using temporary;