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). I have sent your question to our web site team, as I similarly do not see the signature files. Sorry for the confusion. Thanks, Brian On Dec 2, 2010, at 3:53 PM, Varuna Seneviratna varunasenevira...@gmail.com mailto: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 mailto:brian@oracle.com wrote: Hi Varuna, Sorry, I do not know the answer to this. Who is your account manager, and I can ask him/her to find out for you? If you do not know your account manager, please let me know your company name and location, and we can find out who your account manager is. Thanks, Brian Oracle http://www.oracle.com/ Brian Guy | MySQL Consulting Practice Manager, Americas OracleMySQL Seattle, Washington USA Green Oracle http://www.oracle.com/commitment Oracle is committed to developing practices and products that help protect the environment On Dec 2, 2010, at 6:12 AM, Varuna Seneviratna wrote: Hi Brian I am contacting you according the mail I got from Brian Miezejewski I suppose, As you can see from the below reply I got after posting to the mailing list.My question is described below According to the Doc http://dev.mysql.com/doc/refman/5.1/en/checking-gpg-signature.html the Signature file for a MySQL package can be obtained from the download page.But I am not able to locate it? -- Forwarded message -- From: brian.miezejew...@oracle.com mailto:brian.miezejew...@oracle.com Date: 2 December 2010 19:34 Subject: Auto Reply: How can I obtain the corrosponding Signature file for a MySQL package to verify package Intergrity Using GnuPG? To: varuna.senevira...@gmail.com mailto:varuna.senevira...@gmail.com Hi, I am on Medical Leave. Please contact Brian Guy at brian@oracle.com mailto:brian@oracle.com in my absense. Cheers, Brian -- Kind Regards Varuna Seneviratna -- Kind Regards Varuna Seneviratna
Re: Auto Reply: How can I obtain the corrosponding Signature file for a MySQL package to verify package Intergrity Using GnuPG?
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). I have sent your question to our web site team, as I similarly do not see the signature files. Sorry for the confusion. Thanks, Brian On Dec 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 to this. Who is your account manager, and I can ask him/her to find out for you? If you do not know your account manager, please let me know your company name and location, and we can find out who your account manager is. Thanks, Brian Brian Guy | MySQL Consulting Practice Manager, Americas Oracle MySQL Seattle, Washington USA Oracle is committed to developing practices and products that help protect the environment On Dec 2, 2010, at 6:12 AM, Varuna Seneviratna wrote: Hi Brian I am contacting you according the mail I got from Brian Miezejewski I suppose, As you can see from the below reply I got after posting to the mailing list.My question is described below According to the Doc http://dev.mysql.com/doc/refman/5.1/en/checking-gpg-signature.html the Signature file for a MySQL package can be obtained from the download page.But I am not able to locate it? -- Forwarded message -- From: brian.miezejew...@oracle.com Date: 2 December 2010 19:34 Subject: Auto Reply: How can I obtain the corrosponding Signature file for a MySQL package to verify package Intergrity Using GnuPG? To: varuna.senevira...@gmail.com Hi, I am on Medical Leave. Please contact Brian Guy at brian@oracle.com in my absense. Cheers, Brian -- Kind Regards Varuna Seneviratna -- Kind Regards Varuna Seneviratna
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 for that specific language_id, I want to have NULL. Because I'm using mysql 4.0, no subqueries allowed. Is there any way to rewrite the following? SELECT language_id, language_title, (SELECT object_title FROM objects WHERE object_id = ? AND object_language = l.id) AS object_title FROM languages l Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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..) when I try to define `cid` as a foreign key to country.id country.id and countrytext.cid are both smallint(5) Any help? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
I have zero experience, really, with Mysql although I compiled it on a Linux box and it works well for a couple of sites and messageboards that I host from my house. I do this strictly for fun and would like to let some friends and family members have websites as well. Here's what I don't get (well, a tiny protion of what I don't get): when I paid for webhosting I could set up a php messageboard and (if I recall correctly) and I was issued a unique username and password for the mysql database. As it is now, I am required to use my root account and username - and use a different prefix for each instance of phpBB2 (a messageboard) when I install something. Is there a way that users can have sectors, or tables, or whatever that are allocated to them and which they access with their own usernames and passwords? I know I can change my password with /.mysqadmin -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 server. We want to provide the MySQL service to our staff but might not be able to justify seperate servers. Are there any good articles available on this matter Cheers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 December 2003 7:32 a.m. To: Defryn, Guy Cc: [EMAIL PROTECTED] Subject: Re: Specs for a dedicated MySQL server There's actually a MySQL Database Appliance out there. Have you looked at that yet? http://pogolinux.com/mysql/index.html You could run MySQL on any number of different machines. Intel, Athlon, PowerPC, etc. Linux, FreeBSD, Windows, Mac OS X. - Gabriel On Dec 7, 2003, at 4:41 PM, Defryn, Guy wrote: Hi there, I have been asked to investigate a solution to offer MySQL to our staff. I am not sure how many people will make use of it at this stage. Most people would most likely use it as a backend for message boards And to store information on whatever they are doing. I am sure it will be for web purposes only. I cannot see the need for transactions etc. My employer usually goes for HP DL380 G3 servers. Any tips on redundancy, backup etc? Also, Is there anyone who uses Windows on a Mysql production server? I want to use FreeBSD or Linux but that might not be up to me. What License do I need? Basically we are an ISP for our departments Cheers GUY -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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:01 a.m. To: [EMAIL PROTECTED] Subject: 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 December 2003 7:32 a.m. To: Defryn, Guy Cc: [EMAIL PROTECTED] Subject: Re: Specs for a dedicated MySQL server There's actually a MySQL Database Appliance out there. Have you looked at that yet? http://pogolinux.com/mysql/index.html You could run MySQL on any number of different machines. Intel, Athlon, PowerPC, etc. Linux, FreeBSD, Windows, Mac OS X. - Gabriel On Dec 7, 2003, at 4:41 PM, Defryn, Guy wrote: Hi there, I have been asked to investigate a solution to offer MySQL to our staff. I am not sure how many people will make use of it at this stage. Most people would most likely use it as a backend for message boards And to store information on whatever they are doing. I am sure it will be for web purposes only. I cannot see the need for transactions etc. My employer usually goes for HP DL380 G3 servers. Any tips on redundancy, backup etc? Also, Is there anyone who uses Windows on a Mysql production server? I want to use FreeBSD or Linux but that might not be up to me. What License do I need? Basically we are an ISP for our departments Cheers GUY -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
Hi there, I have been asked to investigate a solution to offer MySQL to our staff. I am not sure how many people will make use of it at this stage. Most people would most likely use it as a backend for message boards And to store information on whatever they are doing. I am sure it will be for web purposes only. I cannot see the need for transactions etc. My employer usually goes for HP DL380 G3 servers. Any tips on redundancy, backup etc? Also, Is there anyone who uses Windows on a Mysql production server? I want to use FreeBSD or Linux but that might not be up to me. What License do I need? Basically we are an ISP for our departments Cheers GUY
Reliability of _rowid over multiple database accesses
I'd like to use the _rowid capability of MySQL to improve the efficiency of a project, but I have concerns about the reliability of the number it returns. I understand that _rowid may change over time depending on many factors, but I'd like to know whether this is true 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
Hello, The application I'm dealing with, is writen in java, jsp, jdbc, mysql 4.0... I use a broker between java classes and mysql db. broker creates n connections when the server tomcat start and shares connections. Here is the code to create connections : for (int i = 0; i n; i++) { Class.forName (com.mysql.jdbc.Driver); connPool[i] = DriverManager.getConnection (jdbc:mysql://localhost/dbname,username,pwd); } Calls to mysql from java classes looks like: try { connection = Mem.getBrokerdb().getConnection(); pstmt = connection.prepareStatement(...); pstmt.setString(1, var); pstmt.executeUpdate(); } finally { Mem.getBrokerdb().freeConnection(connection); } Does someone know how to embed Mysql and what consequence there is in java code. What mysql files or folders 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
On June 28, 2003 05:33 am, Aodhan Cullen wrote: 6/27/03 6:37:49 PM, Jeremy Zawodny [EMAIL PROTECTED] wrote: My read/update ratio would be something along the lines of 1:3, 3 updates for every read. So it is highly unusual, and more or less rules replication out of the picture. I'm unclear why you can't use replication for this. There must be an assumption about what you're doing that we do not share. If you read from the slave and write to the master, why does this not work? A slave would simply not be able to keep up, replication works really well if you have a lot of reads, and a small number of updates. This is reverse ways, and needs a different approach. Actually, I've found MySQL replication to be extremely fast. Our database is also atypical having over 70% writes to 30% or less reads. However, we have yet to have a slave (of 2 or 3) not be able to keep up. In fact, I can bring a slave that has been pasued for a few days (as a snapshot) up to speed again within an hour or two. Here's some stats on our 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.guydavis.caCalgary, Alberta, Canada -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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_safe from [EMAIL PROTECTED]@ Any ideas? - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 you must include one of the following words in your message: sql,query,queries,smallint If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: However, I have never noticed it to work on Windows. Are you using Windows? I am the moment so that explains why it did not work Cheers - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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), - species VARCHAR(20), sex CHAR(1), birth DATE, death DATE); VARCHAR is a good choice for the name, owner, and species columns because the column values will vary in length. The lengths of those columns need not all be the same, and need not be 20. You can pick any length from 1 to 255, whatever seems most reasonable to you. (If you make a poor choice and it turns out later that you need a longer field, MySQL provides an ALTER TABLE statement.) Animal sex can be represented in a variety of ways, for example, m and f, or perhaps male and female. It's simplest to use the single characters m and f. Query/mysql - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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)' - is it implemented? Hello, I see in the mysqladmin man page for version 3.23.55-1 that 'slave-start' and 'slave-stop' have at least been thought of at some stage (they're listed in the COMMAND SYNOPSIS section), but they don't seem to work when I try them... I've just been through 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? Thanks 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
'mysqladmin slave-st(art|op)' - is it implemented?
Hello, I see in the mysqladmin man page for version 3.23.55-1 that 'slave-start' and 'slave-stop' have at least been thought of at some stage (they're listed in the COMMAND SYNOPSIS section), but they don't seem to work when I try them... I've just been through 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? Thanks in advance, Guy. -- Guy Waugh Unix Team Information Technology Telecommunication Services Southern Cross University P.O. Box 157 Lismore NSW 2480 Ph: 61 2 6620 3196 Fax: 61 2 6620 3033 www.scu.edu.au/admin/it -- - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication error: 'Could not initialize master info'
Hi list, My original post concerning this issue is below - it was a week or so ago. No replies were forthcoming, but I'm pleased and a bit embarrassed (so simple) to say that I have figured it out, and my slave is now replicating from the master. The problem was that the mysql data directory was owned by root, not mysql. While the database directories within the data directory were owned by mysql, the data directory itself was root:root 755. Changing the data directory to be owned by mysql obviously allowed the master.info file to be written there when I did the 'change master to...' command. Original post here: * Hi there, I'm trying to set up replication between two RH7.2 Linux servers running MySQL 3.23.54a (mysql RPMs). I've followed the instructions in the MySQL online manual (section 4.10 Replication in MySQL), and when I do the following command on the slave: change master to master_host='db1', master_user='not shown here', master_password='not shown here', master_log_file='db1-binary-log.004', master_log_pos=38456522; , mysql tells me: 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 course, MyISAM). I'm not using InnoDB tables. Can anyone give me an idea of how to troubleshoot this one? Thanks, 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mod_Auth_MySQL for Apache 2 and Windows?
Just wondering whether anyone had a working, compiled mod_auth_mysql module for doing basic auth against a MySQL database on a Windows system (XP to be exact). If not, has anyone ever compiled one on Windows? I found one for Apache 2.0.43 at this site: http://www.pcp-computer.de/gkn/apache/httpd-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 at www.keyserver.net) PGP Fingerprint: F685 97D0 0FC6 F016 E9EB CCD3 F183 1BC7 759A 998E - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mod_Auth_MySQL for Apache 2 and Windows?
Just wondering whether anyone had a working, compiled mod_auth_mysql module for doing basic auth against a MySQL database on a Windows system (XP to be exact). If not, has anyone ever compiled one on Windows? I found one for Apache 2.0.43 at this site: http://www.pcp-computer.de/gkn/apache/httpd-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 393B 39DB CDBF 196D 31D0 30D5 2F0 - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication error: 'Could not initialize master info'
Hi there, I'm trying to set up replication between two RH7.2 Linux servers running MySQL 3.23.54a (mysql RPMs). I've followed the instructions in the MySQL online manual (section 4.10 Replication in MySQL), and when I do the following command on the slave: change master to master_host='db1', master_user='not shown here', master_password='not shown here', master_log_file='db1-binary-log.004', master_log_pos=38456522; , mysql tells me: 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 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 Information Technology Telecommunication Services Southern Cross University P.O. Box 157 Lismore NSW 2480 Ph: 61 2 6620 3196 Fax: 61 2 6620 3033 www.scu.edu.au/admin/it -- - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 : skipping to next header Tar: archive contains obsolescent base-64 headers Gunzip: stdin: invalid compressed data --crc error Tar: error exit delayed from previous errors Does anyone know why this happens. I am using a fresh freebsd 4.7 install Cheers - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 : skipping to next header Tar: archive contains obsolescent base-64 headers Gunzip: stdin: invalid compressed data --crc error Tar: error exit delayed from previous errors Does anyone know why this happens. I am using a fresh freebsd 4.7 install You're not transferring the distribution in binary (image) mode, and you're ending up with a corrupted download as a result. At least, that's the most common reason for errors such as these. - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
host table in mysql database
Hi there, I'm cleaning up MySQL permissions on one of my servers, and I see that in the mysql.host table, there are 8 rows. All 8 rows contain specific hosts in the 'Host' column (i.e. no wildcards) and specific databases in the 'Db' column. Further, all rows in all privilege columns in the host table contain 'Y'. I see from reading Paul DuBois' MySQL book that MySQL ANDs privileges in the host table with privileges in the db table, allowing administrators to revoke particular privileges for users connecting from particular hosts. Can anyone tell me, then, if the host table is currently having any effect on permissions? I'm thinking not, as a logical AND of the host table 'Y' and the db table 'Y' or 'N' will result in the privilege recorded in the db table. Also, Paul's book says that the host table is only checked if the 'Host' column in the relevant client's row in the db table is blank, and all rows in the db table contain values in the 'Host' column. So on that fact alone, it looks like I can delete all rows in the host table without permissions being 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/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. Affordable. Sign up now. http://mailplus.yahoo.com - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: secure replication
On Thu, 2002-10-24 at 20:26, Lists @ Apted Technologies Inc. wrote: i am going to be setting up four mysql servers, three of which will replicate data off of the primary. i know that in more recent versions of mysql client/server communciations can be encrypted internally. but is 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 -- Guy Davis http://www.guydavis.caCalgary, Alberta, Canada Digitally signed by GnuPG (DSA ID 30D52F0B at www.keyserver.net) PGP Fingerprint: 8DC8 4A6F C1AD 393B 39DB CDBF 196D 31D0 30D5 2F0 - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
small bug in mysqlcheck
Hi, When trying to check/repair/analaiz a table with a name like 'table-name' mysqlcheck (from source package 3.23.53) fails with: mysqlcheck: Got error: 1064: You have an error in your SQL syntax near '-name' at line 1 when executing 'CHECK TABLE ... Here's the patch for it: --- mysqlcheck.old Sat Oct 26 11:37:49 2002 +++ mysqlcheck.cSat Oct 26 11:35:12 2002 @@ -521,7 +521,7 @@ if (!(query =(char *) my_malloc((sizeof(char)*(length+110)), MYF(MY_WME return 1; - sprintf(query, %s TABLE %s %s, op, tables, options); + 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] | Administration. No outsourcing. Phone: +972 3 6201373 | Security, Installations, Support http://www.uadm.com/pgp.key | Upgrades and Maintenance. - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 result). - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysock.sql problem
I have installed mysql from the ports collection on FreeBSD and it was working fine. I would like to move the /tmp/mysql.sock file ( or is it safe to leave it there?) so I Created a my.cnf file with the following options [mysqld] port=3306 socket=/usr/local/mysql/mysql.sock I take down 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 - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 | +---+-+--+-+-+---+ | customer_name | varchar(20) | YES | | NULL| | | loan_number | varchar(5) | YES | | NULL| | +---+-+--+-+-+---+ 2 rows in set (0.00 sec) I use the following to load the data stored in borrower.txt into the table borrower : mysql load data local infile c:\\data\\borrower.txt into table borrower; Query OK, 8 rows affected (0.00 sec) Records: 8 Deleted: 0 Skipped: 0 Warnings: 1 Case 1: The file borrower.txt looks like the following : Adams L-16 Curry L-93 Hayes L-15 Jackson L-14 Jones L-17 Smith L- 11 Smith L-23 WilliamsL-17 When I run a select query i get the following output : mysql select * from borrower; +---+-+ | customer_name | loan_number | +---+-+ | Adams | L-16| | Curry | L-93| || L-15 |n | L-14 || L-17 | Smith | L- 11 | || L-23 | Williams | L-17| +---+-+ 8 rows in set (0.06 sec) Case 2: When the contents of borrower.txt is changed to no spaces in between name and loan_number : AdamsL-16 CurryL-93 HayesL-15 JacksonL-14 JonesL-17 SmithL-11 SmithL-23 WilliamsL-17 The data stored in the table is: mysql select * from borrower; +---+-+ | customer_name | loan_number | +---+-+ | NULL| | NULL| | NULL| | NULL| | NULL| | NULL| | NULL| | NULL| +---+-+ 8 rows in set (0.00 sec) Why was the data not correctly loaded into the table? Please Help me. Regards, Vaibhav Jha. - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 mysql install has been done with default settings and There are never more than 2 people using the database at the same time. I also created a PHP interface to the database and I received the same error. The error does not occur all the time and when it occurs it goes away by refreshing the web browser. I never have any problems when working on the mysql server from the command line. Any ideas? - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 fine. It seems to me it's like a Timeout thing. This is my connection to the database set oconn = server.createobject(Adodb.connection) oconn.connectionstring = server=192.168.1.73;driver=MySQL;db=supplies;uid=myname;pwd=mypwd oconn.open Any ideas? - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 fine. It seems to me it's like a Timeout thing. This is my connection to the database set oconn = server.createobject(Adodb.connection) oconn.connectionstring = server=192.168.1.73;driver=MySQL;db=supplies;uid=myname;pwd=mypwd oconn.open Any ideas? 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 fine. It seems to me it's like a Timeout thing. This is my connection to the database set oconn = server.createobject(Adodb.connection) oconn.connectionstring = server=192.168.1.73;driver=MySQL;db=supplies;uid=myname;pwd=mypwd oconn.open Any ideas? 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I was wondering what advantages one has over the other. I think the old way is easier but is it good enough? Cheers - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 order. This is pretty straightforward My query looks like this sqltext1 = Select orders.orderdate AS orderdate,orders.user AS user , products.productname AS productname, orders.amount as amount,products.price AS Price, sqltext1 = sqltext1 (amount* price) AS subtotal from orders,products where orders.product = products.productid sqltext1 = sqltext1 and cluster = ' cluster ' and orderdate ' printdate ' order by orderdate; Now the other thing I need is the total of all orders so I created a 2nd query sqltext2 = Select sum(orders.amount * products.price) AS total from orders,products where orders.product=products.productid AND cluster = ' cluster 'and orderdate ' printdate '; I have the required result but is there some way I can have everything in one query G - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 order. This is pretty straightforward My query looks like this sqltext1 = Select orders.orderdate AS orderdate,orders.user AS user , products.productname AS productname, orders.amount as amount,products.price AS Price, sqltext1 = sqltext1 (amount* price) AS subtotal from orders,products where orders.product = products.productid sqltext1 = sqltext1 and cluster = ' cluster ' and orderdate ' printdate ' order by orderdate; Now the other thing I need is the total of all orders so I created a 2nd query sqltext2 = Select sum(orders.amount * products.price) AS total from orders,products where orders.product=products.productid AND cluster = ' cluster 'and orderdate ' printdate '; I have the required result but is there some way I can have everything in one query G - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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, Products as P Where O.product=P.productid AND O.cluster = 'ANP'; When I use the first example with INNER JOIN it works as well. The book I use as study guide is a few years old so maybe the syntax has changed ?? Any ideas - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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=MySQL;db=clientdb;uid=us er;pwd=user objconn.open connectionstring sqltxt = select * from client criteriatxt = name like 'TELE*' objrs.open sqltxt, objconn, adopenkeyset, adlockoptimistic objrs.find criteriatxt if objrs.eof then response.write(record is not exist!) else response.write objrs(code) objrs(name) objrs(address) br end if objrs.close objconn.close set objrs = nothing set objconn = nothing % Hope this helps - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 wrong because I don't get any errors. Any ideas? % dim product,amount,cluster,user,orderdate,entered,comment,oconn,sqltext,arrdate function newstr(str) newstr=replace(replace(str,',''),chr(34),quot;) End function product=request.form(product) amount=request.form(amount) cluster=request.form(cluster) user=newstr(request.form(user)) orderdate=request.form(orderdate) comment=newstr(request.form(comment)) entered=request.form(entered) set oconn = server.createobject(Adodb.connection) oconn.connectionstring = server=130.123.80.73;driver=MySQL;db=supplies;uid=itsupport;pwd=itsupport oconn.open sqltext = Insert into orders(orderid,product,amount,cluster,user,orderdate,comment,entered) sqltext = sqltext values(NULL, product , amount ,' cluster ',' user ',# orderdate #,' comment ',' entered ') oconn.close set oconn = nothing % - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 the IUSR_machinename only exists on the web server. How can I give internet users access to a database That is on another server? I would rather use mysql than Access and preferably run mysql on Unix but it is not a must. Hope this makes sense Thanks - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 . (NULL,'$itnumber','$hdsize','$processor','$ram','$monitor','$os','$invoice' ,'$datebought'); mysql_query($query) or die (mysql_error()); ? Everything else works fine. When I enter the date into mysql itself it works fine. Thanks - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 enter ur date as in this format -MM-DD for example: 2002-04-04 Hope this will work Uma On Thu, 16 May 2002, Defryn, Guy wrote: DG DG DGI am working with PHP for the first time and I need a form DGTo insert some details and a date. DG DGWhen I check the mysql database the date is displayed as -00-00 DG DGHere is my php script: DG DG? DG$query = Insert into computers(id,itnumber,hdd,processor,ram,monitor,os,invoice,datebought) values . (NULL,'$itnumber','$hdsize','$processor','$ram','$monitor','$os','$invoice' DG,'$datebought'); DG DGmysql_query($query) or die (mysql_error()); DG DG? DG DGEverything else works fine. When I enter the date into mysql itself it works fine. DG DGThanks DG DG DG- DGBefore posting, please check: DG http://www.mysql.com/manual.php (the manual) DG http://lists.mysql.com/ (the list archive) DG DGTo request this thread, e-mail [EMAIL PROTECTED] DGTo unsubscribe, e-mail [EMAIL PROTECTED] DGTrouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php DG -- Love and you shall be loved by others - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 server. Using a local MySQL server works fine as uname is never called. Have any of you ever seen anything like this? Is that remote server's info in /etc/hosts on the client? If not, see if that makes a difference. Yes, adding the remote server's line to /etc/hosts clears up the problem. Does that meant that our DNS server is somehow misconfigured. Issuing 'host dev.pason.com' at the command line gives me the correct IP address. Here's /etc/host.conf: order hosts,bind Thanks. -- Guy Davishttp://www.guydavis.ca PGP: D2E2 76D4 0C9C 5D99 42AA EB6B B9C2 68CA 2DC7 F2E4 - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help: SIGSEGV inside mysql_connect to remote server
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 server. Using a local MySQL server works fine as uname is never called. Have any of you ever seen anything like this? Here's the backtrace from gdb: Program received signal SIGSEGV, Segmentation fault. 0x0807a086 in uname () (gdb) bt #0 0x0807a086 in uname () #1 0x4011da96 in getdomainname (name=0x4019f240 , len=1024) at ../sysdeps/generic/getdomain.c:40 #2 0x40191ae6 in nis_local_directory () at nis_local_names.c:68 #3 0x40181cb0 in _nss_create_tablename (errnop=0x808c720) at nss_nisplus/nisplus-hosts.c:183 #4 0x40182223 in internal_gethostbyname2_r (name=0xb5b0 dev.pason.com, af=2, host=0x40170620, buffer=0x808fda0 \177, buflen=1024, errnop=0x808c720, herrnop=0xb178, flags=0) at nss_nisplus/nisplus-hosts.c:338 #5 0x401825ca in _nss_nisplus_gethostbyname_r ( name=0xb5b0 dev.pason.com, host=0x40170620, buffer=0x808fda0 \177, buflen=1024, errnop=0x808c720, h_errnop=0xb178) at nss_nisplus/nisplus-hosts.c:447 #6 0x40135cc0 in __gethostbyname_r (name=0xb5b0 dev.pason.com, resbuf=0x40170620, buffer=0x808fda0 \177, buflen=1024, result=0xb174, h_errnop=0xb178) at ../nss/getXXbyYY_r.c:200 #7 0x401356da in gethostbyname (name=0xb5b0 dev.pason.com) at ../nss/getXXbyYY.c:131 #8 0x0805b8cc in mysql_real_connect () #9 0x0805d90c in mysql_connect () #10 0x08070385 in ssConnectDB (databaseName=0x8073c85 hub) at _ssmysql.c:52 Any idea what this could be? Any idea on how I could try to track it down? 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 Pason Systems Fax: (403) 301-3499 PGP: 65BA 484B 0B96 5F3B 4D40 DCA2 B2AE 6B5A F52B 1445 - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Creating MySQL database using DAO
Hello, I would like to create a MySQL database using DAO and Visual C++ 6.0 (CDaoDatabase and CDaoRecordset). I know there is a Create() method on CDaoDatabase but I cannot figure out how to use it to create a mysql database. Does anyone know how to do this? Moreover, do you know which files 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/ - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Rotation of binary logs on replication master?
On Thu, 2002-03-21 at 13:07, Shawn McCool wrote: /usr/local/bin/mysql -hhostname -uusername -ppassword -e flush logs; I guess I wasn't clear that I wanted old binary logs removed. I don't want to have to manually worry about disk space due to ever increasing binary logs. It seems to me FLUSH LOGS just opens a new binary log. The old, unused ones are still left in place. I'm looking for a rotating set of say 4 kept. Anything older is deleted. Logrotate does this for Apache's logs for example. The RESET command seems to delete all binary logs. I don't want them all deleted, just very old ones. Any ideas? Thanks. Flush logs did the following: [root@nachos root]# du -h /var/lib/mysql/nachos* 4.0k/var/lib/mysql/nachos-bin.001 700M/var/lib/mysql/nachos-bin.002 4.0k/var/lib/mysql/nachos-bin.003 1.1G/var/lib/mysql/nachos-bin.004 350M/var/lib/mysql/nachos-bin.005 4.0k/var/lib/mysql/nachos-bin.006 189M/var/lib/mysql/nachos-bin.007 384M/var/lib/mysql/nachos-bin.008 4.0k/var/lib/mysql/nachos-bin.009 1.1G/var/lib/mysql/nachos-bin.010 289M/var/lib/mysql/nachos-bin.011 1.1G/var/lib/mysql/nachos-bin.012 1.1G/var/lib/mysql/nachos-bin.013 684M/var/lib/mysql/nachos-bin.014 4.0k/var/lib/mysql/nachos-bin.index 332k/var/lib/mysql/nachos-slow.log 4.0k/var/lib/mysql/nachos.us.pason.com.pid mysql FLUSH LOGS; [root@nachos root]# du -h /var/lib/mysql/nachos* 4.0k/var/lib/mysql/nachos-bin.001 700M/var/lib/mysql/nachos-bin.002 4.0k/var/lib/mysql/nachos-bin.003 1.1G/var/lib/mysql/nachos-bin.004 350M/var/lib/mysql/nachos-bin.005 4.0k/var/lib/mysql/nachos-bin.006 189M/var/lib/mysql/nachos-bin.007 384M/var/lib/mysql/nachos-bin.008 4.0k/var/lib/mysql/nachos-bin.009 1.1G/var/lib/mysql/nachos-bin.010 289M/var/lib/mysql/nachos-bin.011 1.1G/var/lib/mysql/nachos-bin.012 1.1G/var/lib/mysql/nachos-bin.013 684M/var/lib/mysql/nachos-bin.014 4.0k/var/lib/mysql/nachos-bin.015 4.0k/var/lib/mysql/nachos-bin.index 332k/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 - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Rotation of binary logs on replication master?
Just wondering if any Linux users of MySQL out there had written a logrotate configuration file for dealing with MySQL binary logs on a replication Master. I want to rotate these logs (6.5 GB now) as some are over a month old. However, I don't want to confuse any of the replicating slaves. 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: 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 confused. Basically, I am trying to set up forms using Microsoft FrontPage 2000 where the results (form input) will be sent to a database (Microsoft Access 2000) and to an email address. I am following instructions outlined in a Microsoft white paper which has specifically been written to address this topic (found at http://download.microsoft.com/download/fp2000/whitep/1/NT5XP/EN-US/cdonts200 0.EXE) My problem is that I can only get one form field value to be inserted into my table. I think I have followed the instructions that the white paper gives for building the mySQL string that is used to insert the form information into the database - but I am having no success in getting all the form information inserted into the databse. -- The mySQL syntax given by the white paper is the following: mySQL = INSERT INTO [your_table_name] mySQL = mySQL ([database_field_names]) mySQL = mySQL VALUES ('[form_field_names]') -- The example mySQL string in the white paper is: mySQL= INSERT INTO Employees mySQL= mySQL (FirstName,LastName,Address,City,Region,PostalCode) mySQL= mySQL VALUES (' Request.Form(FirstName) ',' mySQL= mySQL Request.Form(LastName) ' mySQL= mySQL ,' Request.Form(Address) ' mySQL= mySQL ,' Request.Form(City) ',' mySQL= mySQL Request.Form(Region) ',' mySQL= mySQL Request.Form(PostalCode) ') --- The white paper gives the following my SQL syntax to help with customizing the SQL string: INSERT INTO [table] ([DBfield1],[DBfield2]) VALUES ('[form_field1]','[form_field2]') mySQL = INSERT INTO [table] (DBfield) VALUES (' Request.Form(form_field) ') -- Background: The Microsoft Access 2000 database table I want to insert information into is named Action The form field names or VALUES I am trying to insert information from (from the FrontPage 2000 form) are: RequestDate CommerceID LastName FirstName Email DepartmentNumber Sector StreetAddress City State ZipCode LocationCode MailDrop TelephoneNumber FaxNumber RequestType Library Request The Microsoft Access 2000 database table field names (to which I want to insert information into) are: RequestDate CommerceID Client FirstName Email DepartmentNum Sector StreetAddress City State ZipCode LocCode MailDrop TelephoneNum FaxNum ServiceName InternalGroup Request The form field values correspond to the table colums in the following way: RequestDate (value from form) insert RequestDate (database field name) CommerceID (value from form) insert into CommerceID (database field name) LastName (value from form) insert into Client (database field name) FirstName (value from form) insert into FirstName (database field name) Email (value from form) insert into Email (database field name) DepartmentNumber (value from form) insert into DepartmentNum (database field name) Sector (value from form) insert into Sector (database Field name) StreetAddress (value from form) insert into StreetAddress (database field name) City (value from form) insert into City (database field name) State (value from form) insert into State (database field name) ZipCode (value from form) insert into ZipCode (database field name) LocationCode (value from form) insert into LocCode (database field name) MailDrop (value from form) insert into MailDrop (database field name) TelephoneNumber (value from form) insert into TelephoneNum (database field name) FaxNumber (value from form) insert into FaxNumber (database field name) RequestType (value from form) insert into ServiceName (database field name) Library (value from form) insert into InternalGroup (database field name) Request (value from form) insert into Request (database Field name) - What I have tried and the results: I have tried the following mySQL string - based on the example given in thw white paper (did not include all form fields as I wanted to see if it would work using the example given as a template). This string gave me error messages... mySQL= INSERT INTO Action mySQL= mySQL (RequestDate,CommerceID,Client,FirstName,Sector,Request) mySQL= mySQL VALUES (' Request.Form(RequestDate) ',' mySQL= mySQL Request.Form(CommerceID) ' mySQL= mySQL ,' Request.Form(Client) ' mySQL= mySQL ,' Request.Form(FirstName) ',' mySQL= mySQL
Re-baselining replication slaves?
I started replicating the MySQL DB on our production server last month. I was wondering if anyone who has been doing replication for a while has seen the need to resync the slave. (i.e. snapshot the master, install on slave, and re-start replication from snapshot) Are there systems out 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 - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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://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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: insert picture file in MySQL (+php)
On Thu, 2002-02-14 at 08:42, Eric Torr Klopper wrote: How would you go about doing this. Could somebody send me some sample code and also explain how to get the image link into the database so I can access the image. I'm fairly new to MySql and PHP so any help on this will be appreciated. I use this for the photo album on my web site (http://www.guydavis.ca). It's not a high traffic site by any means, so performance isn't an issue. Can't show you PHP, but here's what I did in an Java servlet. It handles uploaded (POST) images from friends. byte_out is a ByteArrayOutputStream. imageIcon is an Icon that I create using JDK 1.4's headless AWT support to allow me to calculate the image's thumbnail dimensions. Connection con = WebUtils.getConnection(); String st = INSERT INTO photos (location, description, date_shot, filename, mimetype, img_data, ; st += height, width, thumb_height, thumb_width, category, access, title) ; st += VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); PreparedStatement stmnt = con.prepareStatement(st); stmnt.setString(1, ((String) params.get(location))); stmnt.setString(2, ((String) params.get(description))); stmnt.setString(3, date); stmnt.setString(4, (image.getFileName())); stmnt.setString(5, image.getContentType()); stmnt.setBytes(6, byte_out.toByteArray()); stmnt.setInt(7, imageIcon.getIconHeight()); stmnt.setInt(8, imageIcon.getIconWidth()); stmnt.setInt(9, thumb_height); stmnt.setInt(10, thumb_width); stmnt.setInt(11, Integer.parseInt((String) params.get(category))); stmnt.setString(12, (String) params.get(access)); stmnt.setString(13, ((String) params.get(title))); stmnt.executeUpdate(); Given that most of the photos posted by myself and friends are personal, I needed an access control system and I wanted something more robust than a publicly accessible image with a random name. The only way to do that is to have a servlet or CGI read in a image from disk or database (where's it's not web accessible) and write the data out to the client. Here's the relevant code from my PhotoServlet: String query = SELECT * FROM photos WHERE id=+id; ResultSet rs = WebUtils.doSQL(query); if (!rs.first()) { displayError(request, response); return; } // if it's marked personal, only logged in people should see it if ((rs.getString(access).equalsIgnoreCase(Personal)) (session.getValue(login) == null)) { displayError(request, response); return; } if (rs.getString(filename).toUpperCase().indexOf(.GIF) = 0) response.setContentType(image/gif); else response.setContentType(image/jpeg); Blob img_blob = rs.getBlob(img_data); InputStream in = img_blob.getBinaryStream(); while (in.available() 0) buf_out.write(in.read()); buf_out.flush(); buf_out.close(); Here's the CREATE TABLE for my photos table: photos | CREATE TABLE `photos` ( `id` smallint(5) unsigned NOT NULL auto_increment, `location` varchar(255) NOT NULL default '', `description` mediumtext NOT NULL, `date_shot` date NOT NULL default '-00-00', `filename` varchar(255) NOT NULL default '', `mimetype` varchar(50) NOT NULL default '', `height` smallint(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') default 'Personal', `title` varchar(255) 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 - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ADO to MySQL interface?
Hi all, The company I work for is a Linux shop using MySQL almost exclusively, however we're partnering with Windows-only shop to tie their application into our overall product offering. Their app uses ADO as it's database interface and they say it will work with Oracle, MS SQL Server, 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 SQL Server. -- 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://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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 PRIMARY KEY (`Column1`) ) TYPE=MyISAM | mysql show create table table2; | Table | Create Table -- | table2 | CREATE TABLE `table2` ( `Column1` varchar(63) default NULL KEY `idx1` (`Column1`) ) TYPE=MyISAM | ++ 1) When i run the first query through explain the expected results happen mysql explain SELECT table1.column1 FROM table1, table2 WHERE table1.column1 = table2.column2; +-+---+---+-+-+---+---+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+---+---+-+-+---+---+-+ | table1 | index | PRIMARY | PRIMARY | 63 | NULL | 57379 | Using index | | table2 | ref | idx1 | idx1| 64 | table1.column1| 1 | Using index | +-+---+---+-+-+---+---+-+ However, when i select an additional column, the following unexpected results happen mysql explain SELECT table1.column1, table1.column2 FROM table1, table2 WHERE table1.column1 = table2.column2 +-+--+---+--+-+---+---+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+---+---+-+ | table1 | ALL | PRIMARY | NULL |NULL | NULL | 57379 | | | table2 | ref | idx1 | idx1 | 64 | table1.column1| 1 | Using index | +-+--+---+--+-+---+---+-+ 2) Also, look at the following scanario mysql explain SELECT table1.column1 FROM table1, table2 WHERE table1.column1 = table2.column2 order by table1.column1 asc; +-+---+---+-+-+---+---+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+---+---+-+-+---+---+-+ | table1 | index | PRIMARY | PRIMARY | 63 | NULL | 57379 | Using index | | table2 | ref | idx1 | idx1| 64 | table1.column1| 1 | Using index | +-+---+---+-+-+---+---+-+ However, when i select an additional column, the following unexpected results happen mysql explain SELECT table1.column1, table1.column2 FROM table1, table2 WHERE table1.column1 = table2.column2 order by table1.column1 asc +-+--+---+--+-+---+---++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+---+---++ | table1 | ALL | PRIMARY | NULL |NULL | NULL | 57379 | Using filesort | | table2 | ref | idx1 | idx1 | 64 | table1.column1| 1 | Using index| +-+--+---+--+-+---+---++ I am baffled as to why simple selecting an extra column results in the index no longer being used even though the where clause has not changed. If anybody could provide me an explain as to why this is occuring with a solution, it would be greatly appreciated. TIA __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Linking problems
Hi, I did all that but I still have the linking problems: it seems that it doesn't find the MysqlConnection implementation. NOTES: -- 1) The main workspace and project for the mysql++ API are located in the root directory 2) This project, when built, will yield the static library mysql++.lib in the /lib directory 3) This library needs the header files in the /include and /mysql/include directory, and libmysql.lib in the mysql/lib directory 4) All programs using MySQL++ need libmysql.dll (located in the /mysql/lib directory) to be able to run. You have to put it into the same directory as the executable, or for example copy it into the windows/system directory 5) In the /example directory a workspace and project have been made for building the (non-MFC) examples 6) In the /example/MFC_example an example for using MySQL++ in an MFC project has been made PROBLEMS: - 1) Visual C++ doesn't provide full functionality for longlongs, such as strtoll and ostream operator , so all longlongs have been replaced with ints in the examples 2) The example custom4.cpp could not be compiled 3) There are still some problems with the functions for static result sets. They seem to work alright with vectors, but might not work for the other STL containers 4) In every project you make with MySQL++ support, you need to use the multithreaded DLL run-time library. This can be set in Project Settings, C/C++ tab, category Code Generation, Use run-time library listbox. If you don't want to change your run-time library, change the run-time library in the MySQL++ project and rebuild mysql++.lib (warning: this is not recommended and may yield linker errors in your project!) HOW TO RUN THE EXAMPLES --- 1) You should have mysql server installed on your localhost with user root and no password. 2) Run resetdb.exe example in order to create test database. 3) Run other examples HOW TO ADD MYSQL++ TO AN EXISTING VISUAL C++ PROJECT 1) Add mysql++.lib to the project 2) Go to Project Settings, C/C++ tab, category Preprocessor, and add the directories include and mysql/include to the Additional include directories edit box 3) In the source files, in which you want to use MySQL++, add the line #include mysql++ 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 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: MFC_ex.exe - 18 error(s), 0 warning(s) Thanks a lot for your help Hi! You have to link in MySQL C API library too ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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_ex.obj : error LNK2001: unresolved external symbol public: __thiscall MysqlConnection::~MysqlConnection(void) (??1MysqlConnection@@QAE@XZ) MFC_ex.obj : error LNK2001: unresolved external symbol class std::basic_ostreamchar,struct std::char_traitschar __cdecl operator(class std::basic_ostreamchar,struct std::char_traitschar ,class mysql_ColDataclass const_string const ) (??6@YAAAV?$basic_ostream@DU?$char_traits@D@std@@@std@@AAV01@ABV?$mysql_ColData@Vconst_string@Z) MFC_ex.obj : error LNK2001: unresolved external symbol public: __thiscall MysqlConnection::MysqlConnection(char const *,char const *,char const *,char const *,bool) (??0MysqlConnection@@QAE@PBD000_N@Z) MFC_ex.obj : error LNK2001: unresolved external symbol public: __thiscall MysqlResUse::~MysqlResUse(void) (??1MysqlResUse@@QAE@XZ) MFC_ex.obj : error LNK2001: unresolved external symbol _mysql_num_rows@4 MFC_ex.obj : error LNK2001: unresolved external symbol _mysql_fetch_lengths@4 MFC_ex.obj : error LNK2001: unresolved external symbol _mysql_fetch_row@4 MFC_ex.obj : error LNK2001: unresolved external symbol _mysql_data_seek@12 MFC_ex.obj : error LNK2001: unresolved external symbol public: class std::basic_stringchar,struct std::char_traitschar,class std::allocatorchar __thiscall SQLQuery::str(class SQLQueryParms const )const (?str@SQLQuery@@QBE?AV?$basic_strin g@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@ABVSQLQueryParms@@@Z) MFC_ex.obj : error LNK2001: unresolved external symbol public: class std::basic_stringchar,struct std::char_traitschar,class std::allocatorchar __thiscall SQLQuery::str(class SQLQueryParms const ,enum query_reset) (?str@SQLQuery@@QAE?AV?$ basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@ABVSQLQueryParms@@W4query_reset@@@Z) MFC_ex.obj : error LNK2001: unresolved external symbol public: class MysqlRes __thiscall MysqlConnection::store(class std::basic_stringchar,struct std::char_traitschar,class std::allocatorchar const ,bool) (?store@MysqlConnection@@QAE?AVM ysqlRes@@ABV?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@_N@Z) MFC_ex.obj : error LNK2001: unresolved external symbol protected: virtual class std::fposint __thiscall std::strstreambuf::seekoff(long,short,int) (?seekoff@strstreambuf@std@@MAE?AV?$fpos@H@2@JFH@Z) MFC_ex.obj : error LNK2001: unresolved external symbol public: unsigned int __thiscall MysqlResUse::num_fields(void)const (?num_fields@MysqlResUse@@QBEIXZ) MFC_ex.obj : error LNK2001: unresolved external symbol private: void __thiscall MysqlFieldNames::init(class MysqlResUse const *) (?init@MysqlFieldNames@@AAEXPBVMysqlResUse@@@Z) MFC_ex.obj : error LNK2001: unresolved external symbol private: void __thiscall FieldTypes::init(class MysqlResUse const *) (?init@FieldTypes@@AAEXPBVMysqlResUse@@@Z) nafxcwd.lib(thrdcore.obj) : error LNK2001: unresolved external symbol __endthreadex nafxcwd.lib(thrdcore.obj) : error LNK2001: unresolved external symbol __beginthreadex Debug/MFC_ex.exe : fatal error LNK1120: 17 unresolved externals Error executing link.exe. MFC_ex.exe - 18 error(s), 0 warning(s) Thanks a lot for your help __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling problem: error in type_info1.hh
: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(63) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(72) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(83) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(88) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(93) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(98) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(103) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(108) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(113) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(122) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(123) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(126) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(142) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(147) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(152) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(162) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(172) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(177) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(182) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(187) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(195) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(196) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(199) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(217) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(222) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(227) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(237) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(247) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(252) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(257) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(263) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(272) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(273) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(276) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(292) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(297) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(306) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(317) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(322) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(327) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(336) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\manip1.hh(337) : 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: 'ostream' : ambiguous symbol c:\sqlplus\include\vallist1.hh(56) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\vallist1.hh(71) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\vallist1.hh(71) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\vallist1.hh(88) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\vallist1.hh(88) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\vallist1.hh(99) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\vallist1.hh(99) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\null2.hh(7) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\null2.hh(7) : error C2872: 'ostream' : ambiguous symbol c:\sqlplus\include\set3.hh(23) : error C2872: 'ostream' : ambiguous 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 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 please. I would really appreciate it. You can reply me using my mail adress: [EMAIL PROTECTED] Thanks Please download and use
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 please. I would really appreciate it. You can reply me using my mail adress: [EMAIL PROTECTED] Thanks Configuration: prog - Win32 Debug Compiling... prog.cpp c:\sqlplus\type_info1.hh(31) : error C2758: '_base_type' : must be initialized in constructor base/member initializer list c:\sqlplus\type_info1.hh(27) : see declaration of '_base_type' c:\sqlplus\type_info1.hh(31) : error C2758: '_default' : must be initialized in constructor base/member initializer list c:\sqlplus\type_info1.hh(28) : see declaration of '_default' c:\sqlplus\type_info1.hh(69) : error C2252: 'offset' : pure specifier can only be specified for functions c:\sqlplus\type_info1.hh(70) : error C2258: illegal pure syntax, must be '= 0' c:\sqlplus\type_info1.hh(70) : error C2252: 'unsigned_offset' : pure specifier can only be specified for functions c:\sqlplus\type_info1.hh(71) : error C2258: illegal pure syntax, must be '= 0' c:\sqlplus\type_info1.hh(71) : error C2252: 'null_offset' : pure specifier can only be specified for functions c:\sqlplus\type_info1.hh(72) : error C2258: illegal pure syntax, must be '= 0' c:\sqlplus\type_info1.hh(72) : error C2252: 'unsigned_null_offset' : pure specifier can only be specified for functions c:\sqlplus\type_info1.hh(79) : error C2258: illegal pure syntax, must be '= 0' c:\sqlplus\type_info1.hh(79) : error C2252: 'string_type' : pure specifier can only be specified for functions c:\sqlplus\type_info1.hh(163) : warning C4800: 'unsigned int' : forcing value to bool 'true' or 'false' (performance warning) c:\sqlplus\type_info1.hh(176) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\sqlplus\type_info1.hh(180) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\sqlplus\type_info1.hh(184) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\sqlplus\type_info1.hh(188) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\sqlplus\coldata1.hh(60) : error C2039: 'string_type' : is not a member of 'mysql_type_info' c:\sqlplus\type_info1.hh(62) : see declaration of 'mysql_type_info' c:\sqlplus\coldata1.hh(125) : see reference to class template instantiation 'mysql_ColDataStr' being compiled c:\sqlplus\coldata1.hh(63) : error C2039: 'string_type' : is not a member of 'mysql_type_info' c:\sqlplus\type_info1.hh(62) : see declaration of 'mysql_type_info' c:\sqlplus\coldata1.hh(125) : see reference to class template instantiation 'mysql_ColDataStr' being compiled c:\program files\microsoft visual studio\vc98\include\strstream(52) : error C2039: 'openmode' : is not a member of 'ios' c:\program files\microsoft visual studio\vc98\include\ios.h(106) : see declaration of 'ios' c:\program files\microsoft visual studio\vc98\include\strstream(52) : error C2061: syntax error : identifier 'openmode' c:\program files\microsoft visual studio\vc98\include\strstream(54) : error C2039: 'openmode' : is not a member of 'ios' c:\program files\microsoft visual studio\vc98\include\ios.h(106) : see declaration of 'ios' c:\program files\microsoft visual studio\vc98\include\strstream(54) : error C2061: syntax error : identifier 'openmode' c:\program files\microsoft visual studio\vc98\include\strstream(91) : error C2629: unexpected 'class std::ostrstream (' c:\program files\microsoft visual studio\vc98\include\strstream(91) : error C2238: unexpected token(s) preceding ';' c:\program files\microsoft visual studio\vc98\include\strstream(109) : error C2629: unexpected 'class std::strstream (' c:\program files\microsoft visual studio\vc98\include\strstream(109) : error C2238: unexpected token(s) preceding ';' c:\program files\microsoft visual studio\vc98\include\xtree(118) : warning C4786: 'std::_Treestd::basic_stringchar,std::char_traitschar,std::allocatorchar ,std::pairstd::basic_stringchar,std::char_traitschar,std::allocatorchar const , int,std::mapstd::basic_stringchar,std::char_traitschar,std::allocatorchar ,int,std::lessstd::basic_stringchar,std::char_traitschar,std::allocatorchar ,std::allocatorint ::_Kfn,std::lessstd::basic_stringchar,std::char_traitscha r,std::allocatorchar ,std::allocatorint ' : identifier was truncated to '255' characters in the debug information c:\program files\microsoft visual studio\vc98\include\map(46) : see reference to class template instantiation 'std::_Treestd::basic_stringchar,std::char_traitschar,std::allocatorchar ,std::pairstd::basic_stringchar,std::char_traits char,std::allocatorchar const
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 - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 not get updated. The web hosting service (20after4.com = recommended - very helpful people there) has performed a replication between two of their servers, using the same master for my replication attempt as the master for theirs. Their replication worked. The main difference is that they did not use redirection and I did. Having the development database on this system, I do not want to replicate directly. So, when we synced I created a local database here (xxxprod), copied the snapshot of the production database to the xxxprod data directory here, then initiated replication. We have tried putting the replication commands in the my.cnf file and using the 'change master to' command, and get the same results. Here is the current my.cnf file. [mysqld] server-id=11 replicate-do-db=xxx replicate-rewrite-db=xxx-xxxprod Anyone have an idea what we may have done wrong? - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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, copy over the existing data directory. -Original Message- From: Peter H. Burris [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 1:49 PM To: [EMAIL PROTECTED] Subject: aggravating failure symptoms and steps to remedy them... I'm a sysadmin who created mysql installs for users on linux x86 boxen; I had to create self-contained, architecture-specific packages to comply with our in-house means of handling software in my department. That took three weeks to fine-tune and distribute and mysql seemed to run out of the box, after some tuning on my build-host. Everything LOOKED good...until the user who called and said, did you change my password? uh, no. Why can't I get on Mysql, then? uh, did you do a ps -ef? nothing happens. well, the host.some.domain.err says the following: 010619 16:39:30 mysqld started 010619 16:39:30 /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010619 16:39:30 mysqld ended searches on dejanews.com (or 'googlegroups, as they are known) revealed someone had run into this and had been advised to run the installdb script; I did that again, but now it doesn't do me much good, so I try linking over /usr.../mysql/var/mysql to /usr/../,ysql/libexec, but to no visible change in behavior, judging by stdout and the *.err log. What painfully simple, stupid thing am I missing? - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Start fails after upgrade to 3.23.32 - no host.ISM file
Description: Upgraded from 3.22.27 to 3.23.32. Built from source. When attempting to start the daemon, it immediately terminates. Log file shows Can't find file: 'host.ISM' (errno: 2). I checked the old data directory (from where I copied the database files) and there never has been a host.ISM file. I don't see a reference to this in the trouble shoot guides. Please note: I cannot go to the current version as this machine (development) cannot be on a higher version that the production machine, which is on 3.23.32. How-To-Repeat: Use either safe_mysqld or mysql.server to start. 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: support Release: mysql-3.22.32 (TCX binary) Environment: System: Linux linus 2.2.14-5.0 #1 Tue Mar 7 20:53:41 EST 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors' LDFLAGS='-static' Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=TCX binary' --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 mySQL /data directory, and there never was any such file. I can still start the old server without error. Any suggestions are welcome. OS:RedHat Linux 6.2 DIST: Built from source
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 mySQL /data directory, and there never was any such file. I can still start the old server without error. Any suggestions are welcome. OS:RedHat Linux 6.2 DIST: Built from source
RE: Upgrade and start-up failures
Tried both. 1st copied the data tree (wherein there is a host.frm, host.MYD, and host.MYI files). When that didn't work, I did the mysql_install_db, but that had no effect. I suspect that there is a ./configure option I missed that declares the default data file format to use, and that they were built differently. But I cannot yet find that in the docs. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Brazill Sent: Monday, June 18, 2001 6:11 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: 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 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 mySQL /data directory, and there never was any such file. I can still start the old server without error. Any suggestions are welcome. OS:RedHat Linux 6.2 DIST: Built from source - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 through the install process several times without a change in symptoms. Oh, the correct number of rows are returned - the data is just unusable. Any help is appreciated. - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 17, 2001 8:35 AM Subject: Re: mm.mysql.jdbc-1.2c and applets Applet don't allow bulid new socket connection, which will do when you make a connection from applet to database. The solution is writing a servlet to let applet call it. On Wed, 17 Jan 2001, Paulo Mora de Freitas wrote: Dear All, Could someone help me to access my mysql database from an applet with mm.mysql.jdbc-1.2c? The problem is that when trying to access a mysql database from an applet using Netscape it get an AppletSecurityException (described at end of this message). But the mm.mysql.jdbc-1.2c documentation says that "it allows Java developers to make connections to MySQL servers from both Java applications and applets", so I don't understand what is wrong. The same piece of code works nice if running as an application. Cheers, Paulo Mora de Freitas. Nestacape error message: netscape.security.AppletSecurityException: security.Couldn't connect to 'aldebaran.in2p3.fr' with origin from 'local-classpath-classes'. at netscape.security.AppletSecurity.checkConnect(AppletSecurity.java:776) at java.lang.SecurityManager.checkConnect(SecurityManager.java:718) at java.net.InetAddress.getAllByName0(InetAddress.java:457) at java.net.InetAddress.getByName(InetAddress.java:367) at java.net.Socket.init(Socket.java:123) * at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:114) at org.gjt.mm.mysql.Connection.init(Connection.java:229) at org.gjt.mm.mysql.Driver.connect(Driver.java:126) at java.sql.DriverManager.getConnection(DriverManager.java:90) at java.sql.DriverManager.getConnection(DriverManager.java:146) at SimpleApplet.paint(SimpleApplet.java:50) at java.awt.Component.dispatchEventImpl(Component.java:1734) at java.awt.Container.dispatchEventImpl(Container.java:946) at java.awt.Component.dispatchEvent(Component.java:1715) at java.awt.EventDispatchThread$EventPump.dispatchEvents(EventDispatchThread.ja va:83) at java.awt.EventDispatchThread.run(EventDispatchThread.java:135) at netscape.applet.DerivedAppletFrame$AppletEventDispatchThread.run(DerivedAppl etFrame.java:911) SQLException: Cannot connect to MySQL server on aldebaran.in2p3.fr:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (netscape.security.AppletSecurityException) SQLState: 08S01 VendorError: 0 - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php