Re: mysqldump of one table?
hi i want to dump the contents of one table into a text file ... can you tell me what i've done wrong ? i tried : mysqldump --opt --tables studenttable myfile.txt mysqldump --opt --databases [studenttable] myfile.txt mysqldump --opt database [studenttable] myfile.txt but all these result in an error ... i can dump the whol database but not the table studenttable mysqldump database_name table_name myfile.txt / Carsten Carsten H. Pedersen Keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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 - Ultradev
Subject: MySql - Ultradev From: David Raza Date: Wed, 13 Dec 2000 15:55:48 - I was wondering if anyone has managed to use Dreamweaver Ultradev with a MySQL Database? I've been getting started with UltraDev through ColdFusion to mySQL this week. I'm stuck at the moment, trying to get an 'insert record' working. I was stuck yesterday as well, getting a search to work, and the reason it wasn't working was that UltraDev didn't put some quotes into the SQL statement where it should have. Had to put them in by hand, and then it worked fine. Laura SPRU Web Admin www.sussex.ac.uk/spru/ www.sussex.ac.uk/Users/qlfe2/ [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: Number of Tables..?
What is the largest number of table per database does MySQL support? http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_4_0 / Carsten Carsten H. Pedersen Keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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 core dumping mysql
Hi! I'm having core dumps in mysql 3.23.28 ( BSD 4.2 ) during mysqldump. I've tried different options, now I'm currently running: mysqldump -F -l -q -O max_allowed_packet=16777216 db but sometimes mysql core dumps. Thanks for any idea!
MySQL CAPI and Multiple connections
Hi, I'm building a C API MySQL client. I need to connect to different dbs at the same time. My code is (approximately): // MYSQL mysql, *conn1, *conn2; mysql_init(mysql) conn1 = mysql_real_connect(mysq, ip1, user1, pass1, db1, 0, NULL, 0) printf("conn1 = %d", conn1); conn2 = mysql_real_connect(mysq, ip2, user2, pass2, db2, 0, NULL, 0) printf("conn2 = %d", conn1); conn3 = mysql_real_connect(mysq, ip3, user3, pass3, db3, 0, NULL, 0) printf("conn3 = %d", conn3); // ... use conn1 // ... use conn2 // ... use conn3 mysql_close(conn1); mysql_close(conn2); mysql_close(conn3); mysql_close(mysql); // I see always that (conn1 == conn2 == conn3), so the prevuoius connection are overwritten. Could you give some explanation about this? How can I mantain different connections on different db (or different ip, user, etc)? Thanks == Valerio FerrucciTabasoft Sas [EMAIL PROTECTED] http://tabasoft.ancitel.it [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: choose a free databse management
There are mnay free RDBMS around besides MySQL This includes: Postgresql mSQL (mini SQL) Oracle 8i is free for Linux The learning curve from any RDBMS eg: from Postgresql to MySQL or Oracle to MySQL because they are ANSI SQL compliant. On Fri, 12 Jan 2001, you wrote: Hi everybody, I have to choose a database management in order to save a little database (15 tables of 10 000 rows max.) Does someone tell me if mysql is the only free database management? If it doesn't why do you think mySQL is better than other (which are free)? thanks for your help, gaetan - 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 C API multiple connections
Valerio Ferrucci writes: Hi, I'm building a MySQL C API client. I need to connect to different dbs at the same time. My code is (approximately): // MYSQL mysql, *conn1, *conn2; mysql_init(mysql) conn1 = mysql_real_connect(mysq, ip1, user1, pass1, db1, 0, NULL, 0) printf("conn1 = %d", conn1); conn2 = mysql_real_connect(mysq, ip2, user2, pass2, db2, 0, NULL, 0) printf("conn2 = %d", conn1); conn3 = mysql_real_connect(mysq, ip3, user3, pass3, db3, 0, NULL, 0) printf("conn3 = %d", conn3); // ... use conn1 // ... use conn2 // ... use conn3 mysql_close(conn1); mysql_close(conn2); mysql_close(conn3); mysql_close(mysql); // I see always that (conn1 == conn2), so the first connection is lost. Could you give some explanation about this? How can I mantain different connections on different db (ip, user, etc)? == Valerio FerrucciTabasoft Sas [EMAIL PROTECTED] http://tabasoft.ancitel.it [EMAIL PROTECTED] Hi! In all three cases try: conn1 = mysql_real_connect(NULL, ip1, user1, pass1, db1, 0, NULL, 0); Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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-3.23.30-gamma Compile Problem
I have a problem , I install mysql and i have a mistake : install_driver(mysql) failed: Can't load '/usr/local/lib/perl5/site_perl/5.005/s un4-solaris/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/ bin/perl: fatal: relocation error: file /usr/local/lib/perl5/site_perl/5.005/sun 4-solaris/auto/DBD/mysql/mysql.so: symbol uncompress: referenced symbol not foun d at /usr/local/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm line 169. at (eval 1) line 3 Perhaps a required shared library or dll isn't installed where expected at cofide.cgi line 12 Cuold you tell me what is the problem?? Thanks John Romano wrote: Hi All. I'm trying to compile mysql on a intel SMP machine and I get the following error. I'm using redhat 7 any ideas? c++ -O3 -DDBUG_OFF -fno-implicit-templates -rdynamic -o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadline.a -lncurses ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -lz -lcrypt -lnsl -lm -Wl,--rpath -Wl,/usr/local/mysql/lib/mysql ../libmysql/.libs/libmysqlclient.so: undefined reference to `mkstemp64' collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory `/home/temp/mysql-3.23.30-gamma/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/temp/mysql-3.23.30-gamma' make: *** [all-recursive-am] Error 2
Re: query much slower when function used...?
okay, with gdb i can see that this column becomes a blob (thereby not allowing heap tables to be used - which has got to be costing me speed), is there any function i can use to 'cast' this column to a fixed length? hrm, apparently LEFT(SUBSTRING(MAX(CONCAT())), N) will do that for me... sorry for thinking out loud ;-) ahh, this works generically for the 'create table' portion of it, but in order to prevent the blob from being in the tmp table, this really needs to be SUBSTRING(MAX(LEFT(CONCAT(),N))) because the contents of MAX() wind up in the tmp table. and N = 255 (with the potential truncation of data realized as a possibility) to avoid blobishness. or, i could redesign my tables so that the total length of the columns/constants used in CONCAT() was = 255... - 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: index corruption and mysqld crash
Thank you for your help but there is no cron job that kills the process. I also got an answer that was not CC'd to the list that suggested me to install 3.23. I have installed 3.23 (mysqld Ver 3.23.30-gamma for pc-linux-gnu on i686) today since I had a lot of users complaining and could not spend time investigating the problem. In order to be sure of data integrity, I made a mysqldump with 3.22, removed 3.22, installed 3.23, created a new database from mysqldump result and ran myisamchk before restarting our web server (there was no corrupt data at that time). After 2 hours of MySQL running with an average of 250 requests/s without crashing (that's the good news ;), I shut down MySQL and ran myisamchk, one of the table was corrupt ! The message from myisamchk was: Checking MyISAM file: message.MYI Data records: 896368 Deleted blocks: 0 - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 /usr/bin/myisamchk: error: Key 2 doesn't point at same records that key 1 - check record links /usr/bin/myisamchk: error: Keypointers and record positions doesn't match MyISAM-table '/msqldb/mysql/rencontre/message.MYI' is corrupted Fix it using switch "-r" or "-o" So, since installing a new version is not an option anymore, let me ask again : Is it possible to run myisamchk while mysqld is running ? In this case, is it enough to remove --skip-locking option (set in safe_mysqld) or should I also add --enable-locking ? Also, what will be the impact on performance with this option ? Does anybody have any suggestion on where I could look in order to find what is causing these corruptions ? Thanks for your help -- Joseph Bueno NetClub/Trader.com Rolf Hopkins wrote : I can think of only one suggestion. See if there is a cron job or something killing a process. I doubt it though. Hope it helps. - Original Message - From: "Joseph Bueno" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 12, 2001 1:31 Subject: index corruption and mysqld crash Hello, I have switched this morning our Web server from mSQL to MySQL. I am using MySQL 3.22.32 installed from MySQL-3.22.32-1.i386.rpm on a Linux server (RedHat 6.2). mysqld dies very ofen (uptime is between 2mn and 20mn) and the only messages I have in error file look like : Number of processes running now: 1 mysqld process hanging, pid 10827 - killed mysqld restarted on jeu jan 11 17:35:58 CET 2001 /usr/sbin/mysqld: ready for connections Number of processes running now: 1 mysqld process hanging, pid 7973 - killed mysqld restarted on jeu jan 11 17:38:25 CET 2001 /usr/sbin/mysqld: ready for connections I have shut down mysqld several times and run isamchk. Each time, I had to repair at least one table. Is it possible to run isamchk while mysqld is running ? In this case, is it enough to remove --skip-locking option (set in safe_mysqld) or should I also add --enable-locking ? Does anybody have any suggestion on where I could look in order to find what is causing these corruptions ? Thanks for your help -- Joseph Bueno NetClub/Trader.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
Pre-installed MySQL from Redhat 7.0
Fellow travelers, I'm a MySQL debutant. I have no experience with it (other than not being able to get it to work on my Dell PowerEdge 1400 server running RedHat Linux 7.0). Is the RedHat Linux 7.0 distribution of MySQL a satisfactory or difficult one to use. Is it a good idea to buy a distribution from a concern like Abriasoft, in order to get a more useful or complete distribution of the software plus support. Does anyone have a recommendation? Also, can you recommend any books for a newcomer to MySQL? Thanks, Marc P - 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
Off list request for a mySQL solution
Hello, Jonas Norrman at mysql.com suggested that I write directly to this list with my request... I would appreciate if any responses would be sent directly to me at: [EMAIL PROTECTED] --- original message --- We are currently evaluating a hotel management software package which runs on Filemaker Pro 5.x but I understand that MySQL will be available on Mac OS X Server when OS X is released by Apple on March 24. I am looking for hotel/Bed and Breakfast-like management software that is available on MySQL platforms... can you please direct me to someone or somewhere where I can get more information? Thank you. --- end of message --- Thanks everyone... I look forward to hearing from people who use mySQL in the hospitality industry. -John Spady University of Washington Friday Harbor Labs - 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: Perl question
Well, this is a little off topic - but: - name your perl program to nph-yourname.pl (this will allow the non parse output) Start your perl-Script with: #!/usr/bin/perl $|=1; print "HTTP/1.0 200 OK\nServer: CERN/3.0\n"; print "Content-type: multipart/x-mixed-replace;boundary=magicalboundarystring\n"; print "Content-type: text/html\n\n"; . Hope this helps... Mit freundlichen Gruessen, Helge Schacht ___ Helge Christian Schacht Internetservice shop-and-order.net InternetMarketing Jersbeker Str. 7b 23863 Bargfeld-Stegen Tel : +49 4532 262507 Fax : +49 4532 262508 email: [EMAIL PROTECTED] http://shop-and-order.net ___ Verbund - Marketing - Partner: http://rcity.de http://urlaubs-zentrale.de http://saonet.de http://shop-and-order.com http://123shop.de http://reise-zentrale.de http://pkvnetz.de http://reisevertrieb.de http://ihr-geld.de http://internet-con.de http://reise-welt.de http://starttravel.de ___ -Ursprngliche Nachricht- Von: Ron Beck [mailto:[EMAIL PROTECTED]] Gesendet am: Freitag, 12. Januar 2001 17:57 An: Mysql Betreff: Perl question Hello all, I have a procedure that queries my database and produces a line of output for each query. It then processes the data and performs another query. Everything works great interactively. I get the first processing message, wait a bit, get the next processing message, etc... However, when I run this same procedure as a web page, nothing is displayed until the program has completed all processing steps. I would like each processing message to display to my web page as soon as it appears, not (apparently) cached until the procedure has completed. I _KNOW_ there's a way to make perl immediately print the information but for the life of me I can't remember what it is. Can anyone PLEASE help??? Thanks regards, Ron - 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: Locking records
MySQL doesn't have built in row-level locking, but they are chaning that. The best thing to do, for now, is to have a record_locked column, and set it to 1 if the record is in use. To lock the record, you would run a query like update table_name set record_locked = 1 where id = ??? and record_locked = 0 'id' is an auto increment column, so each row has a unique id. If the record is locked, the query will return 0 rows affected, and you wait a while. If it is not yet locked, and the query changes it, it will return 1 row affected, and you now know you have a lock on it. Another note. Something to experiment with, but I'm not sure this is guarenteed behavior, so tread carefully; this was an accidental discovery. This query should also work: update table_name set record_locked = 1 where id = ??? If the record_locked column is already 1, it won't set it to one again, so you might not need the 'and record locked = 0' part of the query, but I'd use it to be safe. Hope that helps. j- k- On Friday 12 January 2001 05:34, Martin Thoma wrote: Hello ! I want to make something like: There is one server and seval clients, which all access the same database. The problem: If one user changes a record, no other user should be able to change it. Whats the general way to do it with MySQL ? Regards Martin -- Joshua Kugler Associated Students of the University of Alaska Fairbanks Information Services Director [EMAIL PROTECTED] 907-474-7601 - 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: third time asking help concerning charsets
Sometimes when people aren't answering a question, it isn't because they are ignoring you or consider your questions stupid. Sometimes it's because we don't know the answer. Your question has nothing to do with MySQL and everything to do with php. It doesn't like that charset. I have no clue on how to make it like it, I don't know what it wants. Ask a php list. - Original Message - From: "Roman Serbski" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 7:43 PM Subject: third time asking help concerning charsets I'm sorry, this is the third time I ask help from this list. No suggestions :-(, not even one. If it is a dummy question please point me to some url ... whatever. Good day all! Please help me with charset adding. I have some strange trouble. I use FreeBSD 4.2 STABLE and MySQL 3.23.28-gamma (compiled from FreeBSD ports) and PHP 4.04. As I understood Latin1 is a default charset. So, I wanted to add cp1251 or koi8_ru. Ok, I add --default-character-set=cp1251 to my mysql start-up script. The problem is: If I connect from console to mysql and type \s (to get status information) it shows: Language: cp1251 Everything seems OK, but if I try to connect via phpMyAdmin or Horde (webmail implementation) it returns - For phpMyAdmin Warning: MySQL Connection Failed: Can't initialize character set 14 (path: default) in /usr/local/www/htdocs/adm/lib.inc.php on line 255 Error For Horde Warning: Can't initialize character set 14 (path: default) in /usr/local/lib/phplib/db_mysql.inc on line 73 I don't know where is my mistake? I do have sql/share/charsets folder with Index and cp1251.conf. I checked Index - records are OK. Should I add something to /etc/my.cnf file? Looking forward to hear from you. Regards, Roman - 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: I need to tell MySQL that i have other database
Did you use mysqldump to save your databases? It is *highly* recommended that you do that instead of just copying the database files over. This way, you can just dump all the data back in and mysql will take care of everything :) If not, you can tell mysqld where to look for its databases: -h, --datadir=pathPath to the database root Atle On Fri, 12 Jan 2001, William M. wrote: Hi, I have been looking for in the manual but i didn't find anything, that how i tell to MySQL tha i have a databases. I had Linux SuSE 6.4 in my box and i decide to change it to Mandrake 7.2, so i made a backup in a windows box of the databases. Now i have Mandrake 7.2 with MySQL and how i tell it and where, that i have others databases... I copy in a windows box in C:\Databases\Inventary(database) and C:\Databases\Projects(database) Where i pass the Inventory and Projects databases in Mandrake box, and MySQL start to know them. (i saw that, one instruction in Postgresql but in MySQL no¡) Thank you... William M. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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: RedHat 7 and MySQL - Can't start server
I would suggest checking your errorlogs. They should be in your datadir. tail datadir/hostname.err that should tell you what the problem is. If you can't figure out how to fix it, you might want to copy and paste the last couple of lines from your logs in your email. Atle On Fri, 12 Jan 2001, John W Cunningham wrote: Hello All, When I try to start the server, with a fresh RPM install, this is what I get... [root@localhost bin]# /usr/bin/safe_mysqld [1] 8438 [root@localhost bin]# Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended [1]+ Done/usr/bin/safe_mysqld Then I try to run the client... [root@localhost bin]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/) [root@localhost bin]# I'm fairly new at this, but it looks like the server is starting and immediately stopping. Any ideas? Thanks! -John - 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: Installation problem.
At 09:08 12/01/2001 -0500, Jenny Lie wrote: Hi! I did reboot the machine and it still can't do mysqld-nt --install. Anything I should do? The first step, I did run setup.exe, then in c:\mysql\bin, I ran mysqld-nt --install, was that right? That is correct. What is your OS ? Regards, Miguel Thanks for your time. Jenny Lie Web Developer Onramp Network Services Inc. 200 Town Centre Blvd, #302 Markham, ON L3R 8G5 (905) 470-4064 EXT 241 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.onramp.ca -Original Message- From: Miguel Angel Solrzano [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:24 PM To: Jenny Lie; [EMAIL PROTECTED] Subject: Re: Installation problem. At 16:19 11/01/2001 -0500, Jenny Lie wrote: Hi! That isn't a bug. This message is launched when: - The service is already installed. - The Service Control Manager is in bad state. When you see this error message, reboot the machine. Take a look if the service was started. Take a look if the service exists. If exist and doesn't was started, remove it: mysqld-nt --remove Install the service: mysqld-nt --install. Start the service: net start mysql Regards, Miguel Hi, I got a problem when I did this: msqld-nt --install it gave me an error message: Failed to install service. What's the problem exactly? Thanks for you time and help. Jenny Lie Web Developer Onramp Network Services Inc. 200 Town Centre Blvd, #302 Markham, ON L3R 8G5 (905) 470-4064 EXT 241 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.onramp.ca - 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 bugs-unsubscribe-#L=#[EMAIL PROTECTED] __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - 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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - 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: Installation problem.
At 09:08 12/01/2001 -0500, Jenny Lie wrote: Hi! I forget to say you in the last mails that you need to do the login in the NT/W2k machine as Administrator privilege or with an user which has the privilege to install services in the machine. Regards, Miguel I did reboot the machine and it still can't do mysqld-nt --install. Anything I should do? The first step, I did run setup.exe, then in c:\mysql\bin, I ran mysqld-nt --install, was that right? Thanks for your time. Jenny Lie Web Developer Onramp Network Services Inc. 200 Town Centre Blvd, #302 Markham, ON L3R 8G5 (905) 470-4064 EXT 241 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.onramp.ca -Original Message- From: Miguel Angel Solrzano [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:24 PM To: Jenny Lie; [EMAIL PROTECTED] Subject: Re: Installation problem. At 16:19 11/01/2001 -0500, Jenny Lie wrote: Hi! That isn't a bug. This message is launched when: - The service is already installed. - The Service Control Manager is in bad state. When you see this error message, reboot the machine. Take a look if the service was started. Take a look if the service exists. If exist and doesn't was started, remove it: mysqld-nt --remove Install the service: mysqld-nt --install. Start the service: net start mysql Regards, Miguel Hi, I got a problem when I did this: msqld-nt --install it gave me an error message: Failed to install service. What's the problem exactly? Thanks for you time and help. Jenny Lie Web Developer Onramp Network Services Inc. 200 Town Centre Blvd, #302 Markham, ON L3R 8G5 (905) 470-4064 EXT 241 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.onramp.ca - 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 bugs-unsubscribe-#L=#[EMAIL PROTECTED] __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - 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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - 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: Installation problem.
Hi, Thanks! I did log in as Administrator. I'm running Windows NT Server 4.0 Jenny Lie Web Developer Onramp Network Services Inc. 200 Town Centre Blvd, #302 Markham, ON L3R 8G5 (905) 470-4064 EXT 241 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.onramp.ca -Original Message- From: Miguel Angel Solrzano [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 2:31 PM To: Jenny Lie; Miguel Angel Solrzano Cc: MySql Mailing List Subject: RE: Installation problem. At 09:08 12/01/2001 -0500, Jenny Lie wrote: Hi! I forget to say you in the last mails that you need to do the login in the NT/W2k machine as Administrator privilege or with an user which has the privilege to install services in the machine. Regards, Miguel I did reboot the machine and it still can't do mysqld-nt --install. Anything I should do? The first step, I did run setup.exe, then in c:\mysql\bin, I ran mysqld-nt --install, was that right? Thanks for your time. Jenny Lie Web Developer Onramp Network Services Inc. 200 Town Centre Blvd, #302 Markham, ON L3R 8G5 (905) 470-4064 EXT 241 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.onramp.ca -Original Message- From: Miguel Angel Solrzano [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:24 PM To: Jenny Lie; [EMAIL PROTECTED] Subject: Re: Installation problem. At 16:19 11/01/2001 -0500, Jenny Lie wrote: Hi! That isn't a bug. This message is launched when: - The service is already installed. - The Service Control Manager is in bad state. When you see this error message, reboot the machine. Take a look if the service was started. Take a look if the service exists. If exist and doesn't was started, remove it: mysqld-nt --remove Install the service: mysqld-nt --install. Start the service: net start mysql Regards, Miguel Hi, I got a problem when I did this: msqld-nt --install it gave me an error message: Failed to install service. What's the problem exactly? Thanks for you time and help. Jenny Lie Web Developer Onramp Network Services Inc. 200 Town Centre Blvd, #302 Markham, ON L3R 8G5 (905) 470-4064 EXT 241 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.onramp.ca - 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 bugs-unsubscribe-#L=#[EMAIL PROTECTED] __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - 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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - 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
Help with an SQL statement
Thanks for everyone's help with the dat question now I would like to know if someone could help me with another question. I have a table called COUNTER and a field in the table called HITS in an SQL statement I would like to update this field by adding 1 to it's current value any ideas? Thanks, 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
Re: MySQL Performance...
"Patrick FICHE" [EMAIL PROTECTED] writes: I just wanted to know if my assertions are rigth and what are the common way to solve this type of problems ? Store your results into a temporary table? -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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: Index ? Key ?
Martin Thoma wrote: Hello ! I'm a database-newbee. What I need is a column that makes the record unique. The content should be generated autoamtically and it should be able to get a lot of records (BIGINT would be nice). But I don't know if I should use PRIMERY KEY, KEY, INDEX or UNIQUE. Perhaps some could tell me the difference and what would be best for my purpose. Thanks a lot ! Martin You shold have atleast one column (or combination) that is unique to each row in your table, this would be the PRIMARY KEY. If you need the database to enforce the uniqueness of other columns (or combinations) you would use a UNIQUE KEY. KEY and INDEX are synonyms. That work? If you want it generated automaticaly what you want is an auto_increment column something like create table blah (id bigint unsigned not null auto_increment, rest of table columns) would hold a VERY large number that would increase for each entry. probably an 'int unsigned' is big enough for most things. - 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 when accessing from several clients
Hi all, When I access MySQL from several API clients, one of them quits with the error message: Query failed (Lost connection to MySQL server during query) Does any one know why?
Help with a semi-complex query
I'm simplifying slightly, here's the basic tables: build --- idx int namechar(16) test_name idx int namechar(64) main_table idx int unsigned test_name_idx medint status char build int swipchar(11) I want to do the following query, but a little more: select distinct test_name.name, status, build.name from main_table, test_name, build where test_name_idx=test_name.idx AND build.name ='x5.1.0' AND build.idx=build_idx; The above works fine. But I need to get the swip value at the same time, which will break the distict function of returning one result for each test name because I may have multiple results for a single test name build. The following does not work: select distinct test_name.name, status, build.name, swip from main_table, test_name, build where test_name_idx=test_name.idx AND build.name ='x5.1.0' AND build.idx=build_idx; Any suggestions? -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
Re: 3.23.28-gamma Crash and data loss
We have replicated this crash over and over just now... Very strange. Yet with the 2.23.30 version, we dont lose the data and dont seem to get corruption. Here is exactly what happened... (This also crashed it in the first place, which lost all our data in the 2.23.28 version) We have a table called user For testing we went to do this insert into the db... which, by the way, was trying to insert into the 17th row in an auto incremented id... This is a Berkely DB file. ERROR 2013: Lost connection to MySQL server during query mysql insert into user (user_id,user_name,first_name,last_name,display_name,email,notes,password) values (NULL,'testuser','Jason','mCwIl','jason ','[EMAIL PROTECTED]','none','tester'); ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:1 You could sit and do this over and over and over. But, the connection would come right back and no data was lost. So, I actually tried a different query next: insert into user values (NULL,'tester','jason','jason','jason mcwilliams','tridog','','[EMAIL PROTECTED]','','','','','','','','','','','','','','','','','','','',''); or somthing simlar which produced: Query OK, 1 row affected (0.02 sec) So, I thought it might be the format of the insert... so then I try the first insert again: insert into user (user_id,user_name,first_name,last_name,display_name,email,notes,password) values (NULL,'testuser','Jason','mCwIl','jason ','[EMAIL PROTECTED]','none','tester'); Query OK, 1 row affected (0.02 sec) I havn't had another error since? It was like it could not insert that style of insert into that particular row, once it got passed that... it is fine. I would think we could reproduce this by dropping the database recreating it, and redoing the create statements (just like we had to do to recover)... If anyone from mysql is interested in trying to reproduce this, let me know. -- Jason McWilliams Tridog Interactive, Inc. 303-415-2538 Jason McWilliams wrote: Well, we upgraded to 2.23.30 and tried to bring it up with the same seemingly corrupt datafiles. It tried to do a recovery (saw this in the error log), but died when it was looking for database directories that had long ago been deleted. It was like it was making its way through the entire db transaction log. We ended dropping the entire database and going to our most recent mysqldump. We just have to hope that the .30 version fixed this corrupted file thing when mysql crashes. If anyone else has knowledge about this, it would be greatly appreciated. Or if anyone knows what type of fixes were made with Berkely db files from the .28 to .30 release. -- Jason McWilliams Tridog Interactive, Inc. 303-415-2538 "Mehalick, Richard RE SSI-GRAX" wrote: The MySQL team recommended upgrading to 3.23.29 gamma, especially if using Berkeley DB. - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [EMAIL PROTECTED] - -Original Message- From: Jason McWilliams [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 4:23 PM To: [EMAIL PROTECTED] Subject: 3.23.28-gamma Crash and data loss We have been using 3.23.28-gamma with berkely db files so we can use transactions. Platform: BSDI 4.1 Everything was rolling along fine when we ran into this while doing some simple command line stuff... It gives me the error that mysql has gone away... lost connection... Something I have seen before. It simply regains a connection and everything seemed fine... Yet, we lost all data in all .db files. The index information in the .frm files were fine. The regular .MYD and .MYI files were all ok as well. The strange thing is that the .db file sizes were still pretty large. Yet, when doing queries, it just says the rows are gone. You can insert etc... For instance, I did an insert on an auto_encrement field and it gave an id of 1... there were many rows before them mysql crash... Has anyone else seen this type of problem after a mysql crash with the Berkely db files? -- Jason McWilliams Tridog Interactive, Inc. 303-415-2538 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) - 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:
mysql-3.23.30-gamma Compile Problem
Hi All. I'm trying to compile mysql on a intel SMP machine and I get the following error. I'm using redhat 7 any ideas? c++ -O3 -DDBUG_OFF -fno-implicit-templates -rdynamic -o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadline.a -lncurses ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -lz -lcrypt -lnsl -lm -Wl,--rpath -Wl,/usr/local/mysql/lib/mysql ../libmysql/.libs/libmysqlclient.so: undefined reference to `mkstemp64' collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory `/home/temp/mysql-3.23.30-gamma/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/temp/mysql-3.23.30-gamma' make: *** [all-recursive-am] Error 2
Re: Perl question
Try http-push Eric Fitzgerald wrote: Beyond the other suggestion, also remember to flush your STDOUT. flush(STDOUT); - Original Message - From: "Ron Beck" [EMAIL PROTECTED] To: "Mysql" [EMAIL PROTECTED] Sent: Friday, January 12, 2001 8:56 AM Subject: Perl question Hello all, I have a procedure that queries my database and produces a line of output for each query. It then processes the data and performs another query. Everything works great interactively. I get the first processing message, wait a bit, get the next processing message, etc... However, when I run this same procedure as a web page, nothing is displayed until the program has completed all processing steps. I would like each processing message to display to my web page as soon as it appears, not (apparently) cached until the procedure has completed. I _KNOW_ there's a way to make perl immediately print the information but for the life of me I can't remember what it is. Can anyone PLEASE help??? Thanks regards, Ron - 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
Mysql and NAS?
I've done quite a bit of searching but I've not run across any experiences with multiple Mysql servers running on separate computers using the same data files off a NAS server. Anyone? - 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: Perl question
perldoc CGI::Push ;-) "Aaron E. Schlesinger" wrote: E-mail me the code. Its late and I'm grumpy. I'll e-mail you back the answer tommorow :) Aaron -Original Message- From: Colin Faber [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 20:28 To: Eric Fitzgerald Cc: Ron Beck; Mysql Subject: Re: Perl question Try http-push Eric Fitzgerald wrote: Beyond the other suggestion, also remember to flush your STDOUT. flush(STDOUT); - Original Message - From: "Ron Beck" [EMAIL PROTECTED] To: "Mysql" [EMAIL PROTECTED] Sent: Friday, January 12, 2001 8:56 AM Subject: Perl question Hello all, I have a procedure that queries my database and produces a line of output for each query. It then processes the data and performs another query. Everything works great interactively. I get the first processing message, wait a bit, get the next processing message, etc... However, when I run this same procedure as a web page, nothing is displayed until the program has completed all processing steps. I would like each processing message to display to my web page as soon as it appears, not (apparently) cached until the procedure has completed. I _KNOW_ there's a way to make perl immediately print the information but for the life of me I can't remember what it is. Can anyone PLEASE help??? Thanks regards, Ron - 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 - 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
Table full error ( I Know its in the manual.. I just don't get it)
Ok I get a table is full error... So how/where do I set the tmp_table_size ? or the BIG_TABLES option so that its started that way at system start-up? from what I gather the Big_Tables option writes ALL tmp tables to disk, is that correct? so I should use tmp_table_size instead (got 512 MB Ram, could trow another 128 meg stick in there) Thanx, and have a nice weekend Ralf R. Kotowski Jones Unlimited, Inc. - Do you Jones? We've got your flix! http://www.dvdjones.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
need advice about security
Hi everyone, I use a MySQL database for the back end of our e-commerce site. We take credit as one method of payment and the last 8 digits of the card number are stored in the database. There is a web interface to the database from which I can get order information, but not the card number. I also can access the database through a MyODBC connection and MyAccess. In order to proceed with invoicing, I need to retrieve the card number (all 16 digits). I can think of a couple of ways to do this: 1. Change the web interface to include the card number. 2. Bring the information into Access through the ODBC connection. 3. Have the card number encrypted and sent through email, using PGP (this is the way we did it on our old system). There may be others which I am not thinking of also. Which method would be the most secure, or is there a better and more secure method which I haven't mentioned? Any suggestions would be greatly appreciated. take care, robynr Robyn Renwick, CPST (NIC 1998) Programmer, Buckingham Stencils, Inc. Robyn Renwick, CPST (NIC 1998) Programmer, Buckingham Stencils, Inc. - 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