Re: www.innodb.com
--On Friday, November 10, 2006 08:46:50 AM -0500 Curtis Maurand [EMAIL PROTECTED] wrote: http://www.oracle.com/innodb/index.html Please quit telling us that Oracle purchased Innodb. That is ancient news. The innodb.com web site had innodb content on it in the past, Heikki signature makes me think that it still should, and it doesn't now. That is the issue that I raised. I am guessing, given Reimer's insight, that the domain name registration has expired and someone needs to renew it. I hope they plan to do that because I found the site useful. Bill Riemer Palstra wrote: On Thu, Nov 09, 2006 at 09:26:52AM -0800, Bill MacAllister wrote: What happened to the Innodb web pages? What comes up for be is a search page with a bunch of related links on it. I wanted to pull down a copy of ibbackup documentation and it isn't there anymore. Strange indeed, I get the search pages that Tucows/OpenSRS put up when they park a domain as soon as a customer lets their domain name expire... -- Riemer PalstraAmsterdam, The Netherlands [EMAIL PROTECTED]http://www.palstra.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] +--- | Bill MacAllister, Senior Programmer | 10030 Foothills Blvd | Roseville, CA 95747 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
www.innodb.com
What happened to the Innodb web pages? What comes up for be is a search page with a bunch of related links on it. I wanted to pull down a copy of ibbackup documentation and it isn't there anymore. Bill +--- | Bill MacAllister, Senior Programmer | 10030 Foothills Blvd | Roseville, CA 95747 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: www.innodb.com
--On Thursday, November 09, 2006 08:37:01 PM +0200 Onur [EMAIL PROTECTED] wrote: Bill MacAllister wrote: What happened to the Innodb web pages? What comes up for be is a search page with a bunch of related links on it. I wanted to pull down a copy of ibbackup documentation and it isn't there anymore. Hi, Maybe domain name down. Best Regards, Onur Yerlikaya mailto:[EMAIL PROTECTED] No the domain is not down. At least the DNS answers up with an IP address and there is a web page that is displayed innodb/mysql type links. Perhaps they are at Oracle now? -- Leandro Guimarï¿£es Faria Corcete DUTRA I suppose this might be so, but here is the signature from a message from Heikki earlier today. Heikki Oracle Corp./Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php You will have trouble ordering anything from the web page that comes up. Bill +--- | Bill MacAllister, Senior Programmer | 10030 Foothills Blvd | Roseville, CA 95747 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Need help coverting MDB SQL
I would recommend that you use perl. 1. Install perl on your Windows box. I use Active State's distribution. 2. Install DBI, DBD::ODBC, and DBD::mysql. The commands you use are: ppm install DBI ppm install DBD-ODBC ppm install DBD-mysql 3. Create a DSN for your Access database. 4. Now you can write perl scripts to read data from one database and write to the second database. I would expect that you will have some data conversions issues that you will have to work through. For example, as I remember Access has a weird format for dates. You put a '#' in literals when you specify them. The good think about using perl is that you can handle all of these problems. Hope that helps, Bill +--- | Bill MacAllister | 14219 Auburn Road | Grass Valley, CA 95949 --On Saturday, March 26, 2005 10:35:04 AM -0500 Ricky Groleau [EMAIL PROTECTED] wrote: Microsofts Acesss that makes ASP pages. The databsae is saved as MDB. Yes, it does have a uplink, my problem is lack of experience with SQL. It asks for localhost, but of course that i smy computer and I dont have any SQL or anything on it. I tried to send it to my sever, but I am lost..is it the IP or web address? Where is SQL hidden on a linux/apache server? ---Original Message--- From: Rhino Subject: Re: Need help coverting MDB SQL Sent: Mar 26 2005 10:26:58 - Original Message - From: Ricky Groleau To: Sent: Saturday, March 26, 2005 10:13 AM Subject: Need help coverting MDB SQL Hello, I have tried and i have failed. I am trying to help out a non-profit site in their move. The old site had a forum run by MDB and in the transfer as you know...it won't work. I have used PHPBB and I like it and want to use it. We need to convert the MDB to SQL. I have DL 2 converters...and MySql..again I have failed. The database is almost 9 meg. I need someone that can convert this for me and then explain how to upload since it is so big. I have read you cannot to it thru the web/mysql? Any help...guidancePLEASE! I'm not familiar with MDB but I'm assuming that it is some kind of database, like DB2 or Oracle. Does MDB have any kind of export facility? All of the good databases - and even a lot of lousy ones - have some way to convert the database format into one or more text files. There might be a single file for all of the data or a separate file for each table in the database. If MDB has such a facility, you can almost certainly use MySQLs import facilities to convert the export files from MDB into MySQL tables. Does MDB have some kind of export capability? If you don't know, can you point me to where the MDB documentation is located online and perhaps I can figure it out for you. Rhino -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.3 - Release Date: 25/03/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] ---Original Message--- +--- | Bill MacAllister | 14219 Auburn Road | Grass Valley, CA 95949 | 530-272-8555 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld_safe in 4.1.2
--On Wednesday, June 30, 2004 07:36:23 PM -0500 Paul DuBois [EMAIL PROTECTED] wrote: At 13:58 -0700 6/30/04, Bill MacAllister wrote: Hello, I am a bit confused by processing of user= specifications in the mysqld_safe script. Here is what I see: * If user= is specificed in the [mysqld] or [server] sections then it is ignored and a flag is set that prevents the specification of a user in any subsequent options parsing. * Otherwise the user will be extracted and used from either the [mysqld_safe], [safe_mysqld], or command line arguements. Not quite. For security reasons, only the *first* encountered instance of the user option is used, and any others are ignored. http://dev.mysql.com/doc/mysql/en/Server_options.html See the descripion of --user in the option list. Thanks for the pointer to the documentation. I just missed it. But, my reading of the code in mysqld_safe (4.1.2) does not match the documentation. The first pass through the option sections [mysqld] and [server] have the SET_USER script variable set to 2. With this value set any user specification is ignored, but specifying a user disables any subsequent user specifications because SET_USER is set to 1. Also, I don't see any where that would generate warnings if there are multiple user specifications. It took me quite a while to figure out why my mysqld_safe was trying to run the mysql server as mysql instead of the user that I specified. Still looks like a bug to me. Bill This is counter intuitive if nothing else, and I really don't see why user should be parsed any differently than any other options. Am I missing something or is this a bug? It's by intent. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com +--- | Bill MacAllister | 14219 Auburn Road | Grass Valley, CA 95949 | 530-272-8555 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld_safe in 4.1.2
Hello, I am a bit confused by processing of user= specifications in the mysqld_safe script. Here is what I see: * If user= is specificed in the [mysqld] or [server] sections then it is ignored and a flag is set that prevents the specification of a user in any subsequent options parsing. * Otherwise the user will be extracted and used from either the [mysqld_safe], [safe_mysqld], or command line arguements. This is counter intuitive if nothing else, and I really don't see why user should be parsed any differently than any other options. Am I missing something or is this a bug? Bill + | Bill MacAllister, Senior Programmer | PRIDE Industries | 10030 Foothills Blvd, Dept 1150 | Roseville, CA 95747 | 916-788-2402 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication and tmp tables
Hello, I am continuing to have what seems to be intermittent problems with replication. I have attempted to exclude temporary tables from replication by using ignore wild specifications in my.cnf on both master and slave. For some unknown reason there are times that MySQL still tries to replicate a temporary table. On the slave: nb3% mysql --version mysql Ver 11.16 Distrib 3.23.49, for redhat-linux-gnu (i386) nb3% cat /etc/my.cnf [mysqld] datadir=/usr/local/mysql/var socket=/usr/local/mysql/tmp/mysql.sock set-variable= key_buffer=256M set-variable= max_allowed_packet=1M set-variable= table_cache=256 set-variable= sort_buffer=1M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=8 master-host=mysql-master.prideindustries.com master-user=slaveuser master-password=slavepassword master-port=3306 server-id=200 replicate-ignore-table=base_housing.u replicate-ignore-table=base_housing.wo replicate-wild-ignore-table=%.tmp% replicate-wild-ignore-table=%.%tmp replicate-wild-ignore-table=%.temp% replicate-wild-ignore-table=%.%temp [mysqldump] quick set-variable= max_allowed_packet=16M [client] socket=/usr/local/mysql/tmp/mysql.sock nb3% mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 36 to server version: 3.23.51-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show slave status \G *** 1. row *** Master_Host: mysql-master.prideindustries.com Master_User: copydb Master_Port: 3306 Connect_retry: 60 Log_File: db1-bin.907 Pos: 14160409 Slave_Running: No Replicate_do_db: Replicate_ignore_db: Last_errno: 1146 Last_error: error 'Table 'm2mreferral.tmp_travis_househits' doesn't exist' on query 'insert into househits_travis select * from tmp_travis_househits' Skip_counter: 0 1 row in set (0.00 sec) mysql I don't think it should be trying to replicate this table. Any suggestions would be greatly appreciated. Thanks, Bill +- | Bill MacAllister, Senior Programmer | PRIDE Industries | Phone: 916-788-2402 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication Problem with Temp tables
Hello, My MySQL slave (3.23.51) stopped with the error: Last_errno: 1146 Last_error: error 'Table 'bts.tmp_na' doesn't exist' on query 'insert into name_address select * from tmp_na ' It is possible that this occured because of inopportune timing in stopping and restarting of the slave. But it seems to me that this could not have been a problem since the my.cnf on the slave has the following entries: replicate-wild-ignore-table=%.tmp% replicate-wild-ignore-table=%.%tmp replicate-wild-ignore-table=%.temp% replicate-wild-ignore-table=%.%temp The documentation seems to save that you put this in the my.cnf on the slave, but maybe it should be on the master as well? Maybe in both places? I will try adding this to the master, but any other suggestions would be greatly appreciated. Thanks, Bill + | Bill MacAllister, Senior Programmer | PRIDE Industries | 10030 Foothills Blvd, Dept 1150 | Roseville, CA 95747 | 916-788-2402 - 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 Clients Hang
--On Saturday, February 02, 2002 2:16 AM -0600 Ed Carp [EMAIL PROTECTED] wrote: I have not completely figured out what the problem is and I never got a response from any one else on the list. I can tell you it looks like a mutex problem between two threads. We have followed it down into pthreads where it seems to be stuck. The external symptom we see is that the MySQL server does not open any of the databases. The really bad news is that it is not a MySQL problem so reinstalling MySQL does nothing to fix it. The worse news is that the MySQL server does not give you a clue what the problem is. We had a Linux guru look at the version of mysql on this system that we compiled with debug. I got information about the debugging session third hand and really don't have any details other than the problem appeared to be in pthreads. I am not so sure pthreads is at fault other than a dead-lock condition exists and it is not detecting it and blowing one of the stuck processes away. What version of Linux are you running? After a lot of reearch and gdb'ing, I found a bug report in bugzilla on redhat.com that seems to illustrate the bug that we're having: http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=13785 In short, it seems it's a contention problem in pthread_lock. the fix is to upgrade to libc 2.1.92 (or better). RedHat 6.2 is running libpthreads 0.8, and I think this problem is fixed in 0.9. Unfortuantely, 0.9 needs libc 2.2, so you're probably better off upgrading to RedHat 7.2. I know, this bug report applies to SMP kernels, but ieven if you're not running an SMP kernel, it's probably a good idea to upgrade anyway. Why it started suddenly and won't go away, I have no idea. Thanks for keeping me informed. Two systems here exhibited the problem, both RedHat 6.1 systems, one a uniprocessor system, and one an SMP system. The kernel on the SMP system is 2.12.12-20smp. The other system has been rebuilt. The SMP system is soon to be rebuilt with RedHat 7.2 and a kernel that we build to make sure we are greater than 2.4.10. Bill +--- | Bill MacAllister | Senior Programmer, Pride Industries | 10030 Foothills Blvd., Roseville CA 95747 | Phone: +1 916.788.2402Fax: +1 916.788-2540 - 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 Clients Hang
--On Tuesday, January 29, 2002 2:08 AM -0600 Ed Carp [EMAIL PROTECTED] wrote: What seems to be happening is that the open of the db hangs. So, when you attempt to connect with a client, mysql tries to look at the grant tables and hangs waiting for access. This is just a guess though. When you connect with a client, mysql_real_connect opens a socket to the server, does the handshaking, then authenticates and passes the query info. When I connect, I don't get anything, and gdb says the client is hung in one of the net_read routines, which makes sense - the client is waiting for something from the server. Yes, exactly. To authenticate you it has to consult the grant tables, i.e. the tables in the mysql db. It has to open those files. I never see the file opens. Is this a MySQL issue or not? I'm not sure - I just downloaded MySQL-3.23.47-1.i386.rpm and installed it (this is supposedly the static version of the server, no?) and it gave me exactly the same result, which if it was a Linux issue, it shouldn't react the same, since it was linked statically, so I'm leaning towards it being a MySQL issue of MySQL not handling an error condition properly. Yes, I think it is a mysql issue in that the mysql server does not respond. It is likely that in both of our situations something has changed in the environment to make the server go catatonic. I just can't figure out what it is and mysql is not helping me figure it out at all. No error message, no core, no nothing. Bill +--- | Bill MacAllister | Senior Programmer, Pride Industries | 10030 Foothills Blvd., Roseville CA 95747 | Phone: +1 916.788.2402Fax: +1 916.788-2540 - 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 Clients Hang
--On Monday, January 28, 2002 11:52:08 AM -0600 Ed Carp [EMAIL PROTECTED] wrote: Hi, Bill! Did you ever get this issue resolved? I've got the same problem - MySQL starts, but no clients can connect, not even mysqladmin. TIA :) I have not completely figured out what the problem is and I never got a response from any one else on the list. I can tell you it looks like a mutex problem between two threads. We have followed it down into pthreads where it seems to be stuck. The external symptom we see is that the MySQL server does not open any of the databases. The really bad news is that it is not a MySQL problem so reinstalling MySQL does nothing to fix it. The worse news is that the MySQL server does not give you a clue what the problem is. Bill + | Bill MacAllister, Senior Programmer | PRIDE Industries | 10030 Foothills Blvd, Dept 1150 | Roseville, CA 95747 | 916-788-2402 - 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 Clients Hang
Hello, We had a development box running Red Hat 6.1 on it. Over the Christmas weekend someone hacked into this system, installed bitchx on it, and filled up the disk among other things. One of the consequences of the attack was that MySQL stopped functioning. MySQL appears to start correctly on this system, that is the startup script finishes and there are mysqld processes that show up. The problem is that when any client attempts to access any database the client hangs. Initially, when we thought we could clean up the box I completely rebuilt MySQL from sources and the problem persisted. We now are just about to completely rebuild the box, but we would like to know what is going on. What should I look at? What is preventing MySQL from answering queries? Thanks in advance, Bill +--- | Bill MacAllister | Senior Programmer, Pride Industries | 10030 Foothills Blvd., Roseville CA 95747 | Phone: +1 916.788.2402Fax: +1 916.788-2540 - 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