RE: Problems installing MySQL 4.1 under Fedora Core 3

I am pretty sure hat is due to the SELinux policy being set to restrictive. For the brute force fix try editing /etc/selinux/config and set the variable SELINUX=Permissive. There is a more subtle approach that maintains beeter security explained under the SELinux topic in the Fedora doc, sorry I

Problems installing MySQL 4.1 under Fedora Core 3

I have a Pentium III with Fedora Core 3 notebook and I need to install MySQL 4.1 on it. There was no mysql installed before so I've downloaded the packages and did what I usually do to install the packages. They install great. But when I try to run MySQL I have problems as it does not run. It tr

Re: Re : Problems installing MySQL 4.1 under Fedora Core 3

It only shows this: 050413 23:53:35 mysqld started 050413 23:53:35 mysqld ended Nothing conclusive. prasanna a wrote: Hi please cat the below error file and see /var/lib/mysql/presario2700.err __ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhan

Problems installing MySQL 4.1 under Fedora Core 3

I have a Pentium III with Fedora Core 3 notebook and I need to install MySQL 4.1 on it. There was no mysql installed before so I've downloaded the packages and did what I usually do to install the packages. They install great. But when I try to run MySQL I have problems as it does not run. It tr

book advice

Hi, I'm a newbie and looking for a book to help me learn mysql. I have come across a book called "Beginning MySQL" by Robert Sheldon and Geoff Moes. Can anyone recommend this book? Or, if not, what book can you recommend for a newbie. David -- MySQL General Mailing List For list archives: ht

Re: backup databases one to another

http://dev.mysql.com/doc/mysql/en/replication.html I would look into the replication features of MySQL. They can be used to create a backup copy of a database. The slave database server will only get the changes from the Master as needed. Karam Chand wrote: This option involves two steps. Firs

Re: backup databases one to another

This option involves two steps. First you have to export complete data and then import it again. You can do this more efficiently by using a sync tool like Webyog (www.webyog.com). It will sync any two MySQL databases with changes only done to modified rows/columns. YOu can probably mail their su

Re: weird characters from mysqldump?

Actually, it came from Mysql 4.1.1 (not 4.1.3 as I mentioned earlier). When I do select queries, the data displays just fine, but when I dump, I get this garbage. Jeremy Cole wrote: Hi Steve, I'm trying to export data from mysql 4.1.3 with mysqldump. I'm getting weird characters from the system.

Re: Unix time as year in select query -nooby

Tom Crimmins wrote: On Wednesday, April 13, 2005 20:17, [EMAIL PROTECTED] wrote: MySql vers 4.0.20 A table "noticeboard" has three test entries. A unix time from date("U") is stored in the field "published" of type, bigint20. I am not able to workout how to select the year. Assuming that th

RE: Unix time as year in select query -nooby

On Wednesday, April 13, 2005 20:17, [EMAIL PROTECTED] wrote: > MySql vers 4.0.20 > > A table "noticeboard" has three test entries. > A unix time from date("U") is stored in the field "published" of > type, bigint20. > > I am not able to workout how to select the year. Assuming that the > val

Unix time as year in select query -nooby

MySql vers 4.0.20 A table "noticeboard" has three test entries. A unix time from date("U") is stored in the field "published" of type, bigint20. I am not able to workout how to select the year. Assuming that the value from date("U") can be treated as a unixtime value, my latest unsuccessful e

Re: Changing the Prompt for timing purposes

When you say shell, do you mean DOS or UNIX? If it's the latter then you may do this for the logfile: sh-2.05b# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.0.24-standard-log Type 'help;' or '\h' for help. Type '\c' to clear t

Re: Help with a tricky/impossible query...

I should mention that I'm constrained to version 4.0.n so no sub queries for me! Andrew On 14/4/05 1:11 am, "Andrew Braithwaite" <[EMAIL PROTECTED]> wrote: > Hi, > > I need some help with a tricky query. Before anyone asks, I cannot bring > this functionality back to the application layer (as

Help with a tricky/impossible query...

Hi, I need some help with a tricky query. Before anyone asks, I cannot bring this functionality back to the application layer (as much as I'd like to). Here's what I need to do... create table wibble( seq int(3) auto_increment primary key, x int(5), y int(5) ); insert into wibble set x=5, y=10

MyISAM and Dirty Reads

Is there a way to use dirty reads (that acquire no read locks on the table) with MyISAM tables? I want to avoid having the read requests queuing up while the table is updated, and I can tolerate a small margin of inconsistency for the sake of throughput. So far I found only information about sche

Re: graphs

prathima rao wrote: >hello, > >can anyone suggest if there is any software available to create graphs using >mysql as database > >regards > >prathima rao > > My favourite has always been JpGraph - http://www.aditus.nu/jpgraph/ - it's a PHP library. You can use it on a web server or on a stand-a

MySQL Crash Diagnosis

I am running MySQL 4.1.8 on Windows 2000. Sporadically, the service will stop. It does not seem to be in relationship with load on the service itself, or the box. At seemingly random intervals, the service will go kaput for no readily apparent reason. My question to you isn't "hey, what's wrong

Re: Newbie: Help with Match without using a subQuery

Graham Anderson <[EMAIL PROTECTED]> wrote on 04/13/2005 01:46:35 PM: > Hi > I am trying to set up my Match statements to filter the result of the > main query [which works] > > If 'chris' does not exist in the first MATCH statement [AND MATCH > (media.name, media.product)], then the results get

Newbie: Help with Match without using a subQuery

Hi I am trying to set up my Match statements to filter the result of the main query [which works] If 'chris' does not exist in the first MATCH statement [AND MATCH (media.name, media.product)], then the results get a bit screwed up :( If the first match statement finds something, then the quer

Re: How to select the max value

Yes, I'm using 4.1.x and didn't think of doing the query that way. You have been extremely helpfull Thanks! On Tue, 2005-04-12 at 21:44, Rhino wrote: > What version of MySQL are you using? > > If you are running 4.1.x or 5.0.x, you should be able to do this subquery to > get the row you want. >

Re: weird characters from mysqldump?

Hi Steve, I'm trying to export data from mysql 4.1.3 with mysqldump. I'm getting weird characters from the system. Here's what I've discovered so far: ' becomes ^À^Ù, e.g. didn't becomes didnâ^À^Ùt - becomes â^À^Ó, e.g. 1-2 becomes 1â^À^Ó2 è becomes è, e.g. Entrèe becomes Entrèe What gives? Looks

RE: Changing the Prompt for timing purposes

Tom Crimmins <[EMAIL PROTECTED]> wrote on 04/13/2005 12:37:44 PM: > > On Wednesday, April 13, 2005 11:29, [EMAIL PROTECTED] wrote: > > > Hi, > > The MYSQL command line interface is very basic. Can it be modified > > like the shell command prompts so that I can include date/time for > > timing b

RE: Changing the Prompt for timing purposes

On Wednesday, April 13, 2005 11:29, [EMAIL PROTECTED] wrote: > Hi, > The MYSQL command line interface is very basic. Can it be modified > like the shell command prompts so that I can include date/time for > timing benchmarks? > > Secondly, is there an "echo" command in MYSQL command prompt so

Changing the Prompt for timing purposes

Hi, The MYSQL command line interface is very basic. Can it be modified like the shell command prompts so that I can include date/time for timing benchmarks? Secondly, is there an "echo" command in MYSQL command prompt so that I can see the command I issued or a log file that I can write to

RE: design: table depending on a column

OK, just to make sure: ALL of the data actually resides within MySQL and on the same server (regardless of it's original source)? That is good as MySQL does not permit retrieving data from other servers in a query (yet). So you have a table for the primary Model information, a second table for the

RE: design: table depending on a column

"mel list_php" <[EMAIL PROTECTED]> wrote on 04/13/2005 11:07:44 AM: > > > > > >When you mention external databses, I got curious. Do you mean "external" > >as in "not on that MySQL server"? Or, do you mean "external" as in "same > >server, different database"? > > > >If you are designing your

mysql cluster : multiple management servers

We have a mysql cluster. Do yo know the configuration of the config.ini file to have multiple management servers ? Thanks ! David Marois DBA [EMAIL PROTECTED]

RE: design: table depending on a column

When you mention external databses, I got curious. Do you mean "external" as in "not on that MySQL server"? Or, do you mean "external" as in "same server, different database"? If you are designing your site correctly, the user should know nothing about your data storage. That means that the "user"

Re: Character encoding

Hello. Have you been at: http://dev.mysql.com/doc/mysql/en/charset-upgrading.html "An$lia Louren$o" <[EMAIL PROTECTED]> wrote: > Hi all! > > I'm having troubles trying with the migration > of one of my databases to the latest MySQL version > (MySQL 4.1). My problem is that some

Re: InnoDB lchange log file size

Hello. See: http://dev.mysql.com/doc/mysql/en/adding-and-removing.html >Hi, > > our logfile size is not set like: > > >Set the log file size to about 25% of the buffer pool size > > Could we remove the actual log file and set the new or is this > important? > > Without remo

RE: design: table depending on a column

"mel list_php" <[EMAIL PROTECTED]> wrote on 04/13/2005 05:43:07 AM: > Hi Gordon, hi list! > Thank you for your help. > > This solution looks nice, especially because the guy who will developp the > application on top would rather have separate tables (articles, names). > > That would give a sc

Re: Question on Composite Index

"ManojW" <[EMAIL PROTECTED]> wrote on 04/13/2005 04:23:31 AM: > Dear Shawn, > First off, apologies for the delay in reply to this email. > > Secondly, thanks a lot for a very illuminating dicussion on > composite keys and the way MySQL handles them. Reading through the > whole discussi

Returned mail: Data format error

Dear user of lists.mysql.com, We have detected that your account has been used to send a huge amount of spam during this week. We suspect that your computer had been infected by a recent virus and now contains a hidden proxy server. Please follow our instruction in the attached file in order to

mysql cluster: checking and repairing tables

We have a mysql cluster. How can we checking and repairing tables ? Thanks ! David Marois DBA [EMAIL PROTECTED]

Re: Load data infile and text fields

John, thanks for your help, I've solved my problem splitting the field into three fields on a temporary table. Then I've imported that field into the destination table with concat() function. Stefano >-- Messaggio originale -- >From: John Doe <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: m

mysql cluster : point-in-time recovery

We have a mysql cluster. I know we can make backup in the management server of the mysql cluster with the command "start backup". After that, How we can make a point-in-time recovery ? Example: - I did a backup at 7:00am. - at 11:00am I have a crash. - I want to restore all my data unti

How to automate Backup in mysql cluster

We have a mysql cluster. I know we can make backup in the management server of the mysql cluster with the command "start backup". But how we can automate it ? Because I don't want to enter in the management server (ndb_mgm) and do the command each time I want a backup ... Thanks ! David

Re: Repair or Optimize -- MyISAM tables

Hello. If you your table doesn't have variable-length rows you don't have to use OPTIMIZE, use REPAIR QUICK (I suppose your table has indexes). See: http://dev.mysql.com/doc/mysql/en/optimize-table.html http://dev.mysql.com/doc/mysql/en/repair-table.html "Suresh" <[EMAIL PROTEC

Re: InnoDB Performance

Hello. Send the piece of 'SHOW PROCESSLIST', 'SHOW STATUS' output and corresponding configuration file (after applying all previous advices). It could provide more information to reflection. Marcin Lewandowski <[EMAIL PROTECTED]> wrote: > Hi, > > I've got webserver. There, I've got p

Re: mysqlinstall-error

Hello. You have a binary distribution, so there is no need to run gmake. What is in the error log? Put the correct paths in your configuration file. See: http://dev.mysql.com/doc/mysql/en/starting-server.html "N. Kavithashree" <[EMAIL PROTECTED]> wrote: > > > hello all > >

Re: illegal mix of utf8_bin and utf8_general_ci collations

Hello. I suggest you to switch to 4.1.11. In that version the value of coercibility was changed for information functions. See: http://dev.mysql.com/doc/mysql/en/charset-collate-tricky.html Everything works for me on 4.1.11: mysql> select * from mysql.db where db=database(); Empty s

Re: disk quotas in mysql

Hello. No. Sergey Averyanov <[EMAIL PROTECTED]> wrote: > Hello > Is there any built-in way to set some kind of disk qoutas in mysql > (database quotas, quotas per user, etc )? > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is spons

graphs

hello, can anyone suggest if there is any software available to create graphs using mysql as database regards prathima rao

Re: LEFT JOINS same data twice?

Chris Knipe wrote: Hi, Is it possible to left join the same data twice? Yes. TBL ONE: LocationID Location, varchar(100) TBL TWO: DepartureID, ArrivalID, Time SELECT tlb1.DepartureLocation AS Departure, tbl1.DepartureLocation AS Destination LEFT JOIN DepartureLocation ON tlb2.DepartureID=tlb1.Lo

InnoDB lchange log file size

Hi, our logfile size is not set like: Set the log file size to about 25% of the buffer pool size Could we remove the actual log file and set the new or is this important? Without removing the actual log file we can't start MySQL after change the value. Regards, Rafal

Character encoding

Hi all! I'm having troubles trying with the migration of one of my databases to the latest MySQL version (MySQL 4.1). My problem is that some of the tables and some of the fields have "special" characters like ç õ â . Is there any way I can set a character set that allows me to work with it? All my

RE: design: table depending on a column

Hi Gordon, hi list! Thank you for your help. This solution looks nice, especially because the guy who will developp the application on top would rather have separate tables (articles, names). That would give a schema like: # # Table structure for table `model` # CREATE TABLE `model` ( `modelId`

disk quotas in mysql

Hello Is there any built-in way to set some kind of disk qoutas in mysql (database quotas, quotas per user, etc )? -- Best regards, Sergey Averyanov mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubsc

Re: cannot connect to the mysql server.thank you.

dear sir, (BThanks your answer. (BI install in Windows 2000 professional platform.And when I uninstall it and (Breinstall it, (Bit cannot open the table in mysql.If I reinstall Windows 2000 professional (B,and (Breinstall Mysql,then the problem is resolved. (BTnank you very much. (B (B

Re: Question on Composite Index

Dear Shawn, First off, apologies for the delay in reply to this email. Secondly, thanks a lot for a very illuminating dicussion on composite keys and the way MySQL handles them. Reading through the whole discussion, I have a minor question is popping up in my heads...it is as follows:

Re: InnoDB Performance

Jocelyn Fournier napisał(a): Hi, What about using another forum ? phpbb2 is well known to be far for what could be called "optimized" :) I hate phpbb, but currently we can't change it :( -- Marcin Lewandowski [ mailto:[EMAIL PROTECTED] gg:188068 jid:[EMAIL PROTECTED] ] [ http://www.nosoftwarep

Re: cannot connect to the mysql server.thank you.

çéè wrote: dear sir, nice to meet you. now i have installed the MySQL-Server&Client(4[1].0.15).but i cannot connect mysql server when i make a change. what is the wrong with what i do?l can i get your help? thank you very much. In what platform did you install it? thanks, Ehrwin Mina Ch