Re: Sharing pws between UNIX and MySQL?
[snip] From: Jonas Larsson [EMAIL PROTECTED] But wouldn't it be possible to let MySQL use MD5-hashed pw like UNIX? Why isn't that implemented? Then it would be easy to transfer the hash... Yes it definitly would be nice and would have been easier to impliment than the current Password() implimentation (just call crypt()!!). I found that Postgresql uses the built in system crypt() while Mysql uses its own hash which causes some problems when porting a database between the systems. ryan - 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 an Ultradev
Hi all, Can anyone point me to a good Macromedia Ultradev Extension for live connection to MySQL? Mike - 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
problems with mysql_connect()
I have recently started using mysql and php. I have created sample databases that are working well. My problem came when I started using PHP. My php scripts are being executed, the pronlem comes when I use the function mysql_connect to connect to any of my databases. It returns the folowing message. Fatal error: Call to unsupported or undefined function mysql_connect() in /home/francis/public_html/allresults.php3 on line 11 I need your assistance urgently because I have a deadline. Yours Sincerely Francis Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problems with mysql_connect()
On Mon, Sep 17, 2001 at 01:02:50AM -0700, francis jeffrey wrote: I have recently started using mysql and php. I have created sample databases that are working well. My problem came when I started using PHP. My php scripts are being executed, the pronlem comes when I use the function mysql_connect to connect to any of my databases. It returns the folowing message. Fatal error: Call to unsupported or undefined function mysql_connect() in /home/francis/public_html/allresults.php3 on line 11 Your PHP doesn't have built-in support for MySQL. Rebuild and re-install PHP. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 11 days, processed 208,188,890 queries (215/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sharing pws between UNIX and MySQL?
But wouldn't it be possible to let MySQL use MD5-hashed pw like UNIX? Why isn't that implemented? Then it would be easy to transfer the hash... Yes it definitly would be nice and would have been easier to impliment than the current Password() implimentation (just call crypt()!!). I found that Postgresql uses the built in system crypt() while Mysql uses its own hash which causes some problems when porting a database between the systems. 1. Have you find a way of porting the pw-database from UNIX to MySQL? As I see it it is impossible due to the one-way-hash of MD5. The only way I've found out is to give all users a new password. :( 2. Is it possible to let the users by them self change their password? Then they could change it to their UNIX-password. As far as I know only the MySQL admin can change the users passwords. :( /jonap _ Hämta MSN Explorer kostnadsfritt på http://explorer.msn.se - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Creating new user
Hi, I've put here this my problem, but without an answer. If I (admin1) have all privileges with grant option on database 'db1' and no privileges in 'mysql', why this does not work mysql grant all privileges on db1.* to aaa@localhost identified by 'aaa'; ERROR 1044: Access denied for user: 'admin1@localhost' to database 'mysql' Thanks for help. Jan Stary - 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
mysqldump not dumps MERGEd tables structure
Hello people, mysqldump not dumps MERGEd tables structure it writes TYPE=MERGE and then UNION() with empty parenthesis so this dump can not be used. -- Best regards, Pedro mailto:[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
import tables from MS-Access
I want to import tables from MS-Access to My-SQL. Please help me out - 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: import tables from MS-Access
I do it by setting up a MyODBC databsource which points to my MySQL database and then export each MS-Access table to that ODBC datasource. It works fine except that it does not do primary key and index definitions (as far as I have been able to tell) and things like setting auto_increment on for an autonumber field. Deon. -Original Message- From: Kasu MarioSuresh Reddy [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 12:48 PM To: [EMAIL PROTECTED] Subject: import tables from MS-Access I want to import tables from MS-Access to My-SQL. Please help me out - 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 Fulltextsearch
Hi! On Sep 13, Doug Poland wrote: One question per line, please ! Problems is knowning how many columns can be indexed in a table. max 16 columns per index. max 32 indexes per table. so 16*32=512 columns can be indexed in a table, which is less then max 3398 columns per table. Is that number including non-FULLTEXT indexes as well? Yes. Is the 500 char/index limitation a compile-time option? Probably, yes, but it may be not that easy to increase. And, anyway, 500 char/index does NOT apply to FULLTEXT indexes. I've got some more questions about the behavoir of FULLTEXT but am leaving for the weekend and will ask on Monday. Thanks for your help so far! you're welcome. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: match Search problems help needed!!
Hi! On Sep 15, [EMAIL PROTECTED] wrote: Hi list, I have a question that hopefully someone can help me with. We have a mysql database which contains 3000 records, and these records need to be searched. The table has 4 fields which need to be searched, so we created a full text index for the 4 fields. Now 1 of the fields contains dates, which we have formatted so that you would search for example for: 05 september 2001 and it needs to return all the results for this date. The problem is as we see it, is mysql has noisewords and the field with the datesearch has lots of records with the same date, and when we search it does not find the records, we need this to work, as otherwise it ruins the way we are producing this site. Has anyone any suggestions on this? Two. 1. Move your date field out of FULLTEXT index. 2. See the manual, how to remove 50% threshold for fulltext search. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Enum
Hi group Access has a datatype (I don't remember the name) which is a kind of boleaen; it represents Yes/No, true or false. When I try to translate that creating a table in MySQL I try ENUM(N,Y) but I do not get the expected result when using If Y then...(ASP). Do I use ENUM right? I have tried SET also, but with no better result. Anyone? Ann - 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: Enum
Ann Myhre wrote: Hi group Access has a datatype (I don't remember the name) which is a kind of boleaen; it represents Yes/No, true or false. When I try to translate that creating a table in MySQL I try ENUM(N,Y) but I do not get the expected result when using If Y then...(ASP). Do I use ENUM right? I have tried SET also, but with no better result. Anyone? Use type `bool'. This is an alias for tinyint(1), with values 0 or 1. Charlie - 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
Phone Puzzler
This is something that has me stumped.. I have a table as follows EndAEndB A B A C B C C D A E D E Imagine this as a table that describes potential links across a phone network. Now supposing I wish to connect from point A to point D, one route would be : A toB B toC C toD another would be A to E E to D using only routes available from the table above. My question is how do I query the database to return a valid route(s) supplying only a start and end point. ie SELECT !!route!! WHERE start=A and end=D, Personally I don't see how this is possible without code, hence why I am querying the brains of the world!!! - 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
ERD modeler and schema generator/modifier
[reaction on joe kaiplings message] hello Joe, I'm trying to contact you but my emails to you our bounced each time. Please give me a valid email address so I can answer your questions in the email you sent me 10-9. regards Rick van Dijk Datanamic http://www.datanamic.com Joe Kaiping schreef: Hi list, Can anyone recommend an ERD modeler for MySQL? I've tested the evaluation version of Dezign for databases and while I like it and was able to generate an initial schema with it, I couldn't get it to create SQL to alter the schema after I had modified the initial ERD. (I was only able to generate SQL that created a fresh new schema.) I sent an email to Datanamic 2-3 weeks ago asking about it, but have received no response. This makes me a little nervous about buying the product even if it is able to maintain a MySQL schema. Anyone have any experiences, good or bad, in using it? Or can someone recommend another modeler that might be out there that you have used and are content with? I'd be happy using one that ran on either Linux or Windows. Anyone tried using Silverrun? Can it work with MySQL? Thanks for any comments, -Joe - 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: Creating new user
[EMAIL PROTECTED] writes: If I (admin1) have all privileges with grant option on database 'db1' and no privileges in 'mysql', why this does not work mysql grant all privileges on db1.* to aaa@localhost identified by 'aaa'; ERROR 1044: Access denied for user: 'admin1@localhost' to database 'mysql' Isn't it rather obvious? If you don't have permission to create new users, you don't have permission to create new users. The same goes for altering their passwords. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: Phone Puzzler
Chris Thorpe writes: My question is how do I query the database to return a valid route(s) supplying only a start and end point. ie SELECT !!route!! WHERE start=A and end=D, Personally I don't see how this is possible without code, hence why I am querying the brains of the world!!! Indeed it isn't. SQL doesn't include a shortest path algorithm. It's easy enough to implement Dijkstra's algorithm (unless you want use Fibbonaci heaps, in which case it's a wee bit trickier). I suppose this is a task for which stored procedures would really be useful. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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_real_connect() does not work but interactive program mysql works
I am running MYSQL 3.23.36 on windows NT. I am not able to connect to the server through a C program using mysql_real_connect() from another computer. The other computer is running on Windows 98. My permissions are alright and I am able to connect to the server interactively through the command line program mysql. Interestingly, the C program works alright when I run it on the WINDOWS NT computer itself (i.e., the computer on which the server is running) using NULL or localhost as the hostname. Relevant Portion of My C program is reproduced below: void print_error(MYSQL *conn, char *message) { char string[500]; char string1[250]; wsprintf(string, %s\n, message); if (conn != NULL) { wsprintf(string1, Error %u (%s)\n, mysql_errno(conn), mysql_error(conn)); strcat(string, string1); } MessageBox(NULL, string, NULL, MB_OK | MB_ICONERROR); } MYSQL *do_connect() { MYSQL *conn; conn = mysql_init(NULL); if (conn == NULL) { print_error(NULL, MySql could not be initialized); return NULL; } if (mysql_real_connect(conn, 191.254.20.103, JKA, jka, ABT, 0, NULL, 0) == NULL) { print_error(conn, Could not connect to server); return NULL; } /*if (mysql_real_connect(conn, NULL, JKA, jka, 0, NULL, 0) == NULL) { print_error(conn, Could not connect to server); return NULL; } if (mysql_select_db(conn, ABT) != 0) { print_error(conn, ABT database could not be selected); mysql_close(conn); return NULL; }*/ return (conn); } I always get the following error message: Error 1044 (Access denied to user: [EMAIL PROTECTED] to database ABT) I have given Select, Insert, and delete grants to [EMAIL PROTECTED] on all tables of the database ABT. Kindly help. Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: Problems...
As root: chown -R mysql /usr/local/mysql Fernando da Motta Hildebrand wrote: I can´t start Mysql (I use Slack and compiled mysql). I´ve followed all instructions in INSTALL text, and i´ve got this in the .err file: 010914 16:19:02 mysqld started 010914 16:19:02 /usr/local/mysql/libexec/mysqld: Can't create/write to file '/usr/local/mysql/var/darkstar.pid' (Errcode: 13) 010914 16:19:02 /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010914 16:19:02 /usr/local/mysql/libexec/mysqld: Error on delete of '/usr/local/mysql/var/darkstar.pid' (Errcode: 13) 010914 16:19:02 mysqld ended 010914 16:19:26 mysqld started 010914 16:19:26 /usr/local/mysql/libexec/mysqld: Can't create/write to file '/usr/local/mysql/var/darkstar.pid' (Errcode: 13) 010914 16:19:26 /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010914 16:19:26 /usr/local/mysql/libexec/mysqld: Error on delete of '/usr/local/mysql/var/darkstar.pid' (Errcode: 13) 010914 16:19:26 mysqld ended 010914 16:27:59 mysqld started /usr/local/mysql/libexec/mysqld: File './darkstar-bin.1' not found (Errcode: 13) 010914 16:27:59 Could not use darkstar-bin for logging (error 13) 010914 16:27:59 /usr/local/mysql/libexec/mysqld: Can't create/write to file '/usr/local/mysql/var/darkstar.pid' (Errcode: 13) 010914 16:27:59 /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010914 16:27:59 /usr/local/mysql/libexec/mysqld: Error on delete of '/usr/local/mysql/var/darkstar.pid' (Errcode: 13) 010914 16:27:59 mysqld ended 010914 16:30:12 mysqld started /usr/local/mysql/libexec/mysqld Ver 3.23.42 for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB, by Monty and others This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Someone help please? 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 -- Gerald L. Clark [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: Sharing pws between UNIX and MySQL?
At 8:27 AM + 9/17/01, Jonas Larsson wrote: But wouldn't it be possible to let MySQL use MD5-hashed pw like UNIX? Why isn't that implemented? Then it would be easy to transfer the hash... Yes it definitly would be nice and would have been easier to impliment than the current Password() implimentation (just call crypt()!!). I found that Postgresql uses the built in system crypt() while Mysql uses its own hash which causes some problems when porting a database between the systems. 1. Have you find a way of porting the pw-database from UNIX to MySQL? As I see it it is impossible due to the one-way-hash of MD5. The only way I've found out is to give all users a new password. :( 2. Is it possible to let the users by them self change their password? Then they could change it to their UNIX-password. As far as I know only the MySQL admin can change the users passwords. :( Yes, that's possible. The user connects and issues this command: SET PASSWORD = PASSWORD('new password') /jonap -- Paul DuBois, [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
socket
I just upgraded to latest mysql. there was an error when starting the demon or using the client about not finding the socket file. i found it in /tmp/mysql.sock and moved it to the directory where it was looking for it. /var/lib/mysql/mysql.sock now i get : ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) can anyone help me out? -Paulo - a.k.a. powlow - 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: Sharing pws between UNIX and MySQL?
2. Is it possible to let the users by them self change their password? Then they could change it to their UNIX-password. As far as I know only the MySQL admin can change the users passwords. :( Yes, that's possible. The user connects and issues this command: SET PASSWORD = PASSWORD('new password') Thanks it worked! The only way I can think of how to manage the transfer of the UNIX accounts into MySQL is to give all users a temporary password (unique for each user) and then ask them to change it to their UNIX account password imediately. To avoid sending the temporary passwords by mail one could put it in a file, e.g. mysql_temp_pw.txt (with perms 600) in their homedir. Then one could delete that file after they have changed the pw. I know there is security problems if you have the fs over NFS, but I think it is better than sending the pws by mail. /jonap _ Hämta MSN Explorer kostnadsfritt på http://explorer.msn.se - 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
rpm install error
when installing with rpm i get: Number of processes running now: 2 mysqld process hanging, pid 30887 - killed mysqld process hanging, pid 30886 - killed 010917 16:04:06 mysqld restarted /usr/bin/safe_mysqld: line 273: 30916 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 and it just keeps going and going and going... any ideas? -powlow - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with MySQL 3.23.40 Install..Source Compiled
Hi Bob! I use Caldera Linux and have a 4 machine LAN. The Lan includes 3 Linux and 1 WinNT install. Now, no matter what I do safe_Mysqld continues to start version: 3.22.32-log .. This is more of a *nix question than a mysql question but whatever. :) I use redhat but the concepts are the same. Here are the steps I took to compile and install ver 3.23.40. to the same directory as ver. 3.22.32 which I hoped would be overwritten. I installed both versions to /usr/share/mysql.. .42 is 'current'. What got me started with learning this trick was when Apache used to change its -entire- directory structure every few minor releases. The answer is to define your own directory structure in a small shell script rather than on a command line. That way you don't have to fool with all your other support files such as rc.d just to upgrade someone else's software. My /root/bin/build.mysql-3.23.42 looks like this: cd /usr/local/src/mysql-3.23.42 ./configure \ --prefix=/home/mysql\ --with-mysqld-user=mysql\ --with-debug\ --bindir=/usr/local/sbin\ --sbindir=/usr/local/sbin (I do make, make test, make install, and restarting manually. You can add those lines if you like.) The point is to have the same Makefile for each release. (Now that I look at that I'm not sure why I set bindir and sbindir to the same place but that was at least a year ago that I started using this method.) In any case with each new release I create a new /root/bin/build.*, edit the cd line, and run it. That way I can keep previous source trees and build files for one or two releases. After restarting if anything screws up I can quickly cd to /usr/local/src/mysql-[previous release] and make install and restart and there's minimal downtime. It -is- a good idea, after each new build.[version], to run a line like diff Makefile ../[previous.version]/Makefile ...just to double check that -previous- configs are maintained and see what -new- options you might/should deal with. basedir=/usr/share/mysql/libexec bindir=/usr/share/mysql/bin pid_file=/var/lib/mysql/mysqld.pid Exactly. But rather than editing Makefile or configure.in and -forgetting- some detail once in a while it's easier to edit -your- script to maintain your directory structure. And I'm particularly lazy so I always take the easier route. :) Also I expected the prefix= switch in the ./configure to overwrite version 3.22.32..Instead it created a sub/sub directory like SO.. /usr/share/mysql/share/mysql Whats That Never seen it do anything like that. I have a lot of house cleaning to do... OK the trick is to clean out everything and have a fresh start. Run this command line: find /* |grep mysql /root/bin/remove.mysql (Or redirect to someplace that you're comfortable.) Edit that file and remove lines that relate to your current **DATABASE** and rc.d and such files. Add rm -f to the start of each line for each file that was found. Make -sure- you are not deleting your *database* tree! Change permissions to make that script executable. *Triple* check it *again* to make sure you don't delete anything you need. Yes, I keep using those !*stars*! to emphasise disabling the 'shoot self in foot' feature while the 'foot nailed to floor' option is still enabled. :) Actually, running a backup just before doing anything serious like this is a PGI. Run mysqladmin -p shutdown. Run that remove.mysql script and blip, your system is clean. Untar the source again and rebuild from a script to retain -your- directory structure and preferences. I also use similar techniques to 'convert' from the rpm system to a 'compiled' version of an application because redhat is often several months to a year to 'forever' behind in upgrades. HTH. Have a :) day! jb -- jim barchuk [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
Can't delete from very fat table: ERROR 1030: Got error 22 from table handler
Description: Can't delete from incredibly fat table. When I attempt to delete from table rCamDom in my database, I get an error: ERROR 1030: Got error 22 from table handler. This table is *huge*, biggest one in my database, other deletes work fine. The table entries begin on Jan 1, 2001. When I try and delete even 1 day's worth of data, I get an error. I would eventually like to blow away several months ofdata . . . Info on fat table, mysql version platform: bash-2.03# du -sk rCamDom.ISM 4198404 rCamDom.ISM bash-2.03# mysql -V mysql Ver 9.38 Distrib 3.22.32, for sun-solaris2.7 (sparc) bash-2.03# uname -a SunOS apu 5.7 Generic_106541-11 sun4u sparc SUNW,Ultra-60 How-To-Repeat: mysql delete from rCamDom where When'2001-01-02'; ERROR 1030: Got error 22 from table handler Also: mysql delete from rCamDom where When='2001-01-01'; ERROR 1030: Got error 22 from table handler Fix: Submitter-Id: [EMAIL PROTECTED] Originator:Super-User Organization: Forbes.com MySQL support: none Synopsis: unable to delete table data, running out of disk space for it! Severity: serious Priority: high Category: mysql Class: support Release: mysql-3.22.32 (Source distribution) Environment: System: SunOS apu 5.7 Generic_106541-11 sun4u sparc SUNW,Ultra-60 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/ccs/bin/make /usr/local/bin/gcc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes Perl: This is perl, version 5.005_03 built for sun4-solaris - 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
50 Million Fresh Email Addresses for $59.95 w/free Emailer
SELL YOUR PRODUCTS AND MAKE 'BIG MONEY' $$$ WITH OUR EMAIL ADDRESSES 1) Let's say you... Sell a $24.95 PRODUCT or SERVICE. 2) Let's say you... Broadcast Email FREE to 500,000 PEOPLE DAILY. 3) Let's say you... Receive JUST 1 ORDER for EVERY 2,500 EMAILS. CALCULATION OF YOUR EARNINGS BASED ON THE ABOVE STATISTICS: [Day 1]: $4,990 [Week 1]: $34,930 [Month 1]: $139,720 * = 50 MILLION HOT - Fresh Email Addresses = Valuable 7 MILLION Remove List Of Known COMPLAINERS = FREE Bulk Email Software = On CD FOR ONLY $59.95!! Normally $249.00 SAVE 76% We have SLASHED Our Prices! Order Today!! This Offer Ends On September 20, 2001! * AND YOU'LL ALSO GET = 2 FREE Fully Functional BULK E-MAIL Software Programs = Free Email Verifier software - verify each email addresses for delivery = Free List Manager software - clean and organize your email addresses = Free Web site Encryption software - protect your hosting account = Free Classified Ad Listings - places to post your free classifieds = THE BULK EMAIL SURVIVAL GUIDE - Great for Experts and Beginners (do's and don't of bulk emailing) = Over 100 HOT Selling In Demand Reports - with Full RESALE RIGHTS = GREAT SELLING Software With Full RESALE RIGHTS = A List of NEWSGROUPS that are literally GOLD-MINE! = FREE Business Tools and Tutorials - that will help you in your current business or start one up [valued over $150.00] = FREE Fully Functional AWESOME Marketing Submission Software: classifieds, newsgroups.. = We have a HUGE list, they are too many to list - Over 20 Software and E-Book Titles on this one CD! Also TRUE SOURCES For: - BULK EMAIL ISP DIALUP Accounts - Foreign BULK Email Friendly Web Hosting Accounts - Reliable Blind Relay Servers - Good Sources Of Great Email Addresses THIS IS A LIMITED TIME OFFER! You Will Receive All Of The Above FOR ONLY $59.95! Normally $249.00 SAVE 76% We have SLASHED Our Prices! Order Today!! This Offer Ends On September 20, 2001! * Our CD is a Must for anyone that wants to Make BIG Money On The Internet! This Awesome CD is not only jammed packed with 50 MILLION hot fresh email addresses of INTERNET BUYERS, but also contains 2 fully functional bulk email software programs that you can immediately begin using to sell your products or services. Hey, do you need products to sell? Well, we've got them. We also give you PROVEN, Hot Selling reports and software that you can RESELL and KEEP ALL OF THE MONEY! Not only that, but our CD contains a Valuable REMOVE LIST which will greatly reduce complaints that you would have received. Knowing who NOT to send email to is as important as knowing WHO to send email to (over 7 million REMOVE EMAILS) These email addresses are FRESH and Super-Cleaned thru our largest database of Remove list with NO DUPLICATIONS! The files are in a .txt [text] format, and grouped into bundles of approximately 100,000 email addresses in each file, and zipped up for space and ease of use. If you don't already know, let me tell you, Bulk Email Marketing is the most cost effective form of advertising and that's why you receive them every day. 1) Let's say you... Sell a $24.95 PRODUCT or SERVICE. 2) Let's say you... Broadcast Email FREE to 500,000 PEOPLE DAILY. 3) Let's say you... Receive JUST 1 ORDER for EVERY 2,500 EMAILS. CALCULATION OF YOUR EARNINGS BASED ON THE ABOVE STATISTICS: [Day 1]: $4,990 [Week 1]: $34,930 [Month 1]: $139,720 All for a simple investment of $59.95 + $5.00 for US Shipping. All for a simple investment of $59.95 + $35.00 for international. You've seen other people charge $250 for only 10 million names. That means you would pay $1250.00 for 50 Million names. YOU ONLY PAY $59.95 + You'll Receive All Of The Other Great Bonuses Too! REMEMBER: We Have SLASHED Our Prices For A Limited Time Only Normally $249.00 SAVE 76% You Will Receive All Of The Above FOR ONLY $59.95! This Offer Ends On September 20, 2001! * Easy Ordering Instructions == --Cut Paste-- -EZ Order Form- [TO ORDER BY POSTAL MAIL]: To order our 'Big Money' CD with a Cashiers Check, Credit Card, US Money Order, or US Personal Check, by postal mail, please print out the order form at the bottom of this email and complete all necessary blanks. Then, send it along with payment of U.S. $59.95 postmarked by September 20th or $249.00 after September 20th to: Internet Marketing Solutions 6080 S. Hulen St. Dept. 360-288 Fort Worth, TX 76132 USA Once your order is received we will IMMEDIATELY RUSH out your 'Big Money' CD to you! - [TO ORDER BY FAX]: To order our 'Big Money' CD by fax with a Credit Card, please print out the order form
Re: Portable MySQL?
Mike wrote: In working with some non profit groups I need to be able to send a complete program that is installed and ran fairly easy. To me MySQL is easy in most cases but to someone not familiar with it it can be a daughtening task. Is there a way to send a setup program using MySQL? Most of the time it's just a few tables so if there was an alternative way to make the tables and use them in a program that would be great. In UN*X land, you could send a shell script, e.g.: #!/bin/sh # echo Setting up the test_table... mysql db -u user -ppassword 'EOF' DROP TABLE IF EXISTS test_table; CREATE TABLE test_table ( a char, b char ); EOF echo Done. Not really portable, 'thogh. --Bill - 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
ANN: EMS MySQL Manager 0.92 released
Dear Sirs and Madams, EMS HiTech company is announcing the next version (0.92) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 0.92? 1. New services were added. Check out the Service menu to find this new features. Now you can Analyze, Check, Repair and Optimize tables step by step with corresponding wizard: a) Analyze Tables wizard allows you to analyze and store the key distribution for specified tables. b) Check Tables wizard allows you to check specified tables for errors. c) Repair Tables wizard allows you to repair a possible corrupted tables. d) Optimize Tables wizard allows you to optimize tables with variable-length rows. 2. The Server Properties menu item was added. Now you can get a detailed information about MySQL server, such as server version, server variables and currently running processes. See menu Service to find it. 3. A few little improvements and minor bugfixes were added. What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit of all MySQL database objects most easy and simple way, run SQL scripts, manage users and administrate users' privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make you work with MySQL server as easy as you want... Best regards, EMS HiTech development team. http://www.ems-hitech.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql install failed on FreeBSD!!
Hi Siva, Were you trying to install from the soure code downloaded from mysql.com? Or are you using the ports collection (ie /usr/ports/databases/mysql ) to install? Because if you are installing fron the download you need to remember to use gmake not BSDi make. Ken - Original Message - From: Siva Namburi [EMAIL PROTECTED] To: 'Chris Johnson' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 14, 2001 8:25 PM Subject: RE: mysql install failed on FreeBSD!! I have FreeBSD 4.3-stable release. Yes the ports collection was also upgraded. How do i know the version of ports collection. thanks, siva - 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 Spawning Tons of Processes
It certainly does seem that 3.23.40+ take considerably more resources to do the exact same thing, than MySQL 3.22.xx Is this correct? On Sun, Sep 16, 2001 at 10:21:05PM -0700, Michael McConnell wrote: So what your saying is MySQL is supposed to fork a new processes for every connection? I don't think so... No. MySQL will spawn a new thread to handle each incoming connection. It's just that threads on a Linux bear a striking similarity to processes. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 11 days, processed 205,098,399 queries (213/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: rpm install error
On Monday 17 September 2001 08:59, powlow wrote: when installing with rpm i get: Number of processes running now: 2 mysqld process hanging, pid 30887 - killed mysqld process hanging, pid 30886 - killed 010917 16:04:06 mysqld restarted /usr/bin/safe_mysqld: line 273: 30916 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 and it just keeps going and going and going... Which RPM are you using, and what distribution? -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / 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
Re: EMS MySQL Manager 0.92 released
Ok... this is getting out of hand. Is it just me or are we getting a posting every week on this? Please keep these postings to majour releases (1.0, 2.0, etc)... at most. Post your minor releases to your own mailing list. This is a relevant product but we do not want to pollute the list. Thanks! Peter Table,MySQL - Original Message - From: Igor Brynskich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 17, 2001 9:32 AM Subject: ANN: EMS MySQL Manager 0.92 released Dear Sirs and Madams, EMS HiTech company is announcing the next version (0.92) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 0.92? 1. New services were added. Check out the Service menu to find this new features. Now you can Analyze, Check, Repair and Optimize tables step by step with corresponding wizard: a) Analyze Tables wizard allows you to analyze and store the key distribution for specified tables. b) Check Tables wizard allows you to check specified tables for errors. c) Repair Tables wizard allows you to repair a possible corrupted tables. d) Optimize Tables wizard allows you to optimize tables with variable-length rows. 2. The Server Properties menu item was added. Now you can get a detailed information about MySQL server, such as server version, server variables and currently running processes. See menu Service to find it. 3. A few little improvements and minor bugfixes were added. What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit of all MySQL database objects most easy and simple way, run SQL scripts, manage users and administrate users' privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make you work with MySQL server as easy as you want... Best regards, EMS HiTech development team. http://www.ems-hitech.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: EMS MySQL Manager 0.92 released
No problems here, Possibly mailing list issues? Peter Harvey wrote: Ok... this is getting out of hand. Is it just me or are we getting a posting every week on this? Please keep these postings to majour releases (1.0, 2.0, etc)... at most. Post your minor releases to your own mailing list. This is a relevant product but we do not want to pollute the list. Thanks! Peter Table,MySQL - Original Message - From: Igor Brynskich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 17, 2001 9:32 AM Subject: ANN: EMS MySQL Manager 0.92 released Dear Sirs and Madams, EMS HiTech company is announcing the next version (0.92) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 0.92? 1. New services were added. Check out the Service menu to find this new features. Now you can Analyze, Check, Repair and Optimize tables step by step with corresponding wizard: a) Analyze Tables wizard allows you to analyze and store the key distribution for specified tables. b) Check Tables wizard allows you to check specified tables for errors. c) Repair Tables wizard allows you to repair a possible corrupted tables. d) Optimize Tables wizard allows you to optimize tables with variable-length rows. 2. The Server Properties menu item was added. Now you can get a detailed information about MySQL server, such as server version, server variables and currently running processes. See menu Service to find it. 3. A few little improvements and minor bugfixes were added. What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit of all MySQL database objects most easy and simple way, run SQL scripts, manage users and administrate users' privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make you work with MySQL server as easy as you want... Best regards, EMS HiTech development team. http://www.ems-hitech.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 Spawning Tons of Processes
On Mon, Sep 17, 2001 at 10:03:29AM -0700, Michael McConnell wrote: It certainly does seem that 3.23.40+ take considerably more resources to do the exact same thing, than MySQL 3.22.xx If that's the case, it's worth tracking down so that it can be fixed. Is this correct? I hope not. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 11 days, processed 217,020,420 queries (216/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can't change to run as ...
I can run safe_mysqld as user MySQL to start the mysql daemon. However, when I try to use safe_mysqld as user root, I get the message, Can't change to run as user 'MySQL'. Any hints much appreciated. Thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: can't change to run as ...
Hello Chris! I can run safe_mysqld as user MySQL to start the mysql daemon. However, when I try to use safe_mysqld as user root, I get the message, Can't change to run as user 'MySQL'. Any hints much appreciated. Thanks in advance. From rc.local: su - mysql -c '/usr/local/sbin/safe_mysqld --log' Have a :) day! jb -- jim barchuk [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
reset auto_increment?
Can someone tell me how to reset a column's auto_increment starting point back to 0 in mysql ? Thanks Paul - 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: Can't delete from very fat table: ERROR 1030: Got error 22 fromtable handler
Hello root! Description: Can't delete from incredibly fat table. Synopsis: unable to delete table data, running out of disk space for it! Well, that pretty much wraps it up, doesn't it? This is a hardware problem, not a software problem. The software must read the old table and create and entirely new table -before- it deletes the old table. So it takes 10M - 1k of free drive space to delete 1k from the original table. Try deleteing a 'several months' worth of data at one shot as you mentioned. You can mysqldump the table and edit it manually and reload it but that still requires a lot of drive space. If you can dump the table, you can delete the real table and very likely have enough drive space to edit and reload but that takes a bit of faith, crossed fingers, and a few heart thumping moments. If you can dump the table but not edit it you can ftp it over to another machine that has enough drive space to edit it. Then ftp it back and reload it. (By coincidence my htdig froze up last night during the nightly update. I usually have about 500M free but forgot to clean up a few things yesterday and left only about 200M free. Gonna write a cron to log free space during that period to find out the the real limit is.) Have a :) day! jb -- jim barchuk [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
copying information
Dear Sirs, I have a database with a lot of information. Can I copy that information to another server??? It's because I'm gonna change of hosting company!!! (I use PHP and Perl) Thanking in advance, Nuno Lopes P.S.: When you reply to the list, reply to me too, 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: reset auto_increment?
Can someone tell me how to reset a column's auto_increment starting point back to 0 in mysql ? Thanks Paul According to Paul DuBois on page 169 of MySQL by New Riders (which you should buy): ALTER TABLE t DROP i, ADD i INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY Jay - 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: copying information
Dear Sirs, I have a database with a lot of information. Can I copy that information to another server??? It's because I'm gonna change of hosting company!!! (I use PHP and Perl) Thanking in advance, Nuno Lopes MySQLDump is what you need, and is quite well documented (many examples exist in the list archives as well.) Good luck! Jay Fesco - 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
Fulltext in v4.0 - why should select count(*) from table match field against ('string') be slow ?
I have a table with about 3.5 million records with a fulltext index on text field of about 90 characters. This has name and address data I'm trying to match against a dirty input string. I've recompiled with the following changed in ft_static.c. ft_min_word_len=2 /* I want to find words like 'BIO' */ ft_precompiled_stopwords [] = { my own list inserted here based on a perl program that does word counts and sorts by frequency }; If I make the stop list big all is fine - but really I'd to be able to tune the full text queries on the fly so a smaller stop list is much better. Now with a small top list I have given myself the ability to do pointless queries that return almost everything and run for ages. eg. select * from table match field against ('a phrase with very common words in here') limit 40 runs for 800 secs No problem (I think) I'll just check there are no bad (ie very common) words in the query then throw them out of the phrase above. select count(*) from table match field against ('word1') select count(*) from table match field against ('word2') select count(*) from table match field against ('word2') ... etc .. The bad news is even these are slow if the word is common WHY ? The full text index should already know the single word count and return in a flash ? Is it still doing scoring and sorting in the count query on a single word - could I turn this off ? Sergei - any ideas ? Thanks Boris Cownie - 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: reset auto_increment?
At 3:15 PM -0400 9/17/01, Jay Fesco wrote: Can someone tell me how to reset a column's auto_increment starting point back to 0 in mysql ? Thanks Paul According to Paul DuBois on page 169 of MySQL by New Riders (which you should buy): ALTER TABLE t DROP i, ADD i INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY Jay Actually, this will drop the column and renumber the rows sequentially. To just reset the sequence to 0 (well, to 1, since sequences start at 1), do this: ALTER TABLE t AUTO_INCREMENT = 1 -- Paul DuBois, [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
Question about converting
I need to convert from Mysql to access for testing reasons. when I do the Mysql dump it either gives me the query code or it saves a file with .sql extension. how do I get this information into access? I wish I could but can not connect direcly to the mysql server cause of the way the hoster set it up. Thank you in Advance Troy - 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: BDB table error
Hi! Dana == Dana Powers [EMAIL PROTECTED] writes: Dana Certainly I understand how the deadlock can occur, but the question is why Dana is this acceptable behaviour? Is the application developer expected to Dana handle this case? If so, how? and shouldnt this be included in the manual Dana under BDB problems? If Im supposed to wrap _every_ sql call I make to a BDB Dana table with something like: 'do { query } while ( !deadlock );' why would I Dana even bother trying to use BDB tables? This seems to me like a _fundamental_ Dana weakness of the BDB table type, and should at least be documented as such... We shall will add som more documentation about this ASAP. In MySQL 3.23.43 you will get the following error: Error: 1213 (ER_LOCK_DEADLOCK) Deadlock found when trying to get lock; Try restarting transaction, Anyway, the problem you are experiencing is something that is normal with all transactional databases. When you have many clients that is reading/updating the same table there is always cases when you will get deadlocks or other failure in the transaction and you have to redo the whole transaction in the application. Regards, Monty - 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: Question about converting
Troy, Have you considered MyODBC? Access works well with linked ODBC tables. Then, within Access, you can copy the linked table into an Access table. Hope this helps! Christopher Reed Application Analyst Information Technology City of Lubbock [EMAIL PROTECTED] Troy Montour [EMAIL PROTECTED] 3:56:14 PM 9/17/2001 I need to convert from Mysql to access for testing reasons. when I do the Mysql dump it either gives me the query code or it saves a file with .sql extension. how do I get this information into access? I wish I could but can not connect direcly to the mysql server cause of the way the hoster set it up. Thank you in Advance Troy - 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: BDB table error
Thanks for the reply! I can understand the situation with muti statement transactions, but I'm not using transactions ( at least from my perspective ); Im only issuing single 'atomic' statements. It would make much more sense if mysql internally detected the deadlock, released the locks and tried to process the statement again. It just seems so counter-intuitive that i can connect, issue a single, isolated select statement and get a deadlock. I dont know if this is possible, but I would love something like this in the mysql engine: retry-deadlock: error = do_query(); if ( ( auto-commit == on ) ( error == DEADLOCK ) ( ++tries threshold ) ) { warn('Deadlock detected. Retrying query.'); goto retry-deadlock; } Of course this could go into the application code, but it would have to go around every single query, transactional or not, and that seems so cumbersome given that the solution is the same in every case. dpk - Original Message - From: Michael Widenius [EMAIL PROTECTED] To: Dana Powers [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, September 17, 2001 2:19 PM Subject: Re: BDB table error Hi! Dana == Dana Powers [EMAIL PROTECTED] writes: Dana Certainly I understand how the deadlock can occur, but the question is why Dana is this acceptable behaviour? Is the application developer expected to Dana handle this case? If so, how? and shouldnt this be included in the manual Dana under BDB problems? If Im supposed to wrap _every_ sql call I make to a BDB Dana table with something like: 'do { query } while ( !deadlock );' why would I Dana even bother trying to use BDB tables? This seems to me like a _fundamental_ Dana weakness of the BDB table type, and should at least be documented as such... We shall will add som more documentation about this ASAP. In MySQL 3.23.43 you will get the following error: Error: 1213 (ER_LOCK_DEADLOCK) Deadlock found when trying to get lock; Try restarting transaction, Anyway, the problem you are experiencing is something that is normal with all transactional databases. When you have many clients that is reading/updating the same table there is always cases when you will get deadlocks or other failure in the transaction and you have to redo the whole transaction in the application. Regards, Monty - 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] - 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: Fulltext - why should select count(*) be slow ?
Hi! On Sep 17, Boris Cownie wrote: select count(*) from table match field against ('word1') select count(*) from table match field against ('word2') select count(*) from table match field against ('word2') ... etc .. The bad news is even these are slow if the word is common WHY ? The full text index should already know the single word count and return in a flash ? Is it still doing scoring and sorting in the count query on a single word - could I turn this off ? You see, MyISAM index structure does NOT maintain a counter for every index entry. So, the only way to found the number of index entries corresponding to a particular word is to scan the index. That is, it's fast to locate those words (due to b-tree structure) but scan time is proportional to the number of words. :-( Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hoping for Crash recovery Miracle
Hi there, I would really appreciate any help someone can give on the following awful problem.. I have been working all day on filling a table with data. (Small records..) Because I have a table which I filled with some binary data someone asked me how big this will get.. I looked at the directory and did a 'tar cfvz' command to (pack the data to a file) an look how big the file would get.. I am not sure what I did wrong, but I got an error which I didn't look at very carefully After this it looked as if I damaged the table I worked on all day The table consists of: 4440 records.. On this moment I can see this number listed when I do a: select count(*) from tablename... (So far so good) When I do a select * from ... this table I get the following error: Warning: MySQL: Unable to save result set in /www/websites/mubo/login/phpmyadmin/sql.php3 on line 65 (This ss a error from the PHP script doing the query, but the error: 'MySQL: Unable to save result set' probably is from mysql..) The three table files look as follow: 2.8M -rw-r-1 root root 2.7M Sep 18 00:37 mubo_boekhoud_boekhoud.ISD 140k -rw-r-1 root root 135k Sep 18 00:37 mubo_boekhoud_boekhoud.ISM 12k -rw-r-1 root root 8.6k Sep 18 00:37 mubo_boekhoud_boekhoud.frm When I do a isamchk mubo_boekhoud_boekhoud I get the following: [root@jaguar test]# isamchk mubo_boekhoud_boekhoud Checking ISAM file: mubo_boekhoud_boekhoud Data records:4440 Deleted blocks: 0 - check file-size isamchk: warning: Size of datafile is: 2878557Should be: 403794 - check delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 - check record links isamchk: error: Wrong bytesec: 31-139-8 at linkstart: 0 ISAM-table 'mubo_boekhoud_boekhoud' is corrupted Fix it using switch -r or -o What are my options...??? If I could only get the data in a readable form, I could at least get back some data.. The .ISD file should be O.K, is it possible to regenerate the .ISM files.. ?? What can I try.. If anyone think I still have some options I will very much appreciate to hear this.. I did try a isamchk -o command, this was the result: [root@jaguar test]# isamchk -o mubo_boekhoud_boekhoud - recovering ISAM-table 'mubo_boekhoud_boekhoud.ISM' Data records: 4440 Wrong bytesec: 31-139- 8 at 0; Skipped Data records: 0 [root@jaguar test]# The .ISD file is truncated to 0 bytes and I then have a table with 0 records... Thankyou very much for any help.. With kind regards David .. - 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
Fw: Hoping for Crash recovery Miracle
Hi there, I would really appreciate any help someone can give on the following awful problem.. I have been working all day on filling a table with data. (Small records..) Because I have a table which I filled with some binary data someone asked me how big this will get.. I looked at the directory and did a 'tar cfvz' command to (pack the data to a file) an look how big the file would get.. I am not sure what I did wrong, but I got an error which I didn't look at very carefully After this it looked as if I damaged the table I worked on all day The table consists of: 4440 records.. On this moment I can see this number listed when I do a: select count(*) from tablename... (So far so good) When I do a select * from ... this table I get the following error: Warning: MySQL: Unable to save result set in /www/websites/mubo/login/phpmyadmin/sql.php3 on line 65 (This ss a error from the PHP script doing the query, but the error: 'MySQL: Unable to save result set' probably is from mysql..) The three table files look as follow: 2.8M -rw-r-1 root root 2.7M Sep 18 00:37 mubo_boekhoud_boekhoud.ISD 140k -rw-r-1 root root 135k Sep 18 00:37 mubo_boekhoud_boekhoud.ISM 12k -rw-r-1 root root 8.6k Sep 18 00:37 mubo_boekhoud_boekhoud.frm When I do a isamchk mubo_boekhoud_boekhoud I get the following: [root@jaguar test]# isamchk mubo_boekhoud_boekhoud Checking ISAM file: mubo_boekhoud_boekhoud Data records:4440 Deleted blocks: 0 - check file-size isamchk: warning: Size of datafile is: 2878557Should be: 403794 - check delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 - check record links isamchk: error: Wrong bytesec: 31-139-8 at linkstart: 0 ISAM-table 'mubo_boekhoud_boekhoud' is corrupted Fix it using switch -r or -o What are my options...??? If I could only get the data in a readable form, I could at least get back some data.. The .ISD file should be O.K, is it possible to regenerate the .ISM files.. ?? What can I try.. If anyone think I still have some options I will very much appreciate to hear this.. I did try a isamchk -o command, this was the result: [root@jaguar test]# isamchk -o mubo_boekhoud_boekhoud - recovering ISAM-table 'mubo_boekhoud_boekhoud.ISM' Data records: 4440 Wrong bytesec: 31-139- 8 at 0; Skipped Data records: 0 [root@jaguar test]# The .ISD file is truncated to 0 bytes and I then have a table with 0 records... Thankyou very much for any help.. With kind regards David .. - 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
Overwrite only if it exists HELP please!
I need to insert a phone number into a table. I would do this with the insert command except I think that it would create duplicate entries even though they are exactly the same is there a way that I can have it not enter the data if it exists already TIA Armando - 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: Overwrite only if it exists HELP please!
At 5:34 PM -0700 9/17/01, Armando Cerna wrote: I need to insert a phone number into a table. I would do this with the insert command except I think that it would create duplicate entries even though they are exactly the same is there a way that I can have it not enter the data if it exists already INSERT IGNORE will ignore the new record if it duplicates an existing record on a primary key value. It's in the manual: http://www.mysql.com/doc/I/N/INSERT.html TIA Armando - 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 -- Paul DuBois, [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: Overwrite only if it exists HELP please!
I understand everything you said except primary key do i need one I have seen it before in some fields but have no clue what it is... thanks btw =) Armando On Monday 17 September 2001 05:44 pm, you wrote: At 5:34 PM -0700 9/17/01, Armando Cerna wrote: I need to insert a phone number into a table. I would do this with the insert command except I think that it would create duplicate entries even though they are exactly the same is there a way that I can have it not enter the data if it exists already INSERT IGNORE will ignore the new record if it duplicates an existing record on a primary key value. It's in the manual: http://www.mysql.com/doc/I/N/INSERT.html TIA Armando - 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: Overwrite only if it exists HELP please!
At 5:54 PM -0700 9/17/01, Armando Cerna wrote: I understand everything you said except primary key do i need one I have seen it before in some fields but have no clue what it is... thanks btw =) All the more reason to consult the manual! :-) Armando On Monday 17 September 2001 05:44 pm, you wrote: At 5:34 PM -0700 9/17/01, Armando Cerna wrote: I need to insert a phone number into a table. I would do this with the insert command except I think that it would create duplicate entries even though they are exactly the same is there a way that I can have it not enter the data if it exists already INSERT IGNORE will ignore the new record if it duplicates an existing record on a primary key value. It's in the manual: http://www.mysql.com/doc/I/N/INSERT.html TIA Armando -- Paul DuBois, [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
mySQL database files help
I was running a mySQL server under slackware for a while, it was interacting with php on an apache webserver, and everything worked fine. There were a few times where I would mess linux up and need to re-install, in which case I would move my database files to my windows partition, re-install linux, move the database files back (database files being everything in /var/lib/mysql) and everythign worked fine. I just decided to change to Debian, and followed the same procedure. After moving my database files back to the /var/lib/mysql directory, and running mysql, if I try to do anything with my tables, i would get the message dbfile.ISM is missing. When I looked in my directory, all the files were of the format dbFile.MYD, dbFile.MYI and dbFile.frm. As far as I know, the files have always been of these extensions (instead of .ISM, .ISD and .frm). If they have not, I have no idea how they changed. Does anyone know how to get mySql (version Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) ) to either recognize my current files as valid, or how to get the data in those files into something that mySQL will recognize. Thank you very much. There is alot of important info in those tables, and I really need them. -Chase - 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
Can't get MySQL running on RH7.0 at all.
I must be a moron but I can't seem to figure out what I need to do to get mysql to work on RH, on Mandrake it just worked straight away. I read and followed the instructions in the INSTALL-BINARY (inspite of the fact that the way red hat installed mysql does not even closely resemble the instructions) but mysql will not come up. This is the error log: 010917 11:26:38 mysqld started 010917 11:26:38 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010917 11:26:38 mysqld ended 010917 11:32:09 mysqld started 010917 11:32:10 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld.pid' (Errcode: 13) 010917 11:32:10 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010917 11:32:10 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' (Errcode: 2) 010917 11:32:10 mysqld ended There must be some secret bit of knowledge that is obvious to everybody else and i'm just not reading the right document or something. I'm sure somebody has been able to install MySQL via the RPMs and get it to work. Can anyone help me with this? Do I need to create a user called mysql and add them to the group root? I'm suspicious of the permission problems... thanks for your time... - 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
Cannot login
Here's what I'm doing. Appently something is going wrong but I am missing exactly what. Any suggestions? Martin mysql INSERT INTO user (Host,User,Password) VALUES('%','chimbis',PASSWORD('pompeji')); Query OK, 1 row affected (0.00 sec) mysql GRANT USAGE ON *.* TO chimbis@% IDENTIFIED BY 'pompeji'; Query OK, 0 rows affected (0.00 sec) [root@chimbis src]# mysql -u chimbis -p Enter password: ERROR 1045: Access denied for user: 'chimbis@localhost' (Using password: YES) [root@chimbis src]# - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re:ERROR 1073: create InnoDB tables!
Hi, Heikki. Thanks for the info. I understand your first explanation, I'll try. You can probably circumvent the problem by adding an extra VARCHAR column where you put the first 255 characters of the blob column. Would you please inform me more externation of second. Can you give me an examples? Or maybe you could generate an artificial primary key with auto-increment, for example? -- Best regards. - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 13, 2001 12:50 AM Subject: Re:ERROR 1073: create InnoDB tables! Hi! You can probably circumvent the problem by adding an extra VARCHAR column where you put the first 255 characters of the blob column. Or maybe you could generate an artificial primary key with auto-increment, for example? Regards, Heikki http://www.innodb.com Hi, I tried create table specify type=InnoDB.with the following script: create table objects(uri blob not null, primary key uriIndex (uri(255)), classname blob) type=InnoDB;I'm getting the following error ERROR 1073: BLOB column 'uri' can't be used in key specification with the used \ table typeThis is what I found in the mySQL docs: * Only the MyISAM table type supports indexing on BLOB and TEXT columns. When putting \ an index on a BLOB or TEXT column you MUST always specify the length of the index: CREATE TABLE test (blob_col BLOB, index(blob_col(10))); I could change the uri to varchar but... * Values in VARCHAR columns are variable-length strings. I can declare a VARCHAR \ column to be any length between 1 and 255, just as for CHAR columns. That's not very good, we can choose- transactions but uri limited to 255 chars - no limit but also no transactions Is it supported ? If yes, please let me know how?Any help is welcome. - 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
AW: [linux] US victims
7 days are now over dear God take the souls of the inocent in thy hands. there is only one question to be answered Who was the man in the back ground ??? Who payed the for the atak of terrorism ??? the one to put the mony for killers, who was it ???. The one will now have to pay with somthing else. Let him alive. but let him burry all he all the man kind he killed let him dig with his own hands more then 5000 graves for every one and let him think with every dig of shovel, what he did If the ones to start the war would have to burry every one they have killed - there would not be war on the mother earth, just or not just. Walter Bertin -Ursprüngliche Nachricht- Von: Lebrun Jonathan [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 17. September 2001 10:02 An: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; Vincent; Verlinden Catherine; Verliefden Jean-Luc; [EMAIL PROTECTED]; tolkien75; Thumelaire Catherine; Sylvie Guillon; Sylvianne Haubruge; [EMAIL PROTECTED]; stéphanie schulze; Snauwaert Valérie; silarbi mustapha; Sébastien Libert; Sébastian Ladrière; [EMAIL PROTECTED]; [EMAIL PROTECTED]; Rizzante Gaëtan 705076008; Rih Naoufal; pyxl; Prakash Manghwani; Pierre-Alain Joye; Pat Rundall; paduwat gregory; [EMAIL PROTECTED]; [EMAIL PROTECTED]; NOURY Loic; Nathalie Schraenen; Michael Thaler; MEUNIER Thibaud; Meuleman Bénédicte; Messori Franca; Mathelart Sébastien; [EMAIL PROTECTED]; Louw, Karolien; Lenoir Fréderic; Lejeune Isabelle; [EMAIL PROTECTED]; [EMAIL PROTECTED]; Laurent Buset; Jonathan Michel Lebrun; [EMAIL PROTECTED]; Jenny Dupuy; Jean-Marie Lambert; Jean-François Boucart; Jean Hermes; [EMAIL PROTECTED]; Jacob Martin; Huygens Axelle; Hurny Cristel; Harwant Grewal; Gylian.Dumay; guillaume henneau; guillaume Gorges; Greg Cardoza; [EMAIL PROTECTED]; [EMAIL PROTECTED]; Franck Touyaa; [EMAIL PROTECTED]; Fabrice GRUWIER; [EMAIL PROTECTED]; fabien DUMINY; Eric Dezaire; Don Dietrick; Denis Gysen; david.duhain; David Dehon; Dave Eno; Daniel Ducat; Cristina Infantino; Cozmin Lucau; Corinne LAMACHE; Clarisse Normand; Claire Symons; Christophe Zych; CF Brussels PC Development Permanent; Carole DAUPIN; Cardinal Sophie; Michel; Boule (E-mail); Bernard Lefèbvre; Asseta Mascia; Artigas, Ricardo Y.; Andy Green; [EMAIL PROTECTED]; Aldo111 Betreff: Fw: [linux] US victims Lebrun Jonathan F.U.C.a.M Rue de Binche,151 Mons 065/32.32.97 [EMAIL PROTECTED] - Original Message - From: Ninja [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 14, 2001 12:23 PM Subject: [linux] US victims | http://www.whitexworldpeace.org | -- | A+ | | Luc[EMAIL PROTECTED] ICQ 37011625 |http://users.skynet.be/kobukai/ | | Si quelqu'un te demande | Quel est l'esprit du Japon: | C'est une fleur de cerisier | Qui s'exhale au Soleil Levant. | - Motoori Norinaga | | _ | Do You Yahoo!? | Get your free @yahoo.com address at http://mail.yahoo.com | | | [ Soyez précis dans vos sujets svp afin de déterminer directement ] | [ le type de demande...] | [ Pour vous (dés)inscrire, aller sur http://unixtech.be/ml.php ] | [ Archives de la mailing list: http://archives.unixtech.be/linux/ ] | [ http://unixtech.be Contact: [EMAIL PROTECTED] ] - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
AW: [linux] US victims
7 days are now over dear God take the souls of the inocent in thy hands. there is only one question to be answered Who was the man in the back ground ??? Who payed the for the atak of terrorism ??? the one to put the mony for killers, who was it ???. The one will now have to pay with somthing else. Let him alive. but let him burry all he all the man kind he killed let him dig with his own hands more then 5000 graves for every one and let him think with every dig of shovel, what he did If the ones to start the war would have to burry every one they have killed - there would not be war on the mother earth, just or not just. Walter Bertin -Ursprüngliche Nachricht- Von: Lebrun Jonathan [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 17. September 2001 10:02 An: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; Vincent; Verlinden Catherine; Verliefden Jean-Luc; [EMAIL PROTECTED]; tolkien75; Thumelaire Catherine; Sylvie Guillon; Sylvianne Haubruge; [EMAIL PROTECTED]; stéphanie schulze; Snauwaert Valérie; silarbi mustapha; Sébastien Libert; Sébastian Ladrière; [EMAIL PROTECTED]; [EMAIL PROTECTED]; Rizzante Gaëtan 705076008; Rih Naoufal; pyxl; Prakash Manghwani; Pierre-Alain Joye; Pat Rundall; paduwat gregory; [EMAIL PROTECTED]; [EMAIL PROTECTED]; NOURY Loic; Nathalie Schraenen; Michael Thaler; MEUNIER Thibaud; Meuleman Bénédicte; Messori Franca; Mathelart Sébastien; [EMAIL PROTECTED]; Louw, Karolien; Lenoir Fréderic; Lejeune Isabelle; [EMAIL PROTECTED]; [EMAIL PROTECTED]; Laurent Buset; Jonathan Michel Lebrun; [EMAIL PROTECTED]; Jenny Dupuy; Jean-Marie Lambert; Jean-François Boucart; Jean Hermes; [EMAIL PROTECTED]; Jacob Martin; Huygens Axelle; Hurny Cristel; Harwant Grewal; Gylian.Dumay; guillaume henneau; guillaume Gorges; Greg Cardoza; [EMAIL PROTECTED]; [EMAIL PROTECTED]; Franck Touyaa; [EMAIL PROTECTED]; Fabrice GRUWIER; [EMAIL PROTECTED]; fabien DUMINY; Eric Dezaire; Don Dietrick; Denis Gysen; david.duhain; David Dehon; Dave Eno; Daniel Ducat; Cristina Infantino; Cozmin Lucau; Corinne LAMACHE; Clarisse Normand; Claire Symons; Christophe Zych; CF Brussels PC Development Permanent; Carole DAUPIN; Cardinal Sophie; Michel; Boule (E-mail); Bernard Lefèbvre; Asseta Mascia; Artigas, Ricardo Y.; Andy Green; [EMAIL PROTECTED]; Aldo111 Betreff: Fw: [linux] US victims Lebrun Jonathan F.U.C.a.M Rue de Binche,151 Mons 065/32.32.97 [EMAIL PROTECTED] - Original Message - From: Ninja [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 14, 2001 12:23 PM Subject: [linux] US victims | http://www.whitexworldpeace.org | -- | A+ | | Luc[EMAIL PROTECTED] ICQ 37011625 |http://users.skynet.be/kobukai/ | | Si quelqu'un te demande | Quel est l'esprit du Japon: | C'est une fleur de cerisier | Qui s'exhale au Soleil Levant. | - Motoori Norinaga | | _ | Do You Yahoo!? | Get your free @yahoo.com address at http://mail.yahoo.com | | | [ Soyez précis dans vos sujets svp afin de déterminer directement ] | [ le type de demande...] | [ Pour vous (dés)inscrire, aller sur http://unixtech.be/ml.php ] | [ Archives de la mailing list: http://archives.unixtech.be/linux/ ] | [ http://unixtech.be Contact: [EMAIL PROTECTED] ] - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
Newbie queries
Hi I am new to My SQL and have just installed it on a Win 98 machine. can you recommend any good front end tool to generate reports ? At present the interface available for both input and output is phpAdmin. Also how does one import data from excel; is it possible ? ans - 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
Does MySql support Synchronous/asynchronous I/O
Hi, Does MySql support Synchronous or asynchronous I/O or both? What do they mean when they ask me if - copy Db is supported by mysql? - version db is supported by mysql? - Sync/Async write strategies? Currently I have been asked to evaluate mysql against TimesTen. Is there such an comparision available? As you can see I'm new to this, request ur patience thanks rock = __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ - 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: Newbie queries
Some people like to use MS Access as a frontend using MyODBC to 'link tables'. If you have access, you'll need to install myodbc ( available in the downloads section of www.mysql.com ), configure a datasource connection with a valid username + password etc, and then in access: File - Get External Data - Link Tables Then choose 'ODBC Connections' in the file type drop down. Select your newly created connection ( from myodbc installation above ), choose your tables and booyaah - your mysql data will seem just like access tables! dpk - Original Message - From: Amit Sathe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 17, 2001 10:36 PM Subject: Newbie queries Hi I am new to My SQL and have just installed it on a Win 98 machine. can you recommend any good front end tool to generate reports ? At present the interface available for both input and output is phpAdmin. Also how does one import data from excel; is it possible ? ans - 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 database files help
It appears that your change to debian was also a change from the current 3.23 mysql version to the old 3.22 version ( major releases ). The old version, 3.22, does not support MyISAM tables, so you'll need to upgrade to the new version. Debian stable, aka potato, uses 3.22, but both woody + sid ( testing + unstable ) are using 3.23. I have no problems running apache + php4 + mysql on debian unstable, if you are concerned about upgrading to the 'non' stable trees. I dont know if you can find a potato-fied mysql-3.23 .deb out there, but it may be available. dpk - Original Message - From: Chase Peeler chase@mail To: [EMAIL PROTECTED] Sent: Monday, September 17, 2001 8:05 PM Subject: mySQL database files help I was running a mySQL server under slackware for a while, it was interacting with php on an apache webserver, and everything worked fine. There were a few times where I would mess linux up and need to re-install, in which case I would move my database files to my windows partition, re-install linux, move the database files back (database files being everything in /var/lib/mysql) and everythign worked fine. I just decided to change to Debian, and followed the same procedure. After moving my database files back to the /var/lib/mysql directory, and running mysql, if I try to do anything with my tables, i would get the message dbfile.ISM is missing. When I looked in my directory, all the files were of the format dbFile.MYD, dbFile.MYI and dbFile.frm. As far as I know, the files have always been of these extensions (instead of .ISM, .ISD and .frm). If they have not, I have no idea how they changed. Does anyone know how to get mySql (version Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) ) to either recognize my current files as valid, or how to get the data in those files into something that mySQL will recognize. Thank you very much. There is alot of important info in those tables, and I really need them. -Chase - 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: Can't get MySQL running on RH7.0 at all.
The error logs seem to indicate that the pid file you've specified is not writable and that the system database tables are not installed properly. 1. make sure that you ran mysql_install_db. If you did, make sure that you didnt change the my.cnf datadir setting without moving your system files or re running mysql_install_db. 2. ( #1 usually takes care of this, but ) make sure the pid file is writable ( find path in error log message or ./mysqld --help or /etc/my.cnf if you've overrided default ) dpk - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 17, 2001 9:42 PM Subject: Can't get MySQL running on RH7.0 at all. I must be a moron but I can't seem to figure out what I need to do to get mysql to work on RH, on Mandrake it just worked straight away. I read and followed the instructions in the INSTALL-BINARY (inspite of the fact that the way red hat installed mysql does not even closely resemble the instructions) but mysql will not come up. This is the error log: 010917 11:26:38 mysqld started 010917 11:26:38 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010917 11:26:38 mysqld ended 010917 11:32:09 mysqld started 010917 11:32:10 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld.pid' (Errcode: 13) 010917 11:32:10 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010917 11:32:10 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' (Errcode: 2) 010917 11:32:10 mysqld ended There must be some secret bit of knowledge that is obvious to everybody else and i'm just not reading the right document or something. I'm sure somebody has been able to install MySQL via the RPMs and get it to work. Can anyone help me with this? Do I need to create a user called mysql and add them to the group root? I'm suspicious of the permission problems... thanks for your time... - 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