Re: InnoDB!!

> Is InnoDB table type support included in the 5.?.? version? Why shouldn't it? Make sure you start the right version of MySQL though. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -

mysql_server cannot auto-refresh...

Hi someone plz help me... I got a problem here with mysql I made a table with 4 fields in local comp then uploaded to my web-hosting... it's all fine 'till I added 1 field to my table so the table now have 5 fields... then uploaded to my web-hosting... but the problem is that the table just

Re: Create Table Syntax

Khashan wrote: **None of these are "table level" modifiers** Sorry, I guess I used the wrong terminology. I am aware of the table options available. What I meant is “additional definitions” after the columns have been defined. Sorry I misunderstood you. Now, do I understand that you are saying

Re: Create Table Syntax

**None of these are "table level" modifiers** Sorry, I guess I used the wrong terminology. I am aware of the table options available. What I meant is “additional definitions” after the columns have been defined. Now, do I understand that you are saying that a user can specify any of :

Re: Create Table Syntax

Khashan wrote: Thanks for the reply. It seems like the syntax for create_table/create_definition should have 2 part-2 modifiers I think you are misreading the syntax. That is, I think you are confusing the index-related create_definitions with the table_options. 1- one part-2 'column' modifi

test disregard

test -- = - Linux rocks!!! http://www.dedserius.com/ = -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

According to the error message, [EMAIL PROTECTED] has a password, but you aren't supplying it. Add -p to your commands to be prompted for the password. If you don't know the password, see "How to Reset The Root Password" in the manual. M

Re: Administrative limitation

On Fri, 2004-04-02 at 08:30, David Fleming wrote: > (newbie question) > > Our web host provides one (1) MySQL database for our account, and > phpmyadmin as the admin interface. We don't have privileges to create > a new database. We would like to install 2 or 3 unrelated applications > that will u

Slave behing nat firewall

Hi, I'm trying to set this up: Master (in DMZ) => Firewall (nat with port forward 3306 to slave) => Slave. Is that possible? Thanks, Ugo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Help:how can i connect mysql server with the server's IP but not localhost?

Hi, You are using sockets to connect to localhost but tcp/ip for the network interface. Check in my ini NOT to have skip-networking BIVOL - Original Message - From: wen heping To: [EMAIL PROTECTED] Sent: Saturday, April 03, 2004 4:19 AM Subject: Help:how can i connect mysql server with th

Help:how can i connect mysql server with the server's IP but not localhost?

Hi: Now i can use command: mysql -h localhost -u root -p connect to mysql server. But when i use command: mysql -h 127.0.0.1 -u root -p or: mysql -h 10.0.0.1 -u root -p (10.0.0.1 is the IP of mysql server) i failed,why? and how can do ? Thanks. __ Do you Yahoo!

RE: Handling threads

Yes it is, it shows the threads_created, threads_cached, threads_active, Do I need to check out another variable, Greetings and thanx in advanced From: Victor Pendleton <[EMAIL PROTECTED]> To: 'Mikel - ' <[EMAIL PROTECTED]>,Victor Pendleton <[EMAIL PROTECTED]>,"'[EMAIL PROTECTED] '" <[EMAIL PR

InnoDB!!

Is InnoDB table type support included in the 5.?.? version? Kirt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: FileMaker Pro compared to MySQL

I use FileMaker in a server-client configuration. Currently there are 5 clients connecting to one server instance of FileMaker. We have multiple databases being served, from contacts to truckloads to mileages to costs. We cover about 40 loads a day and every load has a plethora of information liste

Re: innodb_buffer_pool_size limit

In the last episode (Apr 02), Dathan Vance Pattishall said: > > -Original Message- > > From: Keith Thompson [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, March 23, 2004 12:46 PM > > To: [EMAIL PROTECTED] > > Subject: innodb_buffer_pool_size limit > > > > Is there a limit on what innodb_buff

RE: innodb_buffer_pool_size limit

Try setting it to 4096M -- DVP > -Original Message- > From: Keith Thompson [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 23, 2004 12:46 PM > To: [EMAIL PROTECTED] > Subject: innodb_buffer_pool_size limit > > Is there a limit on what innodb_buffer_pool_size can be set in 4.0.17 > (64-bi

RE: Weird Error message

Rhino, thanks for taking the time to look at this I'm running on Redhat 7.3 on a HP DL380 G3, Mysql 4.0.14 I've noticed it in the mysql.err log. My guess is that it's a query to one of our Search result tables -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: Thursday, Apri

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Hi,When i run mysql,mysqlshow,mysqladmin & etc from mysql command,I receive following error: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) I have RH9. Please guide me. Yours,Mohsen. = -DIGITAL SIGNATURE--- ///Mohsen Pahlevanzadeh/

Re: MySQL and Ms Access - a better description of the problem

Daniel Kasak wrote: Patrick Kirk wrote: [...] CREATE TABLE `tblContacts` ( `p_ID` bigint(11) NOT NULL auto_increment, That's your problem there. You can't have a bigint() column as a primary key when Access is being used. In fact you probably shouldn't have any bigints at all if you're usi

Re: Truncating long numbers

Yes your right - I thought the numbers in the DB were something else. __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ On Apr 2, 2004, at 11:11 AM, Paul DuBois wrote: At 1

Re: Truncating long numbers

At 10:44 -0600 4/2/04, Craig Hoffman wrote: Hi there, I have this query (see below) SELECT SUM(distance + date), DATE_FORMAT(time_upload, '%M') FROM traininglog_client, users WHERE username='$username' AND DATE_SUB(CURDATE(),INTERVAL 1 MONTH) <= time_upload AND users.user_id = traininglog_client

innodb_buffer_pool_size limit

Is there a limit on what innodb_buffer_pool_size can be set in 4.0.17 (64-bit Solaris 9)? I tried setting it to 4G in my.cnf and SHOW VARIABLES says it's 0. -keith -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PR

md5 and table field types

hi... what would be the best field type and length for an md5 encrypted password sort of thing??

Re: MySQL and Ms Access - a better description of the problem

Patrick Kirk wrote: Hi all, I've installed the latest MDAC and Jet service packs on Windows 2000. On Linux I've the latest MySQL and MyODBC3.51. Using the ODBC Administrator I've set up a connection and made sure to check "Don't Optimize columns width", "Return Matching Rows", "Allow BIG Resu

Truncating long numbers

Hi there, I have this query (see below) SELECT SUM(distance + date), DATE_FORMAT(time_upload, '%M') FROM traininglog_client, users WHERE username='$username' AND DATE_SUB(CURDATE(),INTERVAL 1 MONTH) <= time_upload AND users.user_id = traininglog_client.user_id GROUP BY username and it returns t

RE: Handling threads

You say you have a monitor that is logging active connections. Is this monitor reporting that all available connections are used? -Original Message- From: Mikel - To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: 4/2/04 10:29 AM Subject: Re: Handling threads Yes I can ping my server, the ser

Re: Handling threads

Yes I can ping my server, the server still alive, I have a monitor that displays all the active connections, the hostname.err file doesn't log new lines, do I have to check out something else?... Thanks in advance Mikel From: Victor Pendleton <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To

Re: Backup/Restore Procedures

I would strongly recommend proving that your solution will work acceptably by testing it first; don't just assume that all will go well or that we can anticipate all the problems sight unseen. Make small test copies of your databases first and then try doing backups and restores to verify that you

Backup/Restore Procedures

Hi List, I use 3 databases Current, Persistent-1 and Persistent-2. I would like to take backups of Current as when and required and restore them as desired without affecting Persistent-1 and Persistent-2. Initially thought of using mysqldump for this, but was worried about the performance (I u

[Stats] MySQL List: March 2004

-- Searchable archives for this list are available at -- ==

Re: mysql 2 nics forward to bound ipaddress

Frank Singleton wrote: Hi, If I start mysql bound to a particular address on our server, eg: mysqld --bind-address=MY_IP_ADDRESS and this server has 2 nics connected via 2 switches. If the first NIC or switch fails, can I use iptables to forward incoming mysql requests from the 2nd (alive) n

RE: Administrative limitation

Yes. Or find a host that will give you ability for multiple databases. HTH Aaron > -Original Message- > From: David Fleming [mailto:[EMAIL PROTECTED] > Sent: April 2, 2004 10:30 AM > To: [EMAIL PROTECTED] > Subject: Administrative limitation > > (newbie question) > > Our web host prov

Administrative limitation

(newbie question) Our web host provides one (1) MySQL database for our account, and phpmyadmin as the admin interface. We don't have privileges to create a new database. We would like to install 2 or 3 unrelated applications that will utilize the database (forum, image gallery, product catalog).

MySQL and Ms Access - a better description of the problem

Hi all, I've installed the latest MDAC and Jet service packs on Windows 2000. On Linux I've the latest MySQL and MyODBC3.51. Using the ODBC Administrator I've set up a connection and made sure to check "Don't Optimize columns width", "Return Matching Rows", "Allow BIG Results", "Use Compressed

OpenBSD 3.4 Sparc64 trouble

Greetings, I've newly installed mysql 4.1 (alpha) and then back to 4.0.18 and having some trouble. After compiled and installed I start it with mysqld_safe. I then am able to access my 2 databases. I have a homebrewed database for a BBS and then a stock phpBB database. If I connect to my BBS s

Re: Product link that goes to hard core porn site

Yesmy apologies...the OP made it seems like the main page. i didn't go hunting..but i guess i should have gerald_clark

Re: Product link that goes to hard core porn site

Yes they do. Click on the "Publishers site" for the "MS Access to Mysql Conversion Utility", and you will be sent to the porno site. [EMAIL PROTECTED] wrote: No they don'tyour machine may be infected...I'd run a scan. or download some malware fixers (adaware/spybot) Jeff http://www.mysql.

Re: Product link that goes to hard core porn site

[EMAIL PROTECTED] wrote: No they don'tyour machine may be infected...I'd run a scan. or download some malware fixers (adaware/spybot) Yes, they do :-) Check the second link under "Publisher's site" : http://www.customfittech.com/ - Cs. -- MySQL General Mailing List For list archives: ht

Re: Product link that goes to hard core porn site

No they don'tyour machine may be infected...I'd run a scan. or download some malware fixers (adaware/spybot) Jeff http://www.mysql.com/portal/software/convertors/index-2.html http://www.mysql.com/portal/software/item-266.html Regards Richard -- MySQL General Mailing List For list archiv

Product link that goes to hard core porn site

http://www.mysql.com/portal/software/convertors/index-2.html http://www.mysql.com/portal/software/item-266.html Regards Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replication between different database names

Andy Ford <[EMAIL PROTECTED]> wrote: > I guess what I'm trying to ask is . > is it possible for a MySQL server to be a slave to many MySQL masters? > One slave can have only one master. But you can run multiple instances of MySQL on the slave. -- For technical support contracts, goto h

Re: query-cavhe questions revisited

"Mark" <[EMAIL PROTECTED]> wrote: > I recently just upgraded to MySQL 4.0.18. I still have a few questions about > the new query-cache. Since I am new to the query-cache, I really hope > someone has some answers. > > The documentation says: > > "The FLUSH TABLES statement also flushes the query c

RE: How do I determine the row number or key when table has no keyfields

The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments, which must be integer constants. With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the maximum numb

RE: How do I determine the row number or key when table has no key fields

I thought LIMIT limited you to N number of CONCURRENT record. ie. limit 10 or limit 20 I believe Ross would like to select select 1000 records and then do a sub select of records 1-20 and then 21-40 on this record set Or am I barking up the wrong tree? Andy On Fri, 2004-04-02 at 14:05, Andy Eas

RE: How do I determine the row number or key when table has no key fields

Ross, You'll need to do an order by on both columns (so you'll need to index both columns in a compound index), then use the LIMIT keyword which is designed for exactly this job. Alternatively, unload the data using mysqldump, then edit the table definition to have an autoincrement column, then r

Re: Replication between different database names

I guess what I'm trying to ask is . is it possible for a MySQL server to be a slave to many MySQL masters? And can all of this information go into one my.cnf file so on startup the masters will all start syncing their data to the one slave Thanks Andy On Fri, 2004-04-02 at 12:49,

table dumps and md5

Hi, Is it totally possible that when dumping a db to a text file with mysqldump that any encrypted stuff in the tables will be "lost"? when I mean lost I mean that it isnt the same in a text file as it is when it was originally encrypted. I have a problem with creating a table with encrypted p

Re: How do I determine the row number or key when table has no key

Take a look at LIMIT in the Manual Cheers Terry --Original Message- > eg. say a table is created using: > > create table fred (f1 char(10), f2 int) > > Then it has neither keys nor an AUTO_INCREMENT field. > > Let's say 1000,000 records are then inserted into table fred

How do I determine the row number or key when table has no key fields

eg. say a table is created using: create table fred (f1 char(10), f2 int) Then it has neither keys nor an AUTO_INCREMENT field. Let's say 1000,000 records are then inserted into table fred. I then say 'select * from fred' and loop through results writing to a web page. I stop writing to th

Re: Renaming an index

"Chad Attermann" <[EMAIL PROTECTED]> wrote: > Hello, > > Through some strange quirk in my MySQL console application (an older version of > PHPMyAdmin), 4 indexes that I created on different columns of a table all resulted > in indexes with the same keyname, that of the first column that was index

Re: Replication between different database names

I've no idea!! My apologies for the blank response I am rather new to replication and still trying to discover what I actually need to do. I have managed to get two databases with the same name across two different servers replicating correctly. When I change the name on the slave however, re

Re: Replication between different database names

Hello, Is this what you are lookin for? --replicate-rewrite-db=from_name->to_name Regards /Jonas > I have a central mysql server that is required to be a slave to many > different master databases on my customer sites. > > Is it possible to replicate many masters to one slave where the masters

Replication between different database names

I have a central mysql server that is required to be a slave to many different master databases on my customer sites. Is it possible to replicate many masters to one slave where the masters have the same DB name?? i.e. do this . customer A central site DB = cu

installed path with RPM

Hi : I install mysql My-SQL-server-4.0.18-0.i386.rpm in my RedHat 7.3 with following cmd : rpm -iv My-SQL-server-4.0.18-0.i386.rpm, But I can not find the path mySQL installed . Where is it ?

Re: Download

Shrikrishna Sathe <[EMAIL PROTECTED]> wrote: > > Hello, > which mySql version is having Views, Procedures & Functions functionality. I think > the version 4 is not having this. > > Stored Procedures are supported from version 5.0. VIEWs are currently being implemented. They will appear in 5.0

Re: group by & order by rand() problem

Alle 21:57, giovedì 1 aprile 2004, Michael Stassen ha scritto: > You could probably accomplish this with a variant of the MAX-CONCAT > trick > . > Something like: > >SELECT user_id, > SUBSTRING(MAX(CONCAT(TRUNCATE(RAND

Re: Download

Hi, > which mySql version is having Views, Procedures & Functions functionality. I think the version 4 is not having this. Version 5 is will have Stored Procedures and Stored Functions. However, it isn't ready yet - only a very early Alpha version has been released. Triggers are supposed to be a

Download

Hello, which mySql version is having Views, Procedures & Functions functionality. I think the version 4 is not having this. Thanks & Regards Shrikrishna

Re: 5.0 InnoDB problem - ADD CONSTRAINT

"Matt Chatterley" <[EMAIL PROTECTED]> wrote: > Hi folks. I have a problem creating a foreign key constraint which I just > don't seem to be able to figure out. > > There are three tables, for which the 'show create' output is given below: > > CREATE TABLE `users` ( > `UserID` int(11) unsigned NO

Re: Calculation in a mysql column

"Mike R" <[EMAIL PROTECTED]> wrote: > > I am using mysql 4.0.16. > > Is it possible to put a calculation of two other columns as the default > value for a third column? > > Like: > > time = decimal 3,2 > rate = decimal 3,2 > totals = default is time * rate No. Default values must be constant.