Re: How to import data from Dbase3?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 BG Mahesh wrote: Actually I prefer to dump the dbase file on a Linux machine and directly import it into MySQL. There are a bunch of ways of skinning that cat. The easiest of which IMHO is to convert the data to comma separated files first and then use any one of a number of means to get it into the database. - -- Peter L. Berghold [EMAIL PROTECTED] Those who fail to learn from history are condemned to repeat it. AIM: redcowdawgYahoo IM: blue_cowdawg ICQ: 11455958 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCQW7WUM9/01RIhaARArhEAJ9ukrn8JSmmwmtdy9y86TVTcIx6vQCfQwZB G3BfaZB+So4iX6kbPlQCkOA= =cQYJ -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to insert blob data remotely
On Thu, 2004-07-01 at 11:06, Héctor Maldonado wrote: But LOAD_FILE only works if 'picture.jpg' is placed on the same machine where the server is running. That makes sense. You could of course NFS mount from the remote machine to the machine you are working from but that is much the same thing. Alternatively if you are working in a language like Perl there are other tricks you can play... -- Peter L. Berghold[EMAIL PROTECTED] Dog event enthusiast, brewer of Belgian (style) Ales. Happiness is having your contented dog at your side and a Belgian Ale in your glass. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: batch mode
On Tue, 2003-07-29 at 15:19, azamka wrote: [EMAIL PROTECTED] usr]# mysql security select * from machine; -bash: select: No such file or directory EEK! What you told the shell to do was open a file called select and redirect it to mysql. What you meant to do was echo 'select * from machine' | mysql security -- Peter L. Berghold[EMAIL PROTECTED] Dog event enthusiast, brewer of Belgian (style) Ales. Happiness is having your contented dog at your side and a Belgian Ale in your glass. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld shows high cpu usage over extended time, restart = normal
On Wed, 2003-07-09 at 10:31, Dave [Hawk-Systems] wrote: Is there a known issue (running on FreeBSD 4.8, MySQL 3.23.55 MyISAM)? Is there something I should check when next I notice the high CPU usage? I used to see the same kind of behavior a while back with a MySQL installation I did for a client. It turned out that what was happening was a poorly designed client/server app was touching off this really huge query (lots of rows and lots of columns across multiple tables) and then disconnecting before the result could be returned. They fixed their app and the problem went away. Drove me nuts troubleshooting it. Anyway. Make sure you don't have something similar going on. -- Peter L. Berghold[EMAIL PROTECTED] Dog event enthusiast, brewer of Belgian (style) Ales. Happiness is having your contented dog at your side and a Belgian Ale in your glass. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Your professional opinion Please...
On Mon, Mar 24, 2003 at 06:41:07PM -0800, Brian wrote: I have a client with approximately 2 gigabytes of un-indexed document files (includes text and graphics). He wants to be able to enter a few parameters and bring up a list of all If they are flat text files this should not be too big an issue although a very large project nonetheless. Develop an index by yanking out keywords of interest and devloping a table to index them either by filename title or whatever. I'd leave them as flat text files and go from there. If they are adding or removing from the library then do a re-index at an interval that makes sense. -- Peter L. Berghold [EMAIL PROTECTED] Those who fail to learn from history are condemned to repeat it. AIM: redcowdawgYahoo IM: blue_cowdawg ICQ: 11455958 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Your professional opinion Please...
On Tue, 2003-03-25 at 18:11, Brian wrote: What mechanism do you recommend? Something in perl, python or php? Well... I tend to be a Perl bigot so I'd choose Perl. I would do a couple of things. 1) I'd develop a list of words to ignore such as and, if ,but etc. etc.. This may take time and iterations. 2) Read each file in and split on word boundaries and tally the words that are not in the exclusion list and theoretically what is left will be keywords. 3) Use the number of times that a keyword is found in each flat text file as a weight to be used later as a scoring mechanism for the search to determine relevance. 4) Write all this to a table. Once all the documents are scanned THEN build your index. Are their prebuilt modules that would develop such an index? I don't know for sure, check CPAN (www.cpan.org) and see. There may well be as I'm sure someone else has had to do this before. -- Peter L. Berghold [EMAIL PROTECTED] The New Jersey Bergholds -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to Retreive Web Links from MySQL to HTML ???
On Fri, 2002-11-22 at 10:40, tmb wrote: I want to store some web links in a MySQL db... than later using PHP retreive them and put them on a web page... Does PHP have to do all the work here... Personally I would use Perl to do this.. :-P :-) Yeah... you're going to have to write an app for this. MySql just ain't gonna do all that for ya. -- Peter L. Berghold [EMAIL PROTECTED] -or- [EMAIL PROTECTED] Manager Unix Engineering,MT Sinai NYU (212) 659-1468 For PGP public key send email to: [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
Solaris 8 and gcc
Hi folks, I'm trying to compile mysql on a Solaris 8 box with gcc. When I run compile for reasons I do not understand configure thinks the g++ compiler is running as a cross compiler which it is not. This causes the test for the return type of sprintf to fail with the message can not run test program while cross compiling. Has anyone else run into this or am I special? Is there a fix/workaround? -- -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Peter L. Berghold[EMAIL PROTECTED] Manager Unix Engineering [EMAIL PROTECTED] NYU Mt Sinai (212) 263-6932 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problems getting asp to talk to mysql
At 05:46 PM 6/7/2001 +0100, michael.mansfield wrote: my isp olm.net are not helping. what needs to be installed on a unix server to enable an asp page to talk to mysql please. OK: is the ASP running on Unix as well? Who's flavor ASP is it? ChiliSoft? -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Peter L. Berghold[EMAIL PROTECTED] Schooner Technology ConsultingCELL: (732) 539-7920 Unix Professional Services:Sun/Solaris, Linux, Perl, Perl/CGI, mod_perl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: can i keep a connection to the database open
At 07:05 PM 6/7/2001 +0530, Harsh wrote: i want to write a web-based chat application in Perl which runs on Unix server with mySQL as backend. The application needs to continouly interact with database hence instead of opening a DBI connection in each perl page, I wish to keep a live open connection with database. Is it possible ? If yes, how ? What web server are you using? -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Peter L. Berghold[EMAIL PROTECTED] Schooner Technology ConsultingCELL: (732) 539-7920 Unix Professional Services:Sun/Solaris, Linux, Perl, Perl/CGI, mod_perl - 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: heavy load configuration
At 06:34 PM 5/26/2001 +0200, P.Agenbag wrote: How will I know if my server is up to it, or should I rather say, how many consecutive users will this box be able to handle? The line shouldn't be a problem, I think it sits on a couple of 100 MB/s line. Well.. this is one topic I sorta specialize in. Off the bat you look like you have a machine that should be able to handle quite a load without barfing. The two areas I'd be interested in getting more metrics on would be your RAM utilization and a profile of your I/O to and from the disks where you have your tablespace. Without those metrics any advise I would give you is just crystal gazing. In the area of RAM I normally put as much RAM in a machine that can until it is can't take any more if I am running a database that is expected to deal with large queries or lots of small ones. Again, without some sort of metric to work with in terms of what your queries look like and what you actually mean by high traffic. Disk drives I like to put on some sort of RAID when I am thinking of either high throughput or a need for reliablity. Hot swap drives in a hardware raid box are the best way to go. IMHO and AFAIR Raid-5 is to be avoided for databases with a high degree of read-modify-write transactions built into the application or even just high write. With RAID-5 you pay a write penalty in terms of performance because of the fact that parity calculations take some overhead. The exception to this rule is where you have large caches front ending your RAID box. Even here there is cause for concern in the reliability arena as there have been known to be problems with data getting corrupted in a database when cache was not properly destaged after a write. I could on forever on this subject, but I'll stop here. -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Peter L. Berghold[EMAIL PROTECTED] Schooner Technology ConsultingCELL: (732) 539-7920 Unix Professional Services: Sun/Solaris, Perl, Perl/CGI, mod_perl - 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: Advice on Random Numbers
On Wed, May 23, 2001 at 02:22:02PM -0400, Dave Carter spake thusly: *] I need to generate a RANDOM UNIQUE number for every new record. Is there an *] easy way to accomplish this inside of mySQL. *] The way I do this for session ids is through a perl function that I wrote a long time ago. Essentially I create a really long string of mixed case alpha characters and numeric digits. I suppose you could use the same method from perl for record numbers. -- -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Peter L. Berghold[EMAIL PROTECTED] Schooner Technology Consulting http://www.berghold.net Unix Professional ServicesPerl Perl/CGI mod_perl - 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: Telnet into MySQL
On Mon, May 21, 2001 at 03:21:10PM -0500, Tim Thorburn spake thusly: *] Can someone here recommend a good Telnet program (with SSH) that I can use *] to connect to my servers MySQL database? *] Tim, You don't use telnet to connect to the MySQL database... You use the mysql client -- -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Peter L. Berghold[EMAIL PROTECTED] Schooner Technology Consulting http://www.berghold.net Unix Professional ServicesPerl Perl/CGI mod_perl - 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 Thu, May 17, 2001 at 06:36:23AM -0700, mansoor spake thusly: *] i m new to mysql, how i can convert a string 28-MAR-2001 to date *] In what language? -- -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Peter L. Berghold[EMAIL PROTECTED] Linux renders ships http://www.berghold.net NT renders ships useless - 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: telnet MySQL
On Mon, May 14, 2001 at 07:26:44AM -0700, Shtykh Roman spake thusly: *] telnet grdmss57 3030 Can you connect to the database through a normal client? -- -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Peter L. Berghold[EMAIL PROTECTED] Linux renders ships http://www.berghold.net NT renders ships useless - 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