Re: please help setting password
I think you took that the wrong way. I see it as more of a warning than being "nasty". Of course, you don't have to set a password if you don't want to but if other people are able to access it, then you only have yourself to blame if someone gets in and destroys data. My test database does not have a root password as I don't see a point to having one. No one is able to access it anyway. I guess it is a little misleading but then again you should read the manual or type mysqladmin --help for a more decent guide on using mysql. - Original Message - From: "Neil Zanella" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]> Cc: "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, January 11, 2001 15:38 Subject: Re: please help setting password > > On Thu, 11 Jan 2001, Rolf Hopkins wrote: > > > Fresh installation? Then you don't need -p option. If not, what password > > are you using when it ask you to enter the password. It's not newpassword > > as you typed in the prompt, it's your old password > > Hi Rolf, > > Thanks for your helpful comment. I am indeed installing MySQL for the > first time so I don't need the -p option. It would have been nice if > the output of the RPM file had provided this kind of information instead > of shouting at me in big caps, uselessly: > > PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! > This is done with: > /usr/bin/mysqladmin -u root -p password 'new-password' > > Luckily there are people on this list to give real help. > And forgive me all if I misinterpreted the meaning of the big caps in > the RPM output but big caps means shouting and people should not > shout a word of caution without thinking about it twice otherwise > it comes across as condescending hatred. > > But nobody is perfect so let's forget about it. > I'll even take it as plain miscommunication. > > Back to MySQL... now things work! > > [root@tulip /root]# /usr/bin/mysqladmin -u root password rootpassword > [root@tulip /root]# echo $? > 0 > > Thanks a lot, and thanks to everyone, > > -- Neil > > > - > 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: help please!!
Before you do, check out the Delphi components on the mySql home page. I'm sure your aware that you can use Delphi components in BCB. Sean >From: "Justin C. Darby" <[EMAIL PROTECTED]> >To: "Alain Morlans" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> >Subject: Re: help please!! >Date: Wed, 10 Jan 2001 10:39:15 -0600 > >I may be interested in working on some Borland C++ Builder componants for >MySQL, if theres enough interest. Right now, all I do is use the API for >Win32 directly, which is proably the best method. I haven't seen BCB5 >componants for MySQL.. In any case, using the C API directly is the way to >go, even if I do write componants for BCB, it's just going to bloat your >app >even more. =) > >Justin > >- Original Message - >From: "Alain Morlans" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Wednesday, January 10, 2001 9:48 AM >Subject: help please!! > > >Hi! > >I would like to coonect top mysql using Borland C++ builder on a windows >plataform. > >Do you know what is the best way to do it? > > >Thanks in advance >Alain > > >_ >This message has been checked for all known viruses by the >MessageLabs Virus Control Centre. For further information visit >http://www.messagelabs.com/stats.asp > > ><< smime.p7s >> _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
Off-topic, but database
I know it is not the list to make this answer, but i can find good info anyware. I usually work with myqsl and perl, but I need to do the same with perl and oracle, and i don´t know how to conect to the oracle database, make a query or an insert comand and return the values of the query to perl variables. Can anybody help me with some example or a good URL about this question??? Thank a lot, and sorry by the off-topic. ___ I've seen things you people wouldn't believe. Attack ships on fire off the shoulder of Orion. I watched C-beams glitter in the darkness at Tan Hauser Gate. All those moments will be lost in time like tears in rain. Time to die. === Javier Armendáriz [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: please help setting password
On Thu, 11 Jan 2001, Rolf Hopkins wrote: > Fresh installation? Then you don't need -p option. If not, what password > are you using when it ask you to enter the password. It's not newpassword > as you typed in the prompt, it's your old password Hi Rolf, Thanks for your helpful comment. I am indeed installing MySQL for the first time so I don't need the -p option. It would have been nice if the output of the RPM file had provided this kind of information instead of shouting at me in big caps, uselessly: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root -p password 'new-password' Luckily there are people on this list to give real help. And forgive me all if I misinterpreted the meaning of the big caps in the RPM output but big caps means shouting and people should not shout a word of caution without thinking about it twice otherwise it comes across as condescending hatred. But nobody is perfect so let's forget about it. I'll even take it as plain miscommunication. Back to MySQL... now things work! [root@tulip /root]# /usr/bin/mysqladmin -u root password rootpassword [root@tulip /root]# echo $? 0 Thanks a lot, and thanks to everyone, -- Neil - 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: rpm requires perl5 on redhat 7.0
Dear nair, try to get an rpm from radhat site. But my strongly sudjection is to compily the source codes - Original Message - From: "SATYAN NAIR" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 11, 2001 7:21 AM Subject: rpm requires perl5 on redhat 7.0 > dear friends, > i am not able to install MySQL-3.23.30-1.i386.rpm on redhat 6.2 and 7.0 > it says REQUIRES PERL5 at /usr/bin/perl5 > and under /usr/bin i have perl as well as perl5.006 > > > please let me know how do i install the rpm on linux!! > > take care... > have a nice day... > _ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
rpm requires perl5 on redhat 7.0
dear friends, i am not able to install MySQL-3.23.30-1.i386.rpm on redhat 6.2 and 7.0 it says REQUIRES PERL5 at /usr/bin/perl5 and under /usr/bin i have perl as well as perl5.006 please let me know how do i install the rpm on linux!! take care... have a nice day... _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL transaction problem (Again...)
* Carfield Yim <[EMAIL PROTECTED]> wrote on 11.01.01 06:19: > MySQL 3.23.29 or 3.23.30, with RedHat Linux 7.0, compile from tarball > source, can't rollback. > > Do you mean that it is platform?? There are errors build with RedHat 7.0? Hmm. It certainly does seem so as there have been a few reports after my initial report on December 4 when I encountered this problem. I do believe there would have been more if the problem was more widespread. I'm using RH7, and the versions I have noticed this behaviour in are 3.23.28, 3.23.29 and 3.23.30. I upgraded my glibc on December 21 from 2.1.92 to 2.2.9, and my gcc from 2.96-54 to 2.96-69. This did not help. I've tried compiling MySQL from the source RPMS (first the RedHat ones, hacking them with the correct version and Berkeley DB support; then the MySQL ones, putting the Berkeley DB support in them), and manually from the tarball sources. When I first encountered this, rollback did work for some tables but not others. Nowadays, it doesn't seem to work for any tables. This may be due to the change of MySQL and/or Berkeley DB versions, or the glibc/gcc update, or just some difference in the build itself (which I doubt). I don't know which change to blame as I didn't test rollback except with the table that rollback didn't work with initially, and only now tested rollback on other tables and noticed it didn't work at all anymore. For example, this used to work but now it doesn't anymore: create table tt (id integer) type=bdb; show table status; # Ensure it actually is BDB set autocommit=0; begin; insert into tt (id) values (55); rollback; select * from tt; # Earlier this didn't result in anything, nowadays it does # have the row id=55 -- Tomi Junnila <[EMAIL PROTECTED]> http://www.badzilla.net/~topeju/ Electronics and Information Technology, University of Turku, Finland - 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 read the manual
> Eric Fitzgerald writes: > > > > > > > > Also, might it be possible to move the manual comments to another > > list? :) > > I have decided to stop the [DOCS COMMENT] flood. *Most* comments were > completely useless... even though I added in BIG RED LETTERS that > adding a comment to the manual is not a good place to ask > questions. :( Just had a look at the searchable online manual and I didn't see those BIG RED LETTERS anywhere or anywhere obvious. > I guess it proves the need for some alternate forum for newbies to ask > questions. Apparantly joining the mailing list is too daunting for > beginners. I don't think having another forum/mailing list will help. Newbies will always be newbies and having another forum just for them may just confuse them even more as there will be even more places for them to ask questions. An idea might be to have NEWBIES GO HERE on the mysql home page. This new page should contain as few words as possible but be informative as possible since people are generally lazy and don't like to read. Three things should be enough 1. Explain a little about the MySQL user manual and that they should read it. 2. The main mysql mailing list. They have attempted to read the manual first as answers to most questions asked on the mailing list, can be found in the manual. They don't need to join. Maybe mention the list archive 3. Downloading mysql > We will soon begin to moderate the comments in the manual, to remove > the cruft. Maybe during this moderation, we (the people moderating) > can forward *interesting* comments (and questions if they come up) to > the list for all to share. How do you plan on doing that? If you continuously moderate it manually, it will take up a lot of your time. An idea is to make it more difficult for people to submit comments to the manual. Ah... ... difficult isn't quite the word. More like, it requires a little more effort to submit a comment. Ie. To submit a comment to the online manual, users need to select a category from a list. The default could be something like "question" and this will not get submitted to the online manual but to the mailing list instead. If someone is true blue about making a comment, they'll put in the effort to change the category. Believe me, people are generally lazy and newbies are most likely to see "question" in the category list, say "yes, I'm asking a question, that'll do", write their question and press submit. Cheers Rolf - 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: Lazy
Quentin Bennett writes: > Perhaps, along with the 'Please check the manual' message at the end of all > messages, there should be a reference to a reliable archive, allowing list > users who are referred to the archive an easy way of finding it! Done. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - 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
Testing new trailer
Testing new trailer message. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - 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]> If you are having troubles with unsubscribing, try: http://lists.mysql.com/php/unsubscribe.php
Anyone got suggestions for tuning MYSQL (my.cnf suggestion request)
Well, finally I have launched full blown MySQL database. Speed is amazing (in comparison with our previous monogenous M$Access database). I am now tuning MySQL (3.23.30 on RH7.0/ PIII300 Dell server with 128RAM) server via my.cnf So far here is what I got: 1. ANSI mode tables 2. logs are off 3. no slave I need ideas!?!? I looked at the manual (and Paul DUBois book), but I really need more insight from people who have mission critical productions systems running. Database is not too large. 12 tables with about 1 rows each and an average of 10 columns each. Lots of reads, sorts and joins. Inserts, adds and deletes comprise about 5 percent of all activities, and a staff of very impatient non tech savyy associates (hey they'd rather play Win98 tetris). Any ideas would be appretiated. I really would like to set this server and forget about it (just like after my switch from NT to RH6 and RH7.0 later). I can't remember the last time I had to reboot the server. Thanks -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
RE: [Make Crashes and Burns on myisam - "Don't know how to make mi_test_all"]
Ok, rule number 1. Check and make sure your building software is up to date before you whine to the MySQL List. I'm still compiling, but it's much further down the path then when it crashed before. While I wait for this thing to compile I even helped a few newbies :) Thanks for your help! -Original Message- From: Vivek Khera [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 23:27 To: [EMAIL PROTECTED] Subject: Re: [Make Crashes and Burns on myisam - "Don't know how to make mi_test_all"] > "a" == aarons <[EMAIL PROTECTED]> writes: a> I assume you mean GNU Make? I'm downloading it now. I'm trying to Yes. It should already be in /usr/contrib/bin on your bsd/os system. -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: please help setting password
Fresh installation? Then you don't need -p option. If not, what password are you using when it ask you to enter the password. It's not newpassword as you typed in the prompt, it's your old password - Original Message - From: "Neil Zanella" <[EMAIL PROTECTED]> To: "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, January 11, 2001 12:31 Subject: please help setting password > > Hello, > > I have installed the RPMs and I am now trying to set the MySQL root > password as the output of the RPM files tells me to do... > > [root@tulip /root]# su mysql > [mysql@tulip /root]$ /usr/bin/mysqladmin -u root -p password newpassword > Enter password: > /usr/bin/mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: YES)' > [mysql@tulip /root]$ exit > [root@tulip /root]# /usr/bin/mysqladmin -u root -p password newpassword > Enter password: > /usr/bin/mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: YES)' > [root@tulip /root]# > > I cannot get this to work. Other than that I can login as root and > create a database or login with "mysql -u root" as a regular user > with no password and use databases etc... The only problem I am > facing right now is the security risk of not being able to set > a root password. And what does (Using password: YES) mean. I tried > entering YES as my password but it did not work. Also, how come > I am instructed to enter the MySQL root password on the command line? > Isn't this a security risk because the characters are echoed? > > I have looked at the documentation and searched the archivesbut for > some reason I was not able to find a concrete clear answer on how to > do this and my PHP book seems to skip this step. Maybe I should look > at a book on MySQL but then the book might be outdated since 3.20 is > no longer supported. > > Thanks for your help, > > Neil > > > -- > - > Please check "http://www.mysql.com/documentation/manual.php" before > posting. To request this thread, e-mail [EMAIL PROTECTED] > > To unsubscribe, send a message to: > <[EMAIL PROTECTED]> > > If you have a broken mail client that cannot send a message to > the above address (Microsoft Outlook), you can use: > http://lists.mysql.com/php/unsubscribe.php -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Other uses for admin
Carlos Corzo writes: > Hello, > > Other than installing the .pkg file into the server and running it > through his interface, do I need to get the server admin to do anything > else? I am afraid that I am running out of time with him, meaning, I am > running out of time with root priviledges. I am trying here. We have > tried all sorts of crap but nothing. What would be beautiful is just a > small sample creation of a database. I have tried the sample I have but > did not work very well! Hi! Alright, there are only a few steps where you need your admin guy. Here's what you need to do: shell> mysqladmin -u root --password=? create carlos_database shell> mysql -u root --password=? mysql -> GRANT ALL ON carlos_database.* TO carlos@"%_" IDENTIFIED BY -> 'carlos_password'; -> FLUSH PRIVILEGES; -> exit; After this is done, you (Carlos) will be able to connect to your database 'carlos_database' (or whatever you want to call it) as user 'carlos' (again, or whatever you chose for a username) with password 'your_password' (again, you can guess what I'm about to say :). Once connected you can create all tables and whatnot yourself. Note that the SQL Grant statement above will allow the user 'carlos' to connect from _any_ machine. This *may* be a security issue...? But without knowing more about your exact needs, this should work. For more info about GRANT look at: http://www.mysql.com/manual.php?section=GRANT For clarity, note that 'shell>' indicates the UNIX Shell -- and '->' indicates the MySQL Shell. Hope everything works for you! Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Other uses for admin
Hello, Other than installing the .pkg file into the server and running it through his interface, do I need to get the server admin to do anything else? I am afraid that I am running out of time with him, meaning, I am running out of time with root priviledges. I am trying here. We have tried all sorts of crap but nothing. What would be beautiful is just a small sample creation of a database. I have tried the sample I have but did not work very well! See you later. -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
ANYONE
Hello, I need help. I am sitting here with our server administrator (a miracle in itself) and the SQL manual and some scripts to follow. We just finished installing the .pkg program on the RAQ3 and MySQL is up and running. The next step to take to create the database according to Andrew Chen's step-by-step write up is to create the database. We type at the /home/mysql directory mysqladmin -uroot create testdatabase and it seems to have created a database. It puts me into -> If I just type \u testdatabase to use the test database I get a priviledge error. I tried running the mysql commands that I was given to set up the access to the database but after that, I tried to look at the tables I created and run \u command, followed by \s command and \u gave me an error while \s said there are no databases running! Why is this so complicated. I would love to just create the database, define my tables, and run with it! If anyone is willing to help, I would be eternally grateful, I don't get this guy's assistance much and if I need to do anything with root priviledges, it is now or never (FEW WEEKS FROM TODAY) for me! Thanks. -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
please help setting password
Hello, I have installed the RPMs and I am now trying to set the MySQL root password as the output of the RPM files tells me to do... [root@tulip /root]# su mysql [mysql@tulip /root]$ /usr/bin/mysqladmin -u root -p password newpassword Enter password: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' [mysql@tulip /root]$ exit [root@tulip /root]# /usr/bin/mysqladmin -u root -p password newpassword Enter password: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' [root@tulip /root]# I cannot get this to work. Other than that I can login as root and create a database or login with "mysql -u root" as a regular user with no password and use databases etc... The only problem I am facing right now is the security risk of not being able to set a root password. And what does (Using password: YES) mean. I tried entering YES as my password but it did not work. Also, how come I am instructed to enter the MySQL root password on the command line? Isn't this a security risk because the characters are echoed? I have looked at the documentation and searched the archivesbut for some reason I was not able to find a concrete clear answer on how to do this and my PHP book seems to skip this step. Maybe I should look at a book on MySQL but then the book might be outdated since 3.20 is no longer supported. Thanks for your help, Neil -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Please read the manual
Eric Fitzgerald writes: > > > > Also, might it be possible to move the manual comments to another > list? :) I have decided to stop the [DOCS COMMENT] flood. *Most* comments were completely useless... even though I added in BIG RED LETTERS that adding a comment to the manual is not a good place to ask questions. :( I guess it proves the need for some alternate forum for newbies to ask questions. Apparantly joining the mailing list is too daunting for beginners. We will soon begin to moderate the comments in the manual, to remove the cruft. Maybe during this moderation, we (the people moderating) can forward *interesting* comments (and questions if they come up) to the list for all to share. Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: [Make Crashes and Burns on myisam - "Don't know how to make mi_test_all"]
> "MW" == Matt Wagner <[EMAIL PROTECTED]> writes: >> As far as I know, just try building it on an i386 running BSDI 4.1 MW> Who was the guy that just contributed the BSDI 4.2 tarball? Maybe he MW> could give Aaron here some pointers. Try using gmake for bsd systems. The makefiles are proably not totally compatible with berkeley make. -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL transaction problem (Again...)
MySQL 3.23.29 or 3.23.30, with RedHat Linux 7.0, compile from tarball source, can't rollback. Do you mean that it is platform?? There are errors build with RedHat 7.0? On Wed, 10 Jan 2001, goEbusiness.com Mail Lists wrote: > MySQL 3.23.29a-gamma > Solaris 7 > > No problems here. > > On Wed, 27 Dec 2000, Carfield Yim wrote: > > > Hi all, I have bulid MySQL from source. From the output of ./configure, I > > know that MySQL know where is BDB. > > After table bulid complete, I create the table for testing using following > > SQL: > > > > create table test (id integer) type = BDB > > set autocommit=0; > > begin; > > insert into test values (1); > > rollback; > > > > But table test don't rollback as expected, where do I get wrong?
Re: [Make Crashes and Burns on myisam - "Don't know how to make mi_test_all"]
[EMAIL PROTECTED] writes: > > > > >How-To-Repeat: >As far as I know, just try building it on an i386 running BSDI 4.1 Sinisa, Who was the guy that just contributed the BSDI 4.2 tarball? Maybe he could give Aaron here some pointers. Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
[Make Crashes and Burns on myisam - "Don't know how to make mi_test_all"]
>Description: After configure this happens: % make make all-recursive Making all in include Making all in Docs Making all in readline Making all in libmysql Making all in client Making all in strings Making all in dbug Making all in mysys Making all in extra Making all in regex Making all in isam Making all in merge Making all in myisam make: don't know how to make mi_test_all. Stop *** Error code 1 Stop. *** Error code 1 Stop. >How-To-Repeat: As far as I know, just try building it on an i386 running BSDI 4.1 >Fix: >Submitter-Id: Aaron Schlesinger >Originator:System Administrator >Organization: >MySQL support: unfortunatally, none at this time. >Synopsis: Can't build any version of 3.23.x >Severity: Starting to become a critical issue. >Priority: I hope high priority >Category: mysql >Class: >Release: mysql-3.23.30-gamma (Source distribution) >Environment: System: BSD/OS atc.lanline.com 4.1 BSDI BSD/OS 4.1 Kernel #7: Wed Feb 16 21:50:07 EST 2000 [EMAIL PROTECTED]:/usr/src/sys/compile/LOCAL i386 Some paths: /usr/bin/perl /usr/bin/make /usr/contrib/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 bin bin 1619382 Nov 22 1999 /usr/lib/libc.a -r--r--r-- 1 bin bin 8561 Nov 22 1999 /usr/lib/libc.except Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --without-berkeley-db Perl: This is perl, version 5.005_03 built for i386-bsdos -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
please help me with charset
Good day all! Please help me with charset adding. I have some strange trouble. I use FreeBSD 4.2 STABLE and MySQL 3.23.28-gamma (compiled from FreeBSD ports) and PHP 4.04. As I understood Latin1 is a default charset. So, I wanted to add cp1251 or koi8_ru. Ok, I add --default-character-set=cp1251 to my mysql start-up script. The problem is: If I connect from console to mysql and type \s (to get status information) it shows: Language: cp1251 Everything seems OK, but if I try to connect via phpMyAdmin or Horde (webmail implementation) it returns - <> Warning: MySQL Connection Failed: Can't initialize character set 14 (path: default) in /usr/local/www/htdocs/adm/lib.inc.php on line 255 Error <> Warning: Can't initialize character set 14 (path: default) in /usr/local/lib/phplib/db_mysql.inc on line 73 I don't know where is my mistake? I do have sql/share/charsets folder with Index and cp1251.conf. I checked Index - records are OK. Should I add something to /etc/my.cnf file? Looking forward to hear from you. Regards, Roman -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: I am really stumped.
[EMAIL PROTECTED] wrote: > > Hey there, I've written about this a few times now and haven't received very many >ideas. > > I'm running a pentium based server with 256 megs of ram using BSDI O/S 4.1 > > I currently have the latest build of Perl 5 on my system as well. > > When I do a make on ANY version of MySQL 3.23.x, it always stops at making myisam. >It fails saying it doesn't know how to make mi_test_all. If someone is willing to >give me a hand with this, I'll send more detailed information. I would really >appreciate any assistance as this has been dogging me for a long while now. > > Aaron can you do after unpacking tarball: aclocal autoconf automake ./configure make This can help sometime. If not, provide mysqlbug output here. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia <___/ -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Some problems
Bob Hall writes: > >This is the first time I've ever been directly in charge of adminstering a > >mysql server. I have a few questions. Since I can't get mysql 3.23.X to > >install, I'm stuck with 3.22.30 and I was wondering what I could do to > >facilitate backups, and to be able to protect my data integrity. I'm at the > >moment taking a mysqldump every 5 minutes via a CRON job, but I'm sure there > >are better facilities available to me. > > > >If anyone has some suggestions I'd appreciate it. (I'd also appreciate some > >assistance with my make problem in 3.23.x) > > Sir, go down to the local bookstore and buy a copy of "MySQL" by Paul > DuBois, published by New Riders. If the local bookstore doesn't have > it, order it from Amazon and have it shipped FedEx overnight. I was > in your situation about 8 months ago and Paul's book saved my sorry > attitude. Or better than going to Amazon, go to the MySQL Books page: http://www.mysql.com/documentation/books.html And order your copy from Barnes and Noble through the links provided. By doing this, B&N will give the MySQL Development team a small kick-back. This helps fund development! Also, Amazon has got that whole sticky "trying to patent web clicks" issue that the Free Software Foundation (and MySQL AB) is boycotting. :) Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
I am really stumped.
Hey there, I've written about this a few times now and haven't received very many ideas. I'm running a pentium based server with 256 megs of ram using BSDI O/S 4.1 I currently have the latest build of Perl 5 on my system as well. When I do a make on ANY version of MySQL 3.23.x, it always stops at making myisam. It fails saying it doesn't know how to make mi_test_all. If someone is willing to give me a hand with this, I'll send more detailed information. I would really appreciate any assistance as this has been dogging me for a long while now. Aaron -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
RE: myisampack can DELETE data files
[root@switch logging]# ls -lh ll* -rw-r-1 root root 44M Jan 10 17:35 ll.MYD -rw-rw1 root root 126M Jan 10 17:45 ll.MYI -rw-r-1 root root 9.7k Jan 10 17:25 ll.frm [root@switch logging]# myisampack ll Compressing ll.MYD: (0 records) - Calculating statistics - Compressing file Empty file saved in compressed format Remember to run myisamchk -rq on compressed tables [root@switch logging]# ls -lh ll* -rw-r-1 root root 63 Jan 10 17:35 ll.MYD -rw-rw1 root root 1.0k Jan 10 17:46 ll.MYI -rw-r-1 root root 9.7k Jan 10 17:25 ll.frm [root@switch logging]# Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: help please!!
At 15:48 10/01/2001 +, Alain Morlans wrote: Hi! >Hi! > >I would like to coonect top mysql using Borland C++ builder on a windows >plataform. > >Do you know what is the best way to do it? There are several way to do it. The best, you decide according with your preference: - You can use the ODBC driver using MyODBC. - You can use the stuff called WinZeos (the URL you find in our contribution page) - You can use C API using static libs compiled with a Borland compiler, you find it for the client 3.23.27 in our Win32 page. - There is a commercial ActiveX called MySQLX. Regards, Miguel >_ >This message has been checked for all known viruses by the >MessageLabs Virus Control Centre. For further information visit >http://www.messagelabs.com/stats.asp __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano <[EMAIL PROTECTED]> /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil <___/ Development Team -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
RE: myisampack can DELETE data files
> :( > > copy MYD and frm file to new table name. Copy MYI from wrong > table to the new table name (oops). myisampack new_table. > new_table.MYD is now 64 bytes. I should have made a note: the bad MYI file copied over was for a compressed table, so myisampack said it was already compressed and set the file length (of the data file) to 63 (not 64) bytes. Data of table erased. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
question: How to fix another MySQL RPM error
Hello, I don't know whether or not the developers of MySQL are aware of this but I got the following error three time when I installed the MySQL-3.23.30-1.i386.rpm and MySQL-client-3.23.30-1.i386.rpm packages on Red Hat Linux 6.2: /usr/bin/mysql_install_db: test: integer expression expected before -eq I am running the Bash shell version 1.14.7 and RPM version 3.0.5 as shown by the fllowing output: [nzanella@tulip nzanella]$ rpm -q rpm bash rpm-3.0.5-9.6x bash-1.14.7-22 [nzanella@tulip nzanella]$ This error message is somewhat strange as I looked at the script /usr/bin/mysql_install_db and did not find anything disagreeing with the Bash manual in places where test and -eq were found. It looks as though "$IN_RPM" or $force is not evaluating to an integer. Why then is RPM complaining? Thanks, Neil -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Something went wrong
Have you tried looking at the data in your tables? I would check that, and then, if it checks out, try to give us some more information. - Original Message - From: "Mike Roberts" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 10, 2001 5:28 PM Subject: Something went wrong > I had this query site working and showing the DB info depending on the > Category. > For some reason it just stopped working. Saying that I can't connect to the > server. > I fixed that script a little bit but now its showing doubles for some of > the records. > > I don't know what is wrong! Nothing on the script was changed! > > > > -- > - > Please check "http://www.mysql.com/documentation/manual.php" before > posting. To request this thread, e-mail [EMAIL PROTECTED] > > To unsubscribe, send a message to: > <[EMAIL PROTECTED]> > > If you have a broken mail client that cannot send a message to > the above address (Microsoft Outlook), you can use: > http://lists.mysql.com/php/unsubscribe.php > > > -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Something went wrong
You'll have to go through the script step by step printing out debug in order to determine what's going on - it's a normal process of elimination when troubleshooting jason > I had this query site working and showing the DB info depending on the > Category. > For some reason it just stopped working. Saying that I can't connect to the > server. > I fixed that script a little bit but now its showing doubles for some of > the records. > > I don't know what is wrong! Nothing on the script was changed! -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
RE: to output a file in table format
Hi Scott -H outputs the file nicely as a HTML bordered table, but I was more looking for a way to output the file as a "bordered" ASCII table (like a screen print below) any clues? cheers Mark Dale -Previous Message- >Have you tried the -H switch to output as HTML? > >see mysql -help > > - Scott > > > -Original Message- > > > Could anybody tell me if there a variation of this string to output a >> file in table format that looks like the one below. >> >>mysql -N -e "select query here" db_name > output_file >> >> >> +-+---+---+-+ >> | datetime| jobno | hours | description | >> +-+---+---+-+ >> | 2001-01-08 08:13:02 | FX395 | 1.00 | Fotel | >> | 2001-01-08 08:19:54 | HSE | 1.00 | Administration | >> | 2001-01-08 09:58:05 | FX405 | 0.50 | New Brand | >> | 2001-01-08 10:06:46 | WC362 | 1.00 | Check proofs| >> | 2001-01-08 11:52:40 | MB021 | 1.00 | Medi Experience | >> | 2001-01-08 11:53:49 | FX405 | 3.00 | New Brand book | >> | 2001-01-08 11:55:22 | HSE | 0.50 | Administration | >> | 2001-01-08 12:36:51 | WC373 | 0.50 | Personal Loan Letter| >> | 2001-01-08 16:42:25 | WR450 | 0.25 | DL Flyer - check art| >> | 2001-01-08 17:01:35 | TF009 | 0.25 | Australia | >> | 2001-01-10 10:46:37 | MB001 | 8.00 | General Strategy. | >> | 2001-01-10 10:48:22 | HSE | 0.75 | Meeting with Tony. | >> | 2001-01-10 10:49:27 | MB021 | 0.50 | Medi Experience | >> | 2001-01-10 10:50:25 | FX405 | 0.50 | Brand Book | >> +-+---+---+-+ >> >> >> For anyone who missed it the other day, Paul DuBois posted this to >> output a comma-delimited file. Works great! >> >> mysql -N -e "your query here" db_name | tr '\t' , > output_file >> >> >> cheers >> >> Mark Dale > > -- -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
myisampack can DELETE data files
:( copy MYD and frm file to new table name. Copy MYI from wrong table to the new table name (oops). myisampack new_table. new_table.MYD is now 64 bytes. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Something went wrong
I had this query site working and showing the DB info depending on the Category. For some reason it just stopped working. Saying that I can't connect to the server. I fixed that script a little bit but now its showing doubles for some of the records. I don't know what is wrong! Nothing on the script was changed! -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL manual: another suggestion was: RPMS are faulty
On Wed, 10 Jan 2001, Michael A. Peters wrote: > Try rpm --nodeps -Uh MySQL-3.23.30-1.i386.rpm > > I doubt that MySQL is dependant upon that particular file existing, if > it wants perl (for benchmark package??) your local perl should work > fine. If MySQL doesn't work- you can remove it, rpm -e MySQL and go to > an older version until they resolve the problem. Thanks Michael, I have another comment regarding the MySQL documentation which shows that one must be careful and always do an rpm -i or similar before doing an rpm --nodeps -i or rpm --nodeps -U ... The section entitled "4.6.1 Linux RPM Notes" of the MySQL manual says the following: The RPM files you may want to use are: MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm MySQL-bench-VERSION.i386.rpm MySQL-devel-VERSION.i386.rpm MySQL-VERSION.src.rpm This list is incomplete because MySQL-bench requires MySQL-DBI-perl-bin. Either MySQL-DBI-perl-bin should be added to the list or MySQL-bench should be removed from the list. [root@tulip /tmp]# rpm -i MySQL-bench-3.23.30-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.30-1 /usr/bin/perl5 is needed by MySQL-bench-3.23.30-1 [root@tulip /tmp]# Regards, Neil -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
RE: Lazy
Perhaps, along with the 'Please check the manual' message at the end of all messages, there should be a reference to a reliable archive, allowing list users who are referred to the archive an easy way of finding it! Quentin > -Original Message- > From: Eric Fitzgerald [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, January 11, 2001 12:29 PM > To: Carlos Corzo; [EMAIL PROTECTED] > Subject: Re: Lazy > > Some people have looked at the manual's, yes, and it's pretty simple to > determine when they have. If the question they ask can be copied/pasted > into the mysql documention search and get the answer, then the person has > not checked the documentation. Sometimes people miss things in the > documentation, this is ok also. However, most of the time, people just > don't LOOK at the documentation. I see the same questions asked over and > over again on this list, and most of the time the answers given are quotes > from the documentation, and the people accept those answers. > > The MySQL manual is written very well IMHO (and there's no bias here, I am > in no way connected to the MySQL dev team except as an end user). Perhaps > if you find a section hard to read, maybe bring that up? I'm sure the > maintainers of the manual hang out on here (I believe Sasha is one), and I > also don't think I'm far off in thinking they would love to have > suggestions > on how to improve the manual. Then again you could just purchase a > support > license or even get a MySQL book (several good ones out there), try to get > one that concentrates on MySQL and the programming language of your > choice. > > The intelligent comment isn't acurate though. I think the problem here is > more the people who refuse to look for themselves to find the answers, and > instead just bring the question directly to the list (some subscribing > just > long enough to post). This list's subscribers probably varies greatly in > users experience/knowledge. I myself am only 20 years old and don't have > the experience of others. But when I bring a question to the list, I try > to > make sure I've exhausted every avenue I have myself for finding the > answer. > Simply because the others on this list have things to do on their own > time, > and don't need to be troubled by a question I have. > > To sum up, if you have a hard time figuring things out, and need to ask a > question, that's fine with me. However, if you simply don't want to take > the time to look and want to fire off a quick E-Mail to the list asking a > question that is very clearly answered in the manual, then I think your > being inconsiderate of others. > > Eric Fitzgerald > Server Administrator > AMN Television Marketing > - Original Message - > From: "Carlos Corzo" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, January 10, 2001 2:58 PM > Subject: Lazy > > > > Some people have tried the manuals verbatim but are really confused > > because they are not at your intellectual level. If this list is for > > the "intelligent only", change the title please. Not everyone can > > decipher a manual. I may post questions but there are reasons for > > them. My time is just as valuable as yours. > > > > take care. > > > > > > -- > > - > > Please check "http://www.mysql.com/documentation/manual.php" before > > posting. To request this thread, e-mail > [EMAIL PROTECTED] > > > > To unsubscribe, send a message to: > > <[EMAIL PROTECTED]> > > > > If you have a broken mail client that cannot send a message to > > the above address (Microsoft Outlook), you can use: > > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > -- > - > Please check "http://www.mysql.com/documentation/manual.php" before > posting. To request this thread, e-mail [EMAIL PROTECTED] > > To unsubscribe, send a message to: > <[EMAIL PROTECTED]> > > If you have a broken mail client that cannot send a message to > the above address (Microsoft Outlook), you can use: > http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Lazy
> I didn't wanted to make you upset. We still try to answer questions and > value your time. Just some questions are repeating up to 3 times per That's great coming from a great team. Who knows ? There might be people who are tasked to frustrate you and this group. For the benefit of the open-source community and the world of tommorrow, never give-up. Cheers. Raju -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Please read the manual
OK enough said. Lets get back to using the best database out there. -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Lazy
Aaron Schlesinger wrote: > I agree with Carlos's response below. Tõnu I appologize for singling you > out, but if you push away those simple questions, you'll just force those > who are just getting started to find more patient people and software to > use. Critics is good :). I try to be more patient and always repeated to myself "answer mails, do it well, do not flame". It was just "please" to our userbase to keep us more free on improving MySQL. We can work more if we spend less time in reading mailing lists (i.e. if there are less writing or we just start skipping them). Also it was just mention, that we do direct developer support which is really unique. We want to provide this also in future but this can be made only if we can sell enough support contracts and have free time. Just reality, nothing else. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia <___/ -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Lazy
Is there any way that the list in question can be broken up into two lists? For example, ASP has two (actually, alot more) lists called ASPFreeForAll, and ASPAdvanced which cater to the various knowledge levels of each list's participants. The ASPAdvanced list is moderated by the person who created the list AND several individuals who have been in the business for quite awhile. If you flame anyone on the list, spam, or ask too many *easy* questions without researching, or (put URGENT in the subject because if it's that URGENT, you should find a consultant), then you'll be temporarily banned from the list. This is an outstanding resource, there are archives, and I'd hate to see this list get filled up with newbie material that appears frequently. Cheers Christopher Oson -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Lazy
Agreed! Eric Fitzgerald wrote: > Some people have looked at the manual's, yes, and it's pretty simple to > determine when they have. If the question they ask can be copied/pasted > into the mysql documention search and get the answer, then the person has > not checked the documentation. Sometimes people miss things in the > documentation, this is ok also. However, most of the time, people just > don't LOOK at the documentation. I see the same questions asked over and > over again on this list, and most of the time the answers given are quotes > from the documentation, and the people accept those answers. > > The MySQL manual is written very well IMHO (and there's no bias here, I am > in no way connected to the MySQL dev team except as an end user). Perhaps > if you find a section hard to read, maybe bring that up? I'm sure the > maintainers of the manual hang out on here (I believe Sasha is one), and I > also don't think I'm far off in thinking they would love to have suggestions > on how to improve the manual. Then again you could just purchase a support > license or even get a MySQL book (several good ones out there), try to get > one that concentrates on MySQL and the programming language of your choice. > > The intelligent comment isn't acurate though. I think the problem here is > more the people who refuse to look for themselves to find the answers, and > instead just bring the question directly to the list (some subscribing just > long enough to post). This list's subscribers probably varies greatly in > users experience/knowledge. I myself am only 20 years old and don't have > the experience of others. But when I bring a question to the list, I try to > make sure I've exhausted every avenue I have myself for finding the answer. > Simply because the others on this list have things to do on their own time, > and don't need to be troubled by a question I have. > > To sum up, if you have a hard time figuring things out, and need to ask a > question, that's fine with me. However, if you simply don't want to take > the time to look and want to fire off a quick E-Mail to the list asking a > question that is very clearly answered in the manual, then I think your > being inconsiderate of others. > > Eric Fitzgerald > Server Administrator > AMN Television Marketing > - Original Message - > From: "Carlos Corzo" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, January 10, 2001 2:58 PM > Subject: Lazy > > > Some people have tried the manuals verbatim but are really confused > > because they are not at your intellectual level. If this list is for > > the "intelligent only", change the title please. Not everyone can > > decipher a manual. I may post questions but there are reasons for > > them. My time is just as valuable as yours. > > > > take care. > > > > > > -- > > - > > Please check "http://www.mysql.com/documentation/manual.php" before > > posting. To request this thread, e-mail [EMAIL PROTECTED] > > > > To unsubscribe, send a message to: > > <[EMAIL PROTECTED]> > > > > If you have a broken mail client that cannot send a message to > > the above address (Microsoft Outlook), you can use: > > http://lists.mysql.com/php/unsubscribe.php > > > > > > -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
RE: Lazy
Ya know, I've asked a few questions on this list already, and I've found it really helpful. Some people just find it in their human nature to ask questions first. What some people refer to as "dumb" questions could be something really serious to a person who is just getting started. How many people can honestly say they fully comprehend something after reading the manual the first time and lacking experience. I agree with Carlos's response below. Tõnu I appologize for singling you out, but if you push away those simple questions, you'll just force those who are just getting started to find more patient people and software to use. Aaron -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tõnu Samuel Sent: Wednesday, January 10, 2001 6:44 PM To: Carlos Corzo Cc: [EMAIL PROTECTED] Subject: Re: Lazy Carlos Corzo wrote: > Some people have tried the manuals verbatim but are really confused > because they are not at your intellectual level. If this list is for > the "intelligent only", change the title please. Not everyone can > decipher a manual. I may post questions but there are reasons for > them. My time is just as valuable as yours. I didn't wanted to make you upset. We still try to answer questions and value your time. Just some questions are repeating up to 3 times per day, other people do not provide any data with their questions and finally all MySQL development goes slower because this. We are providing free support on developer level which is very unique. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia <___/ -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Lazy
At 05:58 PM 1/10/01, Carlos Corzo wrote: >Some people have tried the manuals verbatim but are really confused >because they are not at your intellectual level. If this list is for >the "intelligent only", change the title please. Not everyone can >decipher a manual. I may post questions but there are reasons for >them. My time is just as valuable as yours. However, everyone can search the archives. The point here, is that an incredibly high percentage of what goes across this list, has come across before - and usually not too long ago. Searching the archives gets you your answer faster and reduces the frustration of all the people on this list who really do like helping people, but wish they would try helping themselves first. Jamie -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Lazy
Carlos Corzo wrote: > Some people have tried the manuals verbatim but are really confused > because they are not at your intellectual level. If this list is for > the "intelligent only", change the title please. Not everyone can > decipher a manual. I may post questions but there are reasons for > them. My time is just as valuable as yours. I didn't wanted to make you upset. We still try to answer questions and value your time. Just some questions are repeating up to 3 times per day, other people do not provide any data with their questions and finally all MySQL development goes slower because this. We are providing free support on developer level which is very unique. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia <___/ -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Lazy
Some people have looked at the manual's, yes, and it's pretty simple to determine when they have. If the question they ask can be copied/pasted into the mysql documention search and get the answer, then the person has not checked the documentation. Sometimes people miss things in the documentation, this is ok also. However, most of the time, people just don't LOOK at the documentation. I see the same questions asked over and over again on this list, and most of the time the answers given are quotes from the documentation, and the people accept those answers. The MySQL manual is written very well IMHO (and there's no bias here, I am in no way connected to the MySQL dev team except as an end user). Perhaps if you find a section hard to read, maybe bring that up? I'm sure the maintainers of the manual hang out on here (I believe Sasha is one), and I also don't think I'm far off in thinking they would love to have suggestions on how to improve the manual. Then again you could just purchase a support license or even get a MySQL book (several good ones out there), try to get one that concentrates on MySQL and the programming language of your choice. The intelligent comment isn't acurate though. I think the problem here is more the people who refuse to look for themselves to find the answers, and instead just bring the question directly to the list (some subscribing just long enough to post). This list's subscribers probably varies greatly in users experience/knowledge. I myself am only 20 years old and don't have the experience of others. But when I bring a question to the list, I try to make sure I've exhausted every avenue I have myself for finding the answer. Simply because the others on this list have things to do on their own time, and don't need to be troubled by a question I have. To sum up, if you have a hard time figuring things out, and need to ask a question, that's fine with me. However, if you simply don't want to take the time to look and want to fire off a quick E-Mail to the list asking a question that is very clearly answered in the manual, then I think your being inconsiderate of others. Eric Fitzgerald Server Administrator AMN Television Marketing - Original Message - From: "Carlos Corzo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 10, 2001 2:58 PM Subject: Lazy > Some people have tried the manuals verbatim but are really confused > because they are not at your intellectual level. If this list is for > the "intelligent only", change the title please. Not everyone can > decipher a manual. I may post questions but there are reasons for > them. My time is just as valuable as yours. > > take care. > > > -- > - > Please check "http://www.mysql.com/documentation/manual.php" before > posting. To request this thread, e-mail [EMAIL PROTECTED] > > To unsubscribe, send a message to: > <[EMAIL PROTECTED]> > > If you have a broken mail client that cannot send a message to > the above address (Microsoft Outlook), you can use: > http://lists.mysql.com/php/unsubscribe.php > > > -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
RE: documentation error
Wow I didn't notice this. I believe this will solve my little permission problem I've been having. Thanks Neil. -Matt ::-Original Message- ::From: Neil Zanella [mailto:[EMAIL PROTECTED]] ::Sent: Wednesday, January 10, 2001 3:05 PM ::To: MySQL Mailing List ::Subject: documentation error :: :: :: ::Hello, :: ::There is a documentation error the MySQL manual: :: ::-- ::4.6 Installing a MySQL Binary Distribution :: ::9.Change ownership of the installation directory to the user that you will ::run mysqld as: :: :: shell> chown -R mysql /usr/local/mysql :: shell> chgrp -R mysql /usr/local/mysql :: ::-- :: ::This will not work since /usr/local/mysql is a symbolic link and ::at least the GNU versions of chown -R and chgrp -R do not work ::with symbolic links. The manual should say: :: :: shell> chown -R mysql /usr/local/mysql-VERSION-OS :: shell> chgrp -R mysql /usr/local/mysql-VERSION-OS :: ::-- :: ::Thanks, :: ::Neil :: :: ::-- ::- ::Please check "http://www.mysql.com/documentation/manual.php" before ::posting. To request this thread, e-mail [EMAIL PROTECTED] :: ::To unsubscribe, send a message to: ::<[EMAIL PROTECTED]> :: ::If you have a broken mail client that cannot send a message to ::the above address (Microsoft Outlook), you can use: ::http://lists.mysql.com/php/unsubscribe.php :: -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump question!
try adding a -u (--user=) and -p, this will tell the mysql server what user you are connecting as and it will prompt you for a password. It could be many other things though, depending on how you have set up your access tables. It's usually a bad idea to not restrict connections by either host or password (preferrably both!) On Wed, 10 Jan 2001, Web Master wrote: > Hello, > > can any one help me with my following mysqldump question. > > I want to dump a complete database from one server to another server. I am > trying the following comment > > mysqldump --opt mydatabase | mysql --host=remotehost -C mydatabase > > when I tried, the remote host is failing with invalid log in. > Can any one help me, how I can enter the remote uid and pwd in the same dump? > > Thanks in advance > > > -- > - > Please check "http://www.mysql.com/documentation/manual.php" before > posting. To request this thread, e-mail [EMAIL PROTECTED] > > To unsubscribe, send a message to: > <[EMAIL PROTECTED]> > > If you have a broken mail client that cannot send a message to > the above address (Microsoft Outlook), you can use: > http://lists.mysql.com/php/unsubscribe.php > -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
RE: FULLTEXT performance causing an avalanche of problems
> Possible fixes: o Maybe (I know we've talked about this before), another solution is to have the FT index in another file which could have its own cache size settings. o Lastly, we could switch to using word tables that would use already optimized caching of table and index data, but would require a joi or multiple selects (only really advantageous if we want the word tables on a different machine [which has another benefit of reindexing not causing the table to be locked]). Then there wouldn't be any MySQL isssue to deal with, but kinda defeats the point of having FT inside MySQL itself. o OR, we could put a table with FT index on another machine as a copy where we only do fulltext searches. Ideally then, we'd like to not have the datafile, but I guess it would be handy for a rebuild if needed. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Setting initial root password
On Wed, 10 Jan 2001, Don wrote: > How do I set the initial root password once installation is complete? > Sorry for the repetition. mysqladmin -uroot password 'newpassword' (mysqld has to be running for this to work) -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
RPMS are faulty
Hello, I am running Red Hat Linux 6.2 which is supposedly the platform on which the latest MySQL RPMs were built. However there are problems when I try to install the package even though I follow the instructions in the manual: [root@tulip /tmp]# rpm -i MySQL-3.23.30-1.i386.rpm error: failed dependencies: /usr/bin/perl5 is needed by MySQL-3.23.30-1 [root@tulip /tmp]# rpm -q perl perl-5.00503-10 [root@tulip /tmp]# ls /usr/bin/perl /usr/bin/perl [root@tulip /tmp]# ls /usr/bin/perl5 ls: /usr/bin/perl5: No such file or directory [root@tulip /tmp]# As you can see perl 5 is installed and Red Hat's installation script did not create a symbolic links to /usr/bin/perl5 to /usr/bin/perl so why should the MySQL RPMs complain about it? Even if I create the link manually the Red Hat RPM database is not updated when I do so. This makes the MySQL RPMs defective if not unusable. Thanks, Neil -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
[RFC] Mysql Failsafe Cluster Project (MyFCP)
Hi , Here the situation : Many of us , are using MYSQL in Web production , and in this case we have many loadbalancing systems (Hardware like Alteon or foundry or software like LVS , and hybrid like BigIP) so we can say that if you want an failsafe and scalable WEB cluster it not a problem any more . But can we say the same about our databases ? Here things are more complicated because even if you use an replication sheme , you cannot say that it is fail safe , because : 1) If the master die : Your updates are in /dev/null 2) If one of slaves die : You have to update your progs to use an other slave 3) If you use an Mod_perl enabled cluster you have to update your scripts and restart your dyns to make the whole thing work (this is only in a very wired setup) So we can safe that it is a real pain in the ass ... The purpose of MyFCP is : 1)Write a set of perl scripts witch allows an automatic master election in case of the master death or slave death . 2)Write an SQL wrapper to allow an mod_perl (or modcgi) cluster acces the database , this wrapper will make the difference between SELECT and UPDATE requests and for the SELECT requests it will send them to the right ACTIVE SLAVE. so ti whill have some hash like this : updates--->master# this is for the updates dynperl1--->sqlslave1 dynperl2--->sqlslave2 dynperl3--->sqlslave3 so if the deamon detect than sqlslave1 is dead , he update this list so it becomes : dynperl1--->sqlslave2 dynperl2--->sqlslave2 dynperl3--->sqlslave3 3)Add an backup system Any sugestions are very welcome . Very best CB
documentation error
Hello, There is a documentation error the MySQL manual: -- 4.6 Installing a MySQL Binary Distribution 9.Change ownership of the installation directory to the user that you will run mysqld as: shell> chown -R mysql /usr/local/mysql shell> chgrp -R mysql /usr/local/mysql -- This will not work since /usr/local/mysql is a symbolic link and at least the GNU versions of chown -R and chgrp -R do not work with symbolic links. The manual should say: shell> chown -R mysql /usr/local/mysql-VERSION-OS shell> chgrp -R mysql /usr/local/mysql-VERSION-OS -- Thanks, Neil -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Please read the manual
In the last episode (Jan 10), B. van Ouwerkerk said: > > >Well, enough ranting, now how about some ideas to help fix the problem :) > > > >Maybe if this list was moved from an open list to a moderated one we > >would see a drop? Also, might it be possible to move the manual > >comments to another list? :) > > This has been discussed before. > > It seems I can't find an archive for this list. Perhaps this could help to > reduce the amount of messages. http://www.mysql.com/documentation/searchlists.html -- Dan Nelson [EMAIL PROTECTED] -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Lazy
Some people have tried the manuals verbatim but are really confused because they are not at your intellectual level. If this list is for the "intelligent only", change the title please. Not everyone can decipher a manual. I may post questions but there are reasons for them. My time is just as valuable as yours. take care. -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Please read the manual
>Well, enough ranting, now how about some ideas to help fix the problem :) > >Maybe if this list was moved from an open list to a moderated one we would >see a drop? Also, might it be possible to move the manual comments to >another list? :) This has been discussed before. It seems I can't find an archive for this list. Perhaps this could help to reduce the amount of messages. Some links to really good sites with lots of information (like devshed.com) might also help. On the other hand, some people are just to lazy.. rather ask instead of finding out theirselves. Bye, B. -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Loading Data :-)
LOAD DATA LOCAL INFILE '/path/myfile.txt' INTO TABLE mytable FIELDS TERMINATED BY '|'; If the text values are enclosed by double quotation marks, you need to remove the semicolon in line 3 and add: ENCLOSED BY "\""; If your myfile.txt was created in Windows, you *may* need to remove the semicolon in line 3 and add: LINES TERMINATED BY "\r\n"; Good luck, Andrew Gould --- Marcus Ouimet <[EMAIL PROTECTED]> wrote: > I am still very new to MySQL, I am trying to convert > a flat line database to > MySQL (Database uses | as a deliminator). I have > found what I need in the > documentation to do this yet I am a bit stuck. Could > someone be so kind to > give me an example of (mysql> LOAD DATA LOCAL > INFILE "myfile.txt" INTO > TABLE mytable;) with | instead of a tab > deliminator. My database looks > similiar to: > > field1|field2|field3 > field1|field2|field3 > field1|field2|field3 > field1|field2|field3 > > etc.. __ Do You Yahoo!? Yahoo! Photos - Share your holiday photos online! http://photos.yahoo.com/ -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Loading Data :-)
http://www.mysql.com/documentation/mysql/commented/manual.php?section=LOAD_D ATA LOAD DATA LOCAL INFILE "myfile.txt" INTO TABLE mytable FIELDS TERMINATED BY '|' - Original Message - From: "Marcus Ouimet" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, January 10, 2001 1:47 PM Subject: Loading Data :-) > I am still very new to MySQL, I am trying to convert a flat line database to > MySQL (Database uses | as a deliminator). I have found what I need in the > documentation to do this yet I am a bit stuck. Could someone be so kind to > give me an example of (mysql> LOAD DATA LOCAL INFILE "myfile.txt" INTO > TABLE mytable;) with | instead of a tab deliminator. My database looks > similiar to: > > field1|field2|field3 > field1|field2|field3 > field1|field2|field3 > field1|field2|field3 > > etc.. > > > > -- > - > Please check "http://www.mysql.com/documentation/manual.php" before > posting. To request this thread, e-mail [EMAIL PROTECTED] > > To unsubscribe, send a message to: > <[EMAIL PROTECTED]> > > If you have a broken mail client that cannot send a message to > the above address (Microsoft Outlook), you can use: > http://lists.mysql.com/php/unsubscribe.php > > > -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Please read the manual
Well said. I have brought this up before in a mini rant of my own. I have no gotten to the point that if a question is in the manual, I'm not going to post a reply, simply because I can not take time from my day to give out information that is quoted almost verbatim from (and linked to) the manual. I also am getting tired of the off topic questions, issues about php, perl, java..all of those belong on their respected lists. Just because your using php to post data to mysql and your getting a php error, doesn't mean you should go ask the mysql list. Well, enough ranting, now how about some ideas to help fix the problem :) Maybe if this list was moved from an open list to a moderated one we would see a drop? Also, might it be possible to move the manual comments to another list? :) Eric Fitzgerald Server Administrator AMN Television Marketing - Original Message - From: "Tõnu Samuel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 10, 2001 1:57 PM Subject: Please read the manual > Maybe it is my depression and I see everything in black but please > read manual before posting questions in this list. Manual covers at > least 90% questions asked here. If manual does not cover them, we will > put new chapters in it. This is all because what we do in this list can > be called FREE support. As much I know, most of our developers are > spending 2..4 hours per day just reading all related groups and > answering questions "Error 2002: Can't connect via socket > /tmp/mysql.sock". > > Also I wanted to ask everyone who gets revenue from MySQL still buy > support contract. While MySQL is free to users there are people behind > it who eat, buy books, pay for internet connection get hardware and buy > icecream to kids. This is not about home users. There are companies on > NASDAQ who use heavily different open source software for their success > and have never paid a penny. For that money you get guaranteed answers. > > MySQL is free, support in this list is partially free but do not abuse > it, then it can stay free in future. > > -- > MySQL Development Team >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ / Tonu Samuel <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ > /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ><___/ > > -- > - > Please check "http://www.mysql.com/documentation/manual.php" before > posting. To request this thread, e-mail [EMAIL PROTECTED] > > To unsubscribe, send a message to: > <[EMAIL PROTECTED]> > > If you have a broken mail client that cannot send a message to > the above address (Microsoft Outlook), you can use: > http://lists.mysql.com/php/unsubscribe.php > > > -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
[DOCS COMMENT] Section 'CREATE_TABLE'
The following comment was submitted to the MySQL Manual. - From: Ilia Lobsanov <[EMAIL PROTECTED]> Regarding: http://www.mysql.com/manual.php?section=CREATE_TABLE Would be nice if the DEFAULT parameter accepted a logical statement. eg. ...column varchar(48) not null default substring_index(another_column, '.', 1); -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Please read the manual
Maybe it is my depression and I see everything in black but please read manual before posting questions in this list. Manual covers at least 90% questions asked here. If manual does not cover them, we will put new chapters in it. This is all because what we do in this list can be called FREE support. As much I know, most of our developers are spending 2..4 hours per day just reading all related groups and answering questions "Error 2002: Can't connect via socket /tmp/mysql.sock". Also I wanted to ask everyone who gets revenue from MySQL still buy support contract. While MySQL is free to users there are people behind it who eat, buy books, pay for internet connection get hardware and buy icecream to kids. This is not about home users. There are companies on NASDAQ who use heavily different open source software for their success and have never paid a penny. For that money you get guaranteed answers. MySQL is free, support in this list is partially free but do not abuse it, then it can stay free in future. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia <___/ -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
mysqldump question!
Hello, can any one help me with my following mysqldump question. I want to dump a complete database from one server to another server. I am trying the following comment mysqldump --opt mydatabase | mysql --host=remotehost -C mydatabase when I tried, the remote host is failing with invalid log in. Can any one help me, how I can enter the remote uid and pwd in the same dump? Thanks in advance -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Client Ron out of Memory
Chris Matthews wrote: > > Okay, so no jokes about telling my client, Ron, to go buy more memory... =) > > error is: "MySQL Client Run out of Memory"... > > > We get this error about every 2 weeks or so... Restarting MySQL, purging > > hosts don't fix it, we actually have to restart Apache to fix it... > > > > Does anyone know a permanent solution for this, or at least what the > actual > > problem is? Check the manual. Windows 95 is known to leak memory 200 bytes on every connection. And use mysqlbug when submitting reports. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia <___/ -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
