Mysql 4.0 bitkeeper source fails to compile
>Description: Mysql 4.0 bitkeeper fails to compile >How-To-Repeat: Try to compile >Fix: Fails with a syntax error >Submitter-Id: >Originator:John >Organization: >MySQL support: none >Synopsis: Mysql 4.0 bitkeeper fails to compile >Severity: non-critical >Priority: low >Category: mysql >Class: sw-bug >Release: mysql-@VERSION@@MYSQL_SERVER_SUFFIX@ (@COMPILATION_COMMENT@) >Environment: System: Linux nemesis 2.4.6-pre5 #1 Mon Jun 25 10:14:44 CDT 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='@CC@' CFLAGS='@CFLAGS@' CXX='@CXX@' CXXFLAGS='@CXXFLAGS@' LDFLAGS='@LDFLAGS@' LIBC: -rwxr-xr-x1 root root 1343073 May 11 09:50 /lib/libc.so.6 -rw-r--r--1 root root 24539184 May 11 09:43 /usr/lib/libc.a -rw-r--r--1 root root 178 May 11 09:43 /usr/lib/libc.so Configure command: @CONF_COMMAND@ When trying to compile todays bitkeeper archive of Mysql 4.0, it fails with a syntax error. Making all in sql gmake[2]: Entering directory `/usr/local/src/mysql-4.0/sql' gmake[2]: warning: -jN forced in submake: disabling jobserver mode. yacc -d sql_yacc.yy && mv y.tab.c sql_yacc.cc yacc: e - line 72 of "sql_yacc.yy", syntax error %pure_parser/* We have threads */ ^ gmake[2]: *** [sql_yacc.cc] Error 1 gmake[2]: Leaving directory `/usr/local/src/mysql-4.0/sql' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/usr/local/src/mysql-4.0' gmake: *** [all-recursive-am] Error 2 - 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: Weird select with php
SELECT * FROM members where name like 'A%' ORDER BY RAND(); John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Tue, 6 Mar 2001, Matt "TrollBoy" Wiseman wrote: > I'm attempting to do a select from my table, but the only odd thing is the > customer wants the results to be completely random every time... > > is there anything like this?? > $query = "SELECT * FROM members where Name like 'A%' ORDER BY random"; > > > > Matt "Trollboy" Wiseman > www.shoggoth.net/trollboy/trollboy.jpg > [EMAIL PROTECTED] > "I wish the world had one throat!!" > -Al Bundy > > > - > 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: MySql backup and restore.
You dont need a script or command to restore the database, mysqlhotcopy just creates a copy of your database files (.MYI, etc.) in the /pathToTheBackupDirectory/. It basicaly performs the same function as the unix command cp, only it does the necessary locking, etc. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Tue, 20 Mar 2001, Zhu George-CZZ010 wrote: > Hi, > > If I use "mysqlhotcopy database/pathToTheBackupDirectory/" to backup the >whole database, what's the script/command to restore it? > Thanks > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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: What is best way to check mysql status?
You should look up mysqladmin in the manual. It depends on what you want to know. mysqladmin ping will tell you if the server is alive or not, or you can use mysqladmin status to get a brief stat report about the server. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On 21 Mar 2001, Jose de Leon wrote: > I have found at least three ways to check up/down status of MySQL. I am > wondering what is considered the most reliable method, please comment > and add if you have another method. > > 1. Check for existence of PID file created by MySQL > 2. Check for existence of mysql.sock > 3. Verify connection via telnet to port 3306. > > Thank you, > Jose de Leon > > > > - > 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: Password option
Restart mysqld with the --skip-grant-tables option, this will allow you to bypass mysql's authentication. You can log in as root and then change the password to something else. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Wed, 21 Mar 2001, Jared Rogge wrote: > I have recently tried to install a new Trouble Ticket application on a Unix > machine that was previously administered by somebody else. They have set a > password to MySQL and I cannot into it of course. Does anybody know how to > reset or disable this feature if you have root access to the machine? > > Thanks, > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - 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: backup mysql using crontab
mysqldump --flush-logs -u root -pmarkloky --add-drop-table shuncheong > /backup/shuncheong.sql You have to put username and password as an argument to mysqldump, before your redirection John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Tue, 3 Apr 2001, Mark Lo (3) wrote: > Hi, > >I would like to know how to backup mysql using crontab or cron jog. > > I have add a line in my crontab file : > mysqldump --flush-logs --add-drop-table shuncheong > > /backup/shuncheong.sql -u root -pmarkloky; > > but I got nothing in shuncheong.sql file. > > Thank you for your help > > Mark Lo > > > - > 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: show databases forbidden or limited to the owner database
Try putting a line in your my.cnf that contains: safe-show-database This will only allow the user to see databases that they have permissions for You can optionally use skip-show-database, which will not allow the command at all. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Mon, 9 Apr 2001, Fabien Salvi wrote: > Hello, is it possible to prevent users from seing other databases than > the one there are using ? > > I thought it was possible using priveleges and "Select_priv", but It > doesn't work... > I am using 3.23.33 > > Thanks in advance for your help... > > - > Fabien SALVI Centre de Ressources Informatiques > Archamps, France -- http://www.cri74.org > PingOO GNU/linux distribution : http://www.pingoo.org > > - > 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: Moving Data
It depends on what version of MySQL you are running. MyISAM tables will move across platforms fine, but ISAM tables will not. You could always choose the failsafe and use mysqldump to dump the contents of your database into a file, and then use that to reload the contents on the new machine. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Mon, 9 Apr 2001, Mat Murdock wrote: > We will be moving our MySql databases from a Winnt server to a linux server. Can I >just copy the data files from one machine to the other? If not then how should I do >it? > > Mat Murdock > > > Your mouse has moved. Windows must be restarted for the change to take > effect. Reboot now? [ OK ] > - 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: BEGIN, COMMIT, ROLLBACK
You are using MyISAM tables which do not support transactions. You need to convert your table to either BDB or INNOBASE type in order to use transactions. All the info is in the manual.. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Tue, 10 Apr 2001, Bruno Roselli wrote: > Hi. How to use Begin, Commit and Rollback in my tables type MyISAM ? > > mysql> BEGIN; > Query OK, 0 rows affected (0.00 sec) > > mysql> UPDATE tabgral set codigo=2 where codigo=1 and nrotab=99; > Query OK, 1 row affected (0.00 sec) > Rows matched: 1 Changed: 1 Warnings: 0 > > mysql> ROLLBACK; > ERROR 1196: Warning: Some non-transactional changed tables couldn't be > rolled back > > show table status like 'tabgral'; > +-+++--++-+- > > +--+---++-+- > > +++-+ > | Name| Type | Row_format | Rows | Avg_row_length | Data_length | > Max_data > _length | Index_length | Data_free | Auto_increment | Create_time | > Upda > te_time | Check_time | Create_options | Comment | > +-+++--++-+- > > +--+---++-+- > > +++-+ > | tabgral | MyISAM | Dynamic| 280 | 45 | 12872 | > 429 > 4967295 | 7168 | 0 | NULL | 2001-04-10 09:17:45 | > 2001 > -04-10 12:58:11 | NULL || | > +-+++--++-+- > > +--+---++-+- > > +++-+ > > > > > - > 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: Connection problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 check mysql.user, you probably have permission for franck@localhost, which succeeds when you omit the -h, but no permission for [EMAIL PROTECTED], so you fail when you specify that is where you are coming from. John Barton [EMAIL PROTECTED] http://jbarton.technicalworks.net On Tue, 30 Oct 2001, COLLINEAU Franck FTRD/DMI/TAM wrote: > Hi! > > When i type: mysql -u franck -p then my password, it's ok. > > My machine's name is r-lx-collineau > > When i type mysql - h r-lx-collineau -u franck -p then my password, i have > this message: > "ERROR 1130: host 'r-lx-collineau' is not allowed to connect to this MySQL > server" > > Can anybody help me ? > > > Franck > > - > 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 > -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE73u4tFllLbUnOIMARAioTAJoDH4Av4CtM54YAXX/gFlycDi34VgCdHohi OHy/88V+xUTrBMeJRtLqe5k= =l46z -END PGP SIGNATURE- - 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: ALTER Syntax Question
Sure is: http://www.mysql.com/doc/A/L/ALTER_TABLE.html John Barton [EMAIL PROTECTED] http://jbarton.technicalworks.net On Fri, 9 Nov 2001, Brad Harriger wrote: > Is it legal to change a field name to the same name as in the following? > > ALTER TABLE t1 CHANGE a a INTEGER; > > Thanks, > > Brad > > > > This e-mail and any files transmitted with it are confidential and are intended >solely for the use of the individual or entity to whom they are addressed. This >communication may contain material protected by legal privileges or statutory >protections. If you are not the intended recipient or the individual responsible for >delivering the e-mail to the intended recipient, please be advised that you have >received this e-mail in error and that any use, dissemination, forwarding, printing, >or copying of this e-mail is strictly prohibited. If you have received this e-mail in >error, please immediately notify us and delete the original message. Upon request, we >will reimburse you for reasonable costs incurred in notifying us. > > > - > 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: SSH tunnel MySQL traffic: BOTH remote & local?
Try mapping your remote mysql to a different local port, then specify that port number when you connect. For example: 'ssh -L 3307:hostip:3306 hostname' will map port 3306 on the remote machine to port 3307 on your local machine. Then, use 'mysql -P 3307 -u x -p etc.' to connect to port 3307 on your local machine, and you will hit your remote mysql > Using the -h should do it. > mysql -h 10.129.0.2 -u user -p password yadayadayada > > -Original Message- > From: MySQL baby [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 03, 2002 10:28 AM > To: [EMAIL PROTECTED] > Subject: SSH tunnel MySQL traffic: BOTH remote & local? > > > If I've got one computer with MySQL client and server on it, running > everything localhost, > > but I want to reach out to another MySQL server, through an SSH tunnel, > for some things, > > does anyone know how to differentiate between the two? > > > Usually, for SSH tunnelling, you access a port # at localhost, but if I > also need that port # at localhost, (3306), what's a guy to do? > > > Any advice appreciated. > > > - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> To > unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - > 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 John Barton [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: SSL connection question Again!
Mysql gurus: I have anxiously been watching the list for a response to this question, but still no joy. Does anyone have information on how to make an ssl connection with the mysql client? I have support compiled into the server, but unfortunately I cant find any documentation on the client side. Thanks in advance for any help.. > Happy New Year! > > I'm Sorry if this question has been posted often. > but i cannot find answer. > > I have installed openssl and MySQL 4.0.1 with --with-openssl --with-vio > > And... > > mysql> SHOW VARIABLES LIKE '%ssl%' ; > +---+---+ > | Variable_name | Value | > +---+---+ > | have_openssl | YES | > +---+---+ > 1 row in set (0.10 sec) > > and I granted somebody with REQUIRE SSL. > > But He cannot connect to MySQL using mysql . > > mysql client does not support SSL connection? > > How can he/she connect to MySQL with SSL? > > about PHP and MySQL? > > I'm very pleased if give me any Information ! > > Thank you for advanced Answer! > > >Homepage = http://www.nnr.or.kr/inos/ >ICQ # = 123534385 >Member of DSN(database.sarang.net), NNR(nnr.or.kr) > > > > --MIME Multi-part separator-- > > > - > 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 John Barton [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: alter table example.
Matt, alter table table_name add column column_name column_decriptions; alter table table_name drop column column_name; Try checking documentation for more details: http://www.mysql.com/doc/A/L/ALTER_TABLE.html Hope this helps! > > > Can anyone give me an example of an alter table syntax that. > > 1.) adds a column > 2.) deletes a column. > > I am reading the examples in the oreilly book, and it does not work > also the Oracle or Infomix syntax doesn't work. > > can someone give me a clue please. > > Thanks, > > Matt. > > > - > 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 John Barton [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: Correct syntax?
"select word, count(word) as total from search_words where word IS NOT NULL group by word order by total desc limit 20" John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Thu, 19 Apr 2001, Graham Nichols wrote: > Thanks for help from this group I'm using > > "select word, count(word) as total from search_words group by word order by > total > desc limit 20" > > to locate the top 20 words in a database of website search engine words. > > The database had been altered to include an extra column, other than the > 'word' column. This means that 'word' can now have a null entry sometimes. > How can I modify the sql query above to exclude any row(s) in 'word' with > 'NULL' please? > > regards, Graham > l > > > - > 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: set variable for max_connections
Try putting a line like the following in your my.cnf file: This has always worked for me, including 3.23.37 set-variable = max_connections= John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Thu, 10 May 2001, Mark Lo (3) wrote: > Hi, > > I would like to set a higher values in max_connections for mysql. > > I have tried to use the following command "mysqld --set-variables > max_connections=900 -u root -ppassword". Then, it shows that I have > successfully changed the variable of max_connections. But, when I check it > with the command of "mysqladmin variables -u root -ppassword". The > max_connections return to 100 which is the default value. I wonder what is > wrong with mysql3.23.37. Is this a bug, or I am using the wrong command. > > In additions, Can I set the max_connections values higher than 5000. > > Thank you > > Mark > > > - > 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: simultaneous connections
Mysql allows 101 connections by default, 100 client connections plut it reserves one for "administrator" access. You can set your own maximum connection limit in the my.cnf file by using the directive: [mysqld] set-variable = max_connections= where xxx is the amount you want to set as the max. See the documentation for information and recommendations on what to set the max as for your particular OS. John Barton System Administrator Mpower Communications [EMAIL PROTECTED] - Original Message - From: "Don Pro" <[EMAIL PROTECTED]> To: "msql list" <[EMAIL PROTECTED]> Sent: Friday, May 11, 2001 2:37 PM Subject: simultaneous connections > Hi, > > I'm reading in my documentation (I have a book) that MySQL allows up to > 101 simultaneous connections. Gadzooks! How can MySQL claim to be at > the Enterprise level with this limit? Is there any way around this? > > Thanks, > Don > > > - > 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: Database backup
This would be an acceptable method of backing up your databases, as long as your server is not running at the same time you are doing this. If it is, you risk corrupting your data. You should try one of the utilities provided for making backups, mysqlhotcopy is a good one to do what you are trying to do, and it takes care of the necessary locking, flushing, etc. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Tue, 19 Jun 2001, Tom Lin, Sr. Programmer, Ameriserv.net wrote: > I copy the 3 MYD MYI frm of a database to another directory as a way of backup. > Is this the right way to do it. It appears to be not function correctly. > > Any help appreciate. > > Thanks. > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.23.32 replication problem
I have also encountered this problem when upgrading master and slave from 3.23.31 to 32.23.32. The upgrade of the master went fine, and both servers remained in sync throughout the process. However, when I upgraded the slave and restarted, it gave the same error that it could not find first log. This log was listed in the index file, and was readable (permissions had not been changed). I have done this on two master/slave setups, and both of them broke when the slave was upgraded. I have had to reset both master and slave after the upgrade to bring machines back into sync. The error I received was: 010123 10:01:59 Slave: reconnected to master 'slave@hostname:3306',replication resumed in log 'radius1-bin.006 ' at position 33488482 010123 10:01:59 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) 010123 10:02:59 Slave: Failed reading log event, reconnecting to retry, log 'radius1-bin.006 ' position 33488482 010123 10:02:59 Slave: reconnected to master 'slave@hostname:3306',replication resumed in log 'radius1-bin.006 ' at position 33488482 010123 10:02:59 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) 010123 10:03:24 Slave thread exiting, replication stopped in log 'radius1-bin.006 ' at position 33488482 Thanks for your help in this matter, John [EMAIL PROTECTED] On Tue, 23 Jan 2001, Sasha Pachev wrote: > >Just tried a 3.23.32 slave (on Linux, all rpms from www.mysql.com) against a > 3.23.30 server: > > >010123 09:38:05 mysqld started > /usr/sbin/mysqld: ready for connections > >010123 9:38:05 Slave: connected to master '[EMAIL PROTECTED]:3306', > replication started in log 'jfontain-bin.008 > ' at position 149358 > 010123 9:38:05 Error reading packet from server: Could not find first log > (read_errno 0,server_errno=65535) > 010123 9:38:05 Slave: Failed reading log event, reconnecting to retry, log > 'jfontain-bin.008 > ' position 149358 > 010123 9:38:05 Slave: reconnected to master > '[EMAIL PROTECTED]:3306',replication resumed in log 'jfontain-bin.008 > ' at position 149358 > 010123 9:38:05 Error reading packet from server: Could not find first log > (read_errno 0,server_errno=65535) > 010123 9:38:06 /usr/sbin/mysqld: Normal shutdown > > >010123 9:38:06 Slave thread exiting, replication stopped in log > 'jfontain-bin.008 > ' at position 149358 > >010123 9:38:06 /usr/sbin/mysqld: Shutdown Complete > > Do you have jfontain-bin.008 log on the master? If yes, is it readable by the > master, and is it listed in the log index ( do SHOW MASTER LOGS on the > master). The error message indicates that the log is either not there, not > readable, not listed in the index, otherwise it is a bug. If you have done > reset master, but have not done reset slave, or have been careless with PURGE > LOGS, this would explain the problem. > > > >Do I need to upgrade master and slave? > > Only if you find a bug > > >Is it safe? (these are production machines) or should I wait a while? > > It depends on how you do it. > > -- > MySQL Development Team >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ > /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ><___/ > > - > 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
