backup
Hi, Does any one have a shell script to ftp a file to another location, so that I can schedule to run this file with cron. Many thanks, Hasan - Original Message - From: +ACI-Gerald R. Jensen+ACI- +ADw-gjensen+AEA-autodatasys.com+AD4- To: +ACI-Impex Holidays Maldives / Hasan+ACI- +ADw-hasan+AEA-impex.com.mv+AD4AOw- +ADw-mysql+AEA-lists.mysql.com+AD4- Sent: Sunday, February 24, 2002 10:56 PM Subject: Re: backup +AD4- We us a shell script that calls a cronjob (root) at 3am daily. +AD4- +AD4- The line in the cronjob is: +AD4- +ACo- 3 +ACo- +ACo- +ACo- /usr/local/bin/dbbakup.sh username password +AD4- +AD4- The shell script: +AD4- +AD4- ++ACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIw- +AD4- +ACMAIQ-/bin/sh +AD4- +ACM- +ACQ-1 +AD0- Unix/MySQL Username +AD4- +ACM- +ACQ-2 +AD0- Unix/MySQL Password +AD4- +AD4- if +AFs- +ACE- -e /dbbakup +AF0- +AD4- then +AD4- mkdir /dbbakup +AD4- fi +AD4- +AD4- mysqldump -u+ACQ-1 -p+ACQ-2 -c --add-drop-table --add-locks --flush-logs +--databases +AD4- account+AD4-/dbbakup/account.sql +AD4- mysqldump -u+ACQ-1 -p+ACQ-2 -c --add-drop-table --add-locks --flush-logs +--databases +AD4- payroll+AD4-/dbbakup/payroll.sql +AD4- mysqldump -u+ACQ-1 -p+ACQ-2 -c --add-drop-table --add-locks --flush-logs +--databases +AD4- contact+AD4-/dbbakup/contact.sql +AD4- +AD4- ++ACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIw- +AD4- +AD4- If you wanted to ftp the resulting scripts to another server, you could add +AD4- code to the shell script to run ncftpput, etc. +AD4- +AD4- Gerald Jensen +AD4- +AD4- - Original Message - +AD4- From: +ACI-Impex Holidays Maldives / Hasan+ACI- +ADw-hasan+AEA-impex.com.mv+AD4- +AD4- To: +ADw-mysql+AEA-lists.mysql.com+AD4- +AD4- Sent: Sunday, February 24, 2002 10:31 AM +AD4- Subject: backup +AD4- +AD4- +AD4- Hello everyone, +AD4- +AD4- I am trying to do backups using the crond daemon on my Linux server. +AD4- +AD4- Can I write a similar line as below on my crontab file. Any examples would +AD4- be appreciated. +AD4- +AD4- mysqldump impex +AD4- siteroot/home/hasan/backup/backup.sql +AD4- +AD4- Alternatively i am thinking of running a perl file ...which will find access +AD4- to the database and then do the backing and add this +AD4- file to the crontab. +AD4- Has anyone got a file pre-written for this purpose. +AD4- +AD4- thank you so much. +AD4- Hasan +AD4- +AD4- +AD4- +AD4- - +AD4- Before posting, please check: +AD4-http://www.mysql.com/manual.php (the manual) +AD4-http://lists.mysql.com/ (the list archive) +AD4- +AD4- To request this thread, e-mail +ADw-mysql-thread100889+AEA-lists.mysql.com+AD4- +AD4- To unsubscribe, e-mail +AD4- +ADw-mysql-unsubscribe-autodata+AD0-execpc.com+AEA-lists.mysql.com+AD4- +AD4- Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php +AD4- +AD4- +AD4- +AD4- +AD4- +AD4- - +AD4- Before posting, please check: +AD4-http://www.mysql.com/manual.php (the manual) +AD4-http://lists.mysql.com/ (the list archive) +AD4- +AD4- To request this thread, e-mail +ADw-mysql-thread100894+AEA-lists.mysql.com+AD4- +AD4- To unsubscribe, e-mail ++ADw-mysql-unsubscribe-hasan+AD0-impex.com.mv+AEA-lists.mysql.com+AD4- +AD4- Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php +AD4- +AD4- - 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: encrypting password fields
Thanks guys, Cristian also suggested that I could encrypt the password via the porgramming language I use with mysql(php,perl,etc). How could this be done? I am using the struts framework. JSPs and Java. Does this mean that I can only use md5()? cheers, Ki Mien -Original Message- From: MikeParton [EMAIL PROTECTED] Sent: Sunday, July 07, 2002 3:43 AM To: MikeParton [EMAIL PROTECTED], Ki Mien [EMAIL PROTECTED], [EMAIL PROTECTED] [EMAIL PROTECTED] Subject:Re: encrypting password fields oopsthat's my Apache version. I am using MySQL 4.0.1 and have used md5() with MySQL 3.23.49-max-nt - Original Message - From: MikeParton [EMAIL PROTECTED] To: Ki Mien [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, July 06, 2002 3:02 PM Subject: Re: encrypting password fields I have MySQL 2.0.39 on Win NT and I use md5() to create a digest of the password. Perhaps not the highest level of password encryption, but works for the level of security I need. - Original Message - From: Ki Mien [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, July 06, 2002 4:16 AM Subject: encrypting password fields Hi mySql gurus, I have a table that contains my customers username and password. I would like to know how I can encrypt these values so that they are not stored how in the way that my customers have keyed them from the front end. I have read the documentation on password(), and encrypt but it won't work as I am using windows os and mysql version 3.23.49-max-nt-log. I appreciate any help on this. cheers, Ki Mien cOntact @ Lycos http://contact.lycosasia.com = 10MB for email and filestore + lots of other goodies... - 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 Take part in the Penning on Squares Chinese Essay Writing Contest. Submit your masterpieces or vote for your favourite works, and win attractive prizes. Be there or be SQUARE! http://sea.litcontest.lycosasia.com cOntact @ Lycos http://contact.lycosasia.com = 10MB for email and filestore + lots of other goodies... - 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
An existing table
Hello, Is there a way to add a column to an existing table in a mysql database? couldn't find it on the guide. 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: An existing table
Yes: ALTER TABLE `tablename` ADD `columnname` datatype George - Original Message - From: Yair Zohar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 07, 2002 11:46 AM Subject: An existing table Hello, Is there a way to add a column to an existing table in a mysql database? couldn't find it on the guide. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to search for backlash in a field?
Hello, I created a MYISAM table named 'TBLTest', there is a field named 'value', varchar(32) binary, I insert value in it with a backlash as 'test\ABC', I can search the record by : value='test\\ABC', but I cannot search it by : value like '%test\\ABC%'. The SQL: 1,create the table: create table TBLTest( value varchar(32) binary) ) 2,insert a record: insert into TBLTest values('test\\ABC') 3,the SQL which can find the record just I inserted: select * from TBLTest where value='test\\ABC' 4,the SQL which CANNOT find the record: select * from TBLTest where value like '%test\\ABC%' 5,the SQL which CANNOT find the record: select * from TBLTest where value like '%\\%' Is it a bug or just MySQL designed as that. I am not good at English,I am very sorry if this letter is diffcult for you to read. Thank you very much. _ Do You Yahoo!? ÒøÐоÞÍ·¾Û»áÖÐÔ ´óÀËÌÔ¡®½ð¡¯Ë½«Ð¦°Á http://sweepstakes.yahoo.com/bank_surveywave2/ - 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: An existing table
Give the command: alter table tablename add column column_name create_definition (section 7.7 in the mysql manual) Malki Cymbalista Webmaster, Weizmann Institute of Science Rehovot, Israel 76100 Internet: [EMAIL PROTECTED] Yair Zohar [EMAIL PROTECTED] 07/07/02 01:46PM Hello, Is there a way to add a column to an existing table in a mysql database? couldn't find it on the guide. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backup of mysql
Pada Sun, 7 Jul 2002 17:53:08 +0500 Impex Holidays Maldives / Hasan [EMAIL PROTECTED] menulis : Hi, This may be out of topic,but still I'm working on a mysql back up file. Does any one have a shell script to ftp a file to another location, so that I can schedule to run this file with cron. Many thanks, Hasan 1. you can use replication configuration, but not running it as real time replication ... your cronjob just do load table tablename from master 2. your cronjob do mysqldump - ftp 3. or just ftp the data ... but you'll have table error/corrupt for result. ;-) -- Linux! Guerrilla UNIX Development Venimus, Vidimus, Dolavimus. -- Mark A. Horton KA4YBR, [EMAIL PROTECTED] MySQL 3.23.51 : up 16 days, Queries : 368.371 per second (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: Need help on Matching MySQL, Apache PHP
Pada Sat, 06 Jul 2002 15:10:43 + duo fu [EMAIL PROTECTED] menulis : Dear Friends: I have installed Apache 1.3.26, MySQL.3.23.51 successfully. However, I failed to install tarball versions of PHP4.21 with Apache1.3.26 under my REDHAT 6.2. I always got the error message when I tried to start the APache. - [root@broekhoven libexec]# /usr/local/apache/bin/apachectl start Syntax error on line 205 of /usr/local/apache/conf/httpd.conf: Cannot load /usr/local/apache/libexec/libphp4.so into server: /usr/local/apache/libexec/libphp4.so: undefined symbol: pcre_malloc /usr/local/apache/bin/apachectl start: httpd could not be started -- try to use your PHP as cgi rather than as module (change the config on httpd.conf) ... it should be easier if you don't want/avoid installing all from source (again) :D -- printk(??? No FDIV bug? Lucky you...\n); 2.2.16 /usr/src/linux/include/asm-i386/bugs.h MySQL 3.23.51 : up 16 days, Queries : 368.312 per second (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: mysqldump
Pada Sat, 6 Jul 2002 12:22:44 +0400 Papa Carlo [EMAIL PROTECTED] menulis : mysqldump incorrectly export char/varchar binary and *BLOB fields. it export binary fields like text strings INSERT INTO users VALUES (7,'zk',1,'¦î¯¯Çbv','ó+:ºÐ','Ó]¦Ç\ZW¦{','T~âxÎË-','T üc¦SüG\R-¦Íê'); this is obviously incorrect and may contain non-asci characters. I experienced corrupt records in practice. You should use hex representation, for example : INSERT INTO users VALUES (7,'zk'',1,binary 0x112233,binary 0x44556677,.); or at least escape sequences in text strings have you tried to put this dump file back into live DB ? you should check the BLOB value is correct or wrong ... i never had bad experiences in dumping blob data :D -- printk(??? No FDIV bug? Lucky you...\n); 2.2.16 /usr/src/linux/include/asm-i386/bugs.h MySQL 3.23.51 : up 16 days, Queries : 368.294 per second (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: Access denied error
Pada Sat, 06 Jul 2002 09:36:27 +0500 (IST) VINOD [EMAIL PROTECTED] menulis : I own a domain with MySQL support. I have created a database lnet_cal on the web and also table yarntype, using PHP Myad- min on the webspace and also granted all access privileges to user lnet_root to the database. can u show us the value from DB mysql regarding this privilege ... use mysql; select * from user where user=lnet_root; select * from db where user=lnet_root; maybe we can help you to analyze your problem ;-) -- Let's call it an accidental feature. -- Larry Wall MySQL 3.23.51 : up 16 days, Queries : 368.249 per second (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: Setting up hostname
Pada Fri, 05 Jul 2002 14:19:21 -0700 Desmond Lee [EMAIL PROTECTED] menulis : Hi guys I just managed to install mysql... yippy But, i had to use the '--force option' when executing the /usr/local/mysql/scripts/mysql_install_db . I got a message saying that i needed to configure the hostname latter on. So, now that mysql is isntalled i need to set up the hostname stuff. My host name is just my ip address. And the message also said that it couldn't lookup my host? I've done searches on google and the mysql documentation but i didn't get any useful info about setting up the hostname. I'm just wondering if anyone out there can help me out. check your system configuration ... just run from shell script : hostname and what does it show you ... and then check your /etc/hosts and /etc/resolv.conf after you sure your hostname has been configured properly (on OS side), then restart your mysqld ;-) should be work by then ... -- Write clearly - don't be too clever. - The Elements of Programming Style (Kernighan Plaugher) MySQL 3.23.51 : up 16 days, Queries : 368.224 per second (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
MySql User Lookup
Is there a way to check which my sql user (who has logged into the database) has inserted a row in a table? I could add a logged_in_user column but that seems redundant. --- Introducing NetZero Long Distance Unlimited Long Distance only $29.95/ month! Sign Up Today! www.netzerolongdistance.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 User Lookup
Pada Sun, 7 Jul 2002 13:04:02 -0400 sajiddalvi [EMAIL PROTECTED] menulis : Is there a way to check which my sql user (who has logged into the database) has inserted a row in a table? I could add a logged_in_user column but that seems redundant. you can set your mysqld to log all activities (from my.cnf or command-line when starting mysqld), and track it from the log files. but mysql doesn't have like last as UNIXes do. for active users, you can see from show processlist -- Sic transit discus mundi -- From the System Administrator's Guide, by Lars Wirzenius MySQL 3.23.51 : up 16 days, Queries : 367.960 per second (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
Deep Nesting
Hi; I'm trying to programmatically create tables which are nested so deeply that I fear I'll be creating a gargantuan number of them. I'm seeking a means to limit this, if possible. I'm creating what I call *open source metaphysics*. Here's the scenario: The tables will be used to enable users to enter comments concerning what they believe happens at individual conjunctions. For example, in astrology, let's say one enters a comment of what happens when the Moon enters Scorpio. These comments can then be called by other users and rated with an accreditation system similar to Amazon's rating of books (and those who rate them). The problem occurs with granulation. Let's say, instead, that our above example is when the Moon enters Scorpio while the Sun is in the fifth degree of Aries and Mars is in the twentieth degree of Gemini while the natal chart reflects that this nativity has an ascendant at the seventh degree of Cancer, etc. Indeed, it's actually far more involved than that, because I'd like to cross-reference other metaphysical systems (Tzolkin, I Ching, etc.) several of which have nativities as well as transient elements. I can see tables literally in the thousands (or much higher) with no way to avoid this proliferation. Any suggestions? TIA, BenO sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installing mysqladmin
My platform is RH Linux and I did a rpm with rpm -i /tmp/MySQL-3.23.49a-1.i386.rpm I got back the acknowledgement and the suggestion that I change the root user password with /usr/bin/mysqladmin However, mysqladmin is not on the system!! What did I miss?? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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
privileges
I'm using a MySQL and PHP4 setup that was done for me by the websites owner. I am able to run MySQL through telneting in through SSH, but I can't seem to run any MySQL through the website. Mysql_connect() seems to just hang up the browser till it times out. It doesn't give me password or user incorrect errors, it just times out on a blank page. Once I take the mysql_connect() off the page, the page loads up but of course I can't do any MySQL since it can't connect. Here is the line I am using: $link_id = mysql_connect($dbhost, $dbusername, $dbuserpassword); // where the $dbhost, $dbusername, $dbuserpassword are preset I was wondering if this could be do to privileges or what. Is there a way I could check privileges of my user name and password? Or is there anything else I should check out to see why it is doing this behavior? Thanks ahead of time! -Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installing mysqladmin
At 11:03 -0700 7/7/02, Todd Cary wrote: My platform is RH Linux and I did a rpm with rpm -i /tmp/MySQL-3.23.49a-1.i386.rpm I got back the acknowledgement and the suggestion that I change the root user password with /usr/bin/mysqladmin However, mysqladmin is not on the system!! What did I miss?? The part of the manual that points out how the RPM you installed contains only the server part? :-) For RPM installs, you'll need the MySQL-client.VERSION.i386.rpm file to get the client programs. Install that and you should be all right. - 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
Licensing--web site is schizophrenic
At one place on the MySQL site I see: http://www.mysql.com/support/arrangements.html which says the client library is under the LGPL. At another place I see: http://www.mysql.com/doc/C/o/Copyright.html which says the entire codebase, including the client, is released under the GPL. Does this mean newer versions of MySQL client libraries are GPL'd? I'll be disappointed if this is true, because there are plenty of open source licenses which are incompatible with the GPL. This means that none of those other open source projects can use or include support for MySQL. Which is a shame. -- --- Paul D. Smith [EMAIL PROTECTED] HASMAT--HA Software Mthds Tools Please remain calm...I may be mad, but I am a professional. --Mad Scientist --- These are my opinions---Nortel Networks takes no responsibility for them. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installing mysqladmin
Paul - My mistake was worse than what I thought: somehow I had renamed the Server and Client so they both had the same RPM code. This is why my Client install was *NOT* working. Sone days :-) !! I have a beginners question: how can I have mysql create a database in a different directory than the default. I want a database in /home/sfyc. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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
Deep Nesting (sql)
Hi; I'm trying to programmatically create tables which are nested so deeply that I fear I'll be creating a gargantuan number of them. I'm seeking a means to limit this, if possible. I'm creating what I call *open source metaphysics*. Here's the scenario: The tables will be used to enable users to enter comments concerning what they believe happens at individual conjunctions. For example, in astrology, let's say one enters a comment of what happens when the Moon enters Scorpio. These comments can then be called by other users and rated with an accreditation system similar to Amazon's rating of books (and those who rate them). The problem occurs with granulation. Let's say, instead, that our above example is when the Moon enters Scorpio while the Sun is in the fifth degree of Aries and Mars is in the twentieth degree of Gemini while the natal chart reflects that this nativity has an ascendant at the seventh degree of Cancer, etc. Indeed, it's actually far more involved than that, because I'd like to cross-reference other metaphysical systems (Tzolkin, I Ching, etc.) several of which have nativities as well as transient elements. I can see tables literally in the thousands (or much higher) with no way to avoid this proliferation. Any suggestions? TIA, BenO sql - 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: Deep Nesting (sql)
The tables will be used to enable users to enter comments concerning what they believe happens at individual conjunctions. For example, in astrology, let's say one enters a comment of what happens when the Moon enters Scorpio. These comments can then be called by other users and rated with an accreditation system similar to Amazon's rating of books (and those who rate them). The problem occurs with granulation. Let's say, instead, that our above example is when the Moon enters Scorpio while the Sun is in the fifth degree of Aries and Mars is in the twentieth degree of Gemini while the natal chart reflects that this nativity has an ascendant at the seventh degree of Cancer, etc. Indeed, it's actually far more involved than that, because I'd like to cross-reference other metaphysical systems (Tzolkin, I Ching, etc.) several of which have nativities as well as transient elements. I can see tables literally in the thousands (or much higher) with no way to avoid this proliferation. Any suggestions? Ok, here's one way I see to organize this: First, create a table with all the possible single events (e.g moon enters Scorpio) (is varchar(100) enough for the description?) and an artificially created event ID (id int not null auto_increment primary key). Next, create a table for all the combinations (it is probably more appropriate here to create entries for combinations actually USED, not all possible combinations, as a table for all possible combinations may rapidly exceed the amount of disk storage ever manufactured). I am not sure what you'd need here beyond just a combination ID, but there might be some kind of composite rating of the event. Next, create a table to relate events to combinations (a many-to-many relationship). This combination happens when this event, that event, and a third event happens. This table has two columns, event ID and combination ID, and lists the events that make up a combination. For example, if a combination C happens when three events, X, Y, and Z happen, then you'd have three rows: Event IDCombination ID X C Y C Z C The combination (event ID, combination ID) should be unique. Now, create a table for the people making comments. This would include a commenter ID (primary key), some kind of text name for that person, and possibly a password they use to make comments under their name. This might include an email address and billing information. Next, create a table for the comments. This contains a combination ID for what they are commenting on, the commenter ID, and the comment made. Ok, that's 5 tables. I can't see the number of tables growing even if astrology suddenly discovered 27 more planets and 5 new signs of the zodiac. The contents of the tables would get bigger, but there wouldn't be more of them. I'm not that familiar with Amazon's rating system so I can't comment on what additional tables are needed for that. You'd need a SQL query with a multi-way join to get the description of the combination, the commenter name, and the comment made, but this shouldn't be hard or slow with appropriate indexes on the tables. Gordon L. Burditt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installing mysqladmin
At 13:42 -0700 7/7/02, Todd Cary wrote: Paul - My mistake was worse than what I thought: somehow I had renamed the Server and Client so they both had the same RPM code. This is why my Client install was *NOT* working. Sone days :-) !! I have a beginners question: how can I have mysql create a database in a different directory than the default. I want a database in /home/sfyc. Let MySQL create it in the data directory, then move it where you want it and make a symlink to the new location in the data directory. - 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: Deep Nesting (sql)
Beautiful. Thanks! BenO At 05:00 PM 7/7/02 -0500, you wrote: The tables will be used to enable users to enter comments concerning what they believe happens at individual conjunctions. For example, in astrology, let's say one enters a comment of what happens when the Moon enters Scorpio. These comments can then be called by other users and rated with an accreditation system similar to Amazon's rating of books (and those who rate them). The problem occurs with granulation. Let's say, instead, that our above example is when the Moon enters Scorpio while the Sun is in the fifth degree of Aries and Mars is in the twentieth degree of Gemini while the natal chart reflects that this nativity has an ascendant at the seventh degree of Cancer, etc. Indeed, it's actually far more involved than that, because I'd like to cross-reference other metaphysical systems (Tzolkin, I Ching, etc.) several of which have nativities as well as transient elements. I can see tables literally in the thousands (or much higher) with no way to avoid this proliferation. Any suggestions? Ok, here's one way I see to organize this: First, create a table with all the possible single events (e.g moon enters Scorpio) (is varchar(100) enough for the description?) and an artificially created event ID (id int not null auto_increment primary key). Next, create a table for all the combinations (it is probably more appropriate here to create entries for combinations actually USED, not all possible combinations, as a table for all possible combinations may rapidly exceed the amount of disk storage ever manufactured). I am not sure what you'd need here beyond just a combination ID, but there might be some kind of composite rating of the event. Next, create a table to relate events to combinations (a many-to-many relationship). This combination happens when this event, that event, and a third event happens. This table has two columns, event ID and combination ID, and lists the events that make up a combination. For example, if a combination C happens when three events, X, Y, and Z happen, then you'd have three rows: Event IDCombination ID X C Y C Z C The combination (event ID, combination ID) should be unique. Now, create a table for the people making comments. This would include a commenter ID (primary key), some kind of text name for that person, and possibly a password they use to make comments under their name. This might include an email address and billing information. Next, create a table for the comments. This contains a combination ID for what they are commenting on, the commenter ID, and the comment made. Ok, that's 5 tables. I can't see the number of tables growing even if astrology suddenly discovered 27 more planets and 5 new signs of the zodiac. The contents of the tables would get bigger, but there wouldn't be more of them. I'm not that familiar with Amazon's rating system so I can't comment on what additional tables are needed for that. You'd need a SQL query with a multi-way join to get the description of the combination, the commenter name, and the comment made, but this shouldn't be hard or slow with appropriate indexes on the tables. Gordon L. Burditt - 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
Cannot set privileges
When I log into mysql with [root mysql]# mysql -u root -p and enter the password, I have access to mysql. Then I type in grant all on * to todd identified by 'mypassword' with grant option; Now when I do a select * from users; All of the privileges for todd have N's. Have I missed something here? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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
MERGE FULLTEXT, two years later.
I searched the archives and in December 2000 it did 'not yet' work. ( http://listarchive.nextrieve.com/mysql//200012/msg00539.html ) Will MERGE tables and FULLTEXT indexes work together in 4.x? Two-and-a-half years later? Regards, -Sander - 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
Join problem in MYSQL
sql,query Can anyone have a look at my join. It returns errors Select O.name, O.amount , P.Productname, P.price From Orders AS O JOIN Products AS P ON O.product=P.Productid Where O.cluster= 'ANP'; It works fine when I use Select O.Name, O.amount, P.productname , P.price From Orders as O, Products as P Where O.product=P.productid AND O.cluster = 'ANP'; When I use the first example with INNER JOIN it works as well. The book I use as study guide is a few years old so maybe the syntax has changed ?? Any ideas - 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: Cannot set privileges
Thanks to Paul, I solved the problem by replacing the * with *.*. In my PHP and MySQL book, the * is used in the examples. Any explanation why this does not work? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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
UDF, Can anyone please help?
Hi, I've being trying for the last couple of months to convert a MS Access to Mysql. I pull out data extract from around 100 + queries. These took about 5 months of solid work to develop and are extremely complex. I can convert these to mysql, but have one big problem. There is no last function in mysql. I know you can do a descending sort by ID and grab the first row to get the same thing. This will not work as I need to do it over several thousand different groups. So I need the last row per group. I have been trying to write a aggregate last UDF function in mysql, and would consider this to be very simple, however, I can't get it to work. I don't really know how to program in C and my understanding of it is quite vague. I really need some help to do this from someone in the community. I have posted several times in the past and haven't heard anything from anyone. I am getting quite frustrated and are about ready to flag this exercise as a great waste of time. I have successful so far got the UDF to compile, and installed. I had to recompile mysql for HPUx to get it to support UDFs in the first place. It has taken me 50+ hours to export several hundred meg of data from access to mysql. I have even written quite a bit of code/scripts to get it to the point where I can start fixing things. So, please, can anyone help me with this. I don't expect someone to do this all for me, but just a LITTLE help would be nice. I will quite happily post this back into the community if I can get it to work. I have removed myself off the mailing digest as the volume is too high. If you could please email me at [EMAIL PROTECTED] Yours Gratefully Miles - 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
find record using MYSQL command in ASP
dear all, when i want to find some records in mysql table using ASP script language, i found an error on it. this is error message in my script: Microsoft OLE DB Provider for ODBC Drivers error '80040e29' The rowset cannot scroll backwards /find_record.asp, line 16 and this is my ASP script: % dim objconn, objrs dim sqltxt, criteriatxt set objconn = server.createobject(adodb.connection) set objrs = server.createobject(adodb.recordset) objconn.connectionstring=server=192.168.0.1;driver=MySQL;db=clientdb;uid=us er;pwd=user objconn.open connectionstring sqltxt = select * from client criteriatxt = name like 'TELE*' objrs.open sqltxt, objconn objrs.find criteriatxt if objrs.eof then response.write(record is not exist!) else response.write objrs(code) objrs(name) objrs(address) br end if objrs.close objconn.close set objrs = nothing set objconn = nothing % - 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: find record using MYSQL command in ASP
Hi there, Try this % dim objconn, objrs dim sqltxt, criteriatxt, adopenkeyset, adlockoptimistic adopenkeyset=1 adlockoptimistic=3 set objconn = server.createobject(adodb.connection) set objrs = server.createobject(adodb.recordset) objconn.connectionstring=server=192.168.0.1;driver=MySQL;db=clientdb;uid=us er;pwd=user objconn.open connectionstring sqltxt = select * from client criteriatxt = name like 'TELE*' objrs.open sqltxt, objconn, adopenkeyset, adlockoptimistic objrs.find criteriatxt if objrs.eof then response.write(record is not exist!) else response.write objrs(code) objrs(name) objrs(address) br end if objrs.close objconn.close set objrs = nothing set objconn = nothing % Hope this helps - 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
Relationship between Questions and Com_*
If I want to break down what types of queries my server is handling (INSERT/DELETE/UPDATE/etc) I can look at the Com_* values provided by SHOW STATUS. If I sum up the Com_* values I get a number much larger than the value of Questions. My guess is that this is because REPLACE executes both an INSERT and DELETE at times. Can anyone shed some light on how Questions relates to Com_*? Thanks! Lance sql,query,sql,query,sql,query,sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: find record using MYSQL command in ASP
Beste Defrin... thank u very much my friend. it is work! :D Cheers... - Original Message - From: Defryn, Guy [EMAIL PROTECTED] To: 'Ivan Paul' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 08, 2002 10:38 Subject: RE: find record using MYSQL command in ASP Hi there, Try this % dim objconn, objrs dim sqltxt, criteriatxt, adopenkeyset, adlockoptimistic adopenkeyset=1 adlockoptimistic=3 set objconn = server.createobject(adodb.connection) set objrs = server.createobject(adodb.recordset) objconn.connectionstring=server=192.168.0.1;driver=MySQL;db=clientdb;uid=us er;pwd=user objconn.open connectionstring sqltxt = select * from client criteriatxt = name like 'TELE*' objrs.open sqltxt, objconn, adopenkeyset, adlockoptimistic objrs.find criteriatxt if objrs.eof then response.write(record is not exist!) else response.write objrs(code) objrs(name) objrs(address) br end if objrs.close objconn.close set objrs = nothing set objconn = nothing % Hope this helps - 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
export table?
Where is info on exporting a table? I checked the mysql docs and the only reference to export has nothing to do with exporting a table. I want to copy a table from one server to another, should be simple enough, right? -- Chip [EMAIL PROTECTED] www.wiegand.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php