MySQL Datadir under rhel6

mysqld, copied the content from /var/lib/mysql/myDB to /media/spare/databases/myDB, checked permission etc. 6: Deleted the myDB directory 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

Full-text search and queries sensitive to accents

by 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

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

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.mysql.com

problems with mysql 4.1+suse 10

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.

Re: error in login

forget to flush the privileges ;-) Greetings Mario -- - | havelsoft.com - Ihr Service Partner für Open Source | | Tel: 033876-21 966 | | Notruf: 0173-277 33 60 | | http

Re: migrating 4.0 to 5.0

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 with iconv to utf-8. Greetings Mario -- - | havelsoft.com

Re: Does casing of Table names matter on Linux

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 for tables. Greetings Mario

Re: charactersets

. Greetings Mario -- - | havelsoft.com - Ihr Service Partner für Open Source | | Tel: 033876-21 966 | | Notruf: 0173-277 33 60 | | http://www.havelsoft.com

Re: Installation Gone Haywire

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 966

Move from mysql 4.0.24 to 5.0.22

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

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

searching every occurrence of a term in a text field

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

newbie question about sp

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 -- MySQL General Mailing List

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

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.com/mysql

Use of Parameters

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 del Mundo. Visíta Yahoo

View Users in MySQL 4

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 ever

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

through the POST method, that is why I asked for help. Now I can help others with the same dilemma. Thanks, indeed. p --- John Nichel [EMAIL PROTECTED] wrote: Mario Miyojim wrote: I am trying to revive an existing LAMP system. I recently installed RedHat9. I had several LAMP applications

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

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 p --- Chris [EMAIL PROTECTED] wrote: You could try http://us2

Needing help about PHP+mysql on RedHat 9.

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 FORM ACTION=?php print($PHP_SELF) METHOD=post construct, but they are not

mysql replication question(s)

run this I get an empty set back. Is this needed? Thanks for your help, Mario __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com

mysql replication question(s)

run this I get an empty set back. Is this needed? Thanks for your help, Mario __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com

Import Database from MySQL3.x to MySQL 4.x

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 -- 1. GMX TopMail - Platz 1 und Testsieger! 2. GMX ProMail - Platz 2 und Preis

Recreate mysql

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

Re: Recreate mysql

"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 ("mysql") that contains all the (B a

server has gone away Error

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

Bad field type translation

; 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 - Before posting

How to update the database through an applet?

on the 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

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)

mysql_query

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.mysql.com/ (the list archive

RE: mysql_query

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 -Original Message- From: Mario Ohnewald [mailto

Forgot mysql-root password

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.com/manual.php

Forgot Mysql-Root Password

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.com/manual.php

RE: Forgot mysql-root password

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:25 PM, you wrote: MO I am using

MySQL Statistics

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

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?

] 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] - Before posting, please check: http

SQL/92 99 Information

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

: 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, please check: http://www.mysql.com/manual.php (the manual) http

Re: Kernel crash caused by mysql?

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 croaking while

Re: Newbie need help on MySQL on RH 7.1

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, please check: http://www.mysql.com/manual.php (the manual

Requirement of INFO

Is there any performance difference between running a query on a compressed MyIsam Table rather than a normal MyIsam Table ? Thanks in advance Bye

Mysql performance monitoring?

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, -- Mario Witte [EMAIL

Re: Mysql performance monitoring?

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 Van wrote: Mario Witte

RE: Many Unauthenticatd Users

the server has to delete something between 60 and 90 entries while still inserting new data into the table). -- Mario Witte [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Many Unauthenticatd Users

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] - Before posting, please

Re: Version question: -log no -log ?

- 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 off topic to our filter. To bypass

Re: Version question: -log no -log ?

- 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 off topic to our filter. To bypass

Version question: -log no -log ?

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

How I can run a script in MySQLManager

. 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-0548

some question about create db

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

how to do a query using a file?

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 advance. Mario

Mysql can't start: help!

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@localhost

Re: how to do a query using a file?

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 [EMAIL PROTECTED

Re: Mysql can't start: help!

with safe_mysqld and some other command but it dont work! For the version should be ritht : It was istalled by RedHat (last version!) I need mysql for thesis and I have to develop a free software... so sorry if I make noice but I hope my work will be userfull for somebody of you in the future. Mario

mysqlgui: help.

quot;? 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) To requ

how to connect MySql with Java?

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.mysql.com

how to make SQL command by a file?

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. Mario

how can I get code example of manual?

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 install it? thank y

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

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

Re: How to have a table very very big?

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 you, and got som help

How to have a table very very big?

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.

ordering a table by myiasmchk?

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