Re: Re[2]: RH 7.2 connections problems w 16 web servers to 2 MySQLservers

> The good solution for this would be to put OOPS behind of apache. What is OOPS ? Is it like SQL Relay ? Others have said that we should be using a connection pooler & that it's a PHP/Apache config problem that we're running into. We may also move to BSD from Redhat. > P.S Are you using

Re: Adding an index to a table

http://www.mysql.com/doc/C/R/CREATE_INDEX.html > > 1 - What command do I issue to add a simple index to one field in a > table. > 2 - Do I have to do anything special like stop requests to the > server while I add the index. > 3 - How safe is this to do? > > Before post

Re: DRDB vs. MySQL replication

Hello Jens, Wednesday, March 27, 2002, 2:43:22 PM, you wrote: We have tried to use DRBD with MySQL/EXT3/NFS and some other applications. Generally it works rather good, showing rather nice performance. The only problem we had was problem with EXT3 corruption, which was in earlier (2-3 months)

RE: C API question

hi, I think u don't need to convert it in to string... all the column values comes out in string only... I have used it... Chetan Lavti -Original Message- From: Federico Halperin [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 10:40 AM Subject: C API question In a table, I

Adding an index to a table

Hi, I have a MySQL database that currently is used by about 8000 users. I need to add an index to one of the fields in one of the tables to help speed up a particular query being made to the MySQL database. I am a bit nervous to do so in case I screw up. Mind you I have backed up the

RE: C API question

hi, I think u don't need to convert it in to string... all the column values comes out in string only... or even u need to use atoi() Function for getting the Int ot unsigned int... I have used it... Chetan Lavti -Original Message- From: Federico Halperin [mailto:[EMAIL PROTECTED]] Se

Unicode problem

All Hi! I am a developer of My SQL, and I am developing an application use unicode so I would like to ask you which version that support Unicode and where can I get it. Now I am using My SQL version 3.23.49 thanks alots - Before

RE: To run MySQL Server from the remote machine

> hi, > > Is it possible to run the MySQL Server from the remote machine..?? > Mysql provides a Api's for shutting down the server from the remote > place i.e. ( mysql_shutdown(mysqlhadler)) > but I can't see any api for starting the Mysql server from the remote > machine. > > Does it mean that

Re: Replication Failure (or Bug?): Cannot Connect, but Should?

Honestly, I don't know what was wrong, but I have managed to get this problem fixed. It was one of two things... I upgraded the MySQL slave server to 3.23.49a. I also deleted the master.info file based on something I read in the release info for all of the releases in between the release tha

newbie installing MySQL/InnoDB on RH 7.1

I need some newbie help... I've installed RedHat7.1 off RH7.1 CDs, also, installed MySQL that came with it, the installed MySQL did NOT have InnoDB support; I then d/l off mysql.com MySQL-Max-3.23.49a-1.i386.rpm I installed it using: rpm --install MySQL-Max-3.23.49a-1.i386.rpm (I think

Some permissions help

Hey all, we have a new subscriber here :) I'm working on a MySQL permissions problem, and would welcome some suggestions and/or comments, or to be pointed in the right direction. The goals I have are: a) Limit users to specific db's (no access to mysql.*/etc.) b) Eliminate anony browsing of d

Re: C API question

At 5:09 + 3/28/02, Federico Halperin wrote: >In a table, I declared a column which is an integer unsigned. > >After calling mysql_fetch_row, I need to convert the value of the >column (i.e. row[0]) to a string. According to the manual, *all* column values are returned as strings. I'd say you

Re: Host permissions

Do what Paul DuBois just suggested a few minutes ago on this very list: "Delete the records from the user table that have blank User fields: DELETE FROM mysql.user WHERE User = ''; FLUSH PRIVILEGES; Then try again." That might help. Is your mysql server box behind a firewall? If it is, you mi

C API question

In a table, I declared a column which is an integer unsigned. After calling mysql_fetch_row, I need to convert the value of the column (i.e. row[0]) to a string. I tried to solve it doing this: char var[11]; sprintf (var, "%u", row[0]); , but it doesn't work. Is *row[0] an unsigned int? Can

Host permissions

I have read the mail archives and am still confuessed. mysql version 3.23.49-5 running under debian kernel 2.4.12 I cannot connect to the mysql server from the outside world. I have added a host permission to allow anyone to any database. Can someone assist ? Regards Paul --

Re: Why doesn't % work?

At 23:37 -0500 3/27/02, Chuck \"PUP\" Payne wrote: >Hi, > >I have set up a user call FooBar and I have set up the host that FooBar can >access from %, but everytime I go to a different machine I get an error that >FooBar can't access mysql from that machine IP address. Why isn't the >wildcard (%)

Why doesn't % work?

Hi, I have set up a user call FooBar and I have set up the host that FooBar can access from %, but everytime I go to a different machine I get an error that FooBar can't access mysql from that machine IP address. Why isn't the wildcard (%) working? I am using 3.23.44 with mysql-max. Any clues wo

Re: SELECT frmo two tables

At 21:53 -0600 3/27/02, Alex Behrens wrote: >This is the code I'm using and I'm a newbie so this is still a lil >challenging for me: > >$numberquery = mysql_query("SELECT SUM(s.groundballs) AS grounders FROM >stats s LEFT JOIN rahs r ON s.name = r.name WHERE (s.position = >'$position')"); As I su

Re: SELECT frmo two tables

In my experience, this is frequently the result of a failed connect. Did you verify that the connect statement succeeded? If not, and it didn't, the select will fail, of course, and this is the error you'll get. Mike's advice, checking the value of $position, is also good. By the way, you ask

Re: SELECT frmo two tables

In addition to Paul's suggestion of using mysql_error to check to see if it was successful, when I'm having trouble I like to print the query in the output for testing and then try to run the query from the MySQL CLI. print "SELECT SUM(s.groundballs) AS grounders FROM stats s LEFT JOIN rahs r ON

Re: SELECT frmo two tables

This is the code I'm using and I'm a newbie so this is still a lil challenging for me: $numberquery = mysql_query("SELECT SUM(s.groundballs) AS grounders FROM stats s LEFT JOIN rahs r ON s.name = r.name WHERE (s.position = '$position')"); while($number=mysql_fetch_array($numberquery)){ printf

Re: SELECT frmo two tables

At 20:14 -0600 3/27/02, Alex Behrens wrote: >hey guys, > >this mysql line doesn't seem to work: > >SELECT SUM(s.groundballs) AS grounders FROM stats s LEFT JOIN rahs r ON >s.name = r.name WHERE (s.position = '$position') > >why not? is there somethign wrong with my syntax? it says this error: >"Su

Re: SELECT frmo two tables

I would check the value of $position to make sure it's what you want. Mike - Original Message - From: "Alex Behrens" <[EMAIL PROTECTED]> To: "Ron Jamison" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, March 27, 2002 9:14 PM Subject: Re: SELECT frmo two tables > hey guys, > >

Re: SELECT frmo two tables

hey guys, this mysql line doesn't seem to work: SELECT SUM(s.groundballs) AS grounders FROM stats s LEFT JOIN rahs r ON s.name = r.name WHERE (s.position = '$position') why not? is there somethign wrong with my syntax? it says this error: "Supplied argument is not a valid MySQL result resource"

Re: unix_timesamp function out by a day when using a differenttimezone

On Thu, 2002-03-28 at 12:15, Paul DuBois wrote: > > >Description: > >After setting the TZ environment variable to a different timezone, then > >using the UNIX_TIMESTAMP(...) function on a mysql timestamp string > >brings back the correct time, but a date that is a day out, but only > >for certa

Re: Replication Failure (or Bug?): Cannot Connect, but Should?

Leonard, What command are you using to start the slave server? I was thinking maybe it wasn't reading the correct configuration file? This one is pretty strange. Have you thought about upgrading the slave mysql version, just to disregard that it might be a problem between the two versions? On

Re: Replication Failure (or Bug?): Cannot Connect, but Should?

Thanks Scott. It looks like permissions could be the issue, but checking out the table shows that I have all of the correct permissions setup exactly as you have listed them below. If you have any other ideas, I'd appreciate them. Thanks, Leonard At 12:49 PM 3/27/2002 -0500, you wrote: >Le

Re: Replication Failure (or Bug?): Cannot Connect, but Should?

Thanks Steven, I can telnet to port 3306 of the master system just fine. A (likely unimportant and useless) test I did was to telnet to 3306 on the master and then run "netstat -an" on the master to see if the connect was made. Yes it was... tcp0 0 10.0.0.10:3306 10.0

Re: unix_timesamp function out by a day when using a differenttimezone

> >Description: >After setting the TZ environment variable to a different timezone, then >using the UNIX_TIMESTAMP(...) function on a mysql timestamp string >brings back the correct time, but a date that is a day out, but only >for certain dates. It seems that the date becomes the original date

unix_timesamp function out by a day when using a different timezone

>Description: After setting the TZ environment variable to a different timezone, then using the UNIX_TIMESTAMP(...) function on a mysql timestamp string brings back the correct time, but a date that is a day out, but only for certain dates. It seems that the date becomes the original date plus t

RE: Coldfusion,Mysql,Myodbc

At 13:29 26/3/2002 +0100, =?us-ascii?Q?Xavier_Prelat?= wrote: Hi, >Even if you are using the CFServer 5.0 you will not be able to edit any >MySQL DSN with the ColdFusion DSN web admin tool. A clarification here. Is possible ColdFusion to create DSN on the fly using a custom DLL. I did a DLL some

Re: SELECT frmo two tables

Look in the mysql manual on joins. http://www.mysql.com/doc/J/O/JOIN.html There is also some articles on this subject at http://www.onlamp.com/onlamp/general/mysql.csp Mike - Original Message - From: "Alex Behrens" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 27, 20

RE: SELECT frmo two tables

If you need to do a join: http://www.mysql.com/doc/J/O/JOIN.html However I don't see much logic in what you're doing. Stats should not include information that exists in another table, such as name and team. You need to decide what information will be unique (such as player number) or come up

SELECT frmo two tables

Hey All, I am having problems working on a script and need some advise. Here's my problem. I have two tables with teh following variables: rahs table: name, number, team, position stats table: name, team, penalty, groundballs, shots, faceoffs_won, faceoffs_lost, date and I need to make it so u

Re: addition problem

Just to let everybody know. I found my stupid problem. I was executing the statement twice. Thanks Steve At 03:58 PM 3/27/2002, you wrote: >I hope that someone can help me with this. I understood that if I do an >update on a row in a table, I could use the SET row=row+1 and that would >tak

RE: ASP and MySQL

Loretta, Your syntax appears to be correct. Below is an example of what we do (with some bits cut out) and it works. strSQL = "INSERT INTO tblTempConsolidation SET " & _ "customerId = " & intCustomerId & ", " ..

Re: how to check if table exists?

java. 'show tables like' is what I needed. Thanks, Ken Steven Hajducko wrote: > > You can do a couple of things.. > > Are you using any other language besides SQL? ( perl, PHP? ) > > If you're just looking for a way to do it with sql.. you can try - > > show tables like "tablename"; > > It

Re: how to check if table exists?

You can do a couple of things.. Are you using any other language besides SQL? ( perl, PHP? ) If you're just looking for a way to do it with sql.. you can try - show tables like "tablename"; It'll either give an empty set, or return the tablename. -- sh On Wed, 2002-03-27 at 14:29, Ken Anders

Re: how to check if table exists?

What is the fastest way to check if a table exists? Do a select and catch the error? Try to create the table, and catch the error? Other options? Thanks, Ken sql,query - Before posting, please check: http://www.my

addition problem

I hope that someone can help me with this. I understood that if I do an update on a row in a table, I could use the SET row=row+1 and that would take what was in that row/column and add a 1 to it. For some reason, it is doubling it. My end result is always twice what it should be. Can anybo

Re: sum of a column

select sum(col) from tab; On Wed, 2002-03-27 at 13:32, Aman Raheja wrote: > Hi all > How do I get the sum of all values in a column 'col' of a table 'tab' > I am using CGI-Perl and mysql. > Thank you. > Aman > > _ > Send and receive

sum of a column

Hi all How do I get the sum of all values in a column 'col' of a table 'tab' I am using CGI-Perl and mysql. Thank you. Aman _ Send and receive Hotmail on your mobile device: http://mobile.msn.com ---

RE: cipher strings usable under GRANT command

sql,query What are all the cipher strings possible using the GRANT command and the CIPHER clause? The docs only give one example. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lis

RE: What is wrong in this query???

You cannot update multiple tables in a single UPDATE. Did you read the manual? -Original Message- From: Javier Armendáriz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 2:04 PM To: MySQL Subject: What is wrong in this query??? Can someone tellme the problem in this query??

Re: What is wrong in this query???

At 21:03 +0100 3/27/02, Javier Armendáriz wrote: >Can someone tellme the problem in this query?? > >Is there any problem updating two tables in the same query??? Do you find that syntax to be allowed anywhere in the MySQL manual? There is work on this kind of thing being done for MySQL 4.1.

What is wrong in this query???

Can someone tellme the problem in this query?? Is there any problem updating two tables in the same query??? update alumno, alumnocurso set alumno.nombre='Blas', alumno.apellidos='Martinez Maertinez', alumno.nacimiento='1990-09-12', alumno.telefono = '6', alumnocurso.incorpora

RE: Select data from local database into another host over

4.8.5 mysqldump, Dumping Table Structure and Data Utility to dump a database or a collection of database for backup or for transferring the data to another SQL server (not necessarily a MySQL server). The dump will contain SQL statements to create the table and/or populate the table. I

Re: How can I Sort by Relevance?

Just an aside, the "like" comparison is case insensitive -- so you don't need the "UCASE" in this example. like '%A%' will match both "A" and "a". --jeff - Original Message - From: "Walter D. Funk" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 27, 2002 10:05 AM Sub

RE: Enforcing Column Types

> I have a column that is VARCHAR(32). I use it to store MD5 hash values. MD5 hashes are always 32 byte. So use char(32) instead. I do. -Original Message- From: Joel Rees [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:30 PM To: Tino Didriksen Cc: [EMAIL PROTECTED] Subject: R

Replication failed: TRUNCATE TABLE command

Anti-SPAM: mysql, query Gurus I'm new to replication. Set it up this weekend and has worked flawlessly for several days. Then I used the command: TRUNCATE TABLE tbl; That worked in master, but was not replicated in slave. No mention of this in manual. Using version 3.23.49 on master and slav

RE: hierarchical struture into mysql

Try looking up the Nested Set Hierarchy structure, which is mainly discussed by Joe Celko. There are a number of discussions on usenet (groups.google.com) about it, by him. Also, here's a URL which gives his description. It's a good structure, and with modification, looks like it can fit about a

RE: MYSQL on a Cobalt RaQ4

I have a Raq4 running with MySQL + php no problem. Save yourself a great deal of time by loading the packages available from: http://pkgmaster.com/ These Cobalt support team guys maintain security update and misc. packages which, for the Raq 3 and above, happen to include PHP and MySQL. I hig

Re: How can I Sort by Relevance?

From: Walter D. Funk <[EMAIL PROTECTED]> > ...I'd like to sort them so as the result set becomes like this What language, if any, are you working in, other than SQL? --- Rodney Broom Programmer: Desert.Net - Before posting,

Re: How can I Sort by Relevance?

At 15:05 -0300 3/27/02, Walter D. Funk wrote: >I have a query like this > >select * from PROFILES where UCASE(DESCRIPTION) like '%A%' > >the result of this will be a set in which any member contains at least an >"A", >but I'd like to sort them so as the result set becomes like this > > >first: "A"

RE: How can I Sort by Relevance?

Walter Try adding to your select statement: ORDER BY DESCRIPTION ASC David -Original Message- From: Walter D. Funk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: How can I Sort by Relevance? I have a query like this select * fro

How can I Sort by Relevance?

I have a query like this select * from PROFILES where UCASE(DESCRIPTION) like '%A%' the result of this will be a set in which any member contains at least an "A", but I'd like to sort them so as the result set becomes like this first: "A" second: "AAA" third: "any string containing an A" and

Re: Replication Failure (or Bug?): Cannot Connect, but Should?

Hrm, I'll take a stab at it, since I've got replication working atm... Have you tried basic connectivity tests between the slave and master? ( Just making sure.. ie - can you telnet to port 3306 on the master, from the slave? ) Did you flush the privileges after adding the repl user? Here's my

RE: Adding a Column to an existing table

--- Steven Gearhart <[EMAIL PROTECTED]> wrote: > The easiest way to add a column is to get somebody > else to do it. > > Seriously, Use the "ALTER TABLE TableName ADD COLUMN > Company_id INT UNSIGNED > NULL" command. Yes. But also, the company_id field probably should be reset 'not null' AFTER t

Re: Replication Failure (or Bug?): Cannot Connect, but Should?

Leonard, This is pretty clearly (IMHO) a permissions issue. Make sure the username you use to replicate with, has a '%' in the Host field of the user table. mysql> use mysql mysql> select * from user where user = '' \G *** 1. row ***

more mysql.pm install issues

hello again list i've been trying to install the mysql dbd module on a cobalt-linux box and with some help from this list, i was able to pass most of the tests on the install... only 3 remain and i don't know why it's failing. could someone please look at this output and tell what's wrong? o

Re: MySQL Connection error

You might want to look in the crontab to see if rotatelogs is rotating the logs for mysql. If it is, the mysql database is bounced. The easy thing to do is just to check the connection and make sure it is open before using it. i.e. if (conn.isClosed()) { conn=db.getConnection() } On Wed, 200

Re: Replication Failure (or Bug?): Cannot Connect, but Should?

Sorry to bring this up again, but I haven't received any helpful responses. Does anyone have any clues about this or is this something I should report as a bug? I can't imagine it is. Thank you, Leonard At 12:43 AM 3/26/2002 -0800, you wrote: >Hello, > >I have been attempting to get repli

hierarchical struture into mysql

Hi, from my experience CREATE TABLE message ( id int(10) NOT NULL auto_increment, parent_id int(10) NOT NULL default '0', parents varchar(255) NOT NULL default '', level tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (id), KEY parent_id (parent_id), KEY parents (parents) )

Re: [OT] html to perl to mysql

From: Bob T <[EMAIL PROTECTED]> > The browser displays a new page which displays the perl source code. > How do I run the perl script from the browser This means that Apache isn't executing your code, instead he's just reading in the text of "myperlscript" and sending it to the browser. You nee

Fetching Data based on the day

Soheil, Wednesday, March 27, 2002, 6:45:38 PM, you wrote: SS> I am trying to extract the data from MySQL based on the month, and day of SS> the item, and post them on a page. SS> Something similar to "Today in History" SS> Here is a partial list of my table: SS> CREATE TABLE ANNOUNCEMENT ( SS>

Re: Fetching Data based on the day

From: Soheil Shaghaghi <[EMAIL PROTECTED]> > SELECT AnnouncementID,Title,DateShown FROM ANNOUNCEMENT WHERE > DateShown=NOW() ORDER BY DateShown DESC > ...I only want to look at the month, and the day SELECT AnnouncementID,Title,DateShown FROM ANNOUNCEMENT WHERE substring(DateShown,6,5

Fetching Data based on the day

Hello everyone. I am trying to extract the data from MySQL based on the month, and day of the item, and post them on a page. Something similar to "Today in History" Here is a partial list of my table: CREATE TABLE ANNOUNCEMENT ( AnnouncementID bigint(20) unsigned DEFAULT '0' NOT NULL, Title va

RE: Write query to text file

Thanks That was all I needed. Just a push in the right direction. Your friendliness was must appreciated. Isak -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 27 March 2002 17:01 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Write query to text file

Re: html to perl to mysql

> Using apache 1.3.23 for win32 > WinXp and Perl 5.6 and Mysql 3.23.44-nt > The localhost test page by apache runs correctly > The perl script runs from the command line, the Browser url line and just by > clicking it in the dir. > > Trying to launch this perl-dbi script from the brow

Calling SQL gurus

Hello SQL Gurus I am trying to write an sql statement that will return a row which contains vendor info, how much he owes, total payments and balance due. The results should look like this : ABC,VENDOR ONE,333.33,199.98,133.35 DEF,VENDOR TWO,333.33, 0.00,333.33 The statement uses 3 tables and

How to use SSL on Win2000 client?

We have Solaris 2.8 running Mysql 3.23.49. We are building a database with an Access 2002 front end on Win98/95 or Win2000, which would run over the internet. My problem is, how do we encrypt the communications between the front-end and the back-end (mysql)? Mysql supports SSl but Access does not.

RE: binary expansion?

I don't like the set type as I can't use it on other databases (even though I do not foresee changing databases, I like to keep the option open). The bit method is what I'll probably use. Thanks for the help :-) -Original Message- From: Joel Rees [mailto:[EMAIL PROTECTED]] Sent: Wedne

Re: Large datafiles

At 04:30 AM 3/27/2002, you wrote: >Hi > >I'm running mysql 3.23.36 on a Red Hat 7.1 with the standard kernel. > >I have a /var partition (ext2) with 6.5 gb total space. > >One of the tables are almost running out of space, it is almost 4 gb. is it >the filsystem that prevents files larger than 4 g

Select data from local database into another host over

Does anybody have an idea how to select data from a local database into another host server ? For information, I'm currently using mySQL 3.23. Eric Huwaert Kind regards - Bien cordialement - Vriendelijke groeten - Mit freundlichen Grüßen , ---

Re: [Newbie] MATCH and INDEX question (using a JOIN in a MATCH statement)

Thanks Paul, I figured that was the answer. Do I need to perform a second and third query from my related tables with a join back to the 'main' table? Example: select main.id, main.description, maincat.name, subcat.name from main LEFT JOIN maincat ON main.maincatid=maincat.id LEFT JOIN subcat

Write query to text file

Isak, Wednesday, March 27, 2002, 4:49:01 PM, you wrote: IB> My problem is as follows. I need a c program to run a query on the mysql IB> database and then write the results into a text file. I am running the IB> mysql on a Linux machine. IB> I am new to mysql and according to another source th

Re: Write query to text file

Hi, RTFM see at "INTO OUTFILE" Adib. Isak Badenhorst wrote: > Hi everyone > > My problem is as follows. I need a c program to run a query on the mysql > database and then write the results into a text file. I am running the > mysql on a Linux machine. > > I am new to mysql and according to a

RE: Help me!

Did you try installing a new copy of MySQL and then simply copying the appropriate files from mysql/data/mysql over to your damaged installation? Just an idea. joe > -Original Message- > From: noat naut - nart [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 27, 2002 5:49 AM > To: [EM

deleting logfiles

Hi, I'm running RH Linux 7.0,and Mysql Version: 3.23.22-beta, and the mysqld.log grows very rapidly. Is there a way to turn it off ? Logrotation is not really an option in this case, the only possibilities are not logging or delete it every day. Any hints ? JvD,Netherlands ---

Write query to text file

Hi everyone My problem is as follows. I need a c program to run a query on the mysql database and then write the results into a text file. I am running the mysql on a Linux machine. I am new to mysql and according to another source there is an example program in the mysql source code? I check

RE: MYSQL on a Cobalt RaQ4

Hi Denis, According to its datasheet, the RaQ4 is a 450MHz Intel compatible machine running Linux 2.2 so I can't see any problems installing and running MySQL on it. Regards, Chris > -Original Message- > From: Denis Croombs [mailto:[EMAIL PROTECTED]] > Sent: 27 March 2002 14:30 > To: M

RE: MYSQL on a Cobalt RaQ4

Yes, my hosting providers use raq servers and I have mysql databases on all of my domains -Original Message- From: Denis Croombs [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 8:30 AM To: Mysql (E-mail) Subject: MYSQL on a Cobalt RaQ4 Hi Will MySQL run on a Cobalt RaQ4 ser

MYSQL on a Cobalt RaQ4

Hi Will MySQL run on a Cobalt RaQ4 server ? Denis Croombs - 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

RE: ASP and MySQL

Being in Italy, we use apostrophes in our fields constantly! MySQL itself has no problems with them at all. As you say, you're using ASP as your front end, and standard SQL statements to add, edit and delete records. For ASP I'm not sure, but in our PHP code it works to simply add a backslash be

Re: Replication Connection: Slave -> Master?

Oops meant to include the list on that one :) Begin forwarded message: Date: Wed, 27 Mar 2002 14:11:54 + From: Chris Wilson <[EMAIL PROTECTED]> To: Benji Spencer <[EMAIL PROTECTED]> Subject: Re: Replication Connection: Slave -> Master? On Wed, 27 Mar 2002 07:21:11 -0600 Benji Spencer <[EMA

Re: Date Interval Grouping

try GROUP BY (UNIX_TIMESTAMP(tVH.vDateTime) - MOD(UNIX_TIMESTAMP(tVH.vDateTime, 300))) > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: Date Interval Grouping > Date: Tue, 26 Mar 2002 19:13:44 -0700 > > Ok here's what I trying to do. I am trying to design a little browser/ip > tra

Re: Excel to MySQL

At 3:58 -0800 3/27/02, Thomas Edison Jr. wrote: >How do i import MS Excel Data into MySQL Tables?? One way: save it as a tab-delimited file, then import it with mysqlimport. If you don't want to mess around pointing and clicking to save an Excel file as a tab-delimited file, try using this Perl

Replication Connection: Slave -> Master?

We are looking at using replication between two MySQL servers. In our situation, there might be a firewall between the two servers and we will need to permit the traffic between the two through the firewall. From what I have read, it sounds like the Slave connects to the Master (in stead of t

Help me!

noat, Wednesday, March 27, 2002, 2:49:16 PM, you wrote: nnn> My Server is Redhat 7.2 OS and MySQL Server. nnn> I've deleted the "mysql" system table in MySQL Server. nnn> I can't connect to MySQL Server from any Client. nnn> I would like to know the structure of it in order to recreate it. You

Re: mysqlgui crash caused by infinite loop

[EMAIL PROTECTED] writes: > >Description: > mysqlgui crash caused by infinite loop in > mysql_read_default_options because strcend > never returns 0 > >How-To-Repeat: > > >Fix: > > --- libmysql/libmysql.c.orig Thu Feb 14 18:30:17 2002 > +++ libmysql/libmysql.c Tue

Help me!

My Server is Redhat 7.2 OS and MySQL Server. I've deleted the "mysql" system table in MySQL Server. I can't connect to MySQL Server from any Client. I would like to know the structure of it in order to recreate it. Help me, please! Thank you very much __

last_insert_id() not replicated correctly (?)

Hi Guys, http://www.mysql.com/doc/R/e/Replication_Features.html ... states that last_insert_id() will be replicated "correctly". However I don't think this is always the case, for instance: INSERT INTO TABLE tab1 (field1) values ("Test"); INSERT INTO TABLE tab2 (somefield) values (last_insert_

Large datafiles

Well, if i'm usin ext2 with a blocksize on 4 kb, then the largest file should be about 4 gb, right ? -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: 27. marts 2002 12:16 To: [EMAIL PROTECTED] Subject: Large datafiles Svend, Wednesday, March 27, 2002, 12:30:28 PM,

RedHat6.2 and kernel 2.2.14

We've got a RedHat 6.2 system here, and every so often it fails to commit an INSERT to the database, (using BDB table type). Apart from that the system works fine. I was wondering if this is a symptom of the kernel 2.2.14 problem that's mentioned on the download page. Anyone got any views on th

auto_increment and range or highest value

Hi, I'am using autoincrement field with innodb table. (Mysql 3.23.47-log on Linux ppc) Two questions 1_ how to set a range ? Is the only solution chosing betwwen tinyint, smallint, ..., bigint I over words : I want a range from 1 to 999 for example , how can I do ? 2_ Wha

Excel to MySQL

How do i import MS Excel Data into MySQL Tables?? T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 ***

DRDB vs. MySQL replication

Hi, has anyone used DRDB (http://www.linbit.com/) instead of the standard MySQL replication? DRDB implements a virtual disk mirrored across a local disk and a disk in a remote stand-by server. On first thought, it adds some complexity to setup, but it can also replicate information not written to

permissions

Neil, Wednesday, March 27, 2002, 12:12:37 PM, you wrote: ND> Can anyone tell me how to grant connect to a database. I'm using MySql on an ND> NT server. Most clients can connect to the database but one PC can't, that ND> pc is running linux. Can anyone help? You should to allow your Linux box to

RE: upgrade 3.22 to 3.23 or 4.0 version

Hello Swapna, >I'm trying to upgrade my MySQL 3.22 version to 3.23 or 4.0 version on Linux >flatform, but I don't know the procedure. Could any one please tell me the >procedure how to do it. And if I upgrade to the higher version do I lose >any of my data. There are a lot of info about MySQL up

Large datafiles

Svend, Wednesday, March 27, 2002, 12:30:28 PM, you wrote: SEHJ> I'm running mysql 3.23.36 on a Red Hat 7.1 with the standard kernel. SEHJ> I have a /var partition (ext2) with 6.5 gb total space. SEHJ> One of the tables are almost running out of space, it is almost 4 gb. is it SEHJ> the filsyste

  1   2   >