RE: Problem with UPDATE statement
In what way is it mangling my query? and why won't the same query work from my php script. I would accept this if it was just any interface but myphpadmin is supposed to be in line with mysql standards. update cdrequest set albumfill = hot shots II, releasedatefill = 20010708 where requstID = 2; i get: You have an error in your SQL syntax near '\hot shots II\, releasedatefill = 20010708 where requstID = 2' at line 1 I can't see any reason for the error. Your web based interface is mangling your query. part 2: when I flip to properties for the cdrequest just to make sure i'm spelling the columns corectly and cut and paste the exact same query on that page IT WORKS Why would it work on that page but not the other. both are supposed to be places where you can enter a normal sql query.. Because your web based interface is mangling your query. Try using the mysql command line client. It also doesn't work in my PHP script which is where I really want it to work. Paste 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
Re: Migrating from MS SQLserver to MySQL
try mssql2mysql; this is a VB/VBA script which can connect directly to MySQL, thus eliminating the need of temporary files http://www.kofler.cc/mysql/mssql2mysql.html Best wishes, Michael Kofler - 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: Problem with UPDATE statement
On Fri, Aug 10, 2001 at 02:19:21AM -0400, Julian Simpson wrote: In what way is it mangling my query? and why won't the same query work from my php script. I would accept this if it was just any interface but myphpadmin is supposed to be in line with mysql standards. update cdrequest set albumfill = hot shots II, releasedatefill = 20010708 where requstID = 2; i get: You have an error in your SQL syntax near '\hot shots II\, releasedatefill = 20010708 where requstID = 2' at line 1 I can't see any reason for the error. Your web based interface is mangling your query. Hi Julian. I'd recommend taking the suggestion and try the query through the command-line interface. If it works there, then you've isolated the problem to the interface you're using. Divide and conquer. BTW, should requstID be requestID? -- Maurice Aubrey [EMAIL PROTECTED] Watch the costs and the profits will follow. - Andrew Carnegie MySQL 3.22.32: up 21.9 days, processed 1,514,328,327 queries (799/sec. avg.) - 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
SELECT using IN on SET data
Hi, Whats the most efficient way of doing a SELECT ... IN on a field of datatype 'SET' ? Say you have four types of 'permissions': - superuser - poweruser - normal - guest Each user has a field, permissions, of type SET (superuser,poweruser,normal,guest); Each resource has a field, AllowAccessIf, as above Now I need to SELECT this,that,theother FROM table WHERE permissions IN (superuser,poweruser,normal,guest); his works fine if permissions is only one value, eg superuser OR poweruser, etc. However, if the user is superuser,normal, then ofcourse, it wont match... How do I get around this? I'd prefer NOT to have to have a separate table of 'permission types' or roles etc, as I feel this would slow the process down, and also complicate adding, modifying and removing users and resources. I'd prefer not to just have to go like IN (superuser,powersuer,normal, superuser,poweruser, superuser,normal, normal,guest, guest,superuser, poweruser...) (The example is kinda simplified so that the question was)... Siggy - 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: Problem with UPDATE statement
In what way is it mangling my query? and why won't the same query work from my php script. I would accept this if it was just any interface but myphpadmin is supposed to be in line with mysql standards. update cdrequest set albumfill = hot shots II, releasedatefill = 20010708 where requstID = 2; i get: You have an error in your SQL syntax near '\hot shots II\, releasedatefill = 20010708 where requstID = 2' at line 1 I can't see any reason for the error. Your web based interface is mangling your query. Hi Julian. I'd recommend taking the suggestion and try the query through the command-line interface. If it works there, then you've isolated the problem to the interface you're using. Divide and conquer. At this point I don't have telnet access on my host so I'm down to using scripts and myphpadmin. I've made a request to get telnet access and I'll let you know if command line helpsIn the meantime I'm going to try whatever mysql interfaces i can get my hands on. But it's my php script that Is the main problem. Even If command line does what it should and responds accordingly to a normal insert statement. It still doesn't help me to use it where i need itIn my code BTW, should requstID be requestID? Fortunately this was a typo i made only for the benefit of this group. rest assured I haven't been testing with a misspelled column name :) - 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: Problem with UPDATE statement
On 10-Aug-2001 Julian Simpson wrote: In what way is it mangling my query? and why won't the same query work from my php script. I would accept this if it was just any interface but myphpadmin is supposed to be in line with mysql standards. update cdrequest set albumfill = hot shots II, releasedatefill ^ here ^ and here use single quotes : $qry=update cdrequest set albumfill = 'hot shots II', ... Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table 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: SELECT using IN on SET data
On 10-Aug-2001 [EMAIL PROTECTED] wrote: Hi, Whats the most efficient way of doing a SELECT ... IN on a field of datatype 'SET' ? Say you have four types of 'permissions': - superuser - poweruser - normal - guest Each user has a field, permissions, of type SET (superuser,poweruser,normal,guest); Each resource has a field, AllowAccessIf, as above Now I need to SELECT this,that,theother FROM table WHERE permissions IN (superuser,poweruser,normal,guest); his works fine if permissions is only one value, eg superuser OR poweruser, etc. However, if the user is superuser,normal, then ofcourse, it wont match... How do I get around this? I'd prefer NOT to have to have a separate table of 'permission types' or roles etc, as I feel this would slow the process down, and also complicate adding, modifying and removing users and resources. I'd prefer not to just have to go like IN (superuser,powersuer,normal, superuser,poweruser, superuser,normal, normal,guest, guest,superuser, poweruser...) You could use the numeric value: select ... WHERE permissions|0 in (1,3) ... (The example is kinda simplified so that the question was)... Ya, guest,superuser burrr... Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table 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: programmatically getting field list from a table
On 10-Aug-2001 Bennett Haselton wrote: Is there any way -- using either MySQL directly, or (ideally) using the DBI perl module -- to get a list of fields from a (possibly empty) table? (If the table is nonempty, you can just use a perl function to get the first record, and then apply keys() to the returned reference to get the field names.) $dbh-listfiels('da_table'); Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table 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
Installing MySQL on Linux 7.1
Excuse Me, I'm a starter to Linux. I've downloaded the MySQL-3.23.40-1 for my Linux OS. They are in .rpm form. How can I install the software properly on Linux? I try to follow the instructions mentioned in manual.txt but it didn't work. Can you help me and tell my how to install it via RPM? Thanks! Please send me the solution. E-mail : [EMAIL PROTECTED]
Re: Optimising for 4096MB RAM
Corin Hartland-Swann wrote: Hi there, I am trying to optimise MySQL for use on a machine with: Linux 2.4.7-ac9 (only kernel to work with the disk controller) Dual Pentium III 1000 MHz 4096 MB memory RAID-1 Mirror over two 76GB 7200 RPM UDMA disks Reiserfs partition for MySQL As a reference point, I am running the benchmarking tests to measure the performance. I plan on measuring the performance with our particular queries after this. After reading the section of the manual dealing with performance tuning, I used the following in my.cnf: [mysqld] set-variable = join_buffer=2048M set-variable = key_buffer=2048M set-variable = table_cache=1024 set-variable = max_allowed_packet=16M set-variable = max_connections=200 set-variable = record_buffer=2048M set-variable = sort_buffer=2048M set-variable = tmp_table_size=2048M Take care, record_buffer and sort_buffer are allocated on a per thread basis. According to your setup, you may need up to (record_buffer+sort_buffer)*max_connections = 800 Gb RAM ! Your mysqld process will certainly coredump ! Also remember that Linux on a 32 bits machine cannot allocate more than ~3 Gb per process. The problem is that these settings don't seem to have practically any effect on the amount of memory that MySQL uses when running the benchmarking suite - I expected it to chew up large amounts of memory with these settings. MySQL is currently only taking up 25MB of RAM - not the 512MB plus I was expecting. Your test is not heavy enough ! MySQL allocates memory only when needed, it does not preallocate it at startup. This machine is going to be a dedicated database server for a number of web servers - I expected MySQL to take up about half the memory, and disk caching the other half. I want it to run like a beast posessed :) Does anyone have any real world examples and/or suggestions for how to increase the performance? Any other variables I should be looking at? I would suggest that: - look closely at http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html and be careful with variables that have effect on a per thread connection basis. - search mysql mailing list archives, there were some discussions on these topics (for instance, key_buffer setup). When the machine is operational, the biggest table I expect to be using has 55 million rows and takes up about 2G disk space (compressed, packed, everything). Please could you CC: any replies to me, since I am no longer on the list. Regards, Corin /+-\ | Corin Hartland-Swann |Tel: +44 (0) 20 7491 2000| | Commerce Internet Ltd |Fax: +44 (0) 20 7491 2010| | 22 Cavendish Buildings | Mobile: +44 (0) 79 5854 0027| | Gilbert Street | | | Mayfair|Web: http://www.commerce.uk.net/ | | London W1K 5HJ | E-Mail: [EMAIL PROTECTED]| \+-/ Regards -- Joseph Bueno NetClub/Trader.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: Installing MySQL on Linux 7.1
rpm -i mysql.rpm ? louie miranda (axishift.ath.cx) --- Security is not a product - It is a Process - Original Message - From: Alan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 10, 2001 3:45 PM Subject: Installing MySQL on Linux 7.1 Excuse Me, I'm a starter to Linux. I've downloaded the MySQL-3.23.40-1 for my Linux OS. They are in .rpm form. How can I install the software properly on Linux? I try to follow the instructions mentioned in manual.txt but it didn't work. Can you help me and tell my how to install it via RPM? Thanks! Please send me the solution. E-mail : [EMAIL PROTECTED] - 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: Installing MySQL on Linux 7.1
On Fri, 10 Aug 2001, Alan wrote: I'm a starter to Linux. I've downloaded the MySQL-3.23.40-1 for my Linux OS. They are in .rpm form. How can I install the software properly on Linux? I try to follow the instructions mentioned in manual.txt but it didn't work. Can you help me and tell my how to install it via RPM? You can take rpms from: ftp://devel.iasi.ro/pub/linux/redhat/7.x/i686/mysql-*3.23.40* Are from RawHide, but build on RedHat Linux 7.1. Before, try to do rpm -e MySQL-*, the versions you installed already. You need only to download and do a rpm -Uvh mysql-*. Regards. -- Cristian Paslaru http://devel.iasi.ro - 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: connecting by knowing someone's scrambled password?
Hi! On Aug 10, Carsten H. Pedersen wrote: http://www.mysql.com/doc/U/s/User_names.html says: MySQL encrypts passwords using a different algorithm than the one used during the Unix login process. See the descriptions of the PASSWORD() and ENCRYPT() functions in section 6.4.12 Miscellaneous Functions. Note that even if the password is stored 'scrambled', and knowing your 'scrambled' password is enough to be able to connect to the MySQL server! How is that possible? Even if you do know someone's scrambled password, when you connect to the MySQL server pretending to be that user, it will ask you for their non-scrambled password. After you type it in, the server will scramble it and check that the scrambled value matches the scrambled value stored in the database -- but you can't intercept that part of the process and insert the known scrambled password to be checked. -Bennett The manual certainly *does* need a clean-up on this. --- 4.3.6 Setting Up Passwords: ...When the user jeffrey attempts to connect to the server using this password, the mysql client encrypts it with PASSWORD() and sends the result to the server. The server compares the value in the user table... --- Which would explain why knowing the encrypted password is enough to gain access to the server (you would, of course, need to write your own version of the mysql where you skip the PASSWORD call). However, --- 4.2.8 Access Control, Stage 1: Connection Verification ...The encrypted password is then used when the client/server is checking if the password is correct (This is done without the encrypted password ever traveling over the connection.) ... --- These two statements surely contradict each other. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq Thanks, for pointing this out. Of course, the second statement is correct - MySQL authentification protocol is designed to never send anything reusable (e.g. password) over the wire. We will fix the manual. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: Add Character to Output
On Thursday 09 August 2001 17:58, Bernhard Doebler wrote: I have a select statement and want to add a Percent sign to the output of one expression. Do I have to use Concat-function or is there another way (for only one character)? AFAIK concat is the only way in MySQL, viz: SELECT CONCAT(vat, '%') AS vat_pc FROM price You could of course keep a copy of the numeric value with an added %-sign in a seperate text field, but I'm sure that would only complicate things further ;-) Now if only MySQL supported VIEWs ... (*) HTH Ian Barwick (*) See: http://www.mysql.com/doc/M/i/Missing_Views.html -- Ian Barwick - Developer - [EMAIL PROTECTED] akademie.de asp GmbH - http://www.akademie.de To query tables in a MySQL database is more fun than eating spam - 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
PROCEDURE ANALYSE
Hi, I try to optimize my tables. To see possible errors I use SELECT statements with PROCEDURE ANALYSE. I have a table that holds unique strings and an index by whitch it's referenced to another table. PROCEDURE ANALYSE advises as datatype for the strings to take an enum of (String1,String2,String3,String4,String5,String6,... to 191) Why doesnt it simply (intelligently in that case) advise to take varchar(50)??? Best regards Bernhard - 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 problems
Luc Foisy wrote: We are looking for a solution to backing up a remote database, without using mysqldump, and replication seemed to offer the solution required. I set up the master/slave configurations on both the master and the slave exactly the way it was shown in the MySQL documentation (4.10.3 How To Set Up Replication), With some additional options as shown: MASTER my.cnf [mysqld] log-bin binlog-do-db=masterslave server-id=1 SLAVE my.cnf [mysqld] master-host=172.16.0.100 master-user=rep1 master-password='yesmaster' master-port=3306 server-id=2 replicate-do-db=masterslave I checked the slave status thinking it was telling me everything was fine mysql show slave status; | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | | 172.16.0.100 | rep1| 3306| 60 | | 4| Yes | masterslave | | I made some updates on the master, a couple of inserts and deletes. Not a thing happened to the slave after a few minutes. I checked the error log to see if anything was wrong and this was written a few times (assuming each new attempt at a connection) 010809 13:16:51 Slave thread: error connecting to master:Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)(0), retry in 60 sec I re-input my GRANT several times (checking/retyping the password each time), then connected remotely with the mysql -h option (not a problem) Has anyone else encountered this problem, and/or does anyone have a solution.. Have you given file privilege to user rep1 on your master server? -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - 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 mysql time and the system time
Hi, Since yesterday I'm reading all I can find on MySQL to solve my problem. in mysql : mysqlselect now(); +-+ | now() | +-+ | 2001-08-10 07:28:56 | +-+ 1 row in set (0.00 sec) But on the system : (Linux Red Hat 7.1) /home/gael date Fri Aug 10 09:38:15 BST 2001 There is a difference of 2 hours between them. How can I tell MySQL to follow the system date and time ? Thanks [EMAIL PROTECTED] - 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: About installing MySQL on Linux 7.1
On Thu, Aug 09, 2001 at 02:45:23PM +0800, Alan wrote: Excuse Me, I'm a starter to Linux. I've downloaded the MySQL-3.23.40-1 for my Linux OS. They are in .rpm form. How can I install the software properly on Linux! = I try to follow the instructions mentioned in manual.txt but it didn't = work. Can you help me and tell my how to install it? Thanks! Hi, Normally a simple rpm -ivh mysql-3.23.40-1.rpm (or whatever the file is called) should do it. If it doesn't, can you post the output of rpm to this list? Did you download the right package? Which distribution do you use? BTW: Perhaps your distribution has a version numer of 7.1, but the newest Linux kernel is 2.4.7 ;) With regards, -- Mario Witte [EMAIL PROTECTED] - 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: PROCEDURE ANALYSE
Hi! On Aug 10, Bernhard Doebler wrote: Hi, I try to optimize my tables. To see possible errors I use SELECT statements with PROCEDURE ANALYSE. I have a table that holds unique strings and an index by whitch it's referenced to another table. PROCEDURE ANALYSE advises as datatype for the strings to take an enum of (String1,String2,String3,String4,String5,String6,... to 191) Why doesnt it simply (intelligently in that case) advise to take varchar(50)??? Best regards Bernhard Because ENUM takes less space and is faster. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: mySQL DSN and PHP
Date |Thu, 9 Aug 2001 10:36:59 +0800 From |Steve Doig [EMAIL PROTECTED] Hello! SD $link = mysql_connect(mySQL_test, mysql_login, mysql_password) SD or die (Could not connect); SD print (Connected successfully); SD mysql_select_db (test) SD or die (Could not select database); I think you need to use mysql_connect(localhost, mysql_login, mysql_password); cause mySQL_test doesn't look like normal DNS record. SD In my ODBC sources I have a user DSN of SD name: mySQLtest SD driver: mySQL SD mySQL host: 127.0.0.1 SD mySQL database name: test If you use mysql_* function you do it not through ODBS but use direct mysql connection. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.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: About MYSQLGUI
Date |Thu, 9 Aug 2001 10:38:09 +0800 (CST) From |[EMAIL PROTECTED] Hello! T Dear sir, T I have a problem, I run the MYSQL GUI on my Server, but it always say that Can't connect to local Mysql through socket (111) This message tell what you try connect to local mysql and does'nt set up MySQL GUI properly. You need to set Sql command on connect ( or socket ) entry field to you socket path. in my case (RH linux) it /var/lib/mysql/mysql.sock T What is that socket? T I have already input the port and the server name. What do i need to do or need to set config or..??? please show me the way!! ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.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: MySQLdump failure
Date |Wed, 8 Aug 2001 23:02:26 -0400 From |Wendell Dingus [EMAIL PROTECTED] Hello! WD Right after that last C is my # command prompt with no line-ending character WD in the file. It gets part way through the describe of the table layout and WD stops. Using phpMyAdmin I can view everything just fine and even renamed WD that one field and then named it back thinking there could be a hidden WD control character in the name or something. The one thing to note is that WD there are a LOT of fields in this one table, 500+ I'd guess. Other databases WD on this server (none this large but some fairly large) dump just fine. This WD is the only one with a problem. WD I've even ran mysqldump on other servers with a -h pointing over to this WD server to try to get a dump of the data and see the same results. All WD selects against this database seem to run fine (and fast) and I've rebooted WD and shut down/restarted mysql multiple times. WD I'm at a loss and have to suspect it might be a mysql bug at this point... WD Thanks in advance! WD PS. Threw in a -t to mysqldump to not produce the table create data and it WD got about 20K (versus ~40K previously) into the dump and stopped at the end WD of an insert. Plenty of RAM and plenty of disk space on the server too... try to start mysqldump with -q key. It's tell to mysqldump do not use output buffer. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.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: About installing MySQL on Linux 7.1
Date |Thu, 9 Aug 2001 14:45:23 +0800 From |Alan [EMAIL PROTECTED] Hello! A Excuse Me, A I'm a starter to Linux. A I've downloaded the MySQL-3.23.40-1 for my Linux OS. A They are in .rpm form. How can I install the software properly on Linux! = A I try to follow the instructions mentioned in manual.txt but it didn't = A work. A Can you help me and tell my how to install it? Thanks! Please read man rpm to install .rpm files properly. In short words - use rpm -ihv Your_Rpm_files to install it. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.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: mysqlgui 1.7.5 source
Date |Thu, 09 Aug 2001 23:54:16 -0400 From |Bo Green [EMAIL PROTECTED] Hello! BG The source package for mysqlgui Makefile references an BG object 'edfile' which is not included in the source package BG (at Aug 9, 2001). When I try to compile without that object, BG I get a missing function error. BG Can anyone suggest where I can find this mysterious edfile? BG Thanks. BG Bo Green You need to download also fl_editor widget for fltk from this url: http://www.mysql.com/Downloads/mysqlgui/fl_editor-0.4.tar.gz ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.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: problem!!
Date |Thu, 9 Aug 2001 20:58:14 -0300 (ART) From |Raoni Novellino [EMAIL PROTECTED] Hello! RN I installed MySQL 3.23.40 perfectly without RN ploblems... but I installed MySQL for database to PHP RN 4.0.6 with Apache 1.3.20... but when I compile Apache, RN this error ocours: RN === src/modules RN gcc -c -I./os/unix -I./include -DLINUX=22 RN -I/usr/local/php-4.0.6 -I/usr/local/php-4.0.6/main RN -I/usr/local/php-4.0.6/main RN -I/usr/local/php-4.0.6/Zend RN -I/usr/local/php-4.0.6/Zend RN -I/usr/local/php-4.0.6/TSRM RN -I/usr/local/php-4.0.6/TSRM -I/usr/local/php-4.0.6 RN -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED RN `./apaci` modules.c RN gcc -c -I./os/unix -I./include -DLINUX=22 RN -I/usr/local/php-4.0.6 -I/usr/local/php-4.0.6/main RN -I/usr/local/php-4.0.6/main RN -I/usr/local/php-4.0.6/Zend RN -I/usr/local/php-4.0.6/Zend RN -I/usr/local/php-4.0.6/TSRM RN -I/usr/local/php-4.0.6/TSRM -I/usr/local/php-4.0.6 RN -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED RN `./apaci` buildmark.c RN gcc -DLINUX=22 -I/usr/local/php-4.0.6 RN -I/usr/local/php-4.0.6/main RN -I/usr/local/php-4.0.6/main RN -I/usr/local/php-4.0.6/Zend RN -I/usr/local/php-4.0.6/Zend RN -I/usr/local/php-4.0.6/TSRM RN -I/usr/local/php-4.0.6/TSRM -I/usr/local/php-4.0.6 RN -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED RN `./apaci`\ RN -o httpd buildmark.o modules.o RN modules/standard/libstandard.a modules/php4/libphp4.a RN main/libmain.a ./os/unix/libos.a ap/libap.a RN lib/expat-lite/libexpat.a RN -Wl,-rpath,/usr/local/mysql-3.23.40-pc-linux-gnu-i686/lib RN -rdynamic RN -L/usr/local/mysql-3.23.40-pc-linux-gnu-i686/lib RN -Lmodules/php4 -L../modules/php4 -L../../modules/php4 RN -lmodphp4 -lpam -ldl -lmysqlclient -lcrypt -lresolv RN -lm -ldl -lnsl -lresolv -lm -lcrypt RN /usr/local/mysql-3.23.40-pc-linux-gnu-i686/lib/libmysqlclient.a(my_compress.o): RN In function `my_uncompress': RN my_compress.o(.text+0x9a): undefined reference to RN `uncompress' RN /usr/local/mysql-3.23.40-pc-linux-gnu-i686/lib/libmysqlclient.a(my_compress.o): RN In function `my_compress_alloc': RN my_compress.o(.text+0x12a): undefined reference to RN `compress' RN collect2: ld returned 1 exit status RN make[2]: *** [target_static] Error 1 RN can you give-me a help plis?? You need to add to Makefile linking of zlib libraries. so you need to add -lz key to gcc command lines. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.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: Protection of /tmp/mysql.sock
Date |Thu, 9 Aug 2001 14:33:37 -0400 (EDT) From |sachin shetty [EMAIL PROTECTED] Hello! SS Hi SS i think this isnt a purely mysql specific question but surely related. I SS have a stick bit set on the /tmp directory(Solaris) where the socket file SS resides.But there is no protection on the file because ppl apart from the SS owner of the file can delete the file.. SS Sachin You can set up socket permissions properly. I mean what untrusted users must be removed from mysql group and socket file permission must be changed to srwxrwx--- for example You can move mysql socket file to some other path also. For example to /var/lib/mysql/ or to /var/tmp etc... ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.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
HOWTO enable InnoDB
Hi everyone. I uninstalled mysql and reinstalled using --with-innodb configuration. After install completed, I entered the command mysqladmin variables and found that value of have_innodb is DISABLED. So when I create table with type=InnoDB, this table has type=MyISAM. That is failure to create InnoDB type table. Mysql version is 3.23.40. Please answer to me. Thanks in advance!! - 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: Binary transaction log
Michael T. Babcock writes: I've been reapplying transactions to my aforementioned screwed up database. It seems however, that the binary transaction log doesn't quite work properly with user variables (with MySQL 3.23.38). I have this entry from the log: insert into Projects (ParentID, Name, LongDesc) values (@customer, VPN, VPN Work); I remember doing that transaction, and I'd done a SELECT @customer:=ID WHERE ... beforehand. Since that SELECT isn't stored in the binary log (that I can find), the value for @customer is NULL. This just seems like a bug to me (I know what my SELECT was, so I've redone it, but this would be a problem for large-scale restoring). PS. Now I feel like I'm flooding the list, but that's ok ... -- Michael T. Babcock CTO, FibreSpeed Yes, this definitely looks like an omission by our part. We shall investigate and fix the matter. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.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: HOWTO enable InnoDB
Hello ½ÉÃ溸, Friday, August 10, 2001, 2:27:56 PM, you wrote: DISABLED means you're running with --skip-innodb AFAIK :) ½ Hi everyone. ½ I uninstalled mysql and reinstalled using --with-innodb configuration. ½ After install completed, I entered the command mysqladmin variables and ½ found that value of have_innodb is DISABLED. ½ So when I create table with type=InnoDB, this table has type=MyISAM. That ½ is failure to create InnoDB type table. ½ Mysql version is 3.23.40. ½ Please answer to me. ½ Thanks in advance!! ½ - ½ 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 -- Best regards, Petermailto:[EMAIL PROTECTED] - 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: Fatal warning in MySQL build Sun Solaris x86
Jeff Tanner writes: mysql.cc, line 1187: [__1cVbuild_completion_hash6Fbb_v_]: OPT: Unknown linkage type in dependency graph 1 fatal error Ideas? Thanks Jeff Tanner Seattle, WA Your C++ compiler is broken. Please re-install entire GNU 2.95.2 suite. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.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: HOWTO enable InnoDB
At 19:27 10/08/2001 +0900, =?euc-kr?B?vcnD5rq4?= wrote: Hi! Are you set the my.cnf file for the InnoDB variables and created the data and log directories before the start of the server ?. Take a look in the server_name.err file if you find the message of InnoDB mentioning that wasn't be able to init the database. If true, read the Manual about. Regards, Miguel Hi everyone. I uninstalled mysql and reinstalled using --with-innodb configuration. After install completed, I entered the command mysqladmin variables and found that value of have_innodb is DISABLED. So when I create table with type=InnoDB, this table has type=MyISAM. That is failure to create InnoDB type table. Mysql version is 3.23.40. Please answer to me. Thanks in advance!! - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.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: BSD/OS 4.1 binary for MySql
David Ross writes: Is the freebsd-elf mysql binary available at mysql.com compatible with BSD/OS (bsdi) 4.1? If not, is there a place to download this binary...or am I stuck with building it myself? Thanks, David You should build it yourself. Just follow instructions from the manual. Also use 4.3 as 4.1 has some serious threads problems. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.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
MySQL Query problem, possible bug?
Hello, Today, I tried to move a part of one of my websites, a forum (vBulletin, www.vbulletin.com) to a new server: a FreeBSD server. I installed the package mysql-3.23.40-unknown-freebsdelf4.3-i386.tar.gz on that server, and everything seemed to work perfectly: installation complete, and phpMyAdmin worked perfectly. I reinstalled the forums on the new FreeBSD server (the old one was RH-Linux 7.0), that also went good: I entered the admin, it worked good. Then, I tried to enter the forums, and got a database error: SQL Query: SELECT findword,replaceword FROM replacement WHERE replacementsetid IN(-1,'1') ORDER BY replacementsetid DESC,replacementid DESC Error: Lost connection to MySQL server during query I found out the connection was lost because MySQL crashes: /usr/libexec/ld-elf.so.1: ./mysqld: Undefined symbol strtoll Anyone is familliar with this problem? This query DID work on the previous server, the RedHat one, but just doesn't work on the FreeBSD server. The databases are EXACTLY the same, so there shouldn't be any problems. Or should it? Anyway, thanks in advance for your replies, Leon Mergen [EMAIL PROTECTED] President of Operations BlazeBox, Inc. ICQ: 55677353
Re: mysqlgui 1.7.5 source
I have fltk, flvw, fleditor and the mssql++ libraries linked in, I'm pretty sure this is not the answer, but I could be wrong... Bo Grigory Bakunov wrote: Date |Thu, 09 Aug 2001 23:54:16 -0400 From |Bo Green [EMAIL PROTECTED] Hello! BG The source package for mysqlgui Makefile references an BG object 'edfile' which is not included in the source package BG (at Aug 9, 2001). When I try to compile without that object, BG I get a missing function error. BG Can anyone suggest where I can find this mysterious edfile? BG Thanks. BG Bo Green You need to download also fl_editor widget for fltk from this url: http://www.mysql.com/Downloads/mysqlgui/fl_editor-0.4.tar.gz ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.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
Relication
Hello All I'm new to MySQL although I have experience with SQL Server and MS Access. My current ISP offers MySQL and I would like to make it possible for one of my customers to transfer there data from MS Access to MySQL. This is fine and I know how to do this using ODBC(). But then I would like to have a local copy of the MySQL database on there office network, which replicates with the Internet version. My questions are is this possible and can somewhere send me some websites with has this information Thanks Neil _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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
hello
Hi,everybody! I want to write a Client GUI DBMS for Mysql,but I don't know how to start. Anyone can tell me about the API,how to get it,how to begin? (I should use create,drop,insert,delete,update...) thank you very much _ 24СʱËø¶¨ËѺüÐÂÎÅÖÐÐÄ£¬ÈÈÁÒ×£ºØ±±¾©Éê°ÂÔ²Âú³É¹¦£¡ http://sports.sohu.com/bj2008.shtml - 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
Annoying Too Many Connection error...
Hi, I've just seen when the maximum connection number is reached and you try to shutdown MySQL with mysqladmin shutdown, it couldn't be executed because of too many connections error. It would be smarter if mysqladmin could shutdown MySQL whatever the number of connections, even if the maximum connection ratio is reached. What do you think about it ? Jocelyn Fournier Presence-PC www.presence-pc.com