Virtual IP
hello! i wanted to create a virtual IP so i inserted the following line in the /etc/haresources file: server1 Ipaddress::192.168.1.1::eth0 but when i started heartbeat, i got the following error messages in the command line: Starting High-Availability services: 2006/01/24_23:11:44 ERROR: Cannot locate resource script Ipaddress /usr/lib/heartbeat/ResourceManager: line 197: 192.168.1.1: command not found [FAILED] how do i configure a virtual IP? i am using heartbeat 2.0.2 in Fedora Core 4 and i want to set up a virtual IP address because i will use MasterMySQL... Should my haresources file contain only one line? and also, what's the difference between IPaddr and Ipaddress? i hope you can help thank you. chEn Send instant messages to your online friends http://uk.messenger.yahoo.com
Re: UK Postcodes
On 1/24/06, James Harvard [EMAIL PROTECTED] wrote: It's the Royal Mail. Ordnance Survey, the government mapping agency for the UK, are in on it too. To read their web site (as I have done a couple of years ago, and just now too) you would think it had never occurred to them that people might want to deploy the data as part of a web site. It's all about licensing the data by the number of 'terminals'. Extraordinary. Their prices are fairly extraordinary too. I've always meant to write and complain to Royal Mail, Ordnance Survey, the RM's independent regulator and anyone else I could think of about this inflated, monopoly pricing which can only be hindering UK businesses from developing localised on-line services. I guess we'll wait until Google or Yahoo gets them online. :-) We only need to do 1 lookup for the address for each listing and store it in our database so hopefull they'll offer it in the UK like Yahoo Local does for the U.S. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 回复: Re: MySQL 4.1 and PHP 4.4
Hello. collation. PHP 4.4 doesn't provide API to work with Connection Character Sets and Collations. PHP 5 adds You can change the character_set_xxx variables using SQL queries. I usually put 'SET NAMES' at the beginning of my scripts. 立 周 wrote: --- Gleb Paharenko [EMAIL PROTECTED]写道: Hello. From my experience PHP 4.4 works fine with MySQL 4.1. What troubles are you getting while restoring utf8 database to the server? Please, could you explain more in detail all steps of the restoring process. Include information about database character set as well. I think the problem is: the server is running mysqld with latin chracter set and latin_swidish_ci collation ( the default ). But my database is utf8 encoded ( mainly Simplified Chinese ) with utf8_general_ci collation. PHP 4.4 doesn't provide API to work with Connection Character Sets and Collations. PHP 5 adds this and you can also compile PHP 4.4 with mysqli ( MySQL Improved ) extension to bring this API to PHP 4.4. But on a shared hosting plan, i obviously have no access to any of these solutions. Lionel ___ 雅虎1G免费邮箱百分百防垃圾信 http://cn.mail.yahoo.com/ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 2016 and 2013
Hello. See: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html David Godsey wrote: nativecode=2013 ** Lost connection to MySQL server during query I think 2016 is Lost database connection What I am doing is I have a PHP class object that calls a stored procedure. I don't think I'm hitting any timeouts because it happens in less than a second. So here is my stored procedure: create procedure getElement (IN n VARCHAR(255),IN ptime DOUBLE) BEGIN DECLARE mfid INT UNSIGNED; DECLARE pid INT UNSIGNED; DECLARE foffset INT UNSIGNED; DECLARE flength INT UNSIGNED; DECLARE vid INT UNSIGNED; DECLARE rfid INT UNSIGNED; DECLARE tpid INT UNSIGNED; DECLARE fdata BLOB; DECLARE fdata_tmp BLOB; DECLARE fdata_bigint BIGINT UNSIGNED; DECLARE fdata_signed INT; DECLARE fdata_unsigned INT UNSIGNED; DECLARE fdata_float DOUBLE; DECLARE data_type VARCHAR(20); DECLARE byte_order VARCHAR(20); DECLARE conv_param VARCHAR(255); SELECT major_frame_desc_id, parent_id, frame_offset, frame_length, version_id, top_level_parent_id FROM MajorFrameDescription WHERE name=n INTO mfid,pid,foffset,flength,vid,tpid; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=NormalizedType INTO data_type; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=ConvParams INTO conv_param; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=ByteOrder INTO byte_order; SELECT MAX(raw_major_frame_id) FROM RawMajorFrames WHERE major_frame_desc_id=tpid INTO rfid; IF rfid 0 THEN SELECT payload_time, SUBSTR(BINARY(frame_data), FLOOR(foffset/8)+1, CEIL((flength + (foffset %8 ))/8)) FROM RawMajorFrames WHERE raw_major_frame_id=rfid INTO ptime,fdata; call toBigInt(fdata,fdata_bigint); IF (foffset %8) 0 THEN SET @mask_off=foffset%8; call mask_data(fdata,@mask_off,fdata_bigint); END IF; IF (8-((flength+(foffset%8)) %8)) 0 THEN SELECT (fdata_bigint (8-((flength+(foffset%8)) %8))) INTO fdata_bigint; END IF; CASE data_type WHEN Float THEN call toFloat(fdata_bigint,fdata_float); IF(!ISNULL(conv_param)) THEN call polyConv(fdata_float,conv_param,fdata_float); END IF; SET @fdata_converted=fdata_float; WHEN Double THEN call toFloat(fdata_bigint,fdata_float); IF(!ISNULL(conv_param)) THEN call polyConv(fdata_float,conv_param,fdata_float); END IF; SET @fdata_converted=fdata_float; WHEN Signed THEN call toSigned(fdata_bigint,fdata_signed); SET @fdata_converted=fdata_signed; WHEN Unsigned THEN SET @fdata_converted=fdata_bigint; ELSE SET @fdata_converted=HEX(fdata); END CASE; call enumConv(fdata_bigint,mfid,@fdata_enum); IF(!ISNULL(@fdata_enum)) THEN SET @[EMAIL PROTECTED]; END IF; SELECT mfid AS major_frame_desc_id, nAS name, pid AS parent_id, tpid AS
Re: mysql 5.0.18: Bind on unix socket: Permission denied
Hello. Make several checks that should help. Be sure that no instances of MySQL are running on your computer and check if 5.0.18 starts successfully. Specify another location of the socket file. Temporary disable SELinux. See: http://dev.mysql.com/doc/refman/5.0/en/starting-server.html Nathan Gross wrote: Yesterday I installed the XAMPP (used to be called LAMP) stack, which includes mysql 5.0.18, on a Fedora Core 4 system. This seems like the quickest way of getting version 5 running WITHOUT clashing at all with my current install. Everything went 100% smooth, and I was able to copy my 4.x myisam based schemas over to the new directory (/opt/lampp/var/mysql), browse the data with mysql's gui clients as well as with the phpMysql console. (I do NOT bring both up simultaneously, and have disabled the autostart for the old one.) I changed the own and grp on the /opt/lampp directroy structure, with the owner now being mysql with full rights. I do not know at which point this happened but I can't bring up the thing any longer. This is what I get: 060124 14:15:44 mysqld started 060124 14:15:44 [ERROR] Can't start server : Bind on unix socket: Permission denied 060124 14:15:44 [ERROR] Do you already have another mysqld server running on socket: /opt/lampp/var/mysql/mysql.sock ? 060124 14:15:44 [ERROR] Aborting 060124 14:15:44 [Note] /opt/lampp/sbin/mysqld: Shutdown complete 060124 14:15:44 mysqld ended Your help is appreciated. -nat -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:system PRIVILEGED account Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-4.1.16-standard (MySQL Community Edition - Standard (GPL)) C compiler: C++ compiler: Environment: System: OSF1 ds201.cesca.es V5.1 2650 alpha Machine: alpha Some paths: /usr/bin/perl /sbin/make /usr/local/cygnus/tru64-010710/H-alphaev56-dec-osf5.1/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/cygnus/tru64-010710/H-alphaev56-dec-osf5.1/bin/../lib/gcc-lib/alphaev56-dec-osf5.1/2.97-tru64-010710/specs Configured with: /tantor/build/compaq-tru64/tru64-010710/alphaev56-dec-osf5.1/src/configure -v --host=alphaev56-dec-osf5.1 --build=alphaev56-dec-osf5.1 --prefix=/usr/cygnus/tru64-010710 --exec-prefix=/usr/cygnus/tru64-010710/H-alphaev56-dec-osf5.1 --target=alphaev56-dec-osf5.1 gcc version 2.97-tru64-010710 Compilation info: CC='cc' CFLAGS='-O2 -pthread -ansi_alias -ansi_args -fast -inline speed -speculate all' CXX='cxx' CXXFLAGS='-O2 -pthread -ansi_alias -fast -inline speed -noexceptions -nortti' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx 1 root system17 Jul 2 2004 /lib/libc.a - ../ccs/lib/libc.a lrwxrwxrwx 1 root system17 Jul 2 2004 /usr/lib/libc.a - ../ccs/lib/libc.a Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL Community Edition - Standard (GPL)' '--with-extra-charsets=complex' '--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' '--with-named-thread-libs=-lpthread -lmach -lexc -lc' '--disable-shared' '--with-zlib-dir=bundled' '--with-mysqld-ldflags=-all-static' '--with-readline' '--with-embedded-server' '--with-archive-storage-engine' '--with-innodb' 'CC=cc' 'CFLAGS=-O2 -pthread -ansi_alias -ansi_args -fast -inline speed -speculate all' 'CXXFLAGS=-O2 -pthread -ansi_alias -fast -inline speed -noexceptions -nortti' 'CXX=cxx' scripts/mysql_install_db --user=mysqlp Installing all prepared tables ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/db.MYI' (Errcode: 13) ERROR: 1146 Table 'mysql.db' doesn't exist ERROR: 1146 Table 'mysql.db' doesn't exist ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/host.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/user.MYI' (Errcode: 13) ERROR: 1146 Table 'mysql.user' doesn't exist ERROR: 1146 Table 'mysql.user' doesn't exist ERROR: 1146 Table 'mysql.user' doesn't exist ERROR: 1146 Table 'mysql.user' doesn't exist ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/func.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/tables_priv.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/columns_priv.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/help_topic.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/help_category.MYI'(Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/help_relation.MYI'(Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/help_keyword.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/time_zone_name.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/time_zone.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/time_zone_transition.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/time_zone_transition_type.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/time_zone_leap_second.MYI' (Errcode: 13) Fill help tables ERROR: 1146 Table 'mysql.help_topic' doesn't exist ERROR: 1146 Table 'mysql.help_category' doesn't exist ERROR: 1146 Table 'mysql.help_keyword' doesn't exist ERROR: 1146 Table 'mysql.help_relation' doesn't exist ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Re: Error 2016 and 2013
George Law gave me the answer: http://bugs.mysql.com/bug.php?id=14993 I had read the link you suggested, however it didn't really explain why I was getting the error. Thanks. David Godsey Hello. See: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html David Godsey wrote: nativecode=2013 ** Lost connection to MySQL server during query I think 2016 is Lost database connection What I am doing is I have a PHP class object that calls a stored procedure. I don't think I'm hitting any timeouts because it happens in less than a second. So here is my stored procedure: create procedure getElement (IN n VARCHAR(255),IN ptime DOUBLE) BEGIN DECLARE mfid INT UNSIGNED; DECLARE pid INT UNSIGNED; DECLARE foffset INT UNSIGNED; DECLARE flength INT UNSIGNED; DECLARE vid INT UNSIGNED; DECLARE rfid INT UNSIGNED; DECLARE tpid INT UNSIGNED; DECLARE fdata BLOB; DECLARE fdata_tmp BLOB; DECLARE fdata_bigint BIGINT UNSIGNED; DECLARE fdata_signed INT; DECLARE fdata_unsigned INT UNSIGNED; DECLARE fdata_float DOUBLE; DECLARE data_type VARCHAR(20); DECLARE byte_order VARCHAR(20); DECLARE conv_param VARCHAR(255); SELECT major_frame_desc_id, parent_id, frame_offset, frame_length, version_id, top_level_parent_id FROM MajorFrameDescription WHERE name=n INTO mfid,pid,foffset,flength,vid,tpid; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=NormalizedType INTO data_type; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=ConvParams INTO conv_param; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=ByteOrder INTO byte_order; SELECT MAX(raw_major_frame_id) FROM RawMajorFrames WHERE major_frame_desc_id=tpid INTO rfid; IF rfid 0 THEN SELECT payload_time, SUBSTR(BINARY(frame_data), FLOOR(foffset/8)+1, CEIL((flength + (foffset %8 ))/8)) FROM RawMajorFrames WHERE raw_major_frame_id=rfid INTO ptime,fdata; call toBigInt(fdata,fdata_bigint); IF (foffset %8) 0 THEN SET @mask_off=foffset%8; call mask_data(fdata,@mask_off,fdata_bigint); END IF; IF (8-((flength+(foffset%8)) %8)) 0 THEN SELECT (fdata_bigint (8-((flength+(foffset%8)) %8))) INTO fdata_bigint; END IF; CASE data_type WHEN Float THEN call toFloat(fdata_bigint,fdata_float); IF(!ISNULL(conv_param)) THEN call polyConv(fdata_float,conv_param,fdata_float); END IF; SET @fdata_converted=fdata_float; WHEN Double THEN call toFloat(fdata_bigint,fdata_float); IF(!ISNULL(conv_param)) THEN call polyConv(fdata_float,conv_param,fdata_float); END IF; SET @fdata_converted=fdata_float; WHEN Signed THEN call toSigned(fdata_bigint,fdata_signed); SET @fdata_converted=fdata_signed; WHEN Unsigned THEN SET @fdata_converted=fdata_bigint; ELSE SET @fdata_converted=HEX(fdata); END CASE; call enumConv(fdata_bigint,mfid,@fdata_enum); IF(!ISNULL(@fdata_enum)) THEN SET @[EMAIL PROTECTED]; END IF; SELECT mfid AS major_frame_desc_id, nAS name,
Re: synopsis of the problem (one line)
Hello. ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/db.MYI' (Errcode: 13) perror 13 OS error code 13: Permission denied Check that user mysqlp has access to /usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql. [EMAIL PROTECTED] wrote: Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: system PRIVILEGED account Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-4.1.16-standard (MySQL Community Edition - Standard (GPL)) C compiler: C++ compiler: Environment: System: OSF1 ds201.cesca.es V5.1 2650 alpha Machine: alpha Some paths: /usr/bin/perl /sbin/make /usr/local/cygnus/tru64-010710/H-alphaev56-dec-osf5.1/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/cygnus/tru64-010710/H-alphaev56-dec-osf5.1/bin/../lib/gcc-lib/alphaev56-dec-osf5.1/2.97-tru64-010710/specs Configured with: /tantor/build/compaq-tru64/tru64-010710/alphaev56-dec-osf5.1/src/configure -v --host=alphaev56-dec-osf5.1 --build=alphaev56-dec-osf5.1 --prefix=/usr/cygnus/tru64-010710 --exec-prefix=/usr/cygnus/tru64-010710/H-alphaev56-dec-osf5.1 --target=alphaev56-dec-osf5.1 gcc version 2.97-tru64-010710 Compilation info: CC='cc' CFLAGS='-O2 -pthread -ansi_alias -ansi_args -fast -inline speed -speculate all' CXX='cxx' CXXFLAGS='-O2 -pthread -ansi_alias -fast -inline speed -noexceptions -nortti' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx 1 root system17 Jul 2 2004 /lib/libc.a - ../ccs/lib/libc.a lrwxrwxrwx 1 root system17 Jul 2 2004 /usr/lib/libc.a - ../ccs/lib/libc.a Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL Community Edition - Standard (GPL)' '--with-extra-charsets=complex' '--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' '--with-named-thread-libs=-lpthread -lmach -lexc -lc' '--disable-shared' '--with-zlib-dir=bundled' '--with-mysqld-ldflags=-all-static' '--with-readline' '--with-embedded-server' '--with-archive-storage-engine' '--with-innodb' 'CC=cc' 'CFLAGS=-O2 -pthread -ansi_alias -ansi_args -fast -inline speed -speculate all' 'CXXFLAGS=-O2 -pthread -ansi_alias -fast -inline speed -noexceptions -nortti' 'CXX=cxx' scripts/mysql_install_db --user=mysqlp Installing all prepared tables ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/db.MYI' (Errcode: 13) ERROR: 1146 Table 'mysql.db' doesn't exist ERROR: 1146 Table 'mysql.db' doesn't exist ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/host.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/user.MYI' (Errcode: 13) ERROR: 1146 Table 'mysql.user' doesn't exist ERROR: 1146 Table 'mysql.user' doesn't exist ERROR: 1146 Table 'mysql.user' doesn't exist ERROR: 1146 Table 'mysql.user' doesn't exist ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/func.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/tables_priv.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/columns_priv.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/help_topic.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/help_category.MYI'(Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/help_relation.MYI'(Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/help_keyword.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/time_zone_name.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/time_zone.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/time_zone_transition.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql-standard-4.1.16-dec-osf5.1b-alphaev67/data/mysql/time_zone_transition_type.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file
Fwd: mysql-plain Digest 24 Jan 2006 10:16:15 -0000 Issue 3629
My web hosting server runs PHP 4.4 and MySQL 4.1. But PHP 4.4 doesn't fully support MySQL 4.1. and i have problems restoring a utf8 encoded database dumped from a MySQL 4.0 server to the new 4.1 server. Do i have any chance to get it working in this setup or should i persuade the hosting provider to either upgrade to PHP 5 so i can use Connection Character Sets and Collations in PHP or downgrade to MySQL 4.0? Lionel, Please give us more specific information about the nature of the problem you are having (eg error messages, codes, log file output). The password hashing algorithm changed in MySQL 4.1 which is possibly the cause of your problems with PHP client apps. Try updating the password for your MySQL database account as follows: SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd'); Now use these credentials to make a connection at parse some simple table data. It should work. Regards, Im -- http://www.ImranChaudhry.info MySQL Database Management Design Services -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help with query
From the result set below I have 22 rows and the only difference is the date. I was wondering if there was a way to get all of these results using GROUP BY instead of having to use LIMIT?? As this table grows I'm going to want to get a LIMIT 0,77 but would like it to be grouped by date. So basically I want 7 groups of results and in each group there should be 11 rows. Any idea how to do this? Should it be separate queries or should I just break down and use LIMIT? thanks My attempt was, but doesn't really work. SELECT region_id, date, page_hit, score FROM statistics WHERE date = '2006-01-29' GROUP BY region_id, date ORDER BY date DESC; +---++--+---+ | region_id | date | page_hit | score | +---++--+---+ | CE| 2006-01-23 | 978 | 6.72 | | FL| 2006-01-23 | 558 | 2.75 | | MA| 2006-01-23 | 312 | 0.09 | | MW| 2006-01-23 | 478 | 0.25 | | NA| 2006-01-23 | 4846 | 4.85 | | NC| 2006-01-23 | 3281 | 3.03 | | PN| 2006-01-23 | 3281 | 1.22 | | SW| 2006-01-23 | 1964 | 1.05 | | RM| 2006-01-23 | 1964 | 2.80 | | SO| 2006-01-23 | 173 | 0.11 | | SP| 2006-01-23 | 163 | 0.07 | | CE| 2006-01-29 | 978 | 6.72 | | FL| 2006-01-29 | 558 | 2.75 | | MA| 2006-01-29 | 312 | 0.09 | | MW| 2006-01-29 | 478 | 0.25 | | NA| 2006-01-29 | 4846 | 4.85 | | NC| 2006-01-29 | 3281 | 3.03 | | PN| 2006-01-29 | 3281 | 1.22 | | SW| 2006-01-29 | 1964 | 1.05 | | RM| 2006-01-29 | 1964 | 2.80 | | SO| 2006-01-29 | 173 | 0.11 | | SP| 2006-01-29 | 163 | 0.07 | +---++--+---+ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help with query
Jay Paulson [EMAIL PROTECTED] wrote on 01/25/2006 10:09:36 AM: From the result set below I have 22 rows and the only difference is the date. I was wondering if there was a way to get all of these results using GROUP BY instead of having to use LIMIT?? As this table grows I'm going to want to get a LIMIT 0,77 but would like it to be grouped by date. So basically I want 7 groups of results and in each group there should be 11 rows. Any idea how to do this? Should it be separate queries or should I just break down and use LIMIT? thanks My attempt was, but doesn't really work. SELECT region_id, date, page_hit, score FROM statistics WHERE date = '2006-01-29' GROUP BY region_id, date ORDER BY date DESC; +---++--+---+ | region_id | date | page_hit | score | +---++--+---+ | CE| 2006-01-23 | 978 | 6.72 | | FL| 2006-01-23 | 558 | 2.75 | | MA| 2006-01-23 | 312 | 0.09 | | MW| 2006-01-23 | 478 | 0.25 | | NA| 2006-01-23 | 4846 | 4.85 | | NC| 2006-01-23 | 3281 | 3.03 | | PN| 2006-01-23 | 3281 | 1.22 | | SW| 2006-01-23 | 1964 | 1.05 | | RM| 2006-01-23 | 1964 | 2.80 | | SO| 2006-01-23 | 173 | 0.11 | | SP| 2006-01-23 | 163 | 0.07 | | CE| 2006-01-29 | 978 | 6.72 | | FL| 2006-01-29 | 558 | 2.75 | | MA| 2006-01-29 | 312 | 0.09 | | MW| 2006-01-29 | 478 | 0.25 | | NA| 2006-01-29 | 4846 | 4.85 | | NC| 2006-01-29 | 3281 | 3.03 | | PN| 2006-01-29 | 3281 | 1.22 | | SW| 2006-01-29 | 1964 | 1.05 | | RM| 2006-01-29 | 1964 | 2.80 | | SO| 2006-01-29 | 173 | 0.11 | | SP| 2006-01-29 | 163 | 0.07 | +---++--+---+ Can you please explain what you mean by 7 groups of results and in each group there should be 11 rows. Eleven times seven is seventy-seven, the number of rows you already plan to be getting. I see two groups of results, each group consisting of 7 rows. What would you rather the output look like other than what you showed us? If you want seven separate sets of results, you have to run seven separate queries. All databases work that way. Maybe if you described your problem and your data and your data structures in greater detail, one of us may have a solution different than the one you are currently working on. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Collect SQL Statements
Hi, is there a possibility to collect the sql statements issued to a mysql db to analyse them?? perhaps there is an extra tool or script for this?? Thanks for any suggestions!
RE: Collect SQL Statements
Hello, MySQL has a few logs that can assist you in capturing statements: 1. The query log shows client connections and executed statements 2. The binary log shows all statements that change data (also used for replication) 3. The slow log shows all queries that took more than long_query_time seconds to execute or didn't use indexes See http://dev.mysql.com/doc/refman/5.0/en/log-files.html for more info on setting up and analyzing these logs. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Moeller, Thorsten, AO [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 25, 2006 9:15 AM To: mysql@lists.mysql.com Subject: Collect SQL Statements Hi, is there a possibility to collect the sql statements issued to a mysql db to analyse them?? perhaps there is an extra tool or script for this?? Thanks for any suggestions! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Collect SQL Statements
Hi, is there a possibility to collect the sql statements issued to a mysql db to analyse them?? perhaps there is an extra tool or script for this?? Thanks for any suggestions!
Re: Virtual IP
In the last episode (Jan 25), Chen Abella said: hello! i wanted to create a virtual IP so i inserted the following line in the /etc/haresources file: You're on the wrong mailing list :) Try the documentation at http://www.linux-ha.org/ , and the list archives at http://lists.linux-ha.org/mailman/listinfo/linux-ha . -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Server Shutdown, Start Restart
FreeBSD / UNIX platform, MySQL ver.4.0.16 Prob. of growing /tmp file, solved by introducing a cron job to clean up the folder intermittently. Prob.solve but new one created - mysql socket wiped out. Could not restart the server with all the standard methods. Complained of other running processes. Killed the orphaned processes runining. But still can't restart. So can't do a dump or any other back up action, so created a tar file of the data etc. Now I wanted to try an upgrade to a newer version but concerned about ability to restore data from the tarball. Does anyone have any idea of how I can effect a restart before running to do an Upgrade? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Semi-complicated delete
The better way to do this would be to have the cart.prod_id be a foreign key field that references products.id (available as of 3.23.44) and use ON CASCADE DELETE. But that alters your schema, and you want to think very hard about the problems it might create (and do it with your data on a test server first, so you can see any warnings or errors). -Sheeri On 1/11/06, Adrian Bruce [EMAIL PROTECTED] wrote: IN MySQL 5 you could use a sub query( http://dev.mysql.com/doc/refman/5.0/en/any-in-some-subqueries.html). However, i would try using a left join between cart and products and then bring back the results where the products.id field is 'NULL'. There may be a better way of doing this but that is what comes to mind first. Ade Scott Haneda wrote: 4.0.18-standard-log I have a table cart and a table products Key is as follows: products.id = cart.prod_id The problem I have is we have decided to store the users cart, so when they come back it is still in the same state they left it. Pretty usual stuff so far. Two things can possible happen that would make this bad: 1) product has been deleted 2) product has been disabled. Just before I am checking the user out, I want to fix this scenario with a delete statement. What I need to do is: DELETE FROM cart where cart.prod_id does not exist in the products table, or where 'online' = 0. There is a user_id that I match on as well, but that does not entirely matter to this question. Deleting where online = 0 is simple, but deleting where there is a lack of a matching product has me stumped. -- 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]
Re: Server Shutdown, Start Restart
Joseph E. Maxwell wrote: FreeBSD / UNIX platform, MySQL ver.4.0.16 Prob. of growing /tmp file, solved by introducing a cron job to clean up the folder intermittently. Prob.solve but new one created - mysql socket wiped out. Could not restart the server with all the standard methods. Complained of other running processes. Killed the orphaned processes runining. Aparently not. kill any process containing 'mysql' in the process name and restart the server. Alternatively: re-boot the server. But still can't restart. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Difficult Problem: SQLDescribeCol call on MySQL Error
This call works fine on Oracle, Access, MS SQL. But Not works on MySQL. MySQL 5.0.15, MySQL ODBC drive 3.51, The OP is Windows 2000/2003, Program in VC++ In my SQLDescribeCol call on MySQL I get correct value on: ColumnName, BufferLength, NameLengthPtr, NullablePtr I get corect value on DataTypePtr if the type is not Text. For Text, it return -1. I get correct value on ColumnSizePtr only if the column type is varchar, and datetime , I get all 0 on DecimalDigitsPtr. The SQLRETURN always 0. Any Instruction is welcome. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Semi-complicated delete
Has everyone forgotten that since v4.0, MySQL has a multi-table delete statement? http://dev.mysql.com/doc/refman/4.1/en/delete.html Your original query was almost it (Adrian was on the right track, too): DELETE cart FROM cart LEFT JOIN products prod WHERE prod.id is null or prod.online=0; Sheeri, your answer would have worked for the deleted products but not for those product still in the database but whose online status was changed to 0. Shawn Green Database Administrator Unimin Corporation - Spruce Pine sheeri kritzer [EMAIL PROTECTED] wrote on 01/25/2006 12:47:08 PM: The better way to do this would be to have the cart.prod_id be a foreign key field that references products.id (available as of 3.23.44) and use ON CASCADE DELETE. But that alters your schema, and you want to think very hard about the problems it might create (and do it with your data on a test server first, so you can see any warnings or errors). -Sheeri On 1/11/06, Adrian Bruce [EMAIL PROTECTED] wrote: IN MySQL 5 you could use a sub query( http://dev.mysql.com/doc/refman/5.0/en/any-in-some-subqueries.html). However, i would try using a left join between cart and products and then bring back the results where the products.id field is 'NULL'. There may be a better way of doing this but that is what comes to mind first. Ade Scott Haneda wrote: 4.0.18-standard-log I have a table cart and a table products Key is as follows: products.id = cart.prod_id The problem I have is we have decided to store the users cart, sowhen they come back it is still in the same state they left it. Pretty usual stuff so far. Two things can possible happen that would make this bad: 1) product has been deleted 2) product has been disabled. Just before I am checking the user out, I want to fix this scenario with a delete statement. What I need to do is: DELETE FROM cart where cart.prod_id does not exist in the products table, or where 'online' = 0. There is a user_id that I match on as well, but that does not entirely matter to this question. Deleting where online = 0 is simple, but deleting where there is a lack of a matching product has me stumped. -- 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]
Estimated Drive Space Requirements
If I have about 2Gb of raw text data to import everyday -- can I expect that to take up about 2Gb in a mySQL database ... slightly more.. double? Pretend there's no indexes for now. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Show row number
Is there a command in mysql that will return the row number. I tried rownum and rownum()
Re: Show row number
Clyde Lewis [EMAIL PROTECTED] wrote on 01/25/2006 01:41:30 PM: Is there a command in mysql that will return the row number. I tried rownum and rownum() No, rows do not exist in the base data of a MySQL database. They are called records and records may be stored in any order. Within some MySQL storage engines (particularly InnoDB), more than one of any record may exist in the database at the same time (depending on transaction activity) or in more than one place (NDB). Within the results of a SELECT query, the individual row number is only important to the client. You need to use whatever number your client library provides for you.( ex: in ADO you would use the Recordset.AbsolutePosition property) There is no internal record number that is exposed through any interface to any client. Now, there is a pointer to each record but that is not useful information to any system except the database server itself and cannot be used to query for a particular record because it is not part of the data but it is part of the metadata associated with each record. Records can move around within a database file (changing their pointers) so long as the data pointed to does not change. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
replication
Hi on a slave, is it possible to only stop the SQL Thread? (Slave_SQL_Running: Yes/No) i need to do some testing with my script and i got to make sure it reads that value correctly. regards Morten
Re: Show row number
Excellent explanation. Thanks again. CL At 02:00 PM 1/25/2006, [EMAIL PROTECTED] wrote: Clyde Lewis [EMAIL PROTECTED] wrote on 01/25/2006 01:41:30 PM: Is there a command in mysql that will return the row number. I tried rownum and rownum() No, rows do not exist in the base data of a MySQL database. They are called records and records may be stored in any order. Within some MySQL storage engines (particularly InnoDB), more than one of any record may exist in the database at the same time (depending on transaction activity) or in more than one place (NDB). Within the results of a SELECT query, the individual row number is only important to the client. You need to use whatever number your client library provides for you.( ex: in ADO you would use the Recordset.AbsolutePosition property) There is no internal record number that is exposed through any interface to any client. Now, there is a pointer to each record but that is not useful information to any system except the database server itself and cannot be used to query for a particular record because it is not part of the data but it is part of the metadata associated with each record. Records can move around within a database file (changing their pointers) so long as the data pointed to does not change. Shawn Green Database Administrator Unimin Corporation - Spruce Pine *** Clyde Lewis Database Administrator General Parts, Inc. 919-227-5100
RE: Show row number
Alternatively, you could try something like this : SET @rownum = 0; SELECT @rownum := @rownum + 1 AS rownumber_column, some_real_columnnames FROM your_table LIMIT 100 -Original Message- From: Clyde Lewis [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 25, 2006 3:14 PM To: [EMAIL PROTECTED] Cc: MySQL List Subject: Re: Show row number Excellent explanation. Thanks again. CL At 02:00 PM 1/25/2006, [EMAIL PROTECTED] wrote: Clyde Lewis [EMAIL PROTECTED] wrote on 01/25/2006 01:41:30 PM: Is there a command in mysql that will return the row number. I tried rownum and rownum() No, rows do not exist in the base data of a MySQL database. They are called records and records may be stored in any order. Within some MySQL storage engines (particularly InnoDB), more than one of any record may exist in the database at the same time (depending on transaction activity) or in more than one place (NDB). Within the results of a SELECT query, the individual row number is only important to the client. You need to use whatever number your client library provides for you.( ex: in ADO you would use the Recordset.AbsolutePosition property) There is no internal record number that is exposed through any interface to any client. Now, there is a pointer to each record but that is not useful information to any system except the database server itself and cannot be used to query for a particular record because it is not part of the data but it is part of the metadata associated with each record. Records can move around within a database file (changing their pointers) so long as the data pointed to does not change. Shawn Green Database Administrator Unimin Corporation - Spruce Pine *** Clyde Lewis Database Administrator General Parts, Inc. 919-227-5100 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Estimated Drive Space Requirements
HI, 2006/1/25, Cummings, Shawn (GNAPs) [EMAIL PROTECTED]: If I have about 2Gb of raw text data to import everyday -- can I expect that to take up about 2Gb in a mySQL database ... slightly more.. double? It all depends on your columns, indexes, and so on... http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html Without any more details, we can't help you precisely. Pretend there's no indexes for now. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: replication
SLAVE STOP; or STOP SLAVE; work equally well. Or am I not understanding your question correctly? -Sheeri On 1/25/06, Morten Kallesøe [EMAIL PROTECTED] wrote: Hi on a slave, is it possible to only stop the SQL Thread? (Slave_SQL_Running: Yes/No) i need to do some testing with my script and i got to make sure it reads that value correctly. regards Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query
Check out: http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html http://dev.mysql.com/doc/refman/5.0/en/gone-away.html (I've noticed this has come up a lot recently on the list. . .) -Sheeri On 1/24/06, Jonathan Mangin [EMAIL PROTECTED] wrote: I got exactly that error message last night when doing a numeric comparison on a varchar column. Oops. Kind of misleading, though. - Original Message - From: David Godsey [EMAIL PROTECTED] To: George Law [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, January 24, 2006 4:43 PM Subject: RE: Lost connection to MySQL server during query Thanks for the reply. I'm not using persistend connections though. It appears that it looses the connection in the middle of the query or in other words, before the procedure returns. So that means I not getting the data I need. So for debug purposes, are you saying to do a check status from PHP or in the procedure? From the procedure it wouldn't do any good right? From PHP it would be after I didn't get the data, so I would have to reconnect and rerun the query. That won't really work for me either. David Godsey David, Are you using persistent connections? Sounds like perhaps a persistent connection is timing out. Maybe a quick work around would be to call a check status routine (ie - do a show status), just to see if the connection is still there. If this fails, just do a mysql_connect... Before continuing. -- George -Original Message- From: David Godsey [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 24, 2006 4:09 PM To: mysql@lists.mysql.com Subject: Lost connection to MySQL server during query I am getting this error when connecting to mysql with PHP: Lost connection to MySQL server during query This happens only when I use this procedure, but it doesn't necessarily fail when this procedure is called. The error will happen frequently, however it is not consistent. This is my first procedure I've written, so I'm sure I've done something wrong here. I assume the error message means I'm hitting some kind of timeout? Any ideas would be welcome. Thanks. create procedure getElement (IN n VARCHAR(255),IN ptime DOUBLE) BEGIN DECLARE mfid INT UNSIGNED; DECLARE pid INT UNSIGNED; DECLARE foffset INT UNSIGNED; DECLARE flength INT UNSIGNED; DECLARE vid INT UNSIGNED; DECLARE rfid INT UNSIGNED; DECLARE tpid INT UNSIGNED; DECLARE fdata BLOB; DECLARE fdata_tmp BLOB; DECLARE fdata_bigint BIGINT UNSIGNED; DECLARE fdata_signed INT; DECLARE fdata_unsigned INT UNSIGNED; DECLARE fdata_float DOUBLE; DECLARE data_type VARCHAR(20); DECLARE byte_order VARCHAR(20); DECLARE conv_param VARCHAR(255); SELECT major_frame_desc_id, parent_id, frame_offset, frame_length, version_id, top_level_parent_id FROM MajorFrameDescription WHERE name=n INTO mfid,pid,foffset,flength,vid,tpid; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=NormalizedType INTO data_type; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=ConvParams INTO conv_param; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=ByteOrder INTO byte_order; SELECT MAX(raw_major_frame_id) FROM RawMajorFrames WHERE major_frame_desc_id=tpid INTO rfid; IF rfid 0 THEN SELECT payload_time, SUBSTR(BINARY(frame_data), FLOOR(foffset/8)+1, CEIL((flength + (foffset %8 ))/8)) FROM RawMajorFrames WHERE raw_major_frame_id=rfid INTO ptime,fdata; call toBigInt(fdata,fdata_bigint); IF (foffset %8) 0 THEN SET @mask_off=foffset%8; call mask_data(fdata,@mask_off,fdata_bigint); END IF; IF (8-((flength+(foffset%8)) %8)) 0 THEN SELECT (fdata_bigint (8-((flength+(foffset%8)) %8))) INTO fdata_bigint;
Re: Database backups
The quick answer is: it depends. If you read in the manual the documentation for innodb and myisam tables, you'll see that they're both stored in an operating-system (somewhat) independent way. http://dev.mysql.com/doc/refman/5.0/en/moving.html That references the page Gleb replied with, but it also gives a bit more detail. -Sheeri On 1/23/06, George Law [EMAIL PROTECTED] wrote: Just a quick question regarding mysql backups. I know myisam tables are portal from machine to machine, but I know there are some differences Between innodb tables. I am running mysql 5.0.18 on suse linux 10. I have innodb set up so it stores each table in its own .idb file. I've read that innodb tables are not portable from server to server, my question is if I grab the whole mysql/data directory, can it be restored back on the same computer in the event of a crash. Do I need to enable binlog to do this? I plan on giving myself about a 1 hour maintenance window where all my import scripts skip importing and then just copying the entire mysql/data directory to a back up server where I will tar/gzip the data and push it out to a back up directory so it will get dumped to tape. -- Geo -- 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]
SV: replication
that would make both Slave_IO_Running: Yes Slave_SQL_Running: Yes go to No i only want to stop the Slave_SQL_Running and keep the Slave_IO running so my show slave status would report the following: Slave_IO_Running: Yes Slave_SQL_Running: No it happens if the mysql recives an update and failes during the update. ive tried reading the documentation about mysql replication, but i cannot find what i am looking for. Fra: sheeri kritzer [mailto:[EMAIL PROTECTED] Sendt: on 25-01-2006 22:56 Til: Morten Kallesøe Cc: mysql@lists.mysql.com Emne: Re: replication SLAVE STOP; or STOP SLAVE; work equally well. Or am I not understanding your question correctly? -Sheeri On 1/25/06, Morten Kallesøe [EMAIL PROTECTED] wrote: Hi on a slave, is it possible to only stop the SQL Thread? (Slave_SQL_Running: Yes/No) i need to do some testing with my script and i got to make sure it reads that value correctly. regards Morten
How NOT to log SHOW INNODB STATUS in the query log.
Hi; My query.log is full of 'show innodb status' queries. How do I get this ascii log file not to log these. OR some help with a grep script to copy the file without these lines. Thanks -nat -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
max_connections
Are there any statistics that I can use to determine how high or low I should set max_connections? I am using MySQL as the backend for a Java web application that will need to accommodate a moderate amount of traffic. Also, if max_connections is set too high relative to the needs of the application, does this waste system resources? In other words, does MySQL reserve system resources based on the value of max_connections or does it dynamically reserve/release system resources based on what the application's current needs are? The application itself uses a connection pool and hence idle connections are recycled and reused. Any help would be appreciated. Thanks. - Asad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
help with character sets and collation
I think I have a problem with mysql related character sets and collation. With language English (en-utf-8), MySQL charset UTF-8 Unicode and a MySQL connection collation: ascii_general_ci. I can execute a sql statement in phpmyadmin, like INSERT INTO mytable (id, name) VALUES ('5','Unterwinkel Straáe') But if I try to execute the insert using a php script I get the error 1406 record too long. Using the same insert but without the á character, the sql statement works. INSERT INTO mytable (id, name) VALUES ('5','Unterwinkel StraXe') How would I configure mysql so characters like á can be inserted without problems. Thanks chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: question about recovery with binlog
I execute follow statement. - shellreplace @@session.sql_mode=0 @@session.sql_mode=1 -- 1.01 - But string @@session.sql_mode=0 doesn't replace to @@session.sql_mode=1. - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, January 23, 2006 7:56 PM Subject:Re: question about recovery with binlog Hello. There a lot of different ways to perform this operation. See: http://dev.mysql.com/doc/refman/5.0/en/replace-utility.html man sed man awk wangxu wrote: How to replace it? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: replication
On Wed, 25 Jan 2006, [iso-8859-1] Morten Kalles?e wrote: Hi on a slave, is it possible to only stop the SQL Thread? (Slave_SQL_Running: Yes/No) i need to do some testing with my script and i got to make sure it reads that value correctly. Please follow this link http://dev.mysql.com/doc/refman/5.0/en/stop-slave.html Thanx Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database backups
On Mon, 23 Jan 2006, George Law wrote: Just a quick question regarding mysql backups. I know myisam tables are portal from machine to machine, but I know there are some differences Between innodb tables. I am running mysql 5.0.18 on suse linux 10. I have innodb set up so it stores each table in its own .idb file. I've read that innodb tables are not portable from server to server, my question is if I grab the whole mysql/data directory, can it be restored back on the same computer in the event of a crash. Do I need to enable binlog to do this? Yes you can do a restore if you backup the mysql data directory. But ensure that the server is down for a consistent backup. Binlogs are required only when you have , if you want to trach the updates and some point in time recovery issues. So binlogs req might be based on the backup / recovery strategy. I plan on giving myself about a 1 hour maintenance window where all my import scripts skip importing and then just copying the entire mysql/data directory to a back up server where I will tar/gzip the data and push it out to a back up directory so it will get dumped to tape. The time required will be based on the database size. Thanx Alex MySQL DBA Yahoo! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: union/collation problem, error 1267: feature or bug?
Hi Gleb, localhost.(none) show session variables like %version%; +-+--+ | Variable_name | Value| +-+--+ | protocol_version| 10 | | version | 4.1.16-standard | | version_comment | MySQL Community Edition - Standard (GPL) | | version_compile_machine | i686 | | version_compile_os | pc-linux-gnu | +-+--+ 5 rows in set (0.00 sec) localhost.(none) with the new version , in a first view, the problem i reported on 20. january 2006, does not occur anymore. thanks for your suggestion an help. suomi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]