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 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 wrote: > Hi Varuna, > > Sorry, I do not know the answer

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

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..) w

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

sqadmin -u root 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 ser

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!

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

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

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

if the row is locked. 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

olders do I have to include in setup and what do I have to exclude from 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

ur setup: - Queries per second avg: 117.236 - Generating over a 1GB of binlog entries per day. - Running with ~120 GB 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.guyda

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 @bindir@/mysqld

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

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 t

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), -> s

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 PR

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

rough the change logs for version 4, 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? Than

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

>I can't find anything in the error log, and I've set up the replication user 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

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

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

Replication error: 'Could not initialize master info'

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 troubleshoo

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 archive

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) http://lists.my

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: &

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 : skippi

installation issues in differnt versions

Hi, One of my new years resolutions was to spend some quality time Mysql. Yesterday I started installing it and I have some problems. I have downloaded two different packages 1. Mysql 4.0.8 for Freebsd: Is this actually a freebsd package that you need to install with pkg_add? I tried this

host table in mysql database

affected...? Just wanted some opinion/advice before I potentially get myself into trouble ;-) Thanks in advance, Guy. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

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 - Powerful.

Re: secure replication

s > there any 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

small bug in mysqlcheck

+ sprintf(query, "%s TABLE `%s` %s", op, tables, 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]

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 exp

mysock.sql problem

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 my

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.

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 wo

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 work

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 works

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 per o

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) http://lists.m

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") objconn.connectionstring="server=192.168.0.1;driver=

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,

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 t

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 to

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: Everything else works fine. When I enter the date into mysql itself it works fine. Thanks

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 --

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

Help: SIGSEGV inside mysql_connect to remote server

n? My feeling is that this is most likely something wrong with our C application. However, it calls ssConnectDB right near the beginning of main(), so there isn't much opportunity for memory errors. Thanks. -- Guy Davis Phone: (403) 301-3426 Pas

Help: SIGSEGV inside mysql_connect to remote server

n? My feeling is that this is most likely something wrong with our C application. However, it calls ssConnectDB right near the beginning of main(), so there isn't much opportunity for memory errors. Thanks. -- Guy Davishttp://www.guydavis.ca PGP: D2E2 76D4 0C9C 5D99 42AA EB

Creating a mysql database usinc VC++

Hello, I wondered if there is a way to create a mysql database using Visual C++ 6.0. I don't want the database to be registered, I want the program to create the database for me. Thanks a lot for your help. __ Do You Yahoo!? Yahoo! Tax Center - on

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?

2k/var/lib/mysql/nachos-slow.log 4.0k/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 ---

Rotation of binary logs on replication master?

Any 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:

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 confus

Re-baselining replication slaves?

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

Re: insert picture file in MySQL (+php)

(5) unsigned default NULL, `width` smallint(5) unsigned default NULL, `thumb_height` smallint(5) unsigned default NULL, `thumb_width` smallint(5) unsigned default NULL, `img_data` longblob, `category` smallint(5) unsigned default NULL, `access` enum('Public','Personal&#

ADO to MySQL interface?

er, and MS 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 S

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 P

Re: Linking problems

clude after all other included header 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 usi

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... MFC_e

Re: Compiling problem: error in type_info1.hh

7) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(340) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(345) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\vallist1.hh(56) : error C2872: '

Compiling problem: error in type_info1.hh

Hello, I have troubles compiling this program: #include #include #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 please. I would r

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.

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 data,

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 not

RE: Upgrade and start-up failures

: 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 > &q

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 my

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 my

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

ither safe_mysqld or mysql.server to start. Same symptoms. >Fix: Looking for fix. >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: se

Best way to duplicate a table in a running database?

o i haven't had to touch it much yet ;-) Thanks, Guy. -- Guy Waugh <[EMAIL PROTECTED]>, tel. 61+2 6620 3196 Unix Team, Information Technology Services Southern Cross University Military Rd, Lismore NSW 2480 Australia. -- --

Re: MyODBC and #Delete / almost resolved

Thanks to Apollo and Lee for fast responses. Both recommended adding TimeStamp columns to the table. Lee also recommended adding an auto_increment column. What actually was the culprit was that in the suspect tables, I had a Primary Key on a TinyText field. I have not tried (a) converting the

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 throu

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 PROTE