MySQL Datadir under rhel6

2011-05-24 Thread Mario Deng
and created a symlink for myDB to "/media/spare/databases/myDB". 7: mysqld starts now, but myDB isn't found Any ideas from your side? With best from GER __ Mario Deng -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Full-text search and queries sensitive to accents

2008-09-26 Thread Fco. Mario Barcala
default. Is there any way to change this in mysql 5.1? Thanks in advance, Mario Barcala -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

50% full text threshold

2008-09-12 Thread Fco. Mario Barcala
have to change. Thanks in advance, Mario Barcala -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Full text search and highlight results

2008-09-08 Thread Fco. Mario Barcala
os or function to do this. I want to write the keywords in context (KWIC) boldface and some previous an following words around them normalface. Thanks in advance, Mario Barcala -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysq

problems with mysql 4.1+suse 10

2008-01-02 Thread mario henriquez
hi, i got a problemas in mysql with suse 10 enterprise server, the error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1. when i treat to create a new data base, appears this message. pleas

Re: error in login

2007-07-09 Thread Mario Guenterberg
entry to the full qualified hostname and that was fine. Don't forget to flush the privileges ;-) Greetings Mario -- - | havelsoft.com - Ihr Service Partner für Open Source | | Tel: 033876-21 966 | | Notru

Re: migrating 4.0 to 5.0

2007-03-05 Thread Mario Guenterberg
ecial chars are messed up. afaik 4.0 uses > latin charset and 5.0 utf8 by default. can some one please give me a hint how > to migrate ? i think i'm just too stupid :-) Hi... convert your mysql-dumpl.sql or whatever w

Re: charactersets

2007-02-28 Thread Mario Guenterberg
t it with iconv. Greetings Mario -- - | havelsoft.com - Ihr Service Partner für Open Source | | Tel: 033876-21 966 | | Notruf: 0173-277 33 60 | | http://ww

Re: Does casing of Table names matter on Linux

2007-02-28 Thread Mario Guenterberg
Pl. help me, Hi, Windows is by the way not case sensitive, Linux/Unix is always case sensitive. The MySQL tables are files in filesystem in restrictions for the os you use. It is better, maybe for portable code, to use general uppercase or lowercase names f

Re: Installation Gone Haywire

2007-02-27 Thread Mario Guenterberg
On Tue, Feb 27, 2007 at 06:01:44PM -0500, [EMAIL PROTECTED] wrote: > Hi; Hi have you run mysql_install_db on your production server? Greetings Mario -- - | havelsoft.com - Ihr Service Partner für Open Source | | Tel: 033876-21

Move from mysql 4.0.24 to 5.0.22

2006-11-30 Thread mario
ebuch" instead of "Gästebuch". Any idea what export or import option i need to look at/use? Thanks, Mario -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

searching every occurrence of a term in a text field

2004-12-13 Thread Mario Protto
Hi all having a table with one text field in which I store text (sic!) I need to extract from it every occurence of a term (or a phrase) with its context, litteraly extract 30 char before and 30 char after the term I have searched. thx for any suggestions ciao Mario -- MySQL General Mailing

searching every occurrence of a term in a text field

2004-12-13 Thread Mario Protto
Hi all having a table with one text field in which I store text (sic!) I need to extract from it every occurence of a term (or a phrase) with its context, litteraly extract 30 char before and 30 char after the term I have searched. thx for any suggestions ciao Mario -- MySQL General

newbie question about sp

2004-07-08 Thread Mario Protto
UNTIL @x < 10 END REPEAT; END it seems to go in a loop that block the system instead of exit immediatly from the repeat loop, is there some stupid error I can't see or there are problem with repeat statement in version I am using? thx all Mario --

count(*) in V4.0.18/V4.1

2004-02-25 Thread Mario Neudeck
nyone know about this problem? Are there any server variables to get the right result? I already checked the manual/bug/changes section of MySQL. But I did get any ideas. I hope somebody can help me. Thanks in advance. Mario -- -- MySQL General Mailing List For list archives: http://lists.mysql.co

View Users in MySQL 4

2003-12-29 Thread Mario
Hello! Got a database & I'd like to know what user/s have access to this database. I am able to login to MySQL and can do SHOW DATABASES, Now, I know there's a user supposedly called "kong" using an specific database. How can I tell if that is so? I am new to MySQL, being this the 1st time I eve

Use of Parameters

2003-12-29 Thread Mario Lucero
ySql say there is a mistake near to LIKE. What can I do? Mario. Lic. en Cs. de la Computacion Mario Lucero San Luis - Argentina Sucre 692. Depto D3 TE: 54-2652-421219 - Do You Yahoo!? Todo lo que quieres saber de Estados Unidos, América Latina y el resto de

RE: Needing help about PHP+mysql on RedHat 9.

2003-11-18 Thread Mario Miyojim
Thank you. Now I read tutorials at the new PHP web site, so my old scripts are refurbished and are functional. I initialize every variable like this: $var1 = $_POST['var1']; for example, and values are correctly passed. Mario --- Chris <[EMAIL PROTECTED]> wrote: > You c

Re: Needing help about PHP+mysql on RedHat 9.

2003-11-18 Thread Mario Miyojim
through the POST method, that is why I asked for help. Now I can help others with the same dilemma. Thanks, indeed. --- John Nichel <[EMAIL PROTECTED]> wrote: > Mario Miyojim wrote: > > I am trying to revive an existing LAMP system. > > I recently installed RedHat

Needing help about PHP+mysql on RedHat 9.

2003-11-17 Thread Mario Miyojim
I am trying to revive an existing LAMP system. I recently installed RedHat9. I had several LAMP applications working under RedHat 7.1, but now they don't function properly. For instance, I have many scripts that use the construct, but they are not working as they should. I tried to get help from

mysql replication question(s)

2003-09-02 Thread Mario
,'20139','Reading master update','' '4','system user','none','','Connect','20139','Slave: waiting for binlog update','' my main concern is that the time on the process list is so long. A

mysql replication question(s)

2003-09-02 Thread Mario
,'20139','Reading master update','' '4','system user','none','','Connect','20139','Slave: waiting for binlog update','' my main concern is that the time on the process list is so long. A

Import Database from MySQL3.x to MySQL 4.x

2003-08-14 Thread Mario Ohnewald
27;,10,'r',11.61,11,10,0011,'','A'), ANd this 830 line ist just far to long to post it :) So do i have a general problem or what did i do wrong so far? Cheers, Mario -- COMPUTERBILD 15/03: Premium-e-mail-Dienste im Test -

Re: Recreate mysql

2003-07-03 Thread Mario
"Victoria Reznichenko" <[EMAIL PROTECTED]> wrote: (B> (B> "Mario" <[EMAIL PROTECTED]> wrote: (B> > (B> > I'm a newbie in experimental mode and have just deleted /ALL/ databases (Bon a (B> > MySQL server, i.e. including the one (&q

Recreate mysql

2003-07-03 Thread Mario
Hi! (B (BI'm a newbie in experimental mode and have just deleted /ALL/ databases on a (BMySQL server, i.e. including the one ("mysql") that contains all the (Badministrative stuff like users, privileges, etc. Is there some way to (Brecreate some default version of that database short of reinst

server has gone away Error

2003-06-06 Thread Mario Nicoletti
I' m developing a client application using C-Api functions . Server and Client reside on the same machine, so I connect the Server via Unix socket . If I call the mysql_real_query after the wait_timeout expired on the server side , my client crashes. The Manual speaks about the ability of catch

Bad field type translation

2003-02-20 Thread Gatica, Mario Alberto
Abonados_Servicios where snb=1144293549; it takes : 9 rows in set (45.61 sec) to complete. I'd like to ask you if it wouldn't be better to rise an error or a warning for the second statement instead of taking such amount of time. Thanks Mario Gatica -

How to update the database through an applet?

2003-01-31 Thread Mario Miyojim
net, unsuccessfully. Has anybody out there experiences with this kind of problem? It could be any solution, such as PHP + javascript, or PHP all by itself. Is there a good publication talking about this issue? Thank you Mario __ Do you Yahoo!? Yahoo

Mysql Blob type

2002-10-18 Thread Mario Nicoletti
How I treat, the Mysql Blob type when I do a INSERT/SELECT query ( OS Linux RedHat 7.3)? Does anyone know a solution ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: mysql_query

2002-09-24 Thread Mario Ohnewald
Great, thanks a lot! > From: Henk Huizinga [mailto:[EMAIL PROTECTED]] > > > Mario, > > This is actually an PHP question. You forgot the following code : > > $resultquery = mysql_fetch_row($result); > echo $resultquery[0]; > > Cheers, > Henk > >

mysql_query

2002-09-24 Thread Mario Ohnewald
result"; As result i get: Resource id #2 But i exspected: [EMAIL PROTECTED] I hope i hae exlained it well. Cheers, Mario - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mys

RE: Forgot mysql-root password

2002-09-18 Thread Mario Ohnewald
AH..thx a lot everybody! > -Original Message- > From: Egor Egorov [mailto:[EMAIL PROTECTED]] > Sent: Mittwoch, 18. September 2002 15:34 > To: [EMAIL PROTECTED] > Subject: re: Forgot mysql-root password > > > Mario, > Wednesday, September 18, 2002, 1:50:2

Forgot Mysql-Root Password

2002-09-18 Thread Mario Ohnewald
8 12:42:39 Aborting 020918 12:42:39 mysqld: Shutdown Complete How can i solve this Problem? I have alread reinstalled mysql, but unforunatelly i keeps its password. Cheers, Mario - Before posting, please check: http://www

Forgot mysql-root password

2002-09-18 Thread Mario Ohnewald
8 12:42:39 Aborting 020918 12:42:39 mysqld: Shutdown Complete How can i solve this Problem? I have alread reinstalled mysql, but unforunatelly i keeps its password. Cheers, Mario - Before posting, please check: http://www

MySQL Statistics

2002-06-13 Thread Mario Espinoza Llamas
Hi All, some body knows mysql statistics: # Programers in the world # sites with MySQL database # Companies to support MySQL # sites in with MySQL database Thanks for your help Mario - Before posting, please check

MySQL Statistics

2002-06-12 Thread Mario Espinoza Llamas
Hi All, some body knows mysql statistics: # Programers in the world # sites with MySQL database # Companies to support MySQL # sites in with MySQL database Thanks for your help Mario - Before posting, please check

Re: how to measure the size of MYSQL database?

2001-09-06 Thread Mario Witte
e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php If you are using Linux the following should help: du -hs /var/lib/mysql/ HTH, -- Mario Witte <[EMAIL PROTECTED]> -

SQL/92 99 Information

2001-09-03 Thread Mario Espinoza Llamas
Hi, All. Some body nows how I can get a SQL/92 and 99 information. TIA Mario Espinoza Ll. Consultores STI, S.C. [EMAIL PROTECTED] Av. Guadalupe # 618, Col. Chapalita Guadalajara, Jal. México. +52 3122-9004 Ext. 213

Re: About installing MySQL on Linux 7.1

2001-08-10 Thread Mario Witte
nload the right package? Which distribution do you use? BTW: Perhaps your distribution has a version numer of 7.1, but the newest Linux kernel is 2.4.7 ;) With regards, -- Mario Witte <[EMAIL PROTECTED]> - Before posting, pl

Re: Kernel crash caused by mysql?

2001-08-04 Thread Mario Witte
On Fri, Aug 03, 2001 at 03:42:28AM -0700, Van wrote: > Mario Witte wrote: > Memory or motherboard. How many sticks of RAM do you have in the machine? Are > they the same speed (p100/p133, etc.)? What kind of motherboard? Is updatedb > running at this time? (might be a hard-drive cr

Re: Newbie need help on MySQL on RH 7.1

2001-08-02 Thread Mario Witte
S 0:00 grep mysql If there is no such output or just "grep mysql" try executing "/etc/init.d/mysql start" to start the server manually. HTH, -- Mario Witte <[EMAIL PROTECTED]> - Before posting,

Requirement of INFO

2001-07-27 Thread Gatica, Mario Alberto
Is there any performance difference between running a query on a compressed MyIsam Table rather than a normal MyIsam Table ? Thanks in advance Bye

Re: Mysql performance monitoring?

2001-07-13 Thread Mario Witte
Cricket looks great, I think I'll have to try it ASAP. For the moment I just found a utility called mrtg-mysql which puts mysql-stats into mrtg. Statistics aren't very extensive but enough for the moment. -- Mario Witte <[EMAIL PROTECTED]> On 2001.07.13 07:19:08 -0200 Va

Mysql performance monitoring?

2001-07-13 Thread Mario Witte
Hello, I'm searching for a tool which will provide statistics about the usage of a mysql-server like avg queries/minute, cpu load etc. I've tried mysqler and liked it, but couldn't get it to start as a daemon. Are there any similar tools out there? Thanks in Advance, -- Mari

RE: Many "Unauthenticatd Users"

2001-07-10 Thread Mario Witte
tivating those servers > the > >problem reappears. > > > >Maybe mysql has problems inserting data into a table while doing a huge > >delete-query on the same table? > >(Around 2am the server has to delete something between 60 and 90 > >entries while still ins

Many "Unauthenticatd Users"

2001-07-09 Thread Mario Witte
e a load problem, because before the problem occured the server (a Compaq Proliant with a 933 Mhz Xeon cpu) was running on a load average below 0.10. Any help will be appreciated, Thanks in Advance, -- Mario Witte <[EMAIL PROTECTED]> -

Version question: -log & no -log ?

2001-06-19 Thread Mario Kent
I installed 3.23.38 from source on a linux server, a status simply says: Server version: 3.23.38 Now, I just installed 3.23.39 from source on another linux server and it displays: Server version: 3.23.39-log I want to know what the -log means and how it got in there. [In order to get this messag

Re: Version question: -log & no -log ?

2001-06-19 Thread Mario Kent
- Original Message - From: <[EMAIL PROTECTED]> To: "Mario Kent" <[EMAIL PROTECTED]> Sent: Tuesday, June 19, 2001 1:40 PM Subject: Re: Version question: -log & no -log ? > > Your message cannot be posted because it appears to be either spam or > simply

Re: Version question: -log & no -log ?

2001-06-19 Thread Mario Kent
- Original Message - From: <[EMAIL PROTECTED]> To: "Mario Kent" <[EMAIL PROTECTED]> Sent: Tuesday, June 19, 2001 1:40 PM Subject: Re: Version question: -log & no -log ? > > Your message cannot be posted because it appears to be either spam or > simply

How I can run a script in MySQLManager

2001-06-08 Thread Mario Espinoza Llamas
hanks. Mario Espinoza Ll. Consultares STI, S.C. [EMAIL PROTECTED] Av. Guadalupe # 618, Col. Chapalita. Guadalajara, Jal. México. +52 3121-0411 Ext. 213 +52 3121

some question about create db

2001-05-04 Thread mario . lat
I have to create a database from an application (written in perl) how can I do? how can I create a db if the user is not a root? which command can I use? Thank you in advance, Mario. - Before posting, please check: http

Re: Mysql can't start: help!

2001-04-30 Thread mario . lat
you in the future. Mario. > > I use RedHat (last release) > > I try to use Mysql but It doesen' works: > > I post you some lines can help you to understand the error. > > how can create a tab

Re: how to do a query using a file?

2001-04-30 Thread mario . lat
es in different computers. Thank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[E

Mysql can't start: help!

2001-04-30 Thread mario . lat
I use RedHat (last release) I try to use Mysql but It doesen' works: I post you some lines can help you to understand the error. how can create a table, use Mysql? Thank you in advance, Mario. - [root@loca

how to do a query using a file?

2001-04-30 Thread mario . lat
I have to buitd a "big" database. I have to create table, insert row in database and then do the same thing on another computer. I'd like to do that using a file in whiich I write all ... but how can I do? Thank you in

mysqlgui: help.

2001-04-15 Thread mario . lat
localhost"? mysqlgui ask me a password: what password it want? Tank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

how to connect MySql with Java?

2001-04-09 Thread mario . lat
I'd like to use MySql with Java (under Linux) bu I can't be able to do that: how can I do? Thank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

How compile a C/C++ program which use API for mysql?

2001-03-30 Thread mario . lat
I have write a simple program in C/C++. this program use API for Mysql (linux) the question is : How to compile this programs? Tank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the

how can I get code example of manual?

2001-03-30 Thread mario . lat
I'd like to write a simple application with API of MySql. I see "4.4.1 A Simple Exaple" of the manual but I can't find the file "simple1.cc" that should be in my computer... but there isn't. How can inst

how to make SQL command by a file?

2001-03-30 Thread mario . lat
It is easy make an error while writing SQL coimmand to create table, etc... So I'd like to write this command (CREATE TABLE) in a file then run this command in mysql: How can I do? how can I write it? Thank you in advance.

where is a "visual" tool to use MySQL?

2001-03-29 Thread mario . lat
I saw a visual tool for use mysql in simplest way: under KDE in a window: it let do a query in simple way and see the result in a window... I mead there are program that let use Mysql in KDE ? Thank you in advance, Mario. P.S. where cah I find it

new type of data: IP or NETADDRES: help me.

2001-03-29 Thread mario . lat
ak very much all people had read this mail! Mario. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this threa

Re: How to have a table very very big?

2001-03-16 Thread Mario Latens
ty: I have to study the flow of data in a net : I'm working in a network desing. If somebody is doing that or is interested we can exchange experiences and suggestions. Thank you again. Mario. Il 16:51, giovedì 15 marzo 2001, scrivesti: > Hi Mario, > I think I had the same problem as

ordering a table by myiasmchk?

2001-03-15 Thread Mario Latens
If I order a table using myiasmchk then, when I put other row in the table, this thable is still ordered or I have to reorder again? Thank you in advance,Mario. - Before posting, please check: http://www.mysql.com/manual.php

How to have a table very very big?

2001-03-15 Thread Mario Latens
I have to store data for Internet desining (10-20 Gb at Day) so I have to use a data base very fast: MySql is fast? I have to put 10-20 Gb of data every day: but I can have a table only of 2Gb (I know that reading manual of Mysql). How to do a table so big? Thank you in advance, Rino.

Indefinite Timeouts

2001-02-16 Thread Mario Oschwald
Hi, Didn´t find this anywhere in the documentation... does -1 work if I want to set a Mysql timeout variable to indefinite?? e.g. wait_timeout=-1 Thanks Mario Oschwald - Before posting, please check: http://www.mysql.com