Re: Maximum number of tables

Jose, - Original Message - From: JSL [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, September 02, 2002 11:49 PM Subject: Maximum number of tables - Original Message - From: JSL [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 02, 2002

Re: select using 2 left joins

Hi Jed, you aree totally right. The statement I typed should indeed be: WHERE tableName.manufacturersID=12 Meaning I got the ambiguity error. thx for the tip, Wilbert - Original Message - From: Jed Verity [EMAIL PROTECTED] To: Wilbert Enserink [EMAIL PROTECTED]; [EMAIL

upgrading v3.2.3 to v4.0.2 and An error occurred during the move data process: -103

Well Well Well , I proceeded in upgrading v3.2.3 to v4.0.2 and An error occurred during the move data process: -103 Component Servers File Group: File: Thus i unzipped mysql-4.0.2-alpha-win.zip into C:\mysql and the above happened I am using excessivly MyODBC to connect to M$ Access 2000

Innodb too slow

Hi, why innodb queries work MUCH slower (100 times) than if the table was of myisam type? It's mysql 4.0.3 on FreeBSD 4.5 server. The innodb monitor outputs many messages like the following, why are they there and what do they mean? Purge done for trx's n:o 0 782 undo n:o 0 0 Total number of

mysql_real_connect - capi

I am using c to write some basic mysql programs and I cannot seem to get past mysql_real_connect. I get an access denied message. It does not recognize the password user combination. I set the usr/pswd up with the admin progrram and can get into mysql fine. One thing I noticed on the error

Re: upgrading v3.2.3 to v4.0.2 and An error occurred during the move data process: -103

At 08:41 03/09/02 +0100, Chuck Amadi wrote: Hi, Well Well Well , I proceeded in upgrading v3.2.3 to v4.0.2 and An error occurred during the move data process: -103 Shutdown the current installed server or install 4.0.X on another directory. Component Servers File Group: File: Thus i unzipped

innodb vs myisam performance

Hi, I've just ran a benchmark test to compare Innodb and MyISAM, and I just want some input from you guys which already using Innodb ;-) I have two tables : same definition and same records Innodb table name : CUSTOMER MyISAM table name : CUSTOMER2 and this is what I found on my queries : -

Re: build under Win32 - thanks

Thank you very much for help. Nick. sql,query - 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

Order by date

Hi, I have a query from tables that give me records with two date date1 and date2. How can I order the records by the most recent date (between the two date) for each records ? Example: Data: IDdescriptiondate1date2 1 aaa09/03/02 09/05/02 2

Re: can't start daemon after reboot (after initial install)

Bill, Tuesday, September 03, 2002, 6:08:57 AM, you wrote: BF I installed 3.23.52 on a RedHat 7.3 machine. Everything was just fine until I BF rebooted later for another reason. Now I can't start the daemon. I tried BF deleting /var/lib/mysql/mysql.sock as root. It deleted, but to no avail. Any

Re: Install questions

Matt, Monday, September 02, 2002, 8:33:36 PM, you wrote: MTW I just installed MySQL from RPM and can connect to it via shell using MTW the MySQL command, but I can't get anything else to connect to it. MTW MySQL Connection Failed: Can't connect to local MySQL server through MTW socket

RE: Inno DB Question

Heikki, Thanks for your answer. I was yesterday making other tests using dbExpress components and the only way that I found so far to get the dbExpress components working on transactions on MySQL is using the method ExcuteDirect of the TSQLConnection. This is the code : TSQLConnection *Conn;

MySQL Backup

Hi, can someone point me in the right direction please regarding backing up a MySQL database using Veritas 8.6 on a Windows 2000 server? Is there a script I can use to dump the database to a cold file where I can back it up off-line or are there agents available to enable me to back the

Re: Order by date

Xavier, select ID, description, if (ifnull(date1, 20201231) ifnull(date2, 20201231), ifnull(date1, 20201231), ifnull(date2, 20201231)) as date from MyTable order by date I didn't test it, but it should work. Any questions? don't hesitate to ask. Best regards, Mikhail. - Original

RE: MySQL Backup

-Original Message- From: Tom McCay (Ramesys - Nottingham) [mailto:[EMAIL PROTECTED]] Sent: 3. september 2002 11:59 To: [EMAIL PROTECTED] Subject: MySQL Backup Hi, can someone point me in the right direction please regarding backing up a MySQL database using Veritas 8.6 on a

Re: MySQL Backup

Hello! Erlend Hopsø Strømsvik wrote: -Original Message- From: Tom McCay (Ramesys - Nottingham) [mailto:[EMAIL PROTECTED]] Sent: 3. september 2002 11:59 To: [EMAIL PROTECTED] Subject: MySQL Backup Hi, can someone point me in the right direction please regarding backing up a MySQL

link under Win32 for udf

Hello. It's anew me. And how linking under Win32 with --with-mysqld-ldflags=-rdynamic? I need UDF. Thanks in advance. Nick. mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual)

GRANT not working

I have a new installation of RedHat 7.3 and MySql. I had MySql working great on a Mandrake 8.0 installation. Now that I have reloaded this box with RH, I cannot get setup and working. I can run mysql as root and get in. I ran the commands below: grant all on * to amp identified by 'blahdblah';

Re: MySql 4.0.2a Bind-Address problem

Hi all, I just tried 4.0.3beta and it doesn't seem to address the bind-address problem at all. When I include the option in the ini file and run mysql-max-nt --help, it stops showing the variables when it reaches bind-address variable and a window pops up with the following message: The

Re: GRANT not working

I believe that your problem is specifically with RedHat. I've ran it on just about every incarnation of Linux from Mandrake to Gentoo. The only one that I have ever had a problem getting MySQL to run on was RedHat 7.x and I've even run it on things like OpenMosix (www.openmosix.org) and Scyld.

RE: MySQL Backup

I usually just copy the complete DB directory from one computer to another one. With fast ethernet it takes around 5-10 minutes (30 minutes if I have to backup the table where I store images). Only thing is that mysql can't write to the table currently being copied. But that's

Re: GRANT not working

I personally have never had a problem with Redhat. Andrew try this: grant all privileges on *.* to 'amp'@'%' identified by 'blah' (with grant option) ; let me know if it works. - Original Message - From: Matt Hargraves [EMAIL PROTECTED] To: Andrew Pierce [EMAIL PROTECTED]; [EMAIL

Re: GRANT not working

On Tue, 2002-09-03 at 13:22, Matt Hargraves wrote: Tried RedHat versions from 7.0 to 7.3, none of them will run, install any other distro, it works from the start. Don't matter whether it's MySQL 3.x or 4.x, it won't work for me or anyone else I know with RedHat. I am running mysql 3.23.49

about several selects/inserts

Hi, I would like to know if you could help me to solve the following problem: The application I developed needs to run several selects, inserts and updates all the time. When the clients are selecting data, mySql runs the selects at the same time, but when an update command starts executing,

script for complete Database dump?

is there any single MySQL script that would backup my complete database? thanks! Kai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

host field in tables_priv

Hi I'm new to mysql and i'm trying to understand the privileges table. With the following configuration of the user table +---+--+ | host | user | +---+--+ | % | robber | |

RE: script for complete Database dump?

use mySQLdump. c:\mysql\bin\mysqldump.exe there is a switch for dumping the whole DB. heh, .b -Original Message- From: Kai Vermehr [mailto:[EMAIL PROTECTED]] Sent: 03 September 2002 13:10 To: MySQL List Subject: script for complete Database dump? is there any

Rowlevel Locking

Hi, I have did setup for MySQL - Innodb tables. But I am not getting support for row level locks. Whenever I am issuing a update the innodb tables are locking my tables. Please help me whether I need to set any variables in sqld file to get the support for row level locks ??? Regards, Sekhar

Re: Problem with ALTER query

Ramanathan, Saturday, August 31, 2002, 3:54:27 PM, you wrote: RPS I have two connections open to a mysql-nt server. I am using one RPS connection to add a field field to a table using the command RPS ALTER TABLE testtable ADD testfield int; RPS Now if I issue any query from the second

Re: primary/foreign key contraints

neal, Tuesday, September 03, 2002, 4:06:37 AM, you wrote: n Sorry for the MySQL newbie question ... but are there not primary/foreign n key constraints in MySQL 3? I can't imagine that this is right. Perhaps n I'm just overlooking something Foreign keys constraints is supported in InnoDB

Re: script for complete Database dump?

Kai, Tuesday, September 03, 2002, 3:09:45 PM, you wrote: KV is there any single MySQL script that would backup my complete database? What about mysqldump? http://www.mysql.com/doc/en/mysqldump.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This

Datafiles on raw devices

I've heard that MySQL 4.x can use raw devices on Linux, I'm curious to learn more. Are some speed tests available? Where I can find documentation? I can realize InnoDB tablespaces can benefit from bypassing the filesystem overhead, but one of MySQL advantages is it's based on files you can

RE: Problem with ORDER BY

turn them back into numbers with a math function ORDER BY ABS(value) -Original Message- From: Jürgen Müller [mailto:[EMAIL PROTECTED]] Sent: Friday, August 30, 2002 5:23 PM To: [EMAIL PROTECTED] Subject: Add: Problem with ORDER BY I've changed my query to: $order =

Fwd: Re: MySQL 3.23.52

Forwarded Message: To: Martin Brülisauer [EMAIL PROTECTED] From: [EMAIL PROTECTED] Subject: Re: MySQL 3.23.52 Date: Tue, 3 Sep 2002 14:15:42 +0200 - Your message cannot be posted to [EMAIL PROTECTED] because it did not follow the format expected by our spam/off-topic filter. To this

Re: Inno DB Question

Javier, - Original Message - From: Javier Diaz [EMAIL PROTECTED] To: 'Heikki Tuuri' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] (E-mail) [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 12:32 PM Subject: RE: Inno DB Question Heikki, Thanks for your answer. I was yesterday making

RE: Euro sign mysql

Hi Tod, What happens if you escape the string first, like with DBD's quoting function? Sorry i don't know it, how should i use this function? Still, the error message is a bit odd. Perhaps it isn't even Mysql's fault... How are you connecting? Using the mysql client. thx Derk On

Re: Rowlevel Locking

Sekhar, do your updates have good indexes through which they can access only the rows they are going to update? From section 8.4 of http://www.innodb.com/ibman.html: UPDATE ... SET ... WHERE ... : sets an exclusive next-key lock on every record the search encounters From section 8.5: a..

RE: Bug ?

It think MySQL could very well have corrupted the data back in 3.23.38 for Marian when I first started out using mysql, I was fairly new to linux and totally new to MySQL MySQL default install went to /var/lib/mysql, default RedHat /var is quite small So unknowingly to me, it filled up quite

How Many Fields

What is the limit on amount of fields in a MYSQL table. Access / lotus will only do 255, whereas Filemaker will do over Hopefully someone will tell me it is more than 459 (that is what I need in mine). Thanks Brian Leyland

Row level Locking

Hi, I have did setup for MySQL - Innodb tables. But I am not getting support for row level locks. Whenever I am issuing a update the innodb tables are locking my tables. Please help me whether I need to set any variables in sqld file to get the support for row level locks ??? Regards, Sekhar

Re: Problem with ALTER query

I have just installed redhat linux 7.1 and now need to install Mysql. with innodb support. I downloaded the rpm (3.23.51) from the mysql site and tried to install it. The process appeared to stop mysql and then complained it could not find a file: /etc/rc.d/mysql A query on rpm -qa | grep mysql

Finding gaps in date intervals

Hi, I have a table with this structure: CREATE TABLE dats ( id INT UNSIGNED NOT NULL, id_ref INT UNSIGNED NOT NULL, start DATE NOT NULL, endDATE NOT NULL ) Now I am trying to create a query that will give me all intervals for which the table does not

Insert date format

Hello, I am developing an aplication where I need format the date for inserting into mySQL. With DATE_FORMAT I can format the mySQL date to my date, but I haven't found a good way to format my date to the mySQL date. My format is 'dd-mm-' and to convert it to '-mm-dd' I'm using the

UPDATE syntax dummy question...

Howdy, I'm trying to perform an update on a php poll table. Here is the table description: mysql describe vbooth_data; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ |

Re: Innodb too slow

Hi Alexander, I believe that the the 'count()' function works differently under INNODB type tables. With MyISAM count(*) is stored in a 'table status' area, but INNODB must scan the tables and count the rows (very slow). All other types of queries should perform much better for you, but

Re: primary/foreign key contraints

Neal, Sorry for the MySQL newbie question ... but are there not primary/foreign key constraints in MySQL 3? In MyISAM tables or ISAM tables no. I can't imagine that this is right. Perhaps I'm just overlooking something innodb? (mysql query) DSL

InnoDB locks disappear

My program uses locks to allow for multi-threading (processing requests that are stored in the database using more than one thread and/or application). The problem is that the locks disappear for seemingly no reason at all. The same queries are repeated over and over again until the lock just

entry just made in mysql table

sql,query Is there a way to find out what the value of the last entry just made in a mysql table where the field is being auto incremented? - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: MySQL and Service Pack 3

Hi! Miguel == Miguel Angel Solórzano [EMAIL PROTECTED] writes: Hello, I have a very strange problem with all of the Windows versions of MySQL. I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will not work period. Has anyone ran into this problem and or know of a fix?

getting the id each side of a given id

hi all, given a certain id # (eg 4), how would i query the value either side of it (usually 3 and 5). In theory, yes, it'd be 3 + 5, but in the case of the following table: 1 4 5 it'd be 1 + 5, and this: 3 4 7 it'd be 3 + 7. Even more interesting would be obtaining some sort of an error

Re: Re: Help! Recovering corrupt table

Rolf, Tuesday, September 03, 2002, 1:57:49 AM, you wrote: RH I'm using MySQL 3.23.51. I have a table which started giving 127 errors. [skip] RH It recovers my table but I end up with only 1030 out of 27497 rows, RH so that's not a log of help! RH Running myisamchk -r -e gives a similar result

Re: mysqld --help - Segmentation fault

sitnikov, Friday, August 30, 2002, 8:34:03 PM, you wrote: Description: s Segmentation fault when starti mysqld with --help How-To-Repeat: s mysqld --help I tested it and mysqld --help worked without any problem. Today Michael Tam reported about crush if he used bind-address

Re: mysql_real_connect - capi

Buddy, Tuesday, September 03, 2002, 11:05:24 AM, you wrote: BB I am using c to write some basic mysql programs and I cannot seem to get BB past mysql_real_connect. I get an access denied message. It does not BB recognize the password user combination. I set the usr/pswd up with the BB admin

Number of queries per second

Hi I'm trying to see how many queries per second I have running in my MySQL server. I understand that the number i see (Queries per second avg) is the average since the time the MySQL Server came up. The numbers i see below do not make much sense since the number stabilizes around 47 at any

Re: Insert date format

Hello Javier, I am developing an aplication where I need format the date for inserting into mySQL. =what language is your application written in? =dn With DATE_FORMAT I can format the mySQL date to my date, but I haven't found a good way to format my date to the mySQL date. My format is

Re: Innodb too slow

Thank you Ken for the answer, but here the cause was different from what you say. count() works fast enough for innodb as well, expecially if the query cache feature is turned on. In my case, I used a mysql 4.0.3 compiled from ports, which had a debug option turned on, and it appeared to be

MySQL 4.0.3b Bind-Address problem

Hi all, I just tried 4.0.3beta and it doesn't seem to address the bind-address problem at all. When I include the option in the ini file and run mysql-max-nt --help, it stops showing the variables when it reaches bind-address variable and a window pops up with the following message: The

Re: UPDATE syntax dummy question...

Hi, You should escape quotes within strings: Matthias Trevarthan wrote: Howdy, I'm trying to perform an update on a php poll table. Here is the table description: mysql describe vbooth_data; +-+--+--+-+-+---+ | Field | Type | Null |

Re: How Many Fields

I can't think of any reason to have that many fields. It really starts to make the databases structure unmanageable, or at least difficult and time consuming to manage. It also can make it very difficult to create a good, flexible search interface. Filemaker might be an exception because of

RE: UPDATE syntax dummy question...

Matthias, MySQL is letting you know that you have an unterminated string with the apostrophe. You'll have to either use double quotes to contain the string Not at all, I'm waiting for the other shoe to drop, or escape the apostrophe in the word I'm. i.e. UPDATE vbooth_data SET optionText=Not at

Re: UPDATE syntax dummy question...

You need to escape the ' mark in your string. The query should be: update vbooth_data set optionText='Not at all, I''m waiting for the other shoe to drop' where (pollID=34 AND voteID=3); Note the '' within the string: the first tick escapes the second one. If you're more comfortable with

RE: Insert date format

Hello, I am developing an aplication where I need format the date for inserting into mySQL. =what language is your application written in? =dn The application is written in Java, but the problem is that the module where the dates for the DB are managed is an open source framework and

Openssl and MySQL 4.0.3-Beta

According to the documentation under section 4.3.9 to get openssl working with mysql you need to configure mysql with the --with-vio --with-openssl. When I add the as arguments to ./configure and then compile it I get a mysqld that will run but try to do anything with it and the client

Re: UPDATE syntax dummy question...

Howdy Matthias, update vbooth_data set optionText='Not at all, I'm waiting for the other shoe to drop' where (pollID='34' AND voteID='3'); When I hit Enter, it gives me this prompt: ' Two things: 1 (the ) is because it is waiting for the end of the string - you have an apostrophe opening

Re: entry just made in mysql table

At 17:10 +0200 9/3/02, mixo wrote: sql,query Is there a way to find out what the value of the last entry just made in a mysql table where the field is being auto incremented? SELECT LAST_INSERT_ID(); - Before posting, please

Re: UPDATE syntax dummy question...

Thanks everyone! I see that I need double quotes now. I received about 12 different personal emails from various people with exactly the same answer. Thanks again! On Tuesday 03 September 2002 10:31, Matthias Trevarthan wrote: Howdy, I'm trying to perform an update on a php poll table.

mysql_real_connect - capi

From: Buddy Bell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mysql_real_connect - capi Date: 03 Sep 2002 04:05:24 -0400 I am using c to write some basic mysql programs and I cannot seem to get past mysql_real_connect. I get an access denied message. It does not recognize the

MySQL 4.0.3b Bind-Address Problem

Hi all, I just tried 4.0.3beta and it doesn't seem to address the bind-address problem at all. When I include the option in the ini file and run mysql-max-nt --help, it stops showing the variables when it reaches bind-address variable and a window pops up with the following message: The

case (in)sensitive

Heey Folks, I've got this small problem... I'm working on a site (www.esctoday.com). In runs on PHP and MySQL. The remote server has some linux version, for local testing of scripts I use Windows 2000. And now the problem, when I run a create tables script on windows 2000 it changes the

Re: JOIN?

I have a query which is more complex (taking advantage of relational databases more) than I have ever done before... and I'm not sure where in the docs to be looking for examples. I have three tables... cd (id, title, etc) artist (id, name) cd_to_artist (cdid, artistid) In my CD

Re: UPDATE syntax dummy question...

On Tue, 2002-09-03 at 16:31, Matthias Trevarthan wrote: And here is my update query: update vbooth_data set optionText='Not at all, I'm waiting for the other shoe to drop' where (pollID='34' AND voteID='3'); When I hit Enter, it gives me this prompt: ' This prompt indicates you did

Re: Openssl and MySQL 4.0.3-Beta

At 12:44 -0400 9/3/02, Matthew Scarrow wrote: According to the documentation under section 4.3.9 to get openssl working with mysql you need to configure mysql with the --with-vio --with-openssl. When I add the as arguments to ./configure and then compile it I get a mysqld that will run but

Re: Openssl and MySQL 4.0.3-Beta

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 03 September 2002 18:44, Matthew Scarrow wrote: According to the documentation under section 4.3.9 to get openssl working with mysql you need to configure mysql with the --with-vio --with-openssl. That's correct. When I add the as

Re: InnoDB locks disappear

Wouter, - Original Message - From: Wouter Zelle [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, September 03, 2002 7:43 PM Subject: InnoDB locks disappear My program uses locks to allow for multi-threading (processing requests that are stored in the database using

Re: Fwd: Crash when adding field

Victoria Reznichenko writes: Hi! Indeed I could repeat it :( In addition, MySQL crushes if the table is not empty. Subscriber provide ALTER TABLE .. with a column name that already exists. So I modify test case a little to: CREATE TABLE `users` ( `ID` int(10) unsigned NOT NULL

Re: MySQL 4.0.3b Bind-Address Problem

At 14:25 03/09/02 -0400, Tam, Michael wrote: Hi, I just tried 4.0.3beta and it doesn't seem to address the bind-address problem at all. When I include the option in the ini file and run mysql-max-nt --help, it stops showing the variables when it reaches bind-address variable and a window

UDFs in Windows 2000

Hi Everyone: Can UDFs be written for Microsoft 2000? Many of the posts I read on the newsgroups contradict each other. It seems that support was added by a patch from Ralph Mason, but I can not be sure. I am using 3.23.52 and VC6. I was able to make a dll of the udf I wanted to add. I

crash

Hello ! Mysql 4.03 crash on my linux server... ./resolve_stack_dump -s /tmp/mysqld.sym -n mysql.stack 0x80c84fa handle_segfault__Fi + 450 0x13bae5 (?) 0x80f33bf create_myisam_tmp_table__FP8st_tableP15TMP_TABLE_PARAMUl + 355 0x80f31fe

Re: Install questions

On Tue, 2002-09-03 at 05:24, Victoria Reznichenko wrote: MTW I just installed MySQL from RPM and can connect to it via shell using MTW the MySQL command, but I can't get anything else to connect to it. MTW MySQL Connection Failed: Can't connect to local MySQL server through MTW socket

slow-queries.log vs. explain

I've been monitoring slow-queries.log to try and find querys that might be causing problems. I see the following logged: # Time: 020903 16:59:14 # User@Host: cfweb[cfweb] @ storm.centurytel.net [10.10.1.17] # Query_time: 47 Lock_time: 0 Rows_sent: 5 Rows_examined: 145240 SELECT

RE: Linker issues with 3.23.52 and solaris 7

Reconfiguring without the --with-mysqld-ldflags=-all-static switch resolved the issue. Any idea why the recommended configuration does not link properly in my case? Thanks, Christian - Christian Gilmore Technology Leader GeT WW Global Applications Development IBM Software Group

Linker issues with 3.23.52 and solaris 7

Hello. I'm attempting to install 3.23.52 on solaris 7 from source and am having issues with the linker not finding libraries in /usr/lib. I'd greatly appreciate any help as it seems this should be a non-issue. phantom% gcc -v Reading specs from

Re: Bitten by a strange bug...

Tom - I'll address what I can I had the same problem with fields being truncated on direct connections (the problem does not manifest on ODBC table attaches in Access). IIRC, the way to solve this problem is to make sure the optimize columns widths (option 1) in the ODBC properties.

Cross Database Table Join

I'm trying to do a cross database mysql query. Does anyone know of a way to do this? I've looked through all the documentation I can find including release 4.0. - Before posting, please check:

changing a slave to a master in mysql replication

Currently to make a slave a master, the docs say you need to set the bin-log option in my.cnf on the slave, and that will make the transition to master quicker. I know I can manually change a slave to a master by stopping the slave process, stop mysql, take a snapshot of the databases, copy

Ãâ·ÑÓòÃû£¬.com .net .orgÈÎÒâÑ¡Ôñ

http://www.indexcn.comÖйúÊ×Ò³--ΪÄú´òÔìÆóÒµÉÏÍøÊ×Ò³£¡ Ãâ·ÑÓòÃû£¬.com.net.orgÈÎÒâÑ¡Ôñ£¬ ÏÖÆð·²¹ºÂòÖйúÊ×Ò³¸÷¿îÐéÄâÖ÷»ú¾ùËÍÒ»¸ö¹ú¼ÊÓ¢ÎÄÓòÃû¼ÛÖµ100Ôª£¬¿ÉÖ§³Ö 20¸ö×ÓÓòÃû£¬URLת·¢£¬ÔÚÏßÐÞ¸ÄDNSµÈ¡£ 1.Ö»Òª350Ôª£¬¼´¿ÉÂíÉÏÓµÓÐ"Æóҵͨ"Ìײͣº ¸ßËÙÎȶ¨100MÐéÄâÖ÷»ú£¬ËÍ100MÆóÒµÓʾֿɿªÊ®¸öÓÊÏ䣬

Installing mysql in redhat linux 7.1

I have just installed redhat linux 7.1 and now need to install Mysql. with innodb support. I downloaded the rpm (3.23.51) from the mysql site and tried to install it. The process appeared to stop mysql and then complained it could not find a file: /etc/rc.d/mysql A query on rpm -qa | grep mysql

Re: Installing mysql in redhat linux 7.1

If this is the first time u r installing mysql, then, rpm -i mysql.rpm. If u r updating, then rpm -u mysqlxxx.rpm should do it. The binary install is more optimized and hence is the best way to install mysql, however, rpm's work fine too. Regards, Bhavin. - Original Message - From:

Re: changing a slave to a master in mysql replication

bin-log in 'needed' for a server to act as a master. This will make the server log all it's queries for the slave to follow. Don't know of a faster way. Regards, Bhavin. - Original Message - From: Vicky Gonzalez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002

Re: Bitten by a strange bug...

I had this problem to but was never able to find what was causing it. The way I got around it was by doing execute statements like: connection.execute(INSERT INTO .) That way I avoided VB handling the updates and it worked. But since Josh pointed this little problems solution out I might give

RE: changing a slave to a master in mysql replication

Bhavin Vyas wrote Tuesday, September 03, 2002 9:02 PM in response to: To: Vicky Gonzalez; [EMAIL PROTECTED] Subject: Re: changing a slave to a master in mysql replication bin-log in 'needed' for a server to act as a master. This will make the server log all it's queries for the slave to follow.

Help!! Extreme newbie

Being new to MYSQL as well as this list, I'm hoping you'll forgive what I'm sure will be a rather dumb question... I just installed mysql on a new install of SUSE 8.0 and every time I try to connect to the mysql server as a non root use I am denied access..have changed passwords, granted

Re: changing a slave to a master in mysql replication

As far I know, it would help to leave it set. All the queries executed by the slave to follow the master have the master's server id associated with them. The one's which don't have that id will be replicated by the new slave(old master), there by making the process easier and faster. Regards,

Re: Installing mysql in redhat linux 7.1

I use the 4.x branch for innodb support. Hrmm, did you download ALL the rpm's? the client, the server and libs i think. I suggest backup/dump your databases first before doing a reinstall. I also strongly suggest you install from the source so you can customize your installation of MySQL

Re: Help!! Extreme newbie

Pada Tue, 3 Sep 2002 21:40:44 -0400 Al Davis [EMAIL PROTECTED] menulis : Being new to MYSQL as well as this list, I'm hoping you'll forgive what I'm sure will be a rather dumb question... I just installed mysql on a new install of SUSE 8.0 and every time I try to connect to the mysql server

Re: Cross Database Table Join

Pada Tue, 3 Sep 2002 19:28:33 -0400 Bob Davis [EMAIL PROTECTED] menulis : I'm trying to do a cross database mysql query. Does anyone know of a way to do this? I've looked through all the documentation I can find including release 4.0. what kind of query do want to do ? shell mysql -p DB_A

Re: stored procedures and triggers

That's only if you access it directly from client. What I was talking about is AppServer sitting next to MySQL server. Preferably on the same computer. Agree that for some cascade actions triggers are very useful. But most of the folks just try to push all business logic into sp/triggers. And

row level locking .. urgent

Hi, I have did setup for MySQL - Innodb tables. But I am not getting support for row level locks. Whenever I am issuing a update the innodb tables are locking my tables. Please help me whether I need to set any variables in sqld file to get the support for row level locks ??? Regards, Sekhar

Re: row level locking .. urgent

On Wed, Sep 04, 2002 at 10:28:36AM +0530, Sekhar.Thota wrote: Hi, I have did setup for MySQL - Innodb tables. But I am not getting support for row level locks. Whenever I am issuing a update the innodb tables are locking my tables. Please help me whether I need to set any variables in sqld