Re: Unable to connect to remote mysql server.
The port number is wrong. Change it to 3306, and u should be fine. :I hv mysql server running on a remote machine(ip 202.157.188.2) and i'm :trying to connect to it by ssh from another machine(ip 202.157.137.97) as :follows : : :$ mysql -h 202.157.188.2 -u root -p :Enter password: :ERROR 2003: Can't connect to MySQL server on '202.157.188.2' (61) : :Can you please advice. : :thank you very much, :ally : : :- :Before posting, please check: : http://www.mysql.com/manual.php (the manual) : http://lists.mysql.com/ (the list archive) : :To request this thread, e-mail [EMAIL PROTECTED] :To unsubscribe, e-mail :[EMAIL PROTECTED] :Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php : : : : : :- :Before posting, please check: : http://www.mysql.com/manual.php (the manual) : http://lists.mysql.com/ (the list archive) : :To request this thread, e-mail [EMAIL PROTECTED] :To unsubscribe, e-mail [EMAIL PROTECTED] :Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php : : - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: No Warnings after changed datals
On Sat, 8 Jun 2002, Charlie Thunderberg wrote: Hi. :I'd like to find out how I could convince mysql to generate warnings :whenever the data I want to insert is modified by the server. I believe there's no built-in way of doing that. I keep a checksum of a data stored. And when i want to write to that raw next time I just check the checksum (md5 digest) - 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: Command line interface
I use exclusevely command line interface, and i believe most of the programmers prefer command line interface over GUI. As to large queries... just save them in yor files or use 'edit' command. On Mon, 3 Jun 2002, Ehmer David wrote: Hi Very new to MySQL and just wondering if there is an alternative interface to the command line. The beginners tutorial I am working through from WWW.Mysql.com seems to do all tasks from the command line. This seems very cumbersome in modern times. I understand there is a graphical interface in development. If so is it an improvement to the command line. How do most users of MySQL interact with the program. I would imagine entering or editing large amounts of data at the command line would be quite a task. Thanks David Ehmer Email: [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 - 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
Query question
This query seems to be quite easy, but I still cannot figure out how to do it. I have a randomly ordered table. And I want to SELECT that table by ORDERing it in specific row, and when I'm done I want to find out numeric position of a raw where the first raw is 1, second is 2 etc. Of course I could iterate over each row. But I want to do it for a specific raw only. 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: InnoDB logs
Guys, i get the following error. What does this mean? DBI-connect(myskycastle) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at teamstats.pl line 16 - 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: store JPG in MySQL DB
For real-life example, check out http://cdbaza.ultracgis.com, and check out the filename of the thumbnails images. I'm SELECTing those images from the MySQL database. That's how it's done: 1_ Create a table to store your JPGs, and the column that holds JPG data should be declared as BLOB CREATE TABLE images ( image_id INT UNSIGNED NOT NULL AUT_INCREMENT PRIMARY KEY, image BLOB NOT NULL ); 2_ Now you are ready to load the JPG data into the image column. I use Perl to open the JPG file and dump the contents into the table, and the resulting query looks something like: INSERT INTO images SET image=here goes contents of the JPG file; Perl code that does this job would look like: local ($/); sysopen (JPG, test.jpg, O_RDONLY) or die $!; $dbh-do(qq|INSERT INTO images SET image=?|, undef, JPG); close (JPG); Sorry if you don't know Perl, but you should be able to do similar thing in any other language you might be using Good luck! -- Sherzod - 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: store JPG in MySQL DB
Hi Andrei well, let's just say if it crashes it will mean longer recovery time, you are adding extra processing to the SQL server to handle data it wasn't meant to handle, storing it in the file system has the main advantage that if any Yeah, that crash thing really scares me. I guess you're right about . And how likely that it might crash? changes occurs you can change it faster + easier, besides a database is supposed to store essential data so you don't overload it with things that can be calculated or made pretty easily, and I'd say an image fits under that category. And last time I checked my local hard drive is faster than my network connection :) The choice is yours, but if you have heavy load, I wouldn't use it. Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Sherzod B. Ruzmetov [EMAIL PROTECTED] To: Andrei Cojocaru [EMAIL PROTECTED] Cc: Sameer Maggon [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:37 AM Subject: Re: store JPG in MySQL DB Hi Andrei If I were you I would not store a binary file into the database, I'd store the information required to fetch it from somewhere else like the mySQL manual suggests But what difference does it make? Besides, I found storing it in the DB more convenient than in the file system. In that case, you will have to keep track ofboh the files in the file system, and their meta data in the mysql tables. Please advise Andrei Cojocaru [EMAIL PROTECTED] - Original Message - From: Sherzod B. Ruzmetov [EMAIL PROTECTED] To: Sameer Maggon [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, May 20, 2002 12:26 AM Subject: Re: store JPG in MySQL DB For real-life example, check out http://cdbaza.ultracgis.com, and check out the filename of the thumbnails images. I'm SELECTing those images from the MySQL database. That's how it's done: 1_ Create a table to store your JPGs, and the column that holds JPG data should be declared as BLOB CREATE TABLE images ( image_id INT UNSIGNED NOT NULL AUT_INCREMENT PRIMARY KEY, image BLOB NOT NULL ); 2_ Now you are ready to load the JPG data into the image column. I use Perl to open the JPG file and dump the contents into the table, and the resulting query looks something like: INSERT INTO images SET image=here goes contents of the JPG file; Perl code that does this job would look like: local ($/); sysopen (JPG, test.jpg, O_RDONLY) or die $!; $dbh-do(qq|INSERT INTO images SET image=?|, undef, JPG); close (JPG); Sorry if you don't know Perl, but you should be able to do similar thing in any other language you might be using Good luck! -- Sherzod - 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: store JPG in MySQL DB
Hi Hi, Can i have a table in which i can store my JPG file somehow in MYSQL database. Absolutely. just declare a BLOB column, and load your images rightinto the columsn Sameer -- http://www.dypatil.edu For Better tomorrow - 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: error - please help
Hi my_print_defaults: not found Didnt find usr/local/libexec.mysqld you should do a make install before executing this script So, did you do make install? In that case check out the location above, and try to find libexc.mysqld. And make proper changes - 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
Row Locking issue in 3.23.x
Hi. As far as I know, MySQL doesn't suport row-locking, only table locking is available. But I figured table locking for sessions table of CGI::Session::MySQL would be quite inefficient, for there might be millions of rows and hundreds of them could be active at any time. So what do you guys think of locking a specific row with a semaphore file and what conventions should the locker and/or the table should follow? - 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 with PASSWORD() function
Hi Walter My question is, as I read in the documentation, that the process is irreversible, how can I deal with the fact that a user can forget his password, if I will not be able to retrieve the original string, because what i can see is the encrypted data The purpose of the encrypted password is not to be able to decrypt it, so that the people who have access to the database couldn't use the user's password for any purposes. To deal with the forgotten passwords, you take all the basic steps to ensure that the user is the one, and create a random string for the user, then apply PASSWORD() on the random password and save it. Then you send the same random string for the user himself. So then, he will use that newly created password to access his account (and chage it to some more friendly one if you provide such functionality) -- sherzodr - 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
time calculations
Is there a function or a way to find out how many days/hours/mins/secs have elapsed since date n? For example, i need to be able to get the answer like: 2 days and 3 hours have passed since date [some_date] Thanks sherzodR -- 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: time calculations
Jim, I use Perl. But I was looking for an SQL function/query for doing that. If there isn't any, I welcome any suggestions though. Thanks On 23 Mar 2002, Jim Philips wrote: Are you really looking for SQL to do this? Or do you need PHP functions that will help you to achieve the same result? On Sat, 2002-03-23 at 12:27, Sherzod B. Ruzmetov wrote: Is there a function or a way to find out how many days/hours/mins/secs have elapsed since date n? For example, i need to be able to get the answer like: 2 days and 3 hours have passed since date [some_date] Thanks sherzodR -- 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 - 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