Re: Auto Reply: How can I obtain the corrosponding Signature file for a MySQL package to verify package Intergrity Using GnuPG?

Hi Varuna, the signature file links have been put back on the web site. Can you please try again? Thanks On 12/2/2010 5:57 PM, Brian Guy wrote: Sorry Varuna, I received your email with no context and incorrectly assumed you were one of our consulting customers (I work in our consulting team

Re: Auto Reply: How can I obtain the corrosponding Signature file for a MySQL package to verify package Intergrity Using GnuPG?

2, 2010, at 3:53 PM, Varuna Seneviratna varunasenevira...@gmail.com wrote: Hello Brian! What do you mean!, Who do u intend by account manager.I am using community server 5.1 On 3 December 2010 02:30, Brian Guy brian@oracle.com wrote: Hi Varuna, Sorry, I do not know the answer

LEFT JOIN problem

I have the following tables: languages language_id int, language_title varchar(80) objects object_id int object_language_id int object_title varchar(100) I want to select ALL available languages, and match the translated object (if it is exists) for a specific object_id. If it does not exists

compound foreign key(s)

I have the following innoDb tables: country has `id` as PK lang has `id` as PK I want to have a 3rd innoDb table: countrylang with `cid,lang` as compound key with both `cid` and `lang` as foreign (cascade-delete) keys to the master tables. However mysql throws error (Cannot create table..)

re: SQL Dump

Hello, I am new to mySQL. Someone gave me a dump file and i need to do an import from linux. How can i go about doing this can someone help me? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Rank beginnner - very basic question

password my_password - I know of few basics and that's it. And it does work fine - I just don't want to pass out the root account password to people to let them have access for a messageboard or whatever... Thanks Guy Merritt

Possible drawbacks of suggested mysql install?

Hi there, I would like to know some professional opinions on the following: -Are there any drawbacks on installing Mysql on a windows server? Would it be possible to install it on the same server that hosts SQL server? Can they coexist properly? I do not expect too much usage of the Mysql

RE: Specs for a dedicated MySQL server

This looks like a flash server. I am not sure if we will have enough Mysql use to justify this. Does anyone have an idea for what kind of use (amount of db etc) that I would use this kind of server? Guy -Original Message- From: Gabriel Ricard [mailto:[EMAIL PROTECTED] Sent: Tuesday, 9

RE: Specs for a dedicated MySQL server

There is one server that we have and that I can possible use Dual Pentium 1.2 ghz CPU 1 gig of Ram 18 gb SCSI 0+1 Raid What performance can I expect from this machine. What usage would it be able to handle? cheers -Original Message- From: Defryn, Guy Sent: Tuesday, 9 December 2003 9

Disk Configuration

I have another question regarding specs for a server. I have talked to a DBA who has no mySQL knowledge but did work with Oracle, etc He said I should do some more investigation on disk configuration and how mysql benefits from Separating log files, data files, etc. All feedback welcome!

Specs for a dedicated MySQL server

License do I need? Basically we are an ISP for our departments Cheers GUY

Reliability of _rowid over multiple database accesses

. In particular, can I perform a select on a row which returns a _rowid, modify the row data, and later do an UPDATE using the _rowid as index, without worrying that the _rowid has changed? Any help will be much appreciated. Guy L. Smith Lead Developer [EMAIL PROTECTED]

Mysql embeded

setup. Thanks for answers Guy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: distributed database architecture for a large database

of live data now (used to be 200+ but we have an archival scheme now) Not sure how this compares to your situation. -- Guy Davis http://www.guydavis.caCalgary, Alberta, Canada -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Apache/PHP question

I have set apache 2.0 and PHP 4.3.1 as well as mysql. I was wondering how I can disable PHP per user directory?. At the moment everyone can put php scripts on their personal website. I want to limit it to a few users. Cheers Sql,query

startup and install issues

I have installed 4.0.9 from source. After compiling it I want to start it with /usr/local/mysql/bin/mysqld_safe --user=mysql and the message mysqld ended appears. When I move the startup script to the appropriate directory and reboot I get the following error Can't execute

Auto-completion

Is auto completion a feature that only works in Mysql4? Cheers Sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

RE: RE: Auto-completion

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 February 2003 11:03 a.m. To: Defryn, Guy Subject: Re: RE: Auto-completion Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter

Is it my English or does this sound bad?

I was just reading through the Mysql manual section 3.32 And came across a sentence that started like this Animal sex can be represented in a variety of ways My mother tongue is not English but doesn't it sound rude ? :-) mysql CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), -

Re: 'mysqladmin slave-st(art|op)' - is it implemented?

Hello again, Turns out it is implemented - but it's 'stop-slave' and 'start-slave'. Shoulda done a 'mysqladmin --help'. Grepping the source found it. - GW. Date: Wed, 29 Jan 2003 11:19:06 +1100 To: [EMAIL PROTECTED] From: Guy Waugh [EMAIL PROTECTED] Subject: 'mysqladmin slave-st(art|op

'mysqladmin slave-st(art|op)' - is it implemented?

, and can't find any mention of them in there... Can anyone tell me whether these options for mysqladmin are implemented? If not, can anyone tell me whether I can tell mysqld to stop or start replicating from a shell script rather than the mysql client? Thanks in advance, Guy. -- Guy Waugh Unix

Re: Replication error: 'Could not initialize master info'

on the master as outlined in the manual. Both master and slave are currently using databases with ISAM tables rather than MyISAM tables (although the 'mysql' database is, of course, MyISAM). I'm not using InnoDB tables. Can anyone give me an idea of how to troubleshoot this one? Thanks, Guy

Mod_Auth_MySQL for Apache 2 and Windows?

-2.0/win32/modules/ but it only crashes the Apache server. (Other people have had the same problem with this version as well.) -- Guy Davis Phone: (403) 301-3426 Fax: (403) 301-3499 Pason Systems Calgary, AlbertaCanada Digitally signed by GnuPG (DSA ID 759A998E

Mod_Auth_MySQL for Apache 2 and Windows?

-2.0/win32/modules/ but it only crashes the Apache server. (Other people have had the same problem with this version as well.) -- Guy Davis http://www.guydavis.caCalgary, Alberta, Canada Digitally signed by GnuPG (DSA ID 30D52F0B at www.keyserver.net) PGP Fingerprint: 8DC8 4A6F C1AD

Detecting Mysql servers on the network

Is it possible to detect mysql servers on the network without knowing the hostname? cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Replication error: 'Could not initialize master info'

in the manual. Both master and slave are currently using databases with ISAM tables rather than MyISAM tables (although the 'mysql' database is, of course, MyISAM). I'm not using InnoDB tables. Can anyone give me an idea of how to troubleshoot this one? Thanks, Guy. -- Guy Waugh Unix Team

data directory in 4.0.9

Where does mysql places the databases in 4.0.9 when installing from source? The var directory does not seem to be there anymore - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Unable to install 4.08 or 4.09

I have tried to install mysql 4.0.8 and 4.0.9 and I get the following error After running gunzip mysql-4.0.9-gamma.tar.gz (source install) Mysql-4.0.9-gamma/bdb/ Mysql-4.0.9-gamma/bdb/db/ Mysql-4.0.9-gamma/bdb/db/db_upg.c Mysql-4.0.9-gamma/bdb/db/db.c Mysql-4.0.9-gamma/bdb/db/tags Tar :

RE: Unable to install 4.08 or 4.09

Thanks Paul, It's working now. cheers -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 14 January 2003 3:41 p.m. To: Defryn, Guy; '[EMAIL PROTECTED]' Subject: Re: Unable to install 4.08 or 4.09 At 15:31 +1300 1/14/03, Defryn, Guy wrote: I have tried

host table in mysql database

in advance, Guy. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL

Mysql.sock gets deleated

I installed mysql from rpm package on redhat linux 8.0 and it works fine, but next time i reboot the machine /var/lib/mysql.sock gets deleated and mysql stops working PLEASE HELP ITS URGENT.. __ Do you Yahoo!? Yahoo! Mail Plus -

Re: secure replication

way to encrypt replication communcations between these mysql servers internally so i don't need to set up a vpn or ssl tunnel? thanks all. Setting this up with SSH is quite easy. I have a How-To on it at: http://www.guydavis.ca/projects/oss/docs/ssh_mysql.jsp -- Guy Davis http

small bug in mysqlcheck

, options); if (mysql_query(sock, query)) { sprintf(message, when executing '%s TABLE ... %s, op, options); HTH. Guy -- http://www.uadm.com | Local and Remote Unix/Linux [EMAIL PROTECTED] | Administration. No outsourcing. Phone: +972 3 6201373

Vaibhav Difference between amount null and amount is not null

What is the difference between the following sql queries written to extract tuples with the field amount having non null value: select loan_number from loan where amount null (It returns an empty set) select loan_number from loan where amount is not null(It returns the expected

mysock.sql problem

the mysql server and restart but it refuses to work. It is still looking in the /tmp directory What am I doing wrong? Could this be a permission thing on the sock file? What permissions does this file need? Cheers Guy Sql

Problem with LOAD LOCAL DATA INFILE

I am using MySQL version 3.23.11-alpha on Win98. I have created a database with a table borrower whose description is as follow: mysql describe borrower; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra |

Another one on lost connections( using web interface)

I also have a problem with lost connections. I have small mysql database (version 3.23.49 on FreeBSD 4.5) I have created a website interface to enter and retrieve data. I used ASP to do this. Sometimes when I go to the website I get the error can't connect or lost connection to server. The

Lost connection to mysql server

I have a build an ASP page to enter data in a mysql database. When I open the page I get the following error : Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [TCX][MyODBC]Lost connection to MySQL server during query /centraladmin/products.asp, line 88 When I refresh it

Lost connection to mysql server

I have a build an ASP page to enter data in a mysql database. When I open the page I get the following error : Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [TCX][MyODBC]Lost connection to MySQL server during query /centraladmin/products.asp, line 88 When I refresh it

Lost connection to mysql server

I have a build an ASP page to enter data in a mysql database. When I open the page I get the following error : Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [TCX][MyODBC]Lost connection to MySQL server during query /centraladmin/products.asp, line 88 When I refresh it

RE: Joins, ANSI 92 or the old way

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 17 July 2002 1:59 p.m. To: Defryn, Guy Subject: Re: Joins, ANSI 92 or the old way Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass

Calculations in mysql

Hi there, I am creating a tracking system for the consumables we give away to our staff. It is working but I need to know if there is a better practice than I what I did I need to print reports via a website so I used ASP It needs name,product, amount per item, price per item and total per

Calculations in mysql

Hi there, I am creating a tracking system for the consumables we give away to our staff. It is working but I need to know if there is a better practice than I what I did I need to print reports via a website so I used ASP It needs name,product, amount per item, price per item and total

Mysql certification

I was wondering if anybody heard about a possible release of books that help you prepare for the Mysql certification? Cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Join problem in MYSQL

sql,query Can anyone have a look at my join. It returns errors Select O.name, O.amount , P.Productname, P.price From Orders AS O JOIN Products AS P ON O.product=P.Productid Where O.cluster= 'ANP'; It works fine when I use Select O.Name, O.amount, P.productname , P.price From Orders as O,

RE: find record using MYSQL command in ASP

Hi there, Try this % dim objconn, objrs dim sqltxt, criteriatxt, adopenkeyset, adlockoptimistic adopenkeyset=1 adlockoptimistic=3 set objconn = server.createobject(adodb.connection) set objrs = server.createobject(adodb.recordset)

Insert with ASP into mysql

Hi there, I want to insert data in a mysql database. When I submit I don't get any errors. It takes me to the page that processes everything However, when I check the database the records are not there. Selecting data from the website works fine. My code is below but I don't think anything is

Setting up a mysql server for the web

I hope someone can tell me a bit more on how to integrate a MYSQL server with a windows network. I have a web server that is running IIS5. The internet user account is IUSR_Machinename. I do not want to run the database on the web server. When I tried this with Access it did not work because

insert into multiple tables??

Is it possible to insert data into different tables with one insert statement. For example , I have one form on my web page and the data needs to go into different tables( first 5 entries to table A and the rest to table B)? Mysql

Insert dates with PHP

I am working with PHP for the first time and I need a form To insert some details and a date. When I check the mysql database the date is displayed as -00-00 Here is my php script: ? $query = Insert into computers(id,itnumber,hdd,processor,ram,monitor,os,invoice,datebought) values .

Re: Insert dates with PHP

I did forget to mention that I was using that format. So it must be something else?? Guy -Original Message- From: Uma Shankari T. [mailto:[EMAIL PROTECTED]] Sent: Thursday, 16 May 2002 4:09 p.m. To: Defryn, Guy Cc: [EMAIL PROTECTED] Subject: Re: Insert dates with PHP you have

Re: Help: SIGSEGV inside mysql_connect to remote server

On Thu, 2002-05-02 at 00:38, Jeremy Zawodny wrote: On Wed, May 01, 2002 at 04:24:05PM -0600, Guy Davis wrote: I am having a really strange problem with a in-house C application that calls mysql_connect() and generates a segfault deep within uname() when I configure it to contact a remote

Help: SIGSEGV inside mysql_connect to remote server

right near the beginning of main(), so there isn't much opportunity for memory errors. Thanks. -- Guy Davis Phone: (403) 301-3426 Pason Systems Fax: (403) 301-3499 PGP: 65BA 484B 0B96 5F3B 4D40 DCA2 B2AE 6B5A F52B 1445

Creating MySQL database using DAO

are created while we create a new database and what they contain? Thank you very much for your help. Guy-Maurice __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com

Re: Rotation of binary logs on replication master?

/var/lib/mysql/nachos.us.pason.com.pid -- Guy Davis Phone: (403) 301-3426 Pason Systems Fax: (403) 301-3499 PGP: 65BA 484B 0B96 5F3B 4D40 DCA2 B2AE 6B5A F52B 1445 - Before posting, please check

Rotation of binary logs on replication master?

tips? Thanks. -- Guy Davis Phone: (403) 301-3426 Pason Systems Fax: (403) 301-3499 PGP: 65BA 484B 0B96 5F3B 4D40 DCA2 B2AE 6B5A F52B 1445 - Before posting, please check: http

Problem with using INSERT INTO [table] SQL string

Hi all, Please excuse any ignorance I may show with this question - as I am not a programmer and I am trying to do something that is out of my experience. I feel truly out of my element in this and am hoping that the list expertise will help me. I have looked at the manual - but still am

Re-baselining replication slaves?

there that have been replicating for a year plus with no troubles? Thanks. -- Guy Davis Phone: (403) 301-3426 Pason Systems Fax: (403) 301-3499 PGP: 65BA 484B 0B96 5F3B 4D40 DCA2 B2AE 6B5A F52B 1445

Re: Running Without TCP Port

On Fri, 2002-02-22 at 11:09, havoc wrote: Is it possible to run mysqld without binding to a TCP port? As in run using only unix sockets? Start with --skip-networking: http://www.mysql.com/doc/C/o/Command-line_options.html or put skip-networking into your my.cnf file. -- Guy Davis

Re: insert picture file in MySQL (+php)

) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM I don't see why you shouldn't be able to do something similar in PHP. Hope this helps. -- Guy Davis Phone: (403) 301-3426 Pason Systems Fax: (403) 301-3499 PGP: 65BA 484B 0B96 5F3B 4D40 DCA2 B2AE 6B5A F52B 1445

ADO to MySQL interface?

Access. I'm wondering if there is an ADO adapter out there that will work with MySQL. I know of the ODBC connector, but I'm told ADO replaces ODBC(?). If possible we'd like to stick with MySQL, rather than paying large licensing fees for either Oracle or SQL Server. -- Guy Davis

Possible Index problem?

I am using mysql verison 3.23.41-nt I am working with the following two tables. mysql show create table table1; | Table | Create Table - | table1 | CREATE TABLE `table1` ( `Column1` varchar(63) NOT NULL default '', `Column2` varchar(31) default NULL

Re: Linking problems

files (especially those of MFC) 4) If errors occur, see the Problems section Thanks a lot for your help --- Sinisa Milivojevic [EMAIL PROTECTED] wrote: Guy-Maurice Lepoutre writes: Hello, I am using Visual C++ 6.0 and I have some linking problems while trying to run the example program

Re: Linking problems

Hello, I am using Visual C++ 6.0 and I have some linking problems while trying to run the example program MFC_ex.cpp included in the downloading files in the mysql.com website. Here are the errors I get: Configuration: MFC_ex - Win32 Debug Linking...

Re: Compiling problem: error in type_info1.hh

symbol c:\sqlplus\include\set3.hh(23) : error C2872: 'ostream' : ambiguous symbol Error executing cl.exe. prog.obj - 98 error(s), 6 warning(s) --- Sinisa Milivojevic [EMAIL PROTECTED] wrote: Guy-Maurice Lepoutre writes: Hello, I have troubles compiling this program: #include

Compiling problem: error in type_info1.hh

Hello, I have troubles compiling this program: #include iostream.h #include iomanip.h #include c:/sqlplus/sqlplus.hh int main() {return(0);} As you can see, the program itself isn't very complicated. When I run this program (using MS Visual C++), here are the errors I get. Can anybody help me

relationships between databases

This is my first post to the list What is the best way of making a relationship between tables in Mysql. Do you set it up when you are creating the tables or is it done with the insert statement I am a newbie to Mysql, BTW Guy

downloaded file problem

hi, I have download manual-split.tar.gz and couldn't open it (from www.mysql.com). tried with winzip but had the following error: Invalid Compressed Data - unable to inflate which program should I use? why not Zipping the files? Guy.

Replication and redirection

OS: RedHat 6.2 on master and slave mySQL:3.23.32 on master and slave Problem: Replication is not working. Symptoms include: * Connecting OK. 'Show slave status' reports nominally. * Position on the log file increments correctly when updates occur on the master. * The tables do

RE: aggravating failure symptoms and steps to remedy them...

Not sure I'll be helpful, but I ran into something similar yesterday. Not exactly sure how I fixed it, but this is what I believe. 1) You should create a virgin data directory per the standard procedures on the production machine (install_db and safe_mysqld). 2) Then, if you have existing

Start fails after upgrade to 3.23.32 - no host.ISM file

. Same symptoms. Fix: Looking for fix. Submitter-Id: submitter ID Originator:Guy Smith Organization: FundTheCause, Inc. MySQL support: none Synopsis: Start fails after upgrade to 3.23.32 - no host.ISM file Severity: serious Priority: medium Category: mysql Class

Upgrade and start-up failures

I just upgraded from 3.23.27 to 3.23.32 (can't go higher than that - have to sync development with production systems). I copied the /data directory to the new home. When I try to start mySQL, it halts and the log file has the entry Can't find file: 'host.ISM' (errno: 2). I checked the old

Upgrade and start-up failures

I just upgraded from 3.23.27 to 3.23.32 (can't go higher than that - have to sync development with production systems). I copied the /data directory to the new home. When I try to start mySQL, it halts and the log file has the entry Can't find file: 'host.ISM' (errno: 2). I checked the old

RE: Upgrade and start-up failures

It's looking for the host table (physical files) within the 'mysql' data area (not your own data area). Did you run mysql_install_db after installing the new version ? (or copy the mysql subdirectory from the old version) Guy Smith wrote: I just upgraded from 3.23.27 to 3.23.32 (can't

MyODBC and #Delete

OS: NT 4.0, SP6 MDAC: 2.6 MyODBC: 2.50.36 MS-Access: 2000 (9.0.3821 SR-1) MySQL-OS: Linux, RedHat 6.2 MySql: 3.23.27-beta Symptom: Two of seven tables return all columns and rows as "#Deleted" (and wouldn't you know it, the two most important tables in the database). have been

Re: mm.mysql.jdbc-1.2c and applets

Signing the applet will allow the applet to make the connection. The user of the applet will have to accept and install the certificate use to sign the applet. - Original Message - From: "Carfield Yim" [EMAIL PROTECTED] To: "Paulo Mora de Freitas" [EMAIL PROTECTED] Cc: [EMAIL