Would you suggest mysql to build a vocabulary?
Any examples?
thank you
Pol
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi All,
I have specified innodb_file_per_table option, can i place .idb and and
tablespace (datafiles) in the same directory.
Also, can i please .idb files in different disk from innodb_data_file_path.
regards
anandkl
In news:[EMAIL PROTECTED],
Daevid Vincent [EMAIL PROTECTED] wrote:
Because we're a huge enterprise product, with 3 databases of 200
tables each.
We are migrating from MYISM to INNODB and keeping track of that value
isn't something we thought we'd need to do. Plus it seems like
something we
-Original Message-
From: Maciej Dobrzanski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 27, 2007 6:46 AM
To: mysql@lists.mysql.com
Subject: Re: Why doesn't the InnoDB count() match table status?
MyISAM and InnoDB (and there are plenty more). RDBMS is not an Office
spreadsheet,
FYI - Monday AM, Norton A/V started reporting the uninst.exe and the
sqlyog525.exe files as infected with 'Virus Burst'. This is due to a
NullSoft installer signature problem. SQLyog527 has been released, built
with a newer NullSoft installer, AND the virus definitions from today no
longer
Hi,
I have a HP rp3410 with 4Gb RAM running HPUX 11.11. This is running,
Version: '5.0.26-pro-log' socket: '/tmp/mysql.sock' port: 3306 MySQL
Pro (Commercial)
When this machine is put under load (i.e, a lot of database activity),
the clients are receiving Error 12 errors and the MySQL log
Hi All,
Is there a way to influence the order in which columns are returned in a
describe table statement. Basically I want the same order that I get in the
mysql client (Field, Type, Null, etc) in a little script I am writing, so I
can use the Column headers dynamically.
Thanks
Olaf
--
MySQL
Hello Group,
Looking to use this REPLACE to strip multi line data out of my return
data.
I am having problems getting the \n to work correctly, any ideas?
REPLACE(DESCRIPTION,\n,' ')
SELECT
rpad(CASE WHEN DESCRIPTION IS NULL THEN '' ELSE
REPLACE(DESCRIPTION,'\n',' ') END,80,' ') as var
Instead of just saying 'desc tbl-name;'
Try using information_schema.columns
mysql desc information_schema.columns;
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
Ulrich Staudinger wrote:
first of all, thanks for the world's finest open source database!
I would like to know if someone has an estimate for the availability of
v5.1 as a production release. ?
Keep watching http://dev.mysql.com/doc/refman/5.1/en/news.html and its a
safe bet if its Q3/Q4
Ok.. I found the problem.. I needed to add a \r.. but now that opens up
the question can I have a Multi replace search in replace?
Example can I do something like this in MySQL
REPLACE (STRING,'\r' or '\n',' ')
REPLACE(DESCRIPTION,'\r\n',' ')
Wishing you the best you know you deserve,
On 3/27/07, Tim Lucia wrote:
-Original Message-
From: Maciej Dobrzanski
Sent: Tuesday, March 27, 2007 6:46 AM
To: mysql@lists.mysql.com
Subject: Re: Why doesn't the InnoDB count() match table status?
MyISAM and InnoDB (and there are plenty more). RDBMS is not an Office
I always go with REPLACE(REPLACE(STRING, '\n', ''), '\r', ''), since
depending on where your data came from there may be one or the other, or
both. Although if there is a shorthand/more efficient way I'd love to
hear it.
[EMAIL PROTECTED] wrote:
Ok.. I found the problem.. I needed to add a
Could you post the actual code you are using for the INSERT? Also, what
storage engine are you using?
Jay
andrew collier wrote:
hello,
i am having some trouble getting mysql to perform decently on my machine. it is
a 2 GHz dual core AMD 64 machine (although i am presently running a 32 bit
Hello all.
Does anyone out there (in mysql world) have a Linux -csh script to
refresh test with production data.
My developers would like their test database to be refreshed nightly
with production data. The production and test mysql servers do not run
in the same box. They run on different
If test and production are supposed to be identical, then use this:
mysqldump -hIP for Prod -u... -p... --triggers --routines db-name on Prod |
mysql -hIP for Test -u... -p... -A -Ddb-name on Test
If you havn't noticed, you do not dump the data to a file and ftp or scp
anything anywhere !!!
well, you'd want to come up with your specifics but it's pretty simple using
ssh...
put this is your shell...
$ mysqldump db-name | mysql -h remote.box.com db-name
$ mysqldump db-name | ssh [EMAIL PROTECTED] mysql db-name
$ mysqldump db-name foo | ssh [EMAIL PROTECTED] mysql bar
hope this
Here is my problem.
I have a table called dictionary
The dictionary has the following columns
`wordID` int(10) unsigned NOT NULL auto_increment,
`position` int(10) unsigned NOT NULL ,
`WORD` varchar(120) NOT NULL default ''
What this actually holds is a index of words and their locations of a
Pat,
I am by no means great with sql, but i think i may be able to help you. You
just need to load up your query with or statements. As i understand your
question, you will be searching name for several keywords (x1,x2,...) and
address for several keywrods (y1,y2...)
SELECT * FROM clients
This is using version: 5.0.18-log on linux.
I have a stored procedure that takes .2 sec the first time,
12 the second, 12 the third. The data is unchanged.
The relevant part of the procedure looks like this.
...
drop temporary table if exists temptab;
create temporary table temptab (index
Hi All,
What are all the mysql services i need to monitor to make sure mysql db is
running and send a pager when any one of these services go down.
regards
anandkl
Ananda Kumar wrote:
What are all the mysql services i need to monitor to make sure mysql db is
running and send a pager when any one of these services go down.
mysql daemon on Linux and UNIX systems, MySQL service on Windows
in any case all of them supports executing command on daemon
22 matches
Mail list logo