RE: mysql.sock
mysql.sock is created when mysqld starts and exists only while it runs. B. -Oorspronkelijk bericht- Van: Levi Campbell [mailto:[EMAIL PROTECTED] Verzonden: zaterdag 24 juli 2004 20:53 Aan: [EMAIL PROTECTED]; mysql Onderwerp: Re: mysql.sock it's not in /tmp, /var/lib/mysql or anywhere on my system. could someone please e-mail the file to me? - Original Message - From: Jonathan Villamailto:[EMAIL PROTECTED] To: Levi Campbellmailto:[EMAIL PROTECTED] Sent: Saturday, July 24, 2004 12:42 PM Subject: Re: mysql.sock Levi Campbell said: Hi, I managed to install MySQL on Linux but now I can't find mysql.sock either on my machine or on the CD. how do I create or find mysql.sock? Is MySQL running? check in /tmp or if it was an RPM install, check in /var/lib/mysql or just do updatedb and then locate mysql.sock or as root find / -name '*mysql*' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP script cannot connect MySQL server
At 22:00 22-03-2004 +0200, Sami Maisniemi wrote: Did you provide access to the databases as root? Is there a password associated with access? For instance, how do you statr mysql from the command line: mysql -u root -ppassword mydatabase I think I am using root access, but should I create another user name for MySQL? On the command line, I start MySQL by typing just 'MySQL'. How can I view the user? I tried to create a root password and I added the password to the PHP script, but I did not see any impact. You may want to look at some tutorials at php.net and devshed.com first. They should get you started. B. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: New Microsoft Critical Patch
I have checked almost every M$ critical patch and other messages with the same content and as far as I can tell none came via this or any other list. Easy enough to find out: look at the headers. If it says: Received: from lists.mysql.com (lists1.mysql.com [213.115.162.31]) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 9683 invoked from network); 4 Dec 2003 18:30:13 - Received-SPF: unknown (domain of sender [EMAIL PROTECTED] does not designate mailers: NOERROR) X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Then you may been looking in the right direction. B. At 13:30 04-12-2003 -0500, John Griffin wrote: Okay, let me ask a slightly different question. I am getting several of these Microsoft emails every day and I think that they are coming via this list. Is anyone else having similar problems or am I following a red herring? John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: restoring mysqldump ???
mysql -u user_name -p reporter dumpfile Leaving a space between -u (=user) and the user_name should not be a problem it is if you supply a password on the commandline -p'your_password' but -u user_name B. -Oorspronkelijk bericht- Van: Mikael Fridh [mailto:[EMAIL PROTECTED] Verzonden: zondag 23 november 2003 13:48 Aan: [EMAIL PROTECTED]; Nilesh Avalani Onderwerp: Re: restoring mysqldump ??? but when i try to run : % mysql -u root reporter reporter-dump-Sat.sql mysql -uroot -p reporter dumpfile it says : ERROR 1044: Access denied for user: '@localhost' to database 'reporter'. think it's because of that extra space between the '-u' and 'root' you also need the -p parameter so you can enter your root password. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: restoring mysqldump ???
Hit the right button on the wrong moment... It should be: Leaving a space between -u (=user) and the user_name should not be a problem it is if you supply a password on the commandline in the form of -p'your_password' :( -Oorspronkelijk bericht- Van: B. van Ouwerkerk [mailto:[EMAIL PROTECTED] Verzonden: zondag 23 november 2003 14:11 Aan: 'Mikael Fridh'; [EMAIL PROTECTED]; 'Nilesh Avalani' Onderwerp: RE: restoring mysqldump ??? mysql -u user_name -p reporter dumpfile Leaving a space between -u (=user) and the user_name should not be a problem it is if you supply a password on the commandline -p'your_password' but -u user_name B. -Oorspronkelijk bericht- Van: Mikael Fridh [mailto:[EMAIL PROTECTED] Verzonden: zondag 23 november 2003 13:48 Aan: [EMAIL PROTECTED]; Nilesh Avalani Onderwerp: Re: restoring mysqldump ??? but when i try to run : % mysql -u root reporter reporter-dump-Sat.sql mysql -uroot -p reporter dumpfile it says : ERROR 1044: Access denied for user: '@localhost' to database 'reporter'. think it's because of that extra space between the '-u' and 'root' you also need the -p parameter so you can enter your root password. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL Newbie
1) Can you recommend some good online tutorials for learning the basics of MYSQL? (I can't even say I know exactly what it is; I think of it as some sort of language used to create special effects or special functions, similar to JavaScript.) If you found this list then you should have found information about MySQL. It's a database server ment for running relational databases. (short and simple explanation). You can use languages like Perl, PHP, Python and C to retrieve information. Tutorials: www.php.net --links-tutorials www.devshed.com www.mysql.com www.google.com (search) search this lists archive since it holds many many many other links. YOu will find hundreds of links if you search google. I'm not certain exactly what form this function will eventually take, but I'm just exploring ways to list vast amounts of data that are searchable, sortable or can be manipulated in other ways. If this can be done with MYSQL, can you give me an idea of how to get started? Is there a name for this function, a tutorial that describes it, or a webpage on the Internet that I can use as a model? You can do this with any language mentioned above. 3) Is a knowledge of MYSQL a great help in finding jobs and roughly how long does it take most people to acquire a working knowledge of it? With my skills, I don't expect to become a MYSQL pro any time soon, but I just wondered if even a basic knowledge might help with job searches. Depends on what a company is looking for. Some basic knowledge usually isn't enough. B. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: unable to change password
try: mysql -u root -p then it will ask for your password. or mysql -u root -pmysql_root_password no spaces between -p and your mysql root password This is well documentee :http://www.mysql.com/doc/en/User_names.html please check the manual before asking questions. B. At 12:50 06-04-2003 +0100, Hisako Shimizu wrote: Dear sir/madam Please tolerate my poor English. I had been using mysql for a while without any problems. And one day Error occuered ,I could not access it anymore. My password which I had been using has been declined and i have this error Access Denied even though I have never changed password, at least not I am aware of. --- Welcome to Darwin! [Hisako:~] hisako% /usr/local/mysql/bin/mysql -u root -p mysql Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) [Hisako:~] hisako% /usr/local/mysql/bin/mysql -u root -P mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.55-entropy.ch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: unable to change password
At 08:28 06-04-2003 -0400, Devon Y. wrote: [Hisako:~] hisako% /usr/local/mysql/bin/mysql -u root -p mysql Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) This is the same thing that was happening to me! Then I discovered that my root password was not set, even though I did everything that was supposed to do, according to the manual. The manual tells you to set a root password. You wrote: C:\mysql\bin\ mysqladmin -u root password onyoung If it's the same on windooz as on Linux then it should be: mysqladmin -u root -ponyoung Don't know what good it would do to just run mysqladmin like that but that's how it should look like.. But perhaps there is a difference between the Linux and the windooz version.. If you really messed up you can reset the mysql root password: http://www.mysql.com/doc/en/Resetting_permissions.html Have fun, B. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: My SQL OS X setup - utterly, completely, 100% stumped
You don't explain your problem. You don't even tell which versions you're running. If there is no mysql table then you didn't create it, or you trashed it. In the manual you will find references to how to install MySQL on MAC OS X. http://www.mysql.com/doc/en/Mac_OS_X_installation.html IMHO your problem needs to be solved via the list. That way someone else can learn from the problem and others don't have to ask the same question over and over. You did search the archive.. right? B. At 10:11 06-04-2003 -0400, Ken Tozier wrote: Anyone willing to help a newbie walk through setup and install? I've tried everything specified in the online documentation, the tips on Marc Lynnage's page, install tips in several MySQL books multiple times. I've read all error messages and tried my best to figure out how to work around them. Absolutely nothing works. I can't set the root password, there is no 'mysql' table after the install, can't create new databases, can't reset the root password by following the instructions at: http://www.mysql.com/doc/en/Resetting_permissions.html I don't have the $700 dollars for the commercial license at the moment and can't stomach paying that much just to learn how to get MySQL running and be able to create new tables. I've been a Macintosh C programmer for 7 years and after that, being unable to get a database running after following the instructions to the letter has me rather stumped. Any Unix/MySQL experts willing to spend a 15 minutes or so on AIM to help me out? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help MySQL Beginner please.
PHP? www.php.net (click links-tutorials) PHP/perl/MySQL? www.devshed.com Others will add quite a few too. devshed.com is pretty good. B. At 10:10 02-04-2003 -0500, [EMAIL PROTECTED] wrote: Hi all, The best thing that happened to me today is finding this list on the web. I am in deep problem. I am trying to build database for my site and just discovered that my hosting server uses mySQL and i am not use to it. I don't know where to start. don't know how to create table or anything. is there anyone who can help me with basic information that can get me started? Please not too technical please. Something a new commer can understand. Thanks, Jef -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Could we make this a web discussion forum?
Most ppl don't like forums. Do you know even one serious project which uses a forum? I know Slackware did and it really was a PAIN. Mail to this list gets mirrored on more places then you can imagine, same goes for PHP lists. You can't blame this on the MySQL ppl. There would be less mail if ppl would care to do their homework. Email is convenient, it just gets into your mailbox and you read it.. A forum would require ppl to open a browser or newsreader.. If you're busy then it's not fun. B. At 00:52 31-03-2003 -0800, Seth Brundle wrote: I really hate mailing lists - they are dinosaurs for this type of thing. A web discussion board is a much more powerful and flexible tool for this type of community. Thread tracking, archiving, searching, dont have to download 50 emails a day just to monitor a couple threads...cmon its 2003! Cant we convert this into a discussion board or better yet just make the usenet group mirror postable from google groups? There are 4 lists like this one where I have to continuously subscribe and unsubscribe throughout the year when I want to participate. Also emails get mirrored on google groups for convenient spam harvesting - its really a pain in the butt. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Could we make this a web discussion forum?
I really hate on-line forums. They're difficult to track because I must remember visit them daily. OK this is the first issue - 95% of people who need MySQL info do not need it daily. Mailing lists are a poor tool for them. No but those in need of help does. And those ppl who are capable of helping them are usually busy. Do they keep a browser open and refresh the forum frequently? I'll answer that question: no. The NNTP mirror is actually a double-edged sword - yes it takes care of archiving and searching (via Google Groups), I will agree, but it misleads infrequent users into thinking posting actually does something meaningful. Why don't you build a better one? IIRC sendmail list has both posting via NNTP and mailinglist. -Easily break discussion into sub-categories (especially for MySQL, where SQL questions are combined with everything else, would be nice to break that out) PHP has several different lists and most questions end up on the general list. Usually cross-posted to other lists. SourceForge is a great idea, but a poorly designed system. Obviously a package designed by an engineer, its a mess. You seem to be a brilliant coder so..perhaps you can re-design sourceforge and the underlaying code. Anyway, I expect an announcement from you real soon that you created a mail to NNTP gateway for this list.. You are going to build that.. right? B. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql, PHP, and Dates
This is not a MySQL question. http://www.php.net/manual/en/function.explode.php (probably) visit: http://www.php.net/links.php for tutorials on PHP. If you can control the layout of the database you could use another type of column. See the MySQL manual for more information. B. At 21:47 28-03-2003 -0500, Bruce Feist wrote: I'm experienced with SQL, but new to MySql and PHP, which I'm using together to create a dynamic web site. Right now, I'm having minor difficulties with date formatting. It seems that when I retrieve a date from MySQL into PHP, it shows up as a string instead of a date data type, with format -MM-DD HH:MM:SS. Is there any way that I can get it returned as a PHP date instead? Also, exactly what is it that controls the output format of the date as a string? Is PHP somehow requesting that MySql return the date as a string, or is it getting a date from MySql and then converting it to a string on the PHP side? What's the best way of controlling date format? Obviously, I could use string operators to extract the year, month, and day and do whatever I want to with them, but that's sensitive to how PHP and/or MySql are configured, I assume; it would be better for me to request the date in a specific form (ideally one taken from operating system preferences). Thanks! Bruce Feist -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AW: AW: Mysqld problem
Can't create file could be caused by not having enough free space left. Easy to check . I think I remember I got a different err number in a simular situation.. You did check permissions.. right? B. At 15:32 23-03-2003 +, Phil Dobbin wrote: On 23/3/03 15:27, Stefan Siefert [EMAIL PROTECTED] wrote: Hi Phil, ok, just to make sure your mysqld isn't damaged, what about replacing it with a new one (just binaries, not config and data)? Sounds a good idea but I'm unsure how to go about it. Would you know the best possible way? Regards, Phil. -Ursprungliche Nachricht- Von: Phil Dobbin [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 23. Marz 2003 16:21 An: Stefan Siefert; MySQL Betreff: Re: AW: Mysqld problem On 23/3/03 13:31, Stefan Siefert [EMAIL PROTECTED] wrote: Hi Phil, first of all I don't think your mysqld is damaged. I would first check the following: - where does mysqld looks for its datadir? - under which userid is mysqld supposed to run? - under which userid does mysqld runs? - does the user under which mysqld runs have write access to the datadir directory? - is the mysql database installed in the datadir directory? Hi, Stefan. All things mysql are in their correct place (this has only just happened and I haven't changed anything in any directory pertaining to mysql). I basically cannot get mysqld to start in any shape or form, either from its system boot startup script or manually. Regards, Phil. -Ursprungliche Nachricht- Von: Phil Dobbin [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 23. Marz 2003 14:09 An: MySQL Betreff: Mysqld problem I'm having a problem starting the mysqld. I'm running 3.23.51 on Mac OS X 10.1.5 and have a startup script which confirms on boot that it has started but doesn't. I've tried starting manually from the CLI but no luck. I looked in localhost.err and found: 030323 9:48:21 /usr/local/mysql-3.23.51/bin/mysqld: Can't create/write to file '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13) 030323 9:48:22 /usr/local/mysql-3.23.51/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 030323 9:48:22 /usr/local/mysql-3.23.51/bin/mysqld: Error on delete of '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13) 030323 09:48:22 mysqld ended According to the O'Reilly `MySQL Reference Manual' it seems that the daemon may have been damaged but offers no real clue as how to fix it. One other very odd aspect is that on OS X you create a mysql user in Sys Prefs and I noticed, upon reboot, that this user had disappeared from the pref panel. I re-created but to no avail. Any help at all on this would be gratefully appreciated. Regards, Phil. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: images with mysql
Not an issue since you don't need to edit the htaccess file for every file. You set it for the whole directory. The only reason for preventing ppl to access files would be theft of bandwith. If you worry about ppl being able to get the images then you shouldn't publish them at all. You can't protect them from being dumped with printscreen. Another solution would be to change the the path at random and copy all images to the new location while you copy a special image on the old location. You have no idea how fast ppl will stop using your pics if they have the text stolen from ... where you put your domainname on the dots. This would require you to have the path to the file in your code. HTTP REFERER is not always set correctly so I wouldn't trust that to much. B. At 09:13 21-03-2003 +0100, lasse wrote: sure you can. And i don't mind you disagreeing with me either =) Although, if the solution/site is meant to be used by other than people who know something about the webserver i don't think it's a good solution. I can imagine writing something that reads the htaccess-file and edits it... but i don't like the possible securtyissues with that. Besides... if you render a page with a selectbox from mysqltables and another with images and let the user match them together, it's idiotproof =) If you have a php(or whatever)-file wich sole purpouse is to check users rights and render images it can also always check if you have the right cookies. If you've been to the right previous page to see that picture, if not redirect to '/'; Do you get my point? I still believe that the blob i my saviour... (despite the obvious loss of performance) On Thu, 20 Mar 2003, B. van Ouwerkerk wrote: You can use other ways to protect your images from linking by others. Like with Apache and htaccess.. I don't agree with you on your opinion that it's easier to code. If you insert a link into your database all you have to do is retrieve it and push the link to the browser. B. - 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 And Backup
I have been using mysqldump -a to backup my clients sites. I have discovered a problem with this aproach. I decided to try and restore it with mysqlimport on my local hd and it'll restore it up to a certian point then stop. What I'm looking for is any other recomendations to backup and restore 71 databases. Any scripts for backing it all up will of course be welcom as well. second off, how do I wipe these old databases off my puter :) You can run the dumpfile against a newly created database: mysql -u admin_user_name -p name_of_database ./dump_file.sql If you want to update another database then you should add --add-drop-table to the mysqldump command. On the box where you need to update the database you can run the command mentioned above. http://www.mysql.com/doc/en/Backup.html B. - 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: images with mysql
IMHO it's better to store a link. I have seen databases (not MySQL) getting corrupted because the file inserted was to big. For the visitor it doesn't really matter whether you put it into the database or not. A link is less difficult and you don't have to retrieve pictures from the database so it might be quicker.. B. At 18:34 20-03-2003 +, Lai Liu-yuan wrote: I am now having a database storing images of chinese characters for research purpose. I wrote a program to store and retrieve them. My images are of type ppm. This is how I designed my table: mysql describe poor; +++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +++--+-+-+---+ | cc | char(2) binary | | | | | | width | int(1) | YES | | NULL| | | height | int(1) | YES | | NULL| | | data | blob | YES | | NULL| | +++--+-+-+---+ Just have to be really careful in storing binary data. Hope this help. On Thu, 20 Mar 2003 10:34:19 +0100 [EMAIL PROTECTED] wrote: Hi! I have a problem with my MySQL I need to have some a images related with an item for example -- ! author ! date of birth an death ! image! -- How can I define the field for the images? I have read that LONGBLOB could be useful for large objct like images, but I can't understand how to set it in my database... Thank you in advance stefano -- S t e f a n o C a r d o Debian GNU-Linux user - 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: images with mysql
I assume it is, have not tested it.. If you need to fetch the files from the database your app needs to wait until it has recieved the data. If you only store name/path info it will take less time to fetch the data, ship it off to the browser which can start fetching the images without connecting to the database again. Sounds pretty logical.. and it gets worse if your site is hosted by an ISP who is using a database server running on a seperate box.. B. At 21:35 20-03-2003 +, Lai Liu-yuan wrote: Well, this may be off topic. In my case, I store tens of thousands of images, gradually growing. All of them are quite small, most around 30*30 gray scale. Would it still be faster to store them on disk? On Thu, 20 Mar 2003 13:57:06 +0100 B. van Ouwerkerk [EMAIL PROTECTED] wrote: IMHO it's better to store a link. I have seen databases (not MySQL) getting corrupted because the file inserted was to big. For the visitor it doesn't really matter whether you put it into the database or not. A link is less difficult and you don't have to retrieve pictures from the database so it might be quicker.. B. At 18:34 20-03-2003 +, Lai Liu-yuan wrote: I am now having a database storing images of chinese characters for research purpose. I wrote a program to store and retrieve them. My images are of type ppm. This is how I designed my table: mysql describe poor; +++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +++--+-+-+---+ | cc | char(2) binary | | | | | | width | int(1) | YES | | NULL| | | height | int(1) | YES | | NULL| | | data | blob | YES | | NULL| | +++--+-+-+---+ Just have to be really careful in storing binary data. Hope this help. On Thu, 20 Mar 2003 10:34:19 +0100 [EMAIL PROTECTED] wrote: Hi! I have a problem with my MySQL I need to have some a images related with an item for example -- ! author ! date of birth an death ! image! -- How can I define the field for the images? I have read that LONGBLOB could be useful for large objct like images, but I can't understand how to set it in my database... Thank you in advance stefano -- S t e f a n o C a r d o Debian GNU-Linux user - 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: images with mysql
You can use other ways to protect your images from linking by others. Like with Apache and htaccess.. I don't agree with you on your opinion that it's easier to code. If you insert a link into your database all you have to do is retrieve it and push the link to the browser. B. At 20:18 20-03-2003 +0100, lasse wrote: hey all.. new to the list. Just my 5 cents... I think it's better to store images in the database, sure you loose a bit in performance, but it's easier to code. The way i've done it before is always a separate render.php (or what ever) that compares the users rights to view that image, get's the blob from the database, sets right content-type for the page and then renders the binary data. That way... you can control frames/design (direct links to images can be avoided) und so weiter... //lars On Thu, 20 Mar 2003, B. van Ouwerkerk wrote: I assume it is, have not tested it.. If you need to fetch the files from the database your app needs to wait until it has recieved the data. If you only store name/path info it will take less time to fetch the data, ship it off to the browser which can start fetching the images without connecting to the database again. Sounds pretty logical.. and it gets worse if your site is hosted by an ISP who is using a database server running on a seperate box.. B. At 21:35 20-03-2003 +, Lai Liu-yuan wrote: Well, this may be off topic. In my case, I store tens of thousands of images, gradually growing. All of them are quite small, most around 30*30 gray scale. Would it still be faster to store them on disk? On Thu, 20 Mar 2003 13:57:06 +0100 B. van Ouwerkerk [EMAIL PROTECTED] wrote: IMHO it's better to store a link. I have seen databases (not MySQL) getting corrupted because the file inserted was to big. For the visitor it doesn't really matter whether you put it into the database or not. A link is less difficult and you don't have to retrieve pictures from the database so it might be quicker.. B. At 18:34 20-03-2003 +, Lai Liu-yuan wrote: I am now having a database storing images of chinese characters for research purpose. I wrote a program to store and retrieve them. My images are of type ppm. This is how I designed my table: mysql describe poor; +++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +++--+-+-+---+ | cc | char(2) binary | | | | | | width | int(1) | YES | | NULL| | | height | int(1) | YES | | NULL| | | data | blob | YES | | NULL| | +++--+-+-+---+ Just have to be really careful in storing binary data. Hope this help. On Thu, 20 Mar 2003 10:34:19 +0100 [EMAIL PROTECTED] wrote: Hi! I have a problem with my MySQL I need to have some a images related with an item for example -- ! author ! date of birth an death ! image! -- How can I define the field for the images? I have read that LONGBLOB could be useful for large objct like images, but I can't understand how to set it in my database... Thank you in advance stefano -- S t e f a n o C a r d o Debian GNU-Linux user - 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 -- -BEGIN GEEK CODE BLOCK- Version: 3.1 (2002 update) GCM/GCS/GMU/ d+ s++:++ a-- C++() UBLAIS+() P+ L+(-) E--- W+++ N+ o-- K w O- M- V- PS(+++) PE++ Y PGP- t 5+ X++ R- tv+ b+ DI+++ D- G e h++ r% y++ --END GEEK CODE BLOCK
RE: How to Archive and restore the data in MySQL database.
Perhaps you can search the manual before you send a question to this (or any other) list. You really should since several ppl spend time to create and keep it up to date. The manual is here: http://www.mysql.com/doc/en/index.html If you launch a search for the word backup you will find: http://www.mysql.com/doc/en/Backup.html Another relevant link for you: http://www.tuxedo.org/~esr/faqs/smart-questions.html B. -Oorspronkelijk bericht- Van: Prasad Budim Ram [mailto:[EMAIL PROTECTED]] Verzonden: vrijdag 7 februari 2003 7:31 Aan: [EMAIL PROTECTED] Onderwerp: How to Archive and restore the data in MySQL database. Hi, Can any of you give me links about Archiving and restoring the data in MySQL database. Are there any utilities for the same? Thanks in advance, Ram - 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 IMAP Server
I don't know such product running with MySQL. There is something called Bill storage server which runs with PostgreSQL, perhaps someone knows a way to put MySQL behind it instead of PostgreSQL. B. At 17:26 04-02-2003 +, Ben Clewett wrote: MySQL, My first post, please go easy if this is the wrong pleace! I'm trying to find an IMAP server which used MySQL so that my Mozilla Email client can file it's email a little faster. Has anybody heard of such a device? Regards, Ben - 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.sock is missing - Please....
If it gives errors about creating/writing mysql.sock, check the permissions/ownership of directory /var/lib/mysql.. Check the manual for the right permissions... Might depend on your distro, AFAIK mysql.sock would normally live in /tmp B. - 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: how to change mysql root password
Not related at all: If you would have done a quick search in the manual you would have found: http://www.mysql.com/doc/en/Access_denied.html To start with.. B. -Oorspronkelijk bericht- Van: stephane parenton [mailto:[EMAIL PROTECTED]] Verzonden: zaterdag 1 februari 2003 18:09 Aan: [EMAIL PROTECTED] Onderwerp: RE: how to change mysql root password Hi everyone.. I have a related problem with my mysql 3.23.54 on a RH7.3... Assigning the root password is ok with Mysqladmin -u root password 'newpassword' but when trying to do Mysqladmin -u root -h myhost.mydomain.tld password 'newpassword' i have the following... ./mysqladmin: connect to server at 'myhost.mydomain.tld' failed error: 'Can't connect to MySQL server on 'myhost.mydomain.tld' (111)' Check that mysqld is running on myhost.mydomain.tld and that the port is 3306. You can check this by doing 'telnet myhost.mydomain.tld 3306' Telnet refuses my connexion, even though i'm connecting from the host itself... Anyone has a clue for this ?... Regards steph - 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: how to change mysql root password
This is a FAQ. Please search this lists archive or the manual: http://www.mysql.com/doc/en/Default_privileges.html Ppl have spend time to create a manual so you'd better take a look there.. If it's not clear please come back to the lists and explain which part you don't understand. You will find the complete reference manual here http://www.mysql.com/doc/en/index.html B. -Oorspronkelijk bericht- Van: Jianping Zhu [mailto:[EMAIL PROTECTED]] Verzonden: vrijdag 31 januari 2003 21:46 Aan: [EMAIL PROTECTED] Onderwerp: how to change mysql root password How to change mysql root password in redhat 7.3 ? 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: MySQl and webpages
www.php.net -- links www.google.com -- search for tutorials mysql php --B. -Oorspronkelijk bericht- Van: Doug Thompson [mailto:[EMAIL PROTECTED]] Verzonden: zondag 26 januari 2003 16:39 Aan: [EMAIL PROTECTED]; Scott Lewis Onderwerp: Re: MySQl and webpages For decent explanations of concepts and practicalities, try http://www.webmasterbase.com/subcats/53 and more specifically http://www.webmasterbase.com/article/228 There are also good and more advanced tutorials at http://www.onlamp.com/ http://www.devshed.com/ These are superficial scratches on the surface for web-based tutorials. Enjoy, Doug On Sun, 26 Jan 2003 11:00:18 -, Scott Lewis wrote: As you can tell - very new to Mysql. I was wondering, has anyone some links to howto or even better examples of databases and webpages that I can install, and see the web interaction with webpages and a mysql database. Looking at going down that road as exaaples would help. Scott - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie - Where do I look for answers?
Hi, www.google.com www.mysql.com (the manual) www.devshed.com --server side -- mysql devshed has some very good articles.. Not sure if you think those are easy. Have fun, --B. At 12:20 02-01-2003 -0600, DIetrich Speer wrote: I am a complete newbie to mysql and Linux. I completed the installation of the 4.0 version of MySQL/InnoDB, and now I am stuck with permission problems: Logging in with empty username/password lets me look at the initial state of the db, but creating new users or new tables through any front end fails with permission problem messages. SQL (MS-SQL) is second nature to me, but this is not. - Where do I find an EASY, straight forward manual about MySQL administration on Linux - As the root user, how (and where) do I create new MySQL users, set permissions correctly? I would be very greatful for any help Dietrich - 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: FAQ hosting site (was Re: An Idea)
I'm not following this threath.. but.. Use PHP to fetch mail from a mailbox, insert all questions into a database. Create a searchtool to search the database. No need to have way to many ppl as author. If you want you could have some ppl maintaining a list of keywords per question or remove a question from the database.. If you really persist to create something of your own you shouldn't create catagories. Most ppl don't really understand under which catagory their question could be found. Those who do will probably find an answer much quicker using google. --B. -Oorspronkelijk bericht- Van: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 1 januari 2003 22:26 Aan: David T-G; mysql users Onderwerp: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be extremely convenient, with a persistent cookie, so an author will not actually have to login more than once (from the same browser/machine). 5. An author should be able to insert new content and to update his / her own content, nothing else. - What I said about database design applies to the frontend, too. We can make it more complex later on, when the need arises. We can have user contributed notes, fine grained search criteria, etc. In the beginning, I would suggest to follow the KISS principle (keep it simple stupid). I send this to the list, because a) maybe someone has written exactly what we want, or can give a URL to where to find it, b) maybe someone has better ideas or comments on this. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Great. We should discuss everything else via this list, then. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 4:12 PM Subject: Re: FAQ hosting site (was Re: An Idea) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % see it dropped if they don't jump on it at the start. % % I agree. Will you set it up at http://justpickone.org/? (BTW, I like Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp (I wish we could sftp without then also having ssh; darn) and, meanwhile, it seems like this should be the sort of
RE: php3.0.15
This is a PHP question. Visit: http://www.php.net/manual/en/function.mysql-connect.php for more information about the function mysql_connect. Or: http://www.php.net/links.php To find some tutorials to get you going. You really should upgrade to a newer release of PHP. Have fun, B. -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Verzonden: vrijdag 27 december 2002 7:43 Aan: [EMAIL PROTECTED] Onderwerp: php3.0.15 oY! I am running RH 6.2 with PHP 3.0.15 (don't ask why I do not run php 4 yet, I really need to install theses versions to start everything) but when I am trying to access a mysql function I get the following error : Fatal error: Call to unsupported or undefined function mysql_connect() in /home/httpd/html/test/index.php3 on line 9 And my line #9 is : mysql_connect ( ... ); What I forgot during the installation ? P.S. : I already try dl(mysql.so); at the begining of my pages, not able to load the library! - 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 help
This has been answered a zillion times in the past. Search the archive. mysqld.sock will usually live in /tmp Change the appropriate paths. -B. -Oorspronkelijk bericht- Van: Rich Dodge [mailto:[EMAIL PROTECTED]] Verzonden: zaterdag 21 december 2002 16:10 Aan: [EMAIL PROTECTED] Onderwerp: i need help I keep getting this message what can i do to correct this problem ? Warning: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /web/repository/sites/www/inc/generate-page.php on line 4 - 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: OT: Spam Filter (again)
Allow postings from members only. or I think it's on the PHP lists, if a non-members sends a message he/she gets a message back. After replying to that message the original one hits the list.. mysql, query B. At 14:37 18-12-2002 -0500, Michael T. Babcock wrote: Just for anyone who cares (or cares to do the same), when I reply to messages at my average 80wpm and hit send, I don't check if SQL,QUERY,etc. is in the message 90% of the time. Now, besides thanking the crew for adding a couple more keywords to the filter, it still ticks me off to get a bounce to a legitimate response. If I get such bounces from now on, I'm ignoring them (that includes the last 3 messages I've sent). I'm not going to bother to retype / reformat / forward (because its ugly) the messages. I always reply-to-all, so the author of the previous message gets their copy. PS, it wouldn't be that hard (depending on your mail distribution method) to allow subscribers to post without going through the filter and only filter unsubscribed people. PPS, you could always make it database-driven and add people who post successfully more than once a week to the no-spam-check list instead. - 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 to MySQL
Search the archive! Short answer: export to .txt and import in mysql or use ODBC B. At 13:20 16-12-2002 -0400, Yves Arsenault wrote: Hello, Is there a small program that would transfer the contents of an Access database to MySQL? TIA, Yves Arsenault - 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 with Slackware -- wha?
IIRC Slackware 7 and 8 come with MySQL preinstalled. But.. it does compile fine here.. on both 7 and 8. But you really have to uninstall (pkgtool) the default installed.. next you follow all the staps as explained in the MySQL manual (actually a file in the docs directory). Have fun, B. At 16:11 24-10-02 -0700, Blain Nelson wrote: Howdy, I've used MySQL before, a few years ago, under Slackware. I never could get it to compile (despite lots of help from folks here), but a pre-rolled binary did just fine for what I needed at the time. That system is no longer hooked up. I've recently installed a newer version of Slack (7.0 I believe) which comes with MySQL in it, but I can't get mysqld to run either on its own or (preferably) with safe_mysqld. It appears that all the scripts are in /usr/bin/, mysqld is in /usr/libexec/ and the data files are off of /var/lib/mysql/. I did do mysql_install_db, but, when I try to use safe_mysqld , it says that it's starting, and then it says that it's done. When I look in /var/lib/mysql/ there is a .err file that says /usr/libexec/mysqld Can't find file: './mysql/host.frm' (errno: 13). It's very insistant about this, btw -- I've checked several times, and that's all that it has to say about that. The manual says that errno: 13 means we've got a permission problem, but I've tried chmod to the /var/lib/mysql/ and /var/lib/mysql/mysql/ directories and their contents, and that doesn't seem to make anybody happier. So, for you folks I've seen in the archive saying how Slack rocks (with which I agree), a hand would be appreciated. Additional data in case it's handy: mysqlaccess indicates that this is: $VERSION= 2.06, 20 Dec 2000; and $SERVER = 3.21 Any other information you can tell me how to find out for you will be given on request, but I may ask for commonly used words to be defined or clarified because I'm not all that great with this stuff. TIA, Blain -- ( ) ASCII ribbon campaign X against HTML e-mail / \ - 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: Im New :(
My host is running 3.22.5 on a redhat. Im trying to log in and use the LOAD command but I cant get past 'ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).' I connecting remotely with putty and sshing in on port 22. at command prompt I was told by host to mysql -h localhost -u cbslink -p. It then asks for my password, I enter it , then get the above error. This really is a FAQ, please search the archive first.. remember to use google.com too.. If MySQL is running on the same server you would only need to: mysql -u cbslink -p But I don't think it will cause any error.. Anyway, the error could mean a few things, mysqld is not running (type ps -ax in your shell) or the mysql.sock file lives somewhere else. If this host is configured/supported/maintaned by your ISP you should contact them. If you have to maintain/solve it yourself you should be able to find the solution in the archive.. or using google. Bye, B. - 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: Forgot Mysql-Root Password
How can i solve this Problem? I have alread reinstalled mysql, but unforunatelly i keeps its password. Reinstall will only work if you remove the database containing the passwords and users (mysql). Personally I would prefer the way suggested in the manual. Bye, B. - 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: a newserver would be better than this mailing list
At 18:38 30-7-02 +0200, Bart Burkhardt wrote: I am not going to give my replys to every yours reply, because.. i just know and feel that i gave fair reasons, and i find your replys not strong enough. Exactly why I don't spend much time on this. Your arguments aren't good enough. Consider these: - with many messages you don't have a clue what they are about unless you read them (this list is a positive exception quite a few ppl use the subject to describe the problem - not wanne read a messages -- hit del - to much mail -- choose digest or unsub and read the web archive - on vacation -- unsubscribe or get yourself a mailbox large anough to hold all messages. A real workaholic (like /me) has his notebook with him to read mail while he's on vacation.. - bandwith (I like this one)-- how about ppl visiting a newsserver?? right bandwith too. - a list per subject -- take a look at the PHP lists, crossposting is an art ppl seem to develop there. So it's not really working. - newsservers are taking much more time to visit while mail from a list is getting in automaticly. IIRC this has been discussed in the past. Please stop it, it's just a waste of bandwith. sql query. Bye, B. - 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: always this happenes to me
an error can't connect to MYSQL server through socket /tmp/mysql.sock This is a FAQ. Searching through the archive will get you somewhere around a zillion hits. Get through the filter: mysql, sql, query Bye, B. - 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 bad!.. today.. of all days!
hope you version came out better thn mine.. in my mail it was all out of shape.. maybe could attach a text file.. doubt the list allows that thoough alot dont Upload it as your_code_name.txt to your website and send an URL to the list. filter: mysql query sql Bye, B. - 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: Fw: PHP+MYSQL: unable to select database
If you plan on using MySQL a lot I suggest you buy the book MySQL written by Paul DuBois. You might start by reading information on www.devshed.com (click on MySQL, click on PHP) and www.php.net (click links) Bye, B. - 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: Nusphere is spamming me
It'd be interesting to know if A LOT of people have had this happen. If so, maybe we should apply some social pressure and see if they're see the error of their ways. Thoughts? Yeah.. I think I remember there was a Federal Trading.. thing (forgot it's name) somewhere in the USA which was interested to hear about spammers. Perhaps anyone who received spam from NuShere could drop them an e-mail.. mysql, query Bye, B. - 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: manual
I have tryed to download the mysql manual.pdf but for some reason I cant. Would anyone be able to email me the pdf version? [EMAIL PROTECTED] Hi, I think it's around 3MB.. so if say 10 persons would mail it to you you'll get about 30MB in your mailbox.. If you're using M$ IE you might need to IIRC right click on the link.. mysql, query Bye, B. - 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+web+????
I intend to use linux for the server, mysql for the database, php for the web-forms. but what is with the diagramms? They were not pregenerated, they must be generated as a result of the user parameters. GD might be able to do what you want.. www.boutell.com/gd uhm.. quite sure :-) mysql, query Bye, B. - 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: Root password revisited
At 17:44 28-8-01 -0700, Gregg Baker wrote: Hi all, I just joined list. I spent a couple hours in the archive and decided MySQL better improve their install message regarding setting the root password! Half the posts are about it going badly. ;) When installing from source you will get a messages telling you to set the root password (mysql_install_db does this) but it is NOT mentioned in the manual.txt I didn't see it in the online manual but I didn't look to long.. Perhaps one of the maintainers could think about changing this.. everything is explained in the docs except this little thing.. Bye, B. - 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: Lost Root password
At 03:39 29-8-01 -0700, temi odurinde wrote: Dear List, I have lost the root password to my MySQL installation. What is the quickest way to remedy this situation, uninstall and reinstall MySQL or what???. My installation runs on a RaQ4 server. Take a look at the manual and this lists archive. Bye, B. - 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: Use of the MySQL logo - licensing agreement
Does that make any sense? I'm not trying to slam MySQL, I'm just concerned about displaying the logo on a web site that says powered by MySQL or modifying the logo like folks used to do to produce all kinds of cool enhancements to the name MySQL. Did you try to get permission?? I'll bet it's quite easy. I'll even bet you don't have to pay for it.. I guess this has everything to do with the NuSphere stuff.. Most of the intellectual property (trademark) laws do require the person (company) who has the trademark to enforce it. Otherwise it's useless. If they require you to ask permission then it's their right and a requirement of the law. In most laws the holder of the trademark can give others permission to use their logo.. Now.. what would you prefer.. many forks all using the same logo or that they require you to ask for their permission. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: RE: Use of the MySQL logo - licensing agreement
At 16:10 29-8-01 +0100, Andrew Murphy wrote: Why not get MySQL to make a series of slightly different logos you can choose from like Sun and other companies do. Some are colour, others greyscale, and some are inverse for placement on black backgrounds. It would still violate their trademark cause it's a look-alike. Legally the only way is to ask permission to the owner of the trademark. Bye, B. - 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: how to create a table and a column..?
http://www.mysql.com/doc/C/r/Creating_tables.html Look over http://www.mysql.com/doc/index.html Also have a look at www.devshed.com for some tutorials.. mysql, query Bye, B. - 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: [PHP-DB] Proper Case Conversion
It's a bad habbit to crosspost!! strtolower() stroupper() sql mysql Bye, B. - 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: [PHP-DB] Opps: Proper Case NOT lower case
Buy a good book (PHP 4 Bible)!! read some tutorials!! And CHECK the manual.. found at www.php.net what else did you think people created if for.. http://www.php.net/manual/en/ref.strings.php gives you all string manipulation fun stuff you want. ucfirst() is the solution. And last but not least STOP crossposting. sql, mysql Bye, B. - 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: Just wondering....
I have been considering a database backend for a new website I am creating. If this site becomes successful I may be looking at several hundred concurrent users. Can MySQL handle this? Is there a limit to the number of connections?? Any info would be greatly appreciated. Check this lists archive.. this has been discussed into great dept.. several times.. Bye, B. - 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: Connecting MySQL over a Novell network
PC there communicates through Novell 4.11 server, some use Windows protocol. I've used the same installation, and more, one from Apache serverer PC can be connected alternatively to one or to second network. In the first, it works, as I've mentioned earlier, in the second the server sees himself but on one from other PC's. Is here anybody, who can give my advise, in which direction should I go? Any suggestions are greatly appreciated! With best regards This isn't a MySQL issue.. Think you need to check the protocol running.. and check it's settings.. routing issues.. and more fun.. If you need to install TCP/IP on a Netware server you should checkout www.novell.com for packages and patches.. Bye, B. - 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 on Windows CE
Does anyone have any information on running MySQL on a windows CE handheld? Try it and let us know as soon as you've got it up and running.. Good luck. /me wouldn't even try.. but me wouldn't even try to run MySQL on any M$ product.. mysql, query Bye, B. - 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: Looking for Support
If you're looking for support you can contact MYSQL AB (the creators of MYSQL) checkout www.mysql.com to see which supportcontracts they offer. But you could also try your luck on this list. Bye, B. At 15:00 29-7-01 -0400, Thomas Bernthaler wrote: Hi, I have mysql-3.23.40-sun-solaris2.7 on Sun and I have quite a few problems I try to find somebody that I can pay to help me get this running the way it should. If anyone is good with the produce and is interested to earn some extra money please contact me. I need someone fast. Thomas Bernthaler [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
Re: Telnet
At 18:06 28-7-01 +0200, Marco Bleeker wrote: I need to Telnet into my domain in order to run some MySQL utility like mysqldump (for backup). I am not experienced with Telnet. Any pointers? Any way around it (use mysqldump from PHP?) Good reason to learn it :-) You could try phpadmin (or was is myphpadmin.. anyway.. it is called something like that). | | __@ | _`\,_ |__(*)/ (*)_Ah, op DIE fiets ! Ja. Bye, B. - 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
At 13:44 28-7-01 -0700, tj marlin wrote: There are secure telnet packages. one for windows is SecureCRT. see www.vandyke.com Rather use PuTTY.. it's free!! and a very good SSH client I wonder how many sysadmins still allow telnet.. Use your favorite searchengine to find PuTTY.. or find your way via www.openssh.org magic words: mysql, sql, query Bye, B. - 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.org
As you are aware, we are forming a not-for-profit corporation to focus on building and supporting a larger MySQL development community and promoting MySQL. The mysql.org domain is expected to be transferred to that organization. NuSphere has taken the lead and is covering the costs of forming this organization and expects it will take some time before it can operate on its own. We firmly believe that establishing a source of information independent of any for-profit corporation is an important step for the long term health of the MySQL community. We encourage you to reconsider your opposition and join us in supporting this effort. If the result of this would be 2 versions MySQL (MySQL AB and NuSphere MySQL) than it's unclear to me how the community can benefit. Although diskspace is not much of an issue but I would like to install both.. Although others might have their own opinion about this.. mysql.org looks A-LOT-LIKE mysql.com and it looks to me (and others I've spooken with) as if the mysql.org site is the official MySQL website.. It's great if NuSphere or any other starts a website with addons, tools, etc to be used with MySQL. But please don't start to confuse people.. I don't think the current mysql.org site is what MYSQL AB had in mind. I really hope the MYSQL AB and NuSphere people can come to a agreement.. Bye, B. - 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.org
Hi, Sorry.. can't keep my mouth shut.. A few comments on the legal matter: GPL has been spoken about more then enough here.. Trademark: If no license or agreement exists which allows nusphere to use MYSQL AB's trademark it's probably illegal. One could think of situations where it might be perfectly legal.. MYSQL AB must act otherwise MYSQL AB will probably loose the right to use their trademark and the right to defend it againts others. Having a word in a domainname that corresponds with a trademark does not always mean you're in violation of a trademark.. one might have obtained a license to use the trademark.. or one might have a trademark of their own with the word MYSQL and not violate any trademark.. This is in a nutshell how most laws I've seen work. I studied a few laws which have to do with intellectual property.. NOTE: I did use the word probably quite often.. It's not always sure.. If I look at the mysql.org website it looks to me like I found the home of MySQL. This is what most visitors which are unfamiliar with MySQL might or will think. It's a very thin line.. I know.. If nushere want to provide the mysql community with addons or enhancements.. why can't that be done via mysqladdons.com (if that one is still free).. Or even via mysql.org but without attempting to look like the home of MySQL.. I don't think it's generally a good idea to split a community amongst several websites.. having multiple lists and such.. just my 2 cents.. - 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: hi new to mysql
helo anybody there to help me for my project my project is on PERL and Mysql in Linux please say me the procedure to study those stuffs. thanx in advance Buy the book MySQL written by Paul DuBois. Take a look at www.devshed.com and on webmonkey. Bye, B. - 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: now I have it compiled, ??
Complete tutorial on installing Mysql, PHP and Apache can be found on www.devshed.com Have fun. B. At 11:12 14-6-01 -0700, Mark Vann wrote: Hey gang, I got the configure script to run with no errors and got it installed in the /opt directory by using the following. ./configure --with-named-z-libs=no --without-debug --with-mysqld-user=mysql --prefix=/opt/mysql But after the make install ( and I saw no errors ) there is no /opt/mysql/var directory and I think there is suppsoed to be one. So when I start safe_mysqld I get this error, touch: cannot create /opt/mysql/var/rome-ga-2.err: No such file or directory chown: /opt/mysql/var/rome-ga-2.err: No such file or directory Starting mysqld daemon with databases from /opt/mysql/var ./safe_mysqld: /opt/mysql/var/rome-ga-2.err: cannot create Any ideas? Thanks __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.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: which the best
You're right.. wrong place to ask. I don't want to start a kind of religious war.. but I wouldn't go for M$ products. Further good reading on this is presented in this lists archive. Bye, B. I know this is not list for ask about OS, but I wonder to know that which OS you choose for database server in your mind? Linux Red Hat 7.1 Linux Mandrake 8.0 Windows NT 4.0 Windows 2000 Server or anything else from these OS! Regard, Sommai Fongnamthip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie with PHP
Just a few thoughts. Does the user who needs to insert have enough rights to do so. Is your mysql server up and running.. If you want to take a look at a tutorial: www.devshed.com Bye, B. At 09:09 5-6-01 -0600, Harry Bakken wrote: I apologize if this seems simple, or stupid, or if there is an answer in the archives. I am under an extreme deadline to get my PHP generated form into MySQL. I am trying to collect an order then pass the variables in to a validation page where the customer will review the information then submit it for the database. When I submit the information from the validation page, everything appears to run fine, but no data are inserted in the table. I was getting some parsing errors, but I sorted those out. Now it looks like things are good, but no data are inserted. Any help or guidance is very much appreciated. Harry www.technologytrust.org http://www.technologytrust.org www.technologytrust.net http://www.technologytrust.net - 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: Need help on mysql/php
Great support.. Right.. take a look at www.devshed.com they've got a few nice tutorials.. if you plan to work a lot with MySQL you might want to buy the book called MySQL written by Paul DuBois or fill out the survey and hope you'll get one for free ;-).. Other interesting websites: www.phpbuilder.com www.phpnewbie.com www.phpbeginner.com and many others can be found using your favorite searchengine. Bye, B. At 13:30 5-6-01 -0700, Ed Peddycoart wrote: I recently move my website to FastWebServers.com. MySQL and PHP is provided. I have a control panel which allows me to initialize MySQL for my use. The initialization creates a db, named celticblues_com (my domain is celticblues.com). So far, I have added a table to my database, and added the neccessary fields. Now I am at a total loss at what to do. I want to use PHP scripts to pull info from the db and search the db etc. I have contacted my support from FWS, but they point me to MySQL.com for Mysql commands technical support. Seems to me I would need to know how to set username/password to access the db from script etc. The bottom line question is can someone point me to information on what I need to do to be able to access(open/close) the db, retrieve/store information, etc. in this type of environment (i.e. MySQL provide by my host service, not installed by me)? Ed - 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 php connection errors
At 22:00 30-5-01 +1000, Steve Sapsford wrote: hi ppl, i am a newbie running apache, php mysql on a redhat 7 server... i am getting the following error when i browse to my php file which access my database called steve: == Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/bookorama/index.php3 on line 7 This is a faq. Caused by one of these: - wrong location of mysql.sock in php.ini - wrong location for mysql.sock in /etc/my.cnf Warning: Supplied argument is not a valid MySQL-Link resource in /var/www/html/bookorama/index.php3 on line 9 Line 9 doesn't mean it has to be line 9.. Take a look at some of the tutorials.. www.devshed.com has a real nice one. Bye, B. here is the index.php file: ?php $db = mysql_connect(localhost, root, new-password); mysql_select_db(steve,$db); ? === i can access mysql and this database no problems via the linux box using mysqladmin etc i would be grateful if someone could point me in the right direction thanks in advance steve - 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 create table with file named INFILE
Please check the manual before sending a question to this list.. says every messages.. So: http://www.mysql.com/doc/R/e/Reserved_words.html Workaround: give your table another name. Bye, B. At 14:23 28-5-01 +0200, Alessandro Staltari wrote: Hello. I'm new to MySQL but I have a problem that appears serious, al least for me. I can't create a table with a field named INFILE. I think mysql consider INFILE as a keyword. Is there work around for this? Shouldn't INFILE be used only within a LOAD statement? I think it is a bug in the query parser? Regards Alessandro Staltari - 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: How to transfer database from one machine to another without network
i have created a database ,Now i want to copy it on the server. Is there any way to do it or i have to make tables on the servers if anybody knows please reply a.e.a possible. Take a look at the manual (www.mysql.com).. mysqldump might be what you want. Bye, B. - 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: urgent!!
Can anybody please help me with the making of this database or atleast guide me with the making of this..please. Thank You I suggest you start reading on database normalization (www.devshed.com has an article on this in the mysql part of their website). Bye, B. - 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+ftp]
At 18:52 10-5-01 -0300, Gleidson Henriques wrote: Hello list, I want to install a mysql with a ftp server, is it possible ?! If you mean you want to authenticate users with the userinfo from your database.. sure www.proftpd.org might need so work from the developers.. Bye, B. - 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: running mysql as different users
the script. However, after that, I could not run mysql as root or mysql. It gave me the same error message as it could not connect to local MySQL server through /var/lib/mysql/mysql.sock. /etc/my.cnf might have a line giving the uri above. Mysql.sock normally lives in /tmp change my.cnf accordingly.. or create one.. I assume your mysql server is up and running.. if it isn't start it first.. Bye, B. - 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: Mysqld
At 22:00 2-5-01 -0600, Al Green wrote: When I try to run mysqld I get the following message. How do I rebuild the .sock file. It is not where it should be and the one's that are there are 0 bites Any suggestions The size is right. If the .sock can't be found point to the right location in your my.cnf If this doesn't help search this lists archive.. it's really a FAQ. Bye, B. - 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 not see data or tables in database
I set up a couple of databases last night in mysql and every thing is working just fine. Today when I try to access the data it is not there Using phpMyAdmin when I look at the databases that are completely empty of tables and data that also includes the mysql database. If I start up telnet and go into mysql it shows that all of the tables and data are their including the mysql data. This seems realy strange to me. Could you tell me what I need to do to correct this problem or at lest looking in the right direction. Perhaps a problem with rights.. (settings in phpmyadmin not being saved?).. Not using phpmyadmin myself.. did read about it. Bye, B. - 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[2]: can not see data or tables in database
B. Perhaps a problem with rights.. (settings in phpmyadmin not being saved?).. B. Not using phpmyadmin myself.. did read about it. None of the programs on the web can access the mysql not just phpmyadmin. It was working fine before yesterday and now it just wont work. is there anything that I should check on the server or would it be best to uninstall mysql and reinstall it. Dunno.. What does the logfile say.. Remember to read the manual and this lists archive about trouble shooting.. If it's on windows the you should reboot.. solves almost any windooz problem. There is a seachable manual at www.mysql.com Or wait a while to see if any other suggestion comes up.. Bye, B. - 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 server grant privileges problem
So would anyone explain to me how can I setup up a good privileges of mysql server.Thx Take a look at the manual. It's all there.. as far as I remember.. Bye, B. - 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: New filter
This is email. It's not a bomb on a plane. Choices exist for a digest, or a newsgroup. Freedom has a price. I am more than willing to pay it. I don't feel our freedom has been limited by the filter used. Glad the listadmins does take some steps to prevent spam. just my 0,02 Bye, B. mysql, query, 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: What is SSL ?
I am a Java developper, I use Mysql and TOmcat, I want to know what SSL is? Nothing_to_do_with_mysql. ssl=secure socket layer More info? type ssl into the seach field of you favorite searchengine. Bye, B. - 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: ZipSlack 486 installation problems
MY PROBLEMS SO FAR All versions of MySQL I have tried so far have come in RPM format which I have rpm2targz to set up. Then I have gunzip/tar or tar xzf to unpack the archive. The archive unpacks in different folders to those that the scripts expect and this is a problem for a start. Also some files seem to be missing, in particular mysql.sock . In summary, I am not sure if this unpacking process is working correctly and maybe this explains my problems. I've compiled several 3.23.36 on Slackware 7.1.0 without any problem at all. I don't like RPM stuff.. always compile from source. Missing mysql.sock is caused by settings in /etc/my.cnf (of the top of my head). Or by rights issues (not correct user/group) or cause it's just not running. Nice tutor on www.devshed.com Bye, B. - 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: Password security
How do you keep MySQL password out of view of visitors when needed in PHP to access the db. The password is in plain english in all the php files, and can be easily downloaded by anyone. PHP is parsed so should show the password etc to the world. It's better to use an include and put that file outside the document root. So Apache can't serve but PHP can include.. Just in case someone start playing with apache settings and .php files are shown as textfile.. Bye the way, this question does belong on one of the PHP lists.. Bye, B. - 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 hosting?
read of a free hosting site a while ago if you are developing mysql sites. does anybody know about that? I can't find it anymore. Please I really need to host my test page as the server I had it one broke. Can anybody help me out Use your favorite searchengine. Bye, B. - 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: create table
I got a downloaded version of MYSQL installed. I am not able to create tables within in a database . I think some problem with the edit options.Any solutionbut i am able to create a new database. manual www.mysql.com several websites: www.devshed.com and others. Book: MySQL written by Paul DuBois Bye, B. - 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: [PHP-INST] tforum
COME ON This_is_not_a_MySQL_issue.. It has everything to do with PHP.. please keep this discussion in the PHP lists.. By the way, crossposting isn't the way to make friends.. Looking for more info on PHP and MySQL go to some URL's mentions a million times in several PHP lists. Bye, B. At 12:23 24-4-01 +0100, Rob Wilks wrote: I'm probably out of my depth here, but please have a look at my forum at http://forum.celinestar.org.uk. The error messages are like this: Warning: 0 is not a MySQL result index in functions.php on line 16 Warning: 0 is not a MySQL result index in functions.php on line 21 Warning: Oops, php3_SetCookie called after header has been sent in functions.php on line 556 Warning: Oops, php3_SetCookie called after header has been sent in functions.php on line 562 Warning: Oops, php3_SetCookie called after header has been sent in functions.php on line 581 Warning: Oops, php3_SetCookie called after header has been sent in functions.php on line 584 There are errors like this throughout the forum. I was using it to post messages one day and refreshed it and it came out with all the error messages. - 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: accessing mysql remotely
I have mysql installed on two linux boxes. How can i access one system's mysql db from the other system grant access to the user on the other system. COnnect to the remote system just like you would on the local. Bye, B. - 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: Debian - mySQL - php3
Once again.. a PHP issue.. You might want to try with PHP4.. latest release. If that doesn't help go the archives @php.net.. Bye, B. mysql, query At 15:16 24-4-01 +0200, [EMAIL PROTECTED] wrote: I have a system built up with Debian potato and apache. I have to install (to copy) a database from a Mandrake system - so I installed the php3 modules for apache (restarted the apache) and the Debian package of mysql-server and mysql-client. Can you help me, why I get the following error message? Fatal error: Call to unsupported or undefined function mysql_connect() in /var/web/webspace/cie/roster/passwd.php3 on line 9 - 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 with 23.36
COuld try a mysqldump to backup and restore the tables on the new/other machine. This should get you past the problems you found earlier. Remember to add the propriate users to the new machine.. Bye, B. mysql use lum Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'users' Database changed mysql select * from users; ERROR 1017: Can't find file: './lum/users.frm' (errno: 13) Please anyone. I really need some ideas. I copied my database files made with 23.29 to 23.26 and now I get this. I chowned mysql.mysql and chmoded 660. The location of the databases is good because I have some other databases created with 36 and they work fine. I copied ALL the database's files to /var/lib/mysql where the others are and I get this error. Any idea? Error code 13 means permission denied. How come your database is named 'lumina' and the directory it resides in (or at least the dir that mysql tries to find the tables in) is ./lum/ ? Shouldn't it be looking under lumina? Check that you don't have your database directories messed up under ~mysql/var/ The files are in the right directory with the right permissions and still I get the errors from above. - 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: Connecting to mysql as root
For connecting I have given the user as root and no password in the PERL scipt. You NEED to provide the password otherwise you can't get any data out of the database.. If you didn't entered a password for the mysql root user you need to do it ASAP.. Is there any way to connect to the database in the normal way, I mean from the shell ? mysql -u root -p then you're asked to enter your password use name_of_database Bye, B. - 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 with 23.36
I copied my database files made with 23.29 to 23.26 and now I get this. I chowned mysql.mysql and chmoded 660. What's wrong? Perhaps or.. the location of your database is different.. or.. you didn't copy everything.. including subdirectories. Solution: check the location and if you copied all files.. Bye, B. - 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: Src distribution of MySQL takes up a lot of space
I'm new to MySQL and I've recently installed MySQL (MySQL-3.23.36-1.src.rpm) and it's running ok. But, I noticed that it seems to be consuming so much of my hard disk space. Is this normal? I'm wondering if anyone encountered this problem before or can advise wat I can do abt it? I don't know what gets installed with the .rpm I never use them. If you think stuff gets installed which you don't need you could compile from source. I don't consider it a problem if mysql uses a lot of space.. large drives aren't very expensive anymore.. Bye, B. - 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: how can i make it?
how can i get a recordset constains all records (or records matching a where exp.) from the Table1 with the c values from the Table2, like this: uidnamecs - 1user1'50 - twenty-three - the reason of life' 2user2'twenty-three - 303 rulz' 3user3'' I can make heavy things with mysql, but i'm too small for this :) Think what you want is left join. Check your favorite SQL manual for syntax. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql_install_db problems
This sounds more like a OS problem then a MySQL problem. I don't know much about HPUX. Bye, B. Hi folks, Thought I'd see if I have a common problem before I do a bug report. I am trying to install the binary file for HP/UX 10.20 on a HP/UX 10.20 785 series computer. As the error message is about memory problems the following info may be of interest. The tar file is on a volume with 30,000 bytes free space. I unpack the file into the /usr/local/mysql-OS-version directory onto the volume /usr which has 300,000+ bytes free space. Okay, the result of running the install script is: # scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 010423 11:09:07 Warning: setrlimit couldn't increase number of open files to more than 200 010423 11:09:07 Warning: Changed limits: max_connections: 100 table_cache: 64 scripts/mysql_install_db[284]: 15102 Memory fault(coredump) Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld demon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables There are no logs in the ./data directory just a core dump. When I try ./bin/mysqld --skip-grant I get the following message: # ./bin/mysqld --skip-grant 010423 15:07:48 Warning: setrlimit couldn't increase number of open files to more than 200 010423 15:07:48 Warning: Changed limits: max_connections: 100 table_cache: 64 ./bin/mysqld: Can't change dir to '/usr/local/mysql-3.23.37-hp-hpux10.20-hppa1.1/var/' (Errcode: 2) 010423 15:07:48 Aborting 010423 15:07:48 ./bin/mysqld: Shutdown Complete Why does mysqld even try to change to ../var ? This is a binary distribution and this directory does not exist! Can someone help me or is this a case for bug fixing? Thanks a lot in advance, Pete - 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: how can i make it?
It's a bad habbit to cc to a list. Of course left join. And group by moreover. But how? For the group by i need a sum-like function, which joins the strings. Hmmm, something like concat() you mean? Bye B. mysql, 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: Please assist me?
Are there any suitable training materials on your website? In particular, how can I best use the GUIs in WinMySQLAdmin? Try a few of the websites already mentioned in other postings.. I think www.devshed.com is a nice place to start.. But you can find plenty others in the manual.txt found in the sourcedir.. If you want ot use MySQL I can also recommend the book MySQL written by Paul DuBois.. Have fun.. B. - 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: LIMIT
seems redundant and I really hate the fact that LIMIT is not supported. Any ideas? By the way, suggestions for SQL Server 6.5 or SQL Server 7.0 are both appreciated. M$??.. thought this was about MySQL :-) I wouldn't know.. I do know you can find a few newsgroups somewhere at news.microsoft.com this question will fit nicely there.. Bye, B. - 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: Run time version of MySQL
We are planning to move on to MySQL. Could you send us your opinions about MtSQL. It will greatly help us to make decision and to use MySQL. I love MySQL.. but there are others too. I think their are still some pros and cons.. given time I think the pros will increase.. Although other databases might have some appealing pros.. the question is how important they are to you.. and how bad are the cons.. Sorry, but I cannot answer that question. That's up to you.. Which database to choose does depend on your needs. If you want to let PHP interact with MySQL you'll find lots of code already written by others.. free to use.. many PHP functions.. How important it is.. well.. once again.. thats up to you to decide. Not much fun in talking about this.. if you search this lists archive you will find quite a few discussions.. and comparisons.. Remember every list will find it's "own" database the very very very best.. Bye, B. who sometimes like to play the devils advocate - 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
Fwd: Re: MySQL Reports No More Connections - How to Troubleshoot?
Forwarded cause HH send reply to me instead of to the list.. The connections are released... If an INSERT is trying to update a table that is locked, won't that cause connections to stack up? Anyone have any insight? Hunter From: "B. van Ouwerkerk" [EMAIL PROTECTED] Date: Tue, 17 Apr 2001 22:12:34 +0200 To: [EMAIL PROTECTED] Subject: Re: MySQL Reports No More Connections - How to Troubleshoot? What's the best way to figure this out if I can't get into the server at all when it locks up? Few thoughts: - release the connection in your code.. - use pconnect instead of connect.. Check the logs.. if you have any.. Bye, B. query 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: MySQL Problem
I have done the following :- Login through telnet and become root. accessed : mysql -h server name -u username -p Password : password and tried to create database with : mysql create database cart; ERROR 1044: ACCESS DENIED FOR USER : '[EMAIL PROTECTED]' TO DATABASE 'CART' You say root.. would that be MySQL root user.. or the server root user.. You need to be mysql root user to create databases.. or at least you need the rights to create databases.. Bye, B. - 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: install probs - socket error
When I go to that directory and do a ls -al it is empty. So how do I create this file. If it is not specific to my system can someone just mail me one. I'm doing all this as root - do I need special permissions to this dir and file. mysql.sock usually lives in /tmp and is created when mysqld starts. I'm usually starting mysqld from the location where I install it. I (and anyone else) would recommend running mysqld as another user.. like mysql.. running mysqld as root is a bad idea. Please read the manual.txt in /Docs.. found in your sourcedir. Or the manual found at www.mysql.com form more info. This is a common problem.. please check the archive for more info. To answer your next question: change the location of mysql.sock in you php.ini :-) But that's only after installing mysql, PHP and Apache. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem
I'm trying to install mysql onto a uniz environment. I've already unzipped and untarred, and I've created the mysql - version directory, but when I type configure, I get a grant table failed error. I cant find anything on how to fix this. Take a look at www.devshed.com they've got a nice tutorial.. Manual: www.mysql.com and in the Docs dir somewhere in your source.. Have fun.. Bye, B. - 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: how is this done
I am using php for this project. Right now it is related to mysql. What I want is to display the names of the countries and cities from the Special table instead of the ids. What would be the correct syntax for the select statement? Take a look at websites like www.devshed.com www.phpnewbie.com www.phpbeginner.com and find out how to solve this. You might also want to take a look at www.php.net Or hire someone to do the job for you.. I could help you, so could others. But after this question we will soon see your next question.. Bye, B. - 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: Simple question
Why it display other version of client api than I install. It would be nice that You answer me. Did you compile PHP with --with-mysql=/path/to/mysql Bye, B. - 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: Simple question
At 19:31 17-4-01 +0100, John Dean wrote: Hi Did you leave an old version of the shared libs lying around? The old version is packed with PHP.. Bye, B. query 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: MySQL Reports No More Connections - How to Troubleshoot?
What's the best way to figure this out if I can't get into the server at all when it locks up? Few thoughts: - release the connection in your code.. - use pconnect instead of connect.. Check the logs.. if you have any.. Bye, B. query 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: No Subject
At 20:31 13-4-01 +, [EMAIL PROTECTED] wrote: Hi, Can i make a user friendly interface for Sales people to make a contact to my data base on mysql running on my linux server. PHP, Perl also seen message from people who use VB and ODBC to connect to MySQL. Take a look at this lists archive.. as far as I can remember a few messages about these should be found there. Bye, B. - 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: mail to mysql database recepient
I will like to mail all the users in Mysql database having valid email record, their data with user name and password. How to go about this? does anyone have a free script to share? I also want a column to be updated with random password for each user. This is an application issue. You can do this with PHP, C or Perl and a few others. I've got no free script.. but you could take a look at www.php.net I've seen several scripts there which might be twisted a bit to fit your needs. It's better to learn how to do this yourself. Several good tutorials can be found on the web. The book MySQL written by Paul DuBois can also be a good start if you don't like to search/read/print everything online. Bye, B. - 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