Re: root password
On Thu, 19 Apr 2001, feldekis wrote: > ./bin/mysql -p -user=root > Enter password: password > ERROR 1045: Access denied for user: 'ser=root@localhost' (Using password: YES) ^ mysql -p -u root, not mysql -p -user=root pz -- Bartosz Sienkiewicz - 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: there is no mysql/var directory
take a look at /var/mysql :) - Original Message - From: "Philip Mak" <[EMAIL PROTECTED]> To: "feldekis" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 11:59 PM Subject: Re: there is no mysql/var directory > On Wed, 18 Apr 2001, feldekis wrote: > > > Hi everybody!! > > I've got a pb during the installation of the binary of mysql-3.22.32 (the same > > for 3.23.36 version): > > there is no mysql/var directory, so when i write: chown -R mysql > > /usr/local/mysql/var > > that doesn't work. And it's exactly the same for mysql/bin. > > So PLEASE!!! if someone can help me > > Thanks in advance > > Find the correct path for the mysql directory. I think it might be in > /usr/bin/*mysql* and /var/lib/mysql. Try typing locate mysql, or find /usr > -name "*mysql*" > > Then chown those files. > > -Philip Mak ([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
Weird Ordering & Queries
Ive come up with a curly problem and im wondering if anyone can shed some lights on it. I looked under the SELECT part of Mysql but it didnt seem to cover this and I didnt know how to phrase it. What I have is a displayed list on the site. This data that makes up the list comes from 2 tables. 'item' and 'location' are the 2 table names. For each item there is 1 entry in the item table. But under location there is several entries depending on where the part is. Its done this way to log a history of whether the item has been sent out, or received in. Each entry in the location table is date stamped and records the items location, and the item_id field. Currently I am doing my list like this. $item_q=mysql_query("select * from item order by item name"); while ($item=mysql_fetch_array($item_q)) { $location_q=mysql_query("select * from location where item_id=$item_q[item_id] order by date desc limit=1"); $location=mysql_fetch_array($location_q); echo"$itemlist[item_name] - $location[location] - $location[date]"; } The reason I do it this way is that I firstly need it to list all items, but then next step (and next SELECT) it grabs the most recent entry in location for that item. My problem is, I need to be able to combine the SELECT queries into 1, so that I can order by either Location, Date or Name Im not sure if this sort of thing is possible but it would make life so much easier if I could do it. Thanks Chris -- Chris Aitken - Webmaster/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2 4628 fax: +61 2 4628 8890 Unix -- because a computer's a terrible thing to waste! - 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
Mac OS X -- has anyone gotten mySQL to completely work yet? (passes all mysql-test-run, etc)
If anyone has successfully gotten MySQL to work on Mac OS X, could you please share your tips/solutions? There are at least 3 other people who are not able to get it to work and are showing a variety of problems (can't shut msqld down (hangs), fails to complete the install tests (mysql-test-run). In particular: exact version number exact configure parameters anything else you did to get it to work. VERY much appreciated. I'm ready to rock, I just can't mysql to pick up the beat. peace, Tyler - 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: Inverse Function
Hi. On Wed, Apr 18, 2001 at 04:17:45PM +0800, [EMAIL PROTECTED] wrote: > Siggy... > > thanks for the past reply... > > but i i dont want to SORT the record in ASCENDING or DESCENDING order > just a plain invert... That doesn't make really sense. According to the SQL specification, without ORDER BY the records are retrieved in an undefined order. Inverting an undefined order makes the records still being in an undefined order. You see my point? It seems that you are relying on the internal order of MySQL, which is considered a *Bad Thing*. MySQL is free to change this order at will, any time. According to the specification, if you leave out the ORDER BY clause, generally spoken, an RDBMS is even allowed to return the records in different order each time you run the same query! And there is no guarantee that the next MySQL version won't do exactly that (even if it is very, very unlikely). So you may want to describe to us what you want to archieve (why do you want that inverting) and maybe someone will come up with a solution. Bye, Benjamin. > -- > > use the ORDER BY clause with the SELECT > > SELECT * FROM table ORDERBY fieldname ASC > (or replace ASC with DESC for descending order) > > > Siggy > > - Original Message - > From: "Michael M. Ocana" <[EMAIL PROTECTED]> > To: "Mysql Lists" <[EMAIL PROTECTED]> > Sent: Wednesday, April 18, 2001 2:55 PM > Subject: inverse function > > > > Subject: inverse function (database,sql,query) > > > > > > hello anybody knows how to invert selected records? > > - 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: starting MySql on redhat 7
I don't know if you have fixed this probelm, but I had the same problem on Red Hat 7.0. I had installed the rpm files from MySQL.com and RedHat.com. The problem was solved by doing the following. chmod 755 the "mysql" directory that contains the "mysql.sock" file. I am currently running the latest release of MySQL Server & Client. Don't take this advice as perfect. I am a newbie also. Mike, "bobit" <[EMAIL PROTECTED]> wrote .. > Hi - here's my prob and background info. Tried the fix - it didn't work. > > MySQL Connection Failed: Can't connect to local MySQL server through socket >'/var/lib/mysql/mysql.sock' > (111) > > Any thoughts...? > > > I'm not sure if it's the same problem but here goes: > > I just did a fresh install of RH 7.0 with apache, php, and mysql. > > I had the same problem. > All I had to do was change the permissions on my MySQL directory (in your case >"/var/lib/mysql") > so that my apache user (the user/group that apache runs as) has access. > > check to make sure it also changes permissions on the mysql.sock file. That's the > important one. > > I believe apache only needs read (maybe execute) access. > > chmod 755 /var/lib/mysql > > (that's from memory, but you know the gist of the problem) > > > > > Groan..I knew linux was tough but I didn't think I needed a black belt. I've got > exactly the same prob after a straight redhat7 install. I tried to take milner's > advice and: > > changed the /var/lib/mysql/mysql.sock to 755 for root who I'm logged in as. Then > tried to do the same thing for the Mysql directory. It won't change. Tried a >re-boot. > > Then figured there was something screwy with the directory. > > Moved mysql.sock to /test > rmdir mysql > mkdir mysql > copied the file back in. The file now had rw permissions only. But in the test > dir root had all the permissions to it. Is it being blocked higher up in the tree. > > My linux book isn't very good on dir permissions. Will chmod change these even if > the directory is not empty. > > And how do u list permissions to a directory? ls -l only seems to work for files. > > In the error log in the same directory I also get: > > mysql.host doesn't exist - but this may be a susequent error. > > I'm a complete newbie so any help would be greatly appreciated. > TIA - 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 : inverse
>Subject: inverse function (database,sql,query) > > >hello anybody knows how to invert selected records? > >example : > >i have selected records : > > apple > mangoe > cherry > avocado > >if i invert it : > > avocado > cherry > mangoe > apple Records do not have order unless you use ORDER BY. If the first set of selected was produced using ORDER BY, you can use DESC to reverse the order. Gordon L. Burditt hi gordon! thanks for the fast reply... i select the records without ORDER BY, all i want is to reverse my selected records without using the sort parameters (DESC or ASC). just like reverse() function in other programming languages. 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: Date,time,datetime type
Ch 7 of the manual contains a list of date functions that allows you to do everything, short of boiling an egg. - Original Message - From: "Kevin Xin Lin" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 22:10 Subject: Date,time,datetime type > Hi there, > > If I need compare 2 fields of DATE and TIME to a field of > TIMESTAMP/DATETIME in my query, > what am I supposed to do? Is there a function to get DATE/TIME part from > > a DATETIME field, or combine DATE and TIME to a DATETIME type? > > 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 - 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 for the Final year project..
Here's my 2cents worth. Speed, reliability, ease of use. - Original Message - From: "Dilkushan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 23:10 Subject: Help for the Final year project.. > Hi, > I'm a final year student in a private Campus in Sri Lanka (Collaboration > with Manchester Metropolitan University). My final year project is a Web > Interface to a DBA in a Heterogeneous Databases environment. > I'm basically developing my prototype for two databases Oracle and MySql. > What I want is tell me reasons to choose MySql as the second database. > Previously I was going to choose SQLServer (Microsoft) instead on mySql. > Why I choose Oracle is I have little bit of experience and I have partly > finished my OCP (DBA Track). > > > -- > Dilkushan Karunaratne, > # 50/1A, Sri Indrajothi Road, > Ratmalana, > Sri Lanka. > > Tel 94 1 715716 - 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: timeGetTime
- Original Message - From: <[EMAIL PROTECTED]> To: Brandon Davis <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 7:17 PM Subject: Re: timeGetTime > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > database,sql,query > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. You have written the following: > > > Has anyone ever used the windows API timeGetTime( ) ? > > I am trying to add some logging with my db and i keep getting > > error LNK2001: unresolved external symbol __imp__timeGetTime@0 > > i am using visual c++ 5.0 > > thanks > BD > - 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
Please remove me from the list
Hi There, Please remove me from the mysql mailing list. Leslie - 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
root password
Hi again... I'm going to be crazy soon, it's 2h20 in the morning and i'm dead! Anyway: i've tried to make a new user, and i launch safe_mysqld from him. Everything is ok. (i checked) I've write: ./bin/mysqladmin -u root password password (exactly!!) ok and so: ./bin/mysql -p -user=root Enter password: password ERROR 1045: Access denied for user: 'ser=root@localhost' (Using password: YES) if someone understand anything.. please tell me - 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: Efficiency of MEDIUMTEXT columns?
On Wed, 18 Apr 2001, ryc wrote: > The subject field is a bit more tricky. You COULD change it to > Char(255) but that would waste a lot of space seeing that most > subjects are a lot shorter. You can move the subject into the table > that holds the varchar bodies. This wont hurt anything because that > table already has varaible length rows from the body column, adding > the subject wont hurt. Well, I was wondering if there is a point in putting the SUBJECT field in a separate table, when every query that I would execute needs to retrieve the SUBJECT field anyway... > > Also, is it a good idea to make a field called size and use that instead > > of calling length(message) (message is MEDIUMTEXT) when I don't need to > > retrieve message, or does MySQL have length(message) cached? > > Yes definitly. Although it is tempting to calculate the length/count/other > stats on the fly using database functions, it is not scalable. Okay, I'll do that. The messages don't change once they're posted so it's easy to keep another field indicating the size. > Instead of splitting it into lines based on a newline, you can do a > global replace using \n as an anchor. Something like: search for "\n>" > and replace with "\n$colorcolor>". It's not quite that simple; the color changes depending on how many >'s there are. My current algorithm counts the (number of >'s + 1) % 6 at the beginning of the line to decide what color to use. If this were C, I could probably do this efficiently using character pointers. Come to think of it, when I split the message into a list, that causes two copies of the message to be held in memory: the unsplit version, and the split version. Maybe that's what's slowing it down. I can't think of doing it any other way though. > thinking scalability you might want to do this conversion once, and store > the results in the database. So you dont have to worry about parsing it into > lines once you retrieve it from the db, you can just spit it out because it > already has the color info in it. I might do that once I get my system better developed. Most pages never change once they've been created, and the ones that do change (e.g. when a message gets replied to, its page needs to link to the new reply) can be found and updated relatively simply. So I could just write out a lot of this stuff to static HTML pages for the ultimate performance boost. -Philip Mak ([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
Replication Slave to Master
How much difficulty is there in turning a MySQL replication server into a master?
Re: How to structure a random query
You could also do something like: select field1, field2 from table order by rand() limit 1; HTH Ben - Original Message - From: "Philip Mak" <[EMAIL PROTECTED]> To: "Alec Smith" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 11:50 PM Subject: Re: How to structure a random query > On Wed, 18 Apr 2001, Alec Smith wrote: > > > I've got a table of X rows, each with a unique ID as determined by > > auto_increment when the row is inserted into the database. How would I go > > about doing a SELECT on a row of the database and have MySQL return a row > > at random? > > Maybe you can do something with the MySQL RAND() function, which returns a > random number between 0.0 and 1.0 (so you'd have to normalize it to > between 1 and MAX(ID)). > > You may not be able to use the grouping function that way, though. MySQL > doesn't seem to let you use grouping functions in the WHERE clause. > > mysql> select num from ffml where num=floor(rand()*max(num))+1; > ERROR : Invalid use of group function > > Anyone else have an idea? > > -Philip Mak ([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
Sorry for my question!!
Excuse me, i've solve my pb: i just wrote: mysql -p -user=root and nothing for the password, and it works... don't ask me why... Phelles Anyway thanks for your help Phillip!!! - 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 structure a random query
On Wed, 18 Apr 2001, Alec Smith wrote: > I've got a table of X rows, each with a unique ID as determined by > auto_increment when the row is inserted into the database. How would I go > about doing a SELECT on a row of the database and have MySQL return a row > at random? Maybe you can do something with the MySQL RAND() function, which returns a random number between 0.0 and 1.0 (so you'd have to normalize it to between 1 and MAX(ID)). You may not be able to use the grouping function that way, though. MySQL doesn't seem to let you use grouping functions in the WHERE clause. mysql> select num from ffml where num=floor(rand()*max(num))+1; ERROR : Invalid use of group function Anyone else have an idea? -Philip Mak ([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
Need help with a Freebsd install..
Can any one help me install Mysql on my Freebsd 4.2 box.. the first thing I did was: got a copy of Mysql for mysql.com placed in in the /usr/local then: >gzip -dc mysql-3_23_36-unknown-freebsdelf4_2-i386_tar.gz | tar -vxf - created a mysql directory. /usr/local/mysql then ./configure --prefix=/usr/local/mysql After all that it will not attach to any DB.. It will run but I can restart it once it is stopped with out doing ./configure --prefix=/usr/local/mysql again.. Help.. Larry - 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
An other little question
Hi again... mysql daemon is running... i've wrote 1 time: /my/path/mysql/bin/mysqladmin -u root password 'new-password' nothing happened... after that, i've tried: mysql -p user=root mysql here it answers: ERROR 1045: Access denied for user: 'ser=root@localhost' (Using password: YES) If someone can help me Thanks very much Phelles - 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
How to structure a random query
I'm just starting to learn SQL and MySQL, and am curious as to how the following query might be built. I've got a table of X rows, each with a unique ID as determined by auto_increment when the row is inserted into the database. How would I go about doing a SELECT on a row of the database and have MySQL return a row at random? I figure there must be an easier way then doing a SELECT count(*) from tablename, using that in a random generator in Perl/PHP, and then looking up the resulting row with a second MySQL query. Thanks, Alec - 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 structure a random query
http://www.mysql.com/doc/M/a/Mathematical_functions.html describes how to do this using the RAND() function. -Original Message- From: Alec Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 6:27 PM To: [EMAIL PROTECTED] Subject: How to structure a random query I'm just starting to learn SQL and MySQL, and am curious as to how the following query might be built. I've got a table of X rows, each with a unique ID as determined by auto_increment when the row is inserted into the database. How would I go about doing a SELECT on a row of the database and have MySQL return a row at random? I figure there must be an easier way then doing a SELECT count(*) from tablename, using that in a random generator in Perl/PHP, and then looking up the resulting row with a second MySQL query. Thanks, Alec - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.37 released
Hi! 3.23.37 is now released. This release mainly fixes some minor bugs, so we assume that most users doesn't have to upgrade from 3.23.36. The main change is that Innobase tables changed name to InnoDB to not conflict with the German INNOBASE company. If you are using Innobase, you need to change all your options in your startup and config files from innobase to innodb. (You can still create tables with type=INNOBASE, but this should be changed to type=INNODB over time). We are just now building the first MySQL-Max binaries with support for Berkeley DB and InnoDB tables. The first one will be a Linux x86 RPM (which should be available tomorrow), but other binaries should be available within a few days (or when 3.23.38 is released if we have to do any major porting change). Because of a problem on our windows computer, the windows version of 3.23.37 will be delayed a couple of days. Changes in release 3.23.37 -- * Fixed a bug when using `HEAP' tables with `LIKE'. * Added `--mysql-version' to `safe_mysqld' * Changed `INNOBASE' to `InnoDB' (because the `INNOBASE' name was already used). All `configure' options and `mysqld' start options are now using `innodb' instead of `innobase'. This means that you have to change any configuration files where you have used `innobase' options before upgrading to this version! * Fixed bug when using indexes on `CHAR(255) NULL' columns. * Slave thread will now be started even if `master-host' is not set, as long as `server-id' is set and valid `master.info' is present * Partial updates ( terminated with kill) are now logged with a special error code to the binary log. Slave will refuse to execute them if the error code indicates the update was terminated abnormally, and will have to be recovered with `SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START' after a manual sanity check/correction of data integrity * Fixed bug that erroneously logged a drop of internal temporary table on thread termination to the binary log - bug affected replication * Fixed a bug in `REGEXP()' on 64-bit machines. * `UPDATE' and `DELETE' with `WHERE unique_key_part IS NULL' didn't update/delete all rows. * Disabled `INSERT DELAYED' for tables that supports transactions. * Fixed bug when using date functions on `TEXT'/`BLOB' column with wrong date format. * UDF's now also works on windows. (Patch by Ralph Mason) * Fixed bug in `ALTER TABLE' and `LOAD DATA INFILE' that disabled key-sorting. These command should now be faster in most cases. * Fixed performance bug where reopened tables (tables that had been waiting for `FLUSH' or `REPAIR') would not use indexes for the next query. * Fixed problem with `ALTER TABLE' to Innobase tables on Freebsd. * Added `mysqld' variables `myisam_max_sort_file_size' and `myisam_max_extra_sort_file_size'. * Initialize signals early to avoid problem with signals in Innobase. * Applied patch for the `tis620' character set to make comparisons case-independent and to fix a bug in `LIKE' for this character set. *NOTE*: All tables that uses the `tis620' character set must be fixed with `myisamchk -r' or `REPAIR TABLE' ! * Added `--skip-safemalloc' option to `mysqld'. Regards, Monty - 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: Phrase based fulltext searching
I thought I read that was in the plan for 4.0. I can't find where that's stated in the docs though - all I see is the stuff about boolean operators. Does anyone have experience with using the AOL PLS package for text searching? I am thinking of using it. Braxton -Original Message- From: Philip Mak [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 5:39 PM To: [EMAIL PROTECTED] Subject: Phrase based fulltext searching I read through the MySQL documentation on full text indexing, and there does not seem to be a way to search for a *phrase*, e.g. searching for a document that contains "Sailor Moon", as opposed to one that contains the word "Sailor" and the word "Moon", not necessarily together. (Unless I use LIKE "%Sailor Moon%", but that's inefficient...) Is the above statement correct? What techniques do people here use to overcome that limitation? (Using a program separate from MySQL for indexing text, perhaps?) -Philip Mak ([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: Efficiency of MEDIUMTEXT columns?
> I have some VARCHAR columns (name, e-mail address and subject) that are > used in every query, though. Should I change them to CHAR(255) so that I > can do this? (On a related note, does anyone know whether the RFC for > e-mail messages limit the subject length/name length/e-mail address length > to a certain number of characters? What is this number?) I would suggest to create another seperate table for user info only and just keep a userid field in the message table that corresponds with the user info row that holds the name and email. This way if someone posts 100 messages, you only store their email address once. The subject field is a bit more tricky. You COULD change it to Char(255) but that would waste a lot of space seeing that most subjects are a lot shorter. You can move the subject into the table that holds the varchar bodies. This wont hurt anything because that table already has varaible length rows from the body column, adding the subject wont hurt. > Also, is it a good idea to make a field called size and use that instead > of calling length(message) (message is MEDIUMTEXT) when I don't need to > retrieve message, or does MySQL have length(message) cached? Yes definitly. Although it is tempting to calculate the length/count/other stats on the fly using database functions, it is not scalable. For any stat type field like length(in your case size) ask yourself how often it changes. If it doesnt change often or at all, it is much better to calculate it once and store 'cache' the result in the database. Do the same for number of replies (ie dont calculate them on the fly). Otherwise you are going to find yourself with 500k rows and the counting replies isnt so fast anymore. > So it would appear that retrieving a message (the message that I used in > this test is 300k, about the largest that is in the archive) from the > database is faster than loading it from a disk file. However, when I have > to split() the message into a list (one entry per line), it becomes > slower. Any idea how I can split it more efficiently? (My code has to > process each line individually in order to hilight text from quoted > replies; e.g. look at the different colors in > http://qd.anifics.com/read.asp?num=32) I can think of two solutions. Instead of splitting it into lines based on a newline, you can do a global replace using \n as an anchor. Something like: search for "\n>" and replace with "\n$colorcolor>". I am not sure if this would be much faster than doing a split you can try it out. But again thinking scalability you might want to do this conversion once, and store the results in the database. So you dont have to worry about parsing it into lines once you retrieve it from the db, you can just spit it out because it already has the color info in it. ryan - 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: there is no mysql/var directory
On Wed, 18 Apr 2001, feldekis wrote: > Hi everybody!! > I've got a pb during the installation of the binary of mysql-3.22.32 (the same > for 3.23.36 version): > there is no mysql/var directory, so when i write: chown -R mysql > /usr/local/mysql/var > that doesn't work. And it's exactly the same for mysql/bin. > So PLEASE!!! if someone can help me > Thanks in advance Find the correct path for the mysql directory. I think it might be in /usr/bin/*mysql* and /var/lib/mysql. Try typing locate mysql, or find /usr -name "*mysql*" Then chown those files. -Philip Mak ([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: "Too Many Connections" error
That's weird - my Server will only let me have 210 connections if I set max_connections to 300, it sets at 210. If I set it to 500, it still stays at 210. Any ideas on how to increase this? -Original Message- From: Philip Mak [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 3:30 PM To: Jesse E. Stay II Cc: [EMAIL PROTECTED] Subject: Re: "Too Many Connections" error On Wed, 18 Apr 2001, Jesse E. Stay II wrote: > I'm having a problem, which has occured before, in which I keep getting "Too > Many Connections" Errors in my logs on the web server for MySQL. I am using > Apache::DBI to connect. I fixed the problem before by just increasing the > max_connections. Unfortunately, I am at the max amount of max_connections > (the MySQL docs say that in order to increase it, you have to compile it in > with the code, which I would rather not do.), and I cannot add any more. If > I switch to just regular DBI, will that solve my problem, or what else could > be causing this problem to occur? I've got my boss breathing down my neck, > and I'm unsure what answer to give him. Here's some random thoughts: If you have more Apache processes running than you have maximum connections (I think the hard maximum is around 1000), then you will run out of connections. One thing you could try is setting "MaxClients" in httpd.conf to your max_connections. This will prevent Apache from spawning too many processes, but may cause people viewing your website to have to wait longer. If you use the normal DBI instead of Apache::DBI, then connections will be non-persistent and you'll have more to go around, at the cost of slightly slower website response time. There might be a problem somewhere that is causing your system to use up more MySQL connections than it should. 1000 is a lot of connections, and it shouldn't use that many unless your website is very heavily loaded. (I had a website that got 3 million page views a month and it fit in 40 simultaneous connections, but it was all static files so queries could be served quickly.) -Philip Mak ([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: "Too Many Connections" error
Hi everybody!! I've got a pb during the installation of the binary of mysql-3.22.32 (the same for 3.23.36 version): there is no mysql/var directory, so when i write: chown -R mysql /usr/local/mysql/var that doesn't work. And it's exactly the same for mysql/bin. So PLEASE!!! if someone can help me Thanks in advance Phelles - 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
Phrase based fulltext searching
I read through the MySQL documentation on full text indexing, and there does not seem to be a way to search for a *phrase*, e.g. searching for a document that contains "Sailor Moon", as opposed to one that contains the word "Sailor" and the word "Moon", not necessarily together. (Unless I use LIKE "%Sailor Moon%", but that's inefficient...) Is the above statement correct? What techniques do people here use to overcome that limitation? (Using a program separate from MySQL for indexing text, perhaps?) -Philip Mak ([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: "Too Many Connections" error
On Wed, 18 Apr 2001, Jesse E. Stay II wrote: > I'm having a problem, which has occured before, in which I keep getting "Too > Many Connections" Errors in my logs on the web server for MySQL. I am using > Apache::DBI to connect. I fixed the problem before by just increasing the > max_connections. Unfortunately, I am at the max amount of max_connections > (the MySQL docs say that in order to increase it, you have to compile it in > with the code, which I would rather not do.), and I cannot add any more. If > I switch to just regular DBI, will that solve my problem, or what else could > be causing this problem to occur? I've got my boss breathing down my neck, > and I'm unsure what answer to give him. Here's some random thoughts: If you have more Apache processes running than you have maximum connections (I think the hard maximum is around 1000), then you will run out of connections. One thing you could try is setting "MaxClients" in httpd.conf to your max_connections. This will prevent Apache from spawning too many processes, but may cause people viewing your website to have to wait longer. If you use the normal DBI instead of Apache::DBI, then connections will be non-persistent and you'll have more to go around, at the cost of slightly slower website response time. There might be a problem somewhere that is causing your system to use up more MySQL connections than it should. 1000 is a lot of connections, and it shouldn't use that many unless your website is very heavily loaded. (I had a website that got 3 million page views a month and it fit in 40 simultaneous connections, but it was all static files so queries could be served quickly.) -Philip Mak ([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
"Too Many Connections" error
I'm having a problem, which has occured before, in which I keep getting "Too Many Connections" Errors in my logs on the web server for MySQL. I am using Apache::DBI to connect. I fixed the problem before by just increasing the max_connections. Unfortunately, I am at the max amount of max_connections (the MySQL docs say that in order to increase it, you have to compile it in with the code, which I would rather not do.), and I cannot add any more. If I switch to just regular DBI, will that solve my problem, or what else could be causing this problem to occur? I've got my boss breathing down my neck, and I'm unsure what answer to give him. -Jesse Stay - 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: getting started...the hardest part
Simon, Take a look at www.sunfreeware.com. Go to their Downloading/Installation section (left panel) and grab the pkg-get script. Use pkgadd to install it. (as root: pkgadd -d BOLTpget.pkg ). Then add /usr/local/bin to your path. (PATH=$PATH:/usr/local/bin; export PATH) Use pkg-get to get all sorts of good utilities: pkg-get update #lots of instructions to follow pkg-get install gcc # needed to compile anything pkg-get install tar # absolutely necessary pkg-get install autoconf # useful pkg-get install bash #for sanity pkg-get install flex # if tools you are building require it pkg-get install bison # needed if you are building apache pkg-get install make # absolutely necessary pkg-get install less # helpful pkg-get install perl # most likely pkg-get install zlib # necessary if you want openssl pkg-get install bzip2 # good tool to have Now you will have to tools to build apache, mod-ssl, openssl and I just used the binary of mysql. /Duncan On Wed, Apr 18, 2001 at 02:25:15PM -0400, Matthew P. Marino wrote: > You've got a long way to go. "tar" is short for tape archive. It is > an ancient unix utility that takes directory and file data and builds it > into a contiguous data base file. This is for portability and > manageability. You should have to get past "gzip" before you get to > "tar". gzip is a gnu compression utility. The mysql tarball is tar'd and > gzip'd so one normally has to; > > gzip -d mysql.tar.gz tar -xvf mysql.tar > > That leaves you with a directory you need to enter and "make install". > Read the INSTALL and README files. They'll get you through it OK. The > reason for GNU TAR is that the Solaris "tar" has a 128 charachter path > limit to filenames. I think MySQL exceeds that with the windows32 stuff. > Warning! Solaris has a number of other problems out of the box. The > "cc" compiler is bad, as is the "ld" or linker libraries. If your serious > about using open source software you'd be best to go to www.gnu.org and > get; > > gzip bin utilities make tar gcc > > Your best off to compile and install them so they are custom to your > current solaris' environment. It goes something like; > > gzip -d whatever.tar.gz tar -xvf whatever.tar cd whatever ./configure > make make install > > > Compile and install all of these, add /usr/local/bin to your path; > > PATH=$PATH:/usr/local/bin:/usr/local/lib export PATH > > You are then "in the ball park". It's a tough haul. The solaris 2.8 CD > has a lot of these gnu utilities pre-compiled for Solaris. These can help > but the practice of compiling and installing the minor support libs can > set you up better for the big installs. If solaris wasn't such a rock > solid OS on rock solid hardware I'd recommend setting up FreeBSD on an > old intel box. It's easier but not as robust as freeBSD's development > environment is "GNU/BSD" centric as are most open source efforts. > > Simon Chan wrote: > > > > Hi Everybody! > > > > Just starting to teach myself MySql and databases. I have the O'Reilly > > books on Perl DBI and Mysql, msql. > > > > My question is this: > > > > I am trying to install mysql on sparc sun solaris 2.7 machine. I found > > a binary version in the downloads page of mysql.com (is is called Sun > > Solaris (Sparc)[sun-soalris2.7-sparc] ) > > > > what exactly is the "GNU Tar" command? How do I install mysql with it? > > > > Any help would be much appreciated. Many thanks everybody! > > > > Sincerely, Simon Chan -- Duncan Watson Application Engineer [EMAIL PROTECTED] nCUBE - Beaverton [For best reading adjust your window width to the length of this line -djw] 123456789012345678901234567890123456789012345678901234567890123456789012345 - 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: Efficiency of MEDIUMTEXT columns?
On Wed, 18 Apr 2001, ryc wrote: > A few tips for you... Store all the varchar/text columns for each message in > a seperate table so that the primary message table only has fixed length > fields (ie messageid, size, #of replies, userid, bodyid, ...). I have some VARCHAR columns (name, e-mail address and subject) that are used in every query, though. Should I change them to CHAR(255) so that I can do this? (On a related note, does anyone know whether the RFC for e-mail messages limit the subject length/name length/e-mail address length to a certain number of characters? What is this number?) Also, is it a good idea to make a field called size and use that instead of calling length(message) (message is MEDIUMTEXT) when I don't need to retrieve message, or does MySQL have length(message) cached? ... I just ran a crude benchmark on three different ways to retrieve text from the database. The time required for 100 iterations of each method is: DB2: 3.7 seconds DB3: 11.5 seconds Text: 5.6 seconds DB2 is where I retrieve the message from the database: my $sth = query("SELECT * FROM ffml WHERE num=6051"); my $this = $sth->fetchrow_hashref; print $this->{message}; DB3 is where I retrieve the message from the database and split it: my $sth = query("SELECT * FROM ffml WHERE num=6051"); my $this = $sth->fetchrow_hashref; my @message = split("\n", $this->{message}); for my $line (@message) { print $line."\n"; } Text is where I retrieve the message from a disk file: open(MSG, '6051'); while ($line = ) { print $line."\n"; } So it would appear that retrieving a message (the message that I used in this test is 300k, about the largest that is in the archive) from the database is faster than loading it from a disk file. However, when I have to split() the message into a list (one entry per line), it becomes slower. Any idea how I can split it more efficiently? (My code has to process each line individually in order to hilight text from quoted replies; e.g. look at the different colors in http://qd.anifics.com/read.asp?num=32) > So if you are dumping/posting a lot of messages into the table the > select performance is going to suffer. Inserts shouldn't be too common; just once every time the mailing list receives a new message (no more than 100 per day). Thanks, -Philip Mak ([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
Max sizes?
Hello, I am trying to find some information on MySQL. Could you folks help me out. I need: Max Database Size Max Table Size Max Size for a row Max Number of rows Max Number of Columns Max number of indexes per table Thanks! Joshua Drake - 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: Inserting data to multiple table at once
Yeah, it does require one insert command per table, thats why some people like transaction capability in tables. If we all could insert data into multiple tables with one insert command then we wouldn't need transaction support would we? H, that would be nice though! :o) Patrick -Original Message- From: Peter Skipworth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 11:47 AM To: Fates Cc: [EMAIL PROTECTED] Subject: Re: Inserting data to multiple table at once mySQL requires one insert command per table. Stop being lazy, *grin* P On Wed, 18 Apr 2001, Fates wrote: > How do I insert data into multiple tables without having to use multiple > >insert statements? Can I just do Insert into table1 (data) table2 > (data) >table3 (data) or do I have to use seperate INSERT statements for each > table? I would like to add all at once from web page form > > > $query = "INSERT INTO $table VALUES ('$menu_id', '$server', > '$menunumber', '$menuname')"; > > -- > This email was sent using w3mail. > > > - > 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 > > -- --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - 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: question about integrating ASP pages
> Is it possible to use ASP with MySQL? I found a link > in the documentation to > www.amedea.cz/mysqlx/index.html which was supposed to > have a downloadable MySQL COM extension but the > website was not found. Yes, it's possible to use ASP with MySQL. In a nutshell, you need to make sure that you have the MyODBC driver installed on your server and you can then create a connection object with the DSN name. From there, you will be able to work with it almost like any other connection & recordset object, although there are some limitations with a few ADO properties. I wrote a case study for ASPToday that address this very issue (ASP and MySQL integration). You can check it out at: http://www.asptoday.com/content/casestudies/20010302.asp Good luck, Dennis **' Beridney Computer Services [EMAIL PROTECTED] http://www.beridney.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: ADO RS.Update problem
- Original Message - From: "Pat Sherrill" <[EMAIL PROTECTED]> Sent: Saturday, April 14, 2001 7:34 AM Subject: Re: ADO RS.Update problem > Just a quick note about RecordCount. RecordCount only returns the number of > records or rows from the recordset that have been 'seen'. Therefore it is > only reliable if you have traversed the entire recordset before calling it. That is true in some cases, using MoveLast and then issuing the RecordCount request does give the most accurate result. However, if I remember correctly, when working with MySQL and ADO, MoveNext is one of the few methods that is supported. Further note that even if all the records are "seen" (by using a loop and MoveNext), the RecordCount property will still not work. Therefore, the work-around would require a separate counter with ASP or other language of choice. Good luck, Dennis **' Beridney Computer Services [EMAIL PROTECTED] http://www.beridney.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
sql_create_basic_N questions
NOTE: I have cross-posted this to the plusplus mailing list as well. I am using sql_create_basic_N to generate structures that mirror my database tables. The problem I have is that some of the fields in my database are "blobs" that need to be escaped before insertion. Questions: 1. I am using a string to represent the data in the structure: sql_create_basic_2(StoryBody, 0, 0, INT32, StoryID, string, Body);// this is actually a blob Is there a better data structure for this? 2. The data that I am trying to store has nulls scattered throughout. When I create the insert string using the following code, it only puts in the data up to the first null. That's a side effect of the string, so I have tried escaping the string before I create the insert statement. That doesn't seem to work either. Apparently, MySql is ignoring the escaped characters. StoryBodysb; sb.StoryID = -1; string tmpS(blobSize, blob); sb.Body = tmpS; escape_string(sb.Body); Query q = m_dbconn->query(); stringstream strbuf; try { string tmpQS = "INSERT INTO STORYBODY (Body) VALUES('"; strbuf << "INSERT INTO STORYBODY (Body) VALUES(" << quote << sb.Body << ")"; q.exec(strbuf.str()); } catch(BadQuery e) { // handle error here } Any help would be greatly appreciated. Thanks, Steve
Installing all prepared tables
After posting yesterday about mysql_install_db haning when it says "Installing all prepared tables" I've tried the rpm version, and it hangs in the exact same place. How do I get it to work? The other posts suggest that it's a permissions problem. If that's the case, what do my permissions need to be? I've tried setting various ownerships and privs and nothing works. I've also tried "scripts/mysql_install_db --user=mysql" and that doesn't work either. Any help would be greatly appreciated. I'm about to tear all my hair out. Thanks, Ryan - 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
Drop Table
Hi, I am facing the following problem with MySQL3.2.3: OS:Windows NT 4.0 When ever I try to DROP A TABLE it gives the following "Error on delete of '.\dbhub\data_source_type.MYI' (Errcode: 13)" Can someone let me know the reason.It works fine sometimes.But the behaviour is not consistent. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: Plase Let us know if there is a Racialism for Mysql product and quit
At 18:50 18/04/2001 +0300, Yusuf Incekara wrote: >You said : >Only those who don't read English too good. What I meant was a clarification of your problem since English is not your native language. This has nothing to do with racism whatsoever. For you information I have lived and worked in the Arabian Gulf (Saudi Arabia, Kuwait, Dubai, Abu Dhabi, Yemen, Bahrain and Qatar), Egypt, the Congo, Thailand, Singapore and all over Europe. During this time I made many friend in these countries. So I think you are quite wrong to suggest that my comment is racist. But I stand by the fact that I believe you do not understand what is written in the manual >Being a native English speaker >it is very clear to me. > > >Could you please be more open and honest? > >It is obviously seen that i can easily read and write in English. >But if you disturbed that one Turk found your bug please let me know >and quit . Let all your customers become from Mansfield, England, UK. I am not at all disturbed as you put it and if it was a 'bug' I would be very happy that you had noticed it. But it is not a 'bug' >I am not insisting that my English is perfect. But be sure that >it is not necessary that being a native English speaker. > >I said that no matter but you are looking for a trouble ... > >If you read carefully followed instructions ( by using your perfect native >English ) >you 'll see the differences between Windows directory and System Directory. If you will not be guided then there is nothing I can do The manual states windows-system-directory not windows/system or windows/system32 or winnt/system or winnt/system32. The directory where Windows whatever version is installed. It could be windows or windows.000 or windows.001, etc >If still there is some issues that your perfect English mind can not >understand >please mail me. > >If you say still i am native English. No one can knows better then me even >Microsoft >so there is nothing to say. > >If you undertand your mistake and wanna apologize please forget it. > >Regards. > >Yusuf Incekara >Avukatpro Limited Sirketi >Izmit/Turkey (sorry for not being a native English but smart) > > > > >GetSystemDirectory > >Reference : Microsoft Web site : >http://msdn.microsoft.com/library/psdk/sysmgmt/sysinfo_1unt.htm > >The GetSystemDirectory function retrieves the path of the system directory. >The system directory contains such files as dynamic-link libraries, drivers, >and font files. > >UINT GetSystemDirectory( > LPTSTR lpBuffer, // buffer for system directory > UINT uSize// size of directory buffer >); >Parameters >lpBuffer >[out] Pointer to the buffer to receive the null-terminated string containing >the path. This path does not end with a backslash unless the system >directory is the root directory. For example, if the system directory is >named WINDOWS\SYSTEM on drive C, the path of the system directory retrieved >by this function is C:\WINDOWS\SYSTEM. >uSize >[in] Specifies the maximum size of the buffer, in TCHARs. This value should >be set to at least MAX_PATH. >Return Values > > > >GetWindowsDirectory > >Reference : Microsoft Web site : >http://msdn.microsoft.com/library/psdk/sysmgmt/sysinfo_4k55.htm > > >GetWindowsDirectory >The GetWindowsDirectory function retrieves the path of the Windows >directory. The Windows directory contains such files as applications, >initialization files, and help files. > >UINT GetWindowsDirectory( > LPTSTR lpBuffer, // buffer for Windows directory > UINT uSize// size of directory buffer >); >Parameters >lpBuffer >[out] Pointer to the buffer to receive the null-terminated string containing >the path. This path does not end with a backslash unless the Windows >directory is the root directory. For example, if the Windows directory is >named WINDOWS on drive C, the path of the Windows directory retrieved by >this function is C:\WINDOWS. If the system was installed in the root >directory of drive C, the path retrieved is C:\. >uSize >[in] Specifies the maximum size, in TCHARs, of the buffer specified by the >lpBuffer parameter. This value should be set to MAX_PATH to allow sufficient >room for the path. > > > > > >- Original Message - >From: John Dean <[EMAIL PROTECTED]> >To: Yusuf Incekara <[EMAIL PROTECTED]> >Sent: Wednesday, April 18, 2001 10:11 AM >Subject: Re: Ynt: Bug in Documentation ? > > > > At 09:29 18/04/2001 +0300, you wrote: > > >Ok . No matter for me anymore. cause i solved my problem. > > >i'm paying attention for other users not to have > > >the same problem. > > > > Only those who don't read English too good. Being a native English speaker > > it is very clear to me > > > > >Regards > > >Yusuf Incekara > > > > > > > > >- Original Message - > > >From: John Dean <[EMAIL PROTECTED]> > > >To: Yusuf Incekara <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > >Sent: Tuesday, April 17, 2001 9:27 PM > > >Subject: Re: Bug in Documentation ? > > > > > > > > > > Hi > > > > This is not a "bug
question about integrating ASP pages
Is it possible to use ASP with MySQL? I found a link in the documentation to www.amedea.cz/mysqlx/index.html which was supposed to have a downloadable MySQL COM extension but the website was not found. Thanks! __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.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
Re: Inserting data to multiple table at once
mySQL requires one insert command per table. Stop being lazy, *grin* P On Wed, 18 Apr 2001, Fates wrote: > How do I insert data into multiple tables without having to use multiple > >insert statements? Can I just do Insert into table1 (data) table2 > (data) >table3 (data) or do I have to use seperate INSERT statements for each > table? I would like to add all at once from web page form > > > $query = "INSERT INTO $table VALUES ('$menu_id', '$server', > '$menunumber', '$menuname')"; > > -- > This email was sent using w3mail. > > > - > 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 > > -- --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - 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
Problem when install PHP4 with MySQL
Hi all I need a Help I installed mysql 3.23 ( mysql-3.23.33-hp-hpux11.00-hppa2.0w.tar.gz ) in HP-UX 11.00 and now I try install PHP4 ( 4.0.4pl1 ), but I have some problem's # cd /opt/php4 # ./configure --with-mysql=/opt/mysql # make after make command occur the follow error message >Reference from: /opt/mysql/lib/libmysqlclient.a(str2int.o)(0x6b8) >/usr/bin/ld: Data Linkage Table (+z) overflow in file /opt/mysql/lib/libmysqlclient.a(str2int.o) - use +Z option to recompile Help me please thanks a lot
Re: getting started...the hardest part
You've got a long way to go. "tar" is short for tape archive. It is an ancient unix utility that takes directory and file data and builds it into a contiguous data base file. This is for portability and manageability. You should have to get past "gzip" before you get to "tar". gzip is a gnu compression utility. The mysql tarball is tar'd and gzip'd so one normally has to; gzip -d mysql.tar.gz tar -xvf mysql.tar That leaves you with a directory you need to enter and "make install". Read the INSTALL and README files. They'll get you through it OK. The reason for GNU TAR is that the Solaris "tar" has a 128 charachter path limit to filenames. I think MySQL exceeds that with the windows32 stuff. Warning! Solaris has a number of other problems out of the box. The "cc" compiler is bad, as is the "ld" or linker libraries. If your serious about using open source software you'd be best to go to www.gnu.org and get; gzip bin utilities make tar gcc Your best off to compile and install them so they are custom to your current solaris' environment. It goes something like; gzip -d whatever.tar.gz tar -xvf whatever.tar cd whatever ./configure make make install Compile and install all of these, add /usr/local/bin to your path; PATH=$PATH:/usr/local/bin:/usr/local/lib export PATH You are then "in the ball park". It's a tough haul. The solaris 2.8 CD has a lot of these gnu utilities pre-compiled for Solaris. These can help but the practice of compiling and installing the minor support libs can set you up better for the big installs. If solaris wasn't such a rock solid OS on rock solid hardware I'd recommend setting up FreeBSD on an old intel box. It's easier but not as robust as freeBSD's development environment is "GNU/BSD" centric as are most open source efforts. Simon Chan wrote: > > Hi Everybody! > > Just starting to teach myself MySql and databases. > I have the O'Reilly books on Perl DBI and Mysql, msql. > > My question is this: > > I am trying to install mysql on sparc sun solaris 2.7 > machine. I found a binary version in the downloads > page of mysql.com (is is called Sun Solaris > (Sparc)[sun-soalris2.7-sparc] ) > > what exactly is the "GNU Tar" command? How do I > install mysql with it? > > Any help would be much appreciated. Many thanks > everybody! > > Sincerely, > Simon Chan > > __ > Do You Yahoo!? > Yahoo! Auctions - buy the things you want at great prices > http://auctions.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: Database Planning
I just got done figuring out how to --100%-- normalize a database to make it very flexible. Methinks that Oracle has done this in some fashion, as they claim to be able to make an intersection from any row in any table to any other. A note: Objects, Actors, and Attributes use the names of the tables having 0:1 relationships to them as the value in their name . Example: Actors ActorID=1,TypeID=1,Name=Company ActorID=2,TypeID=1,Name=Company ActorID=3,TypeID=2,Name=Member Objects ObjectID=1,TypeID=1,Name=Schedules ObjectID=1,TypeID=2,Name=Bookings ObjectID=1,TypeID=2,Name=Bookings the database application code/constraints, or scripts accessing the database have to enforce that no ObjectID,ActorID,AttributeID EVER gets used twice and only appears in once of the tables in 0:1 relationship to it. I welcome any comments. I've got the diagram in *.bmp (huge). I'll download a graphics program and convert it to *.jpg. It'll be at: http://64.177.230.204/public/VeryNormalised.jpg http://64.177.230.204/public/VeryNormalised.png - 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
Importing data from Outlook Express
I'm looking for Outlook Express API's, I want to import data from a .dbx file (archive outlook) into a MySql table. - 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 with Mysql inport
Luis ([EMAIL PROTECTED]) writes: > 1. I would love to move my database in access (ms) to mysql running on my > linux box (rh7.0) > How would I do this? We use the ExportSQL script - you can get it from the MySQL.com web site. > 2. Then I would like to connect threw my windows machine into the database > running on the linux box. > > I download the MyODBS file from the site. Installed it went into ODBS set in > the control panel . Here's were I get lost .. >From Access, select File|Get External Data|Link Tables. In the "Files of Type" >dropdown, select "ODBC Databases()". It should be obvious from there :) -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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: Type conversion (String -> Int)
Will Seitz wrote: > > Hi, > I am probably missing something obvious in the documentation, but how do I > convert a string to an integer in mysql. I am sorting on a substring > (String-Number) and want the substring sorted as an integer and not a string. > > database, sql, query > > Thanks, > -Will Seitz > > - select substring(strnumb,5)+0 as subnum from mytable order by subnum; - 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
Inserting data to multiple table at once
How do I insert data into multiple tables without having to use multiple insert statements? Can I just do Insert into table1 (data) table2 (data) table3 (data) or do I have to use seperate INSERT statements for each table? I would like to add all at once from web page form $query = "INSERT INTO $table VALUES ('$menu_id', '$server', '$menunumber', '$menuname')"; -- This email was sent using w3mail. - 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: Type conversion (String -> Int)
On Wed, Apr 18, 2001 at 01:22:21PM -0400, Will Seitz wrote: > Hi, > I am probably missing something obvious in the documentation, but how do I > convert a string to an integer in mysql. I am sorting on a substring > (String-Number) and want the substring sorted as an integer and not a string. Add "+0" to the expression. > > database, sql, query > > Thanks, > -Will Seitz > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help with Mysql inport
Hello all, Just have a simple question I hope. 1. I would love to move my database in access (ms) to mysql running on my linux box (rh7.0) How would I do this? 2. Then I would like to connect threw my windows machine into the database running on the linux box. I download the MyODBS file from the site. Installed it went into ODBS set in the control panel . Here's were I get lost .. First of all I need to move or inport the database to mysql server. How would I do that. Thank you for the help Luis - 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
Type conversion (String -> Int)
Hi, I am probably missing something obvious in the documentation, but how do I convert a string to an integer in mysql. I am sorting on a substring (String-Number) and want the substring sorted as an integer and not a string. database, sql, query Thanks, -Will Seitz - 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: getting started...the hardest part
hi. "GNU `tar' saves many files together into a single tape or disk archive, and can restore individual files from the archive." gnu tar differs from the sun version of tar that comes with solaris. type tar --help to see which tar you have. if you need the gnu version, you can get it from www.sunfreeware.com hth. -ravi -Original Message- From: Simon Chan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 12:48 PM To: [EMAIL PROTECTED] Subject: getting started...the hardest part Hi Everybody! Just starting to teach myself MySql and databases. I have the O'Reilly books on Perl DBI and Mysql, msql. My question is this: I am trying to install mysql on sparc sun solaris 2.7 machine. I found a binary version in the downloads page of mysql.com (is is called Sun Solaris (Sparc)[sun-soalris2.7-sparc] ) what exactly is the "GNU Tar" command? How do I install mysql with it? Any help would be much appreciated. Many thanks everybody! Sincerely, Simon Chan __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.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: MySQL Problem
you need to login into MySQL with rights to create databases. Your being root under linux has got nothing to do with root under mysql. Mani. M >and tried to create database with : >mysql> create database cart; >ERROR 1044: ACCESS DENIED FOR USER : '[EMAIL PROTECTED]' TO DATABASE >'CART' - 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
Corrupt tables after long queries (fwd)
Hi all, Has anyone experienced anything like the following ? I have several queries which, admittedly, are quite complex and operate on several million rows of indexed data. The tables are naturally locked while the query occurs, which is fine, but what is *not* fine is that occasionally, completely unrelated tables end up needing a repair after the long query has completed. The only pattern I can see is that towards the end of the query, I see a hell of a lot of "Opening table" & "Closing table" status messages in the processlist - as soon as I see this, I can assume that the mentioned tables will have become corrupted - see a sample processlist below. Any ideas ? Cheers, P 164804 | hot | localhost | hot | Query | 6| closing tables | select * from tbl_hotclients limit 0 | | 164805 | hot | localhost | hot | Query | 6| closing tables | select * from tbl_hotclients limit 0 | | 164808 | hot | localhost | hot | Query | 14 | closing tables | select job_id from tbl_job_events where session='98760270421222662058432' and event_type='view' and | | 164809 | hot | localhost | hot | Query | 14 | closing tables | select tbl_jobs.refresh_date, tbl_jobs.job_id, tbl_jobs.title, tbl_jobs.region_id, tbl_jobs.hl_regio | | 164811 | hot | localhost | hot | Query | 5| Opening tables | select * from tbl_homepage_crazyjobs limit 0 | | 164823 | hot | localhost | hot | Query | 12 | closing tables | select * from tbl_hours where job_hours_id = 7 | | 164824 | hot | localhost | hot | Query | 6| closing tables | select * from tbl_banner_server limit 0 | | 164825 | hot | localhost | hot | Query | 54 | Locked | insert into tbl_webevents_temp (processtime,event_time,cookie,parent,referer,duration,newuser,a,job_ | | 164832 | hot | localhost | hot | Query | 10 | closing tables | select * from tbl_applications limit 0 | | 164833 | hot | localhost | hot | Query | 5| Opening tables | select * from tbl_applications limit 0 | | 164834 | hot | localhost | hot | Query | 6| closing tables | select * from tbl_applications limit 0 | | 164841 | hot | localhost | hot | Query | 10 | closing tables | select * from tbl_application_emails limit 0 | | 164842 | hot | localhost | hot | Query | 5| Opening table | insert into tbl_job_events (job_id, session, event_type, user_type, recorded, event_time, uni_id) va | --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - 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
Syncronization
Here's the situation. I have two application servers, each running their own mysql databases. If one goes down, the other takes over for it. But when it comes back up, whatever user preferences were stored on the other server during the downtime are lost. I need a way to syncronize the databases. This needs only be a periodic process, say once a day or so, running at command line with no environmental dependencies. It is not the case that one app server is the main and the other is the backup, they are both main servers, both maintaining separate lists of info, even though the type of info they store is the same (ie the load is just balanced between the two).So i need a way to do a two-way sync, so that if a situation like this arises, the user prefs are not totally from the server that went down lost. It isn't especially important to mirror everything on both servers up to the transaction. A loss of preferences over a day or two isn't that big a deal. Just something to sync them once a day so the information on both is relatively current in the context of say weeks rather than days. Suggestions? -- A. Dennison Software Developer - Server Applications Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
getting started...the hardest part
Hi Everybody! Just starting to teach myself MySql and databases. I have the O'Reilly books on Perl DBI and Mysql, msql. My question is this: I am trying to install mysql on sparc sun solaris 2.7 machine. I found a binary version in the downloads page of mysql.com (is is called Sun Solaris (Sparc)[sun-soalris2.7-sparc] ) what exactly is the "GNU Tar" command? How do I install mysql with it? Any help would be much appreciated. Many thanks everybody! Sincerely, Simon Chan __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.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
Re: Plase Let us know if there is a Racialism for Mysql product and quit
lol. guess yusuf gots some point here. Obviously, for one reason or another m$ decided to place some files in the %windir%, and some in the %windir%\system32 dir. Although it never became totally clear to me what structure they had in mind (if there is any). Roughly said: %windir% is for executables, .ini files and other stuff, and %windir%\system32 for 32-bit dll's (and %windir%\system for 16 bit dll's). but hey, take a look at a random installation, and you see loads of (especially big...) companies messing up. In the end, windows doesn't care at all where .dll's , and lot of other stuff, is placed, as long as it is in the path. Although yusuf, if you know the windows api's that well, you should also know that application .ini files should be placed in the windir. with regards, rene - Original Message - From: "Yusuf Incekara" <[EMAIL PROTECTED]> To: "John Dean" <[EMAIL PROTECTED]>; "Mysql Mailing list" <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 5:50 PM Subject: Plase Let us know if there is a Racialism for Mysql product and quit > You said : > Only those who don't read English too good. Being a native English speaker > it is very clear to me. > > > Could you please be more open and honest? > > It is obviously seen that i can easily read and write in English. > But if you disturbed that one Turk found your bug please let me know > and quit . Let all your customers become from Mansfield, England, UK. > > I am not insisting that my English is perfect. But be sure that > it is not necessary that being a native English speaker. > > I said that no matter but you are looking for a trouble ... > > If you read carefully followed instructions ( by using your perfect native > English ) > you 'll see the differences between Windows directory and System Directory. > > If still there is some issues that your perfect English mind can not > understand > please mail me. > > If you say still i am native English. No one can knows better then me even > Microsoft > so there is nothing to say. > > If you undertand your mistake and wanna apologize please forget it. > > Regards. > > Yusuf Incekara > Avukatpro Limited Sirketi > Izmit/Turkey (sorry for not being a native English but smart) > > > > > GetSystemDirectory > > Reference : Microsoft Web site : > http://msdn.microsoft.com/library/psdk/sysmgmt/sysinfo_1unt.htm > > The GetSystemDirectory function retrieves the path of the system directory. > The system directory contains such files as dynamic-link libraries, drivers, > and font files. > > UINT GetSystemDirectory( > LPTSTR lpBuffer, // buffer for system directory > UINT uSize// size of directory buffer > ); > Parameters > lpBuffer > [out] Pointer to the buffer to receive the null-terminated string containing > the path. This path does not end with a backslash unless the system > directory is the root directory. For example, if the system directory is > named WINDOWS\SYSTEM on drive C, the path of the system directory retrieved > by this function is C:\WINDOWS\SYSTEM. > uSize > [in] Specifies the maximum size of the buffer, in TCHARs. This value should > be set to at least MAX_PATH. > Return Values > > > > GetWindowsDirectory > > Reference : Microsoft Web site : > http://msdn.microsoft.com/library/psdk/sysmgmt/sysinfo_4k55.htm > > > GetWindowsDirectory > The GetWindowsDirectory function retrieves the path of the Windows > directory. The Windows directory contains such files as applications, > initialization files, and help files. > > UINT GetWindowsDirectory( > LPTSTR lpBuffer, // buffer for Windows directory > UINT uSize// size of directory buffer > ); > Parameters > lpBuffer > [out] Pointer to the buffer to receive the null-terminated string containing > the path. This path does not end with a backslash unless the Windows > directory is the root directory. For example, if the Windows directory is > named WINDOWS on drive C, the path of the Windows directory retrieved by > this function is C:\WINDOWS. If the system was installed in the root > directory of drive C, the path retrieved is C:\. > uSize > [in] Specifies the maximum size, in TCHARs, of the buffer specified by the > lpBuffer parameter. This value should be set to MAX_PATH to allow sufficient > room for the path. > > > > > > - Original Message - > From: John Dean <[EMAIL PROTECTED]> > To: Yusuf Incekara <[EMAIL PROTECTED]> > Sent: Wednesday, April 18, 2001 10:11 AM > Subject: Re: Ynt: Bug in Documentation ? > > > > At 09:29 18/04/2001 +0300, you wrote: > > >Ok . No matter for me anymore. cause i solved my problem. > > >i'm paying attention for other users not to have > > >the same problem. > > > > Only those who don't read English too good. Being a native English speaker > > it is very clear to me > > > > >Regards > > >Yusuf Incekara > > > > > > > > >- Original Message - > > >From: John Dean <[EMAIL PROTECTED]> > > >To: Yusuf Incekara <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > >Sent: Tuesday,
Re: Efficiency of MEDIUMTEXT columns?
Messages that are around 10k should be just fine, as long as they are the majority. A few tips for you... Store all the varchar/text columns for each message in a seperate table so that the primary message table only has fixed length fields (ie messageid, size, #of replies, userid, bodyid, ...). Then use the "bodyid" field as an index to the table that contains the varchar/text columns (you can do a left join on it when you need the bodies). This way it will be very fast for mysql to find a row in the primary message table. Also it will help you remember to not transfer the body unless you need it (try to make your queries return the fewest number of rows that you can live with because it reduces the strain on the server). One thing to keep in mind about using mysql with something like this with heavy load: inserts lock the table so you can not perform selects during that time (same with updates). So if you are dumping/posting a lot of messages into the table the select performance is going to suffer. If you make the inserts low priority and have a bunch of load they may not get inserted for quite a while. The innobase tables dont have this problem, but I dont think they support mediumtext column types because they have a row size limit (correct me if Im wrong). Hope this helps. ryan > Is it efficient to store things in MEDIUMTEXT columns? > > I am developing a web based system (using perl and MySQL) for viewing an > archive of mailing list messages. In my database, I have one row per > message. The column called "message" is of type MEDIUMTEXT. My perl code > retrieves it using $sth->fetchrow_hashref and then prints it. Message size > is typically ~10K; sometimes it's as high as a few hundred K. > > Here's an example URL from my site: > > http://qd.anifics.com/browse.asp?y=1995&m=12&d=30 > > I'm wondering if it's a good idea to use MEDIUMTEXT like this, or should I > put the message body into individual separate files? It runs fine right > now, but I'm worried that it won't scale up under significant load. > > -Philip Mak ([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
Plase Let us know if there is a Racialism for Mysql product and quit
You said : Only those who don't read English too good. Being a native English speaker it is very clear to me. Could you please be more open and honest? It is obviously seen that i can easily read and write in English. But if you disturbed that one Turk found your bug please let me know and quit . Let all your customers become from Mansfield, England, UK. I am not insisting that my English is perfect. But be sure that it is not necessary that being a native English speaker. I said that no matter but you are looking for a trouble ... If you read carefully followed instructions ( by using your perfect native English ) you 'll see the differences between Windows directory and System Directory. If still there is some issues that your perfect English mind can not understand please mail me. If you say still i am native English. No one can knows better then me even Microsoft so there is nothing to say. If you undertand your mistake and wanna apologize please forget it. Regards. Yusuf Incekara Avukatpro Limited Sirketi Izmit/Turkey (sorry for not being a native English but smart) GetSystemDirectory Reference : Microsoft Web site : http://msdn.microsoft.com/library/psdk/sysmgmt/sysinfo_1unt.htm The GetSystemDirectory function retrieves the path of the system directory. The system directory contains such files as dynamic-link libraries, drivers, and font files. UINT GetSystemDirectory( LPTSTR lpBuffer, // buffer for system directory UINT uSize// size of directory buffer ); Parameters lpBuffer [out] Pointer to the buffer to receive the null-terminated string containing the path. This path does not end with a backslash unless the system directory is the root directory. For example, if the system directory is named WINDOWS\SYSTEM on drive C, the path of the system directory retrieved by this function is C:\WINDOWS\SYSTEM. uSize [in] Specifies the maximum size of the buffer, in TCHARs. This value should be set to at least MAX_PATH. Return Values GetWindowsDirectory Reference : Microsoft Web site : http://msdn.microsoft.com/library/psdk/sysmgmt/sysinfo_4k55.htm GetWindowsDirectory The GetWindowsDirectory function retrieves the path of the Windows directory. The Windows directory contains such files as applications, initialization files, and help files. UINT GetWindowsDirectory( LPTSTR lpBuffer, // buffer for Windows directory UINT uSize// size of directory buffer ); Parameters lpBuffer [out] Pointer to the buffer to receive the null-terminated string containing the path. This path does not end with a backslash unless the Windows directory is the root directory. For example, if the Windows directory is named WINDOWS on drive C, the path of the Windows directory retrieved by this function is C:\WINDOWS. If the system was installed in the root directory of drive C, the path retrieved is C:\. uSize [in] Specifies the maximum size, in TCHARs, of the buffer specified by the lpBuffer parameter. This value should be set to MAX_PATH to allow sufficient room for the path. - Original Message - From: John Dean <[EMAIL PROTECTED]> To: Yusuf Incekara <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 10:11 AM Subject: Re: Ynt: Bug in Documentation ? > At 09:29 18/04/2001 +0300, you wrote: > >Ok . No matter for me anymore. cause i solved my problem. > >i'm paying attention for other users not to have > >the same problem. > > Only those who don't read English too good. Being a native English speaker > it is very clear to me > > >Regards > >Yusuf Incekara > > > > > >- Original Message - > >From: John Dean <[EMAIL PROTECTED]> > >To: Yusuf Incekara <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > >Sent: Tuesday, April 17, 2001 9:27 PM > >Subject: Re: Bug in Documentation ? > > > > > > > Hi > > > This is not a "bug" in the documentation, it is the way you have > > > interpreted what it says > > > On a Win9x/ME system the Windows-System-Directory is called x:\Windows but > > > in Windows NT and Windows 2000 it is called WinNT. If the author meant to > > > write windows(winnt)\system that is what he would have written, not > > > windows-system-directory. So I am sorry to say it is you that is wrong not > > > the documentation writer. > > > > > > At 10:00 17/04/2001 +0300, Yusuf Incekara wrote: > > > >in Mysql documents > > > >section 4.16.5 Options files > > > >it is documented as : > > > > > > > >MySQL reads default options from the following files on Windows: > > > > > > > >Filename Purpose > > > >windows-system-directory\my.ini Global options > > > >C:\my.cnf Global options > > > >C:\mysql\data\my.cnf Server-specific options > > > > > > > >windows-system-directory\my.ini Global options line is incorrect > > > > > > > > > > > >it must be corrected as : windows-directory\my.ini ? > > > >Cause when i try to use my.ini option file which is loc
Help for the Final year project..
Hi, I'm a final year student in a private Campus in Sri Lanka (Collaboration with Manchester Metropolitan University). My final year project is a Web Interface to a DBA in a Heterogeneous Databases environment. I'm basically developing my prototype for two databases Oracle and MySql. What I want is tell me reasons to choose MySql as the second database. Previously I was going to choose SQLServer (Microsoft) instead on mySql. Why I choose Oracle is I have little bit of experience and I have partly finished my OCP (DBA Track). -- Dilkushan Karunaratne, # 50/1A, Sri Indrajothi Road, Ratmalana, Sri Lanka. Tel 94 1 715716
Efficiency of MEDIUMTEXT columns?
Is it efficient to store things in MEDIUMTEXT columns? I am developing a web based system (using perl and MySQL) for viewing an archive of mailing list messages. In my database, I have one row per message. The column called "message" is of type MEDIUMTEXT. My perl code retrieves it using $sth->fetchrow_hashref and then prints it. Message size is typically ~10K; sometimes it's as high as a few hundred K. Here's an example URL from my site: http://qd.anifics.com/browse.asp?y=1995&m=12&d=30 I'm wondering if it's a good idea to use MEDIUMTEXT like this, or should I put the message body into individual separate files? It runs fine right now, but I'm worried that it won't scale up under significant load. -Philip Mak ([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
Max table size [Was: Reg. DBI error]
Hi, I'm using MySQL 3.22.32 on OpenBSD 2.7. Does there exist a maximum table size? How big (4G)? Can I avoid this in any way? -- Aigars > I'm using MySQL on OpenBSD 2.7 and I'm accessing it throhgh DBI/DBD. While > filling a large table with data I finally get the error : > > "Got error 22 from table handler" > > while trying to do an insert statment. The table file is about 4G so I > assume the file is 'full'. Can anyone confirm that the error message really > tries to convey that? > > Secondly, can I get around it? Would a start with "--big-tables" help? - 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: Output from select is not what expected
Hi, It seems like you are not "joining" the tables in any way. Say you have: Table1 --- record1_id = 1 --- record2_id = 2 Table2 --- record1_id = 3 --- record2_id = 4 Table3 --- record1_id = 5 --- record2_id = 6 If you do a select all, you get all permutations: 1, 3, 5 1, 3, 6 1, 4, 5 1, 4, 6 2, 3, 5 2, 3, 6 2, 4, 5 2, 4, 6 * records. What you want is to link the tables in some way. For instance: table 1: id int name varchar(100) table 2: id int person int address blob select * from table1, table2 where table1.id = table2.person This will only pull out records in table2, where table2's current record has a value for field "person" equal to the value of "id" in the current record in table1. I suggest you get yourself a good SQL book (any suggestions anyone?) or have a look at some online tutorials: http://www.devshed.com/Server_Side/MySQL/Intro/ has a good overview of MySQL and some examples. http://www.wdvl.com/ is a good web devlopers resource, with tips and examples of different programming languages... Hope this helps... Ben - Original Message - From: "Fates" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 2:37 PM Subject: Output from select is not what expected > I have three tables in a database called menus and I have added 2 records > to each table so 2*3=6 records. Why is it when I do a "select * from > table1, table2, table3" I get 8 records back when there are only 2 records > in each table? What am I doing wrong? Some of the fields are references > if that makes a difference? I want to list the output from all tables > together. > > Using Latest MySQL RedHat Linux RPM > -- > This email was sent using w3mail. > > > - > 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: 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: Output from select is not what expected
hi. a join across 3 tables with 2 records each will return 8 rows...2*2*2 = 8. hth. -ravi. -Original Message- From: Fates [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 9:38 AM To: [EMAIL PROTECTED] Subject: Output from select is not what expected I have three tables in a database called menus and I have added 2 records to each table so 2*3=6 records. Why is it when I do a "select * from table1, table2, table3" I get 8 records back when there are only 2 records in each table? What am I doing wrong? Some of the fields are references if that makes a difference? I want to list the output from all tables together. Using Latest MySQL RedHat Linux RPM -- This email was sent using w3mail. - 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
Efficiency of MEDIUMTEXT columns?
Is it efficient to store things in MEDIUMTEXT columns? I am developing a web based system (using perl and MySQL) for viewing an archive of mailing list messages. In my database, I have one row per message. The column called "message" is of type MEDIUMTEXT. My perl code retrieves it using $sth->fetchrow_hashref and then prints it. Message size is typically ~10K; sometimes it's as high as a few hundred K. Here's an example URL from my site: http://qd.anifics.com/browse.asp?y=1995&m=12&d=30 I'm wondering if it's a good idea to use MEDIUMTEXT like this, or should I put the message body into individual separate files? It runs fine right now, but I'm worried that it won't scale up under significant load. -Philip Mak ([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: problem
Unzipped What? Sounds like you downloaded a binary tar file. Stephen Henry wrote: > > 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. > > Stephen Henry > > __ > Do You Yahoo!? > Yahoo! Auctions - buy the things you want at great prices > http://auctions.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: Output from select is not what expected
Because 2*2*2=8. You need to put joining information in the where clause. I suggest you get a book on SQL. You might try "MuSQL" by Paul DuBois ( New Riders). Fates wrote: > > I have three tables in a database called menus and I have added 2 records > to each table so 2*3=6 records. Why is it when I do a "select * from > table1, table2, table3" I get 8 records back when there are only 2 records > in each table? What am I doing wrong? Some of the fields are references > if that makes a difference? I want to list the output from all tables > together. > > Using Latest MySQL RedHat Linux RPM > -- > This email was sent using w3mail. > > - 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
Corrupt tables after long queries
Hi all, Has anyone experienced anything like the following ? I have several queries which, admittedly, are quite complex and operate on several million rows of indexed data. The tables are naturally locked while the query occurs, which is fine, but what is *not* fine is that occasionally, completely unrelated tables end up needing a repair after thw long query has completed. The only pattern I can see is that towards the end of the query, I see a hell of a lot of "Opening table" & "Closing table" status messages in the processlist - as soon as I see this, I can assume that the mentioned tables will have become corrupted - see a sample processlist below. Any ideas ? Cheers, P 164804 | hot | localhost | hot | Query | 6| closing tables | select * from tbl_hotclients limit 0 | | 164805 | hot | localhost | hot | Query | 6| closing tables | select * from tbl_hotclients limit 0 | | 164808 | hot | localhost | hot | Query | 14 | closing tables | select job_id from tbl_job_events where session='98760270421222662058432' and event_type='view' and | | 164809 | hot | localhost | hot | Query | 14 | closing tables | select tbl_jobs.refresh_date, tbl_jobs.job_id, tbl_jobs.title, tbl_jobs.region_id, tbl_jobs.hl_regio | | 164811 | hot | localhost | hot | Query | 5| Opening tables | select * from tbl_homepage_crazyjobs limit 0 | | 164823 | hot | localhost | hot | Query | 12 | closing tables | select * from tbl_hours where job_hours_id = 7 | | 164824 | hot | localhost | hot | Query | 6| closing tables | select * from tbl_banner_server limit 0 | | 164825 | hot | localhost | hot | Query | 54 | Locked | insert into tbl_webevents_temp (processtime,event_time,cookie,parent,referer,duration,newuser,a,job_ | | 164832 | hot | localhost | hot | Query | 10 | closing tables | select * from tbl_applications limit 0 | | 164833 | hot | localhost | hot | Query | 5| Opening tables | select * from tbl_applications limit 0 | | 164834 | hot | localhost | hot | Query | 6| closing tables | select * from tbl_applications limit 0 | | 164841 | hot | localhost | hot | Query | 10 | closing tables | select * from tbl_application_emails limit 0 | | 164842 | hot | localhost | hot | Query | 5| Opening table | insert into tbl_job_events (job_id, session, event_type, user_type, recorded, event_time, uni_id) va | --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - 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
Date,time,datetime type
Hi there, If I need compare 2 fields of DATE and TIME to a field of TIMESTAMP/DATETIME in my query, what am I supposed to do? Is there a function to get DATE/TIME part from a DATETIME field, or combine DATE and TIME to a DATETIME type? 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: use of the skip_networking option
You are correct. Mike Cermak wrote: > > This is probably a silly question, but I've read the one reference to >skip_networking in the documentation and searched the archive (first rule of MySQL: >RTFM, second rule of MySQL: read it again, third rule of MySQL: do an archive search >on the term or concept you're looking for and read all relevant results), and I'm >still not totally clear about something: > > If I'm setting up a MySQL server on RedHat Linux that will only be accessed via the >following methods, can I safely start the server with the skip-networking option to >more tightly secure the server? The access methods intended are: > > PHP or perl via web browser (for both queries and administration) > console via Secure Shell (admin only, and only when necessary) > local console (admin only, and only when necessary) > > I'm thinking that skip_netowrking will prevent any network-based connections other >than via http (since the connection isn't to MySQL, but to the web server, which then >locally connects to MySQL), and that console via SSH is not a network connection to >MySQL, but a network connection to the console, which then locally connects to MySQL. >Am I correct in my assessment? If skip_networking is used, does MySQL still advertise >on port 3306? I'm thinking it shouldn't, but just want to be sure. > > Thanks for entertaining the requests of an admitted MySQL neophyte. > > Mike Cermak > > - 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
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. Stephen Henry __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.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
Output from select is not what expected
I have three tables in a database called menus and I have added 2 records to each table so 2*3=6 records. Why is it when I do a "select * from table1, table2, table3" I get 8 records back when there are only 2 records in each table? What am I doing wrong? Some of the fields are references if that makes a difference? I want to list the output from all tables together. Using Latest MySQL RedHat Linux RPM -- This email was sent using w3mail. - 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 install socket error
1. Make sure the execute bit is set ( Mode should be 755 ). 2. The shell will only execute executable files in the default path, unless specifically overridden with a valid search path. Try ./safe_mysqld Kevin J Edwards wrote: > > Hi > Thanx for your response. Umm I have read the manual. As far as I know probs >running as root are basically security. This is a test box which isn't on the net. > > I've tried running safe_sqld from the /support-files directory which is the only >place it appears. Same thing "command not found" > > Could u send a link for searching the archives - I couldn't find it on the site. > > Your patience is appreciated - I know its not much fun dealing with newbies. > > Get 250 color business cards for FREE! > http://businesscards.lycos.com/vp/fastpath/ > - 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
use of the skip_networking option
This is probably a silly question, but I've read the one reference to skip_networking in the documentation and searched the archive (first rule of MySQL: RTFM, second rule of MySQL: read it again, third rule of MySQL: do an archive search on the term or concept you're looking for and read all relevant results), and I'm still not totally clear about something: If I'm setting up a MySQL server on RedHat Linux that will only be accessed via the following methods, can I safely start the server with the skip-networking option to more tightly secure the server? The access methods intended are: PHP or perl via web browser (for both queries and administration) console via Secure Shell (admin only, and only when necessary) local console (admin only, and only when necessary) I'm thinking that skip_netowrking will prevent any network-based connections other than via http (since the connection isn't to MySQL, but to the web server, which then locally connects to MySQL), and that console via SSH is not a network connection to MySQL, but a network connection to the console, which then locally connects to MySQL. Am I correct in my assessment? If skip_networking is used, does MySQL still advertise on port 3306? I'm thinking it shouldn't, but just want to be sure. Thanks for entertaining the requests of an admitted MySQL neophyte. Mike Cermak - 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: Every host is localhost
That is correct. Web programmers must supply their own login and security measures. MySQL is a tool used by the web server. THe web server does the login in the manner the web programmer provides. The host will be the host the CGI is executing from. THe user will be the user the CGI script provides. The access privileges will be what ever the CGI script allows, limited by the privileges granted to the host and user CGI uses when connecting. Sam Yenge wrote: > > Hi > > (Re: mysql 3.23.33 ) > > I have got mysql running fine with the only problem that every connections > made to it through a web browser (using cgi scripts) are considered as > coming from localhost. In this way, I cannot limit the machines that > should be allowed access. I read the manual pages, cleaned up user and > host tables to remove all the default settings but the problem persists. > > The name of the server is being picked up from my scripts in the > my ($dbh) = DBI->connect(.:localhost/machine's name,...)... > > All other machines for which permission was granted are being ignored and > granting users permission to connect from localhost/its real name allows > access from any host which is not what I wanted. > > Wherever the connection comes from, the log file shows: > Connect username@localhost dbname > Query ... > > or > > Connect username@machinename dbname > Query ... > > Any idea?? > > Thanks > > Sam > - 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: Database Planning
The actualy tool I find that works the best is a sheet of paper.. or a white board. I write down all the fields that are required. Then find out what I can break out (normalize). After that I try to figure out what I can slice away and still get the required data. For instance, say the book price is $19.44. You also have a base cost of $18, and 8% tax. You can always write a query to find out the total cost of any book, and get rid of anything to do with the total cost in your tables. Finally I find that primary keys that have no relation to data works the best.. You could have used the ISDN number for the primary key of the book table, but it works out a whole lot easier the other way. Also what I see all the time is text fields as primary keys.. I hate that. Finally come up with some sort of logical naming convention. There is a system called the Leszynski Naming Convention (LNC), which I use where I work. cost: cost_id book_id curCost_base intCost_tax_rate curCost_total -Original Message- From: René Tegel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 2:45 AM To: Jeff Holzfaster; General MySQL List Subject: Re: Database Planning well, start with reading a book about designing databases, especially about the subject 'normalisation'. normalisation is a way to split up data ('entities') in a way that every piece of data only occurs once in your database. (although sometimes for practical reasons you may decide otherwise, but normalising your data is always a good first step!) Since you say newbies will like this, i'll try to give an example. suppose you have a database of books. The database stores the book, it's title and so on, the author, the publisher and the bookstores that sell this particulair book: book title description author author_address publisher publisher_address bookshop bookshop_address [bookshop bookshop_addr], [] well, you could try to make this fit in one table, but you'll get a tough time. so, you split up ('normalise'): books: book_id ISDN title description author_id publisher_id authors: author_id author_name author_addr author_email publishers: publisher_id publisher_name publisher_addr publisher_phone publisher_email bookshops: bookshop_id bookshop_name bookshop_addr bookshop_phone availability: available_id book_id bookshop_id So, you split up your data in more elementary parts. Especially notice how you create a table that links books to the bookshop that sell those books, you only need the two id's from the book and the bookshop. If your very smart, you might figure out by yourself further. Elsewise i still recommend to go to a (online) bookshop and get a nice book about developing databases. gl, rene - Original Message - From: "Jeff Holzfaster" <[EMAIL PROTECTED]> To: "General MySQL List" <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 4:01 AM Subject: Database Planning > I realize this may be a little OT but I'm sure many of us MySQL rookies > would be interested in the responses. > > I would be interested in hearing how someone goes about planning the layout > of their database including how they determine what tables, fields, column > types, queries, etc they will need. How do you start the process? How do > you determine the correct questions to ask of your application? Do you use > some kind of diagramming tool? Blah... Blah... Blah... > > Thanks! > > Jeff > > > - > 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: Help needed on mysql!!
What do you mean by "better" ? Next time it hangs, check your disk freespace. When MySQL runs out of tmp workspace, it waits until some becomes available. [EMAIL PROTECTED] wrote: > > Help! > I have set up a web server with PHP4, RH7 and MySQL 3.23.32. > After surfing for sometime, the browser will be in a forever loading > mode. > I use mysqladmin processlist to take a look and I saw processes > with the command "sleep" (it could be just 1 "sleep" process). > > Everytime I encounter this, I have to restart httpd server. > > Qn: How can I optimize apache, or php or mysql so that it won't "sleep"? >Where should I modify to have no such problem again? > > With a better machine config with same os/softwareconfiguration, > it seems to have no such problem...does that mean it is due to hardware? > > Please help. > TIA!! > > Regards > > - 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 socket error
Hi Thanx for your response. Umm I have read the manual. As far as I know probs running as root are basically security. This is a test box which isn't on the net. I've tried running safe_sqld from the /support-files directory which is the only place it appears. Same thing "command not found" Could u send a link for searching the archives - I couldn't find it on the site. Your patience is appreciated - I know its not much fun dealing with newbies. Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ - 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: resultset problem
[EMAIL PROTECTED] writes: > hi, > > i have a problem with mysql 2.23.36. > so far it everything works fine but since today, i get wrong resultsets > from my sql-selects - even if i try them direct over the mysql sql-editor. > one minute it works fine and the next minute an empty or incomplete > recordset is returned. > can somebody help me with this problem please??? > > kerstin Hi! CHECK your tables. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Administrator Software
Information thank you !! It is very glad. Is connection possible in other software? I can also connect with MySQL of Linux Server. Since my environment has only the Japanese environment of Windows, it cannot experiment in other environment. As much as possible, it tries to be able to solve early hard. #Is it different too? #I am sorry to be poor English. >I am using KaneyanMySQLAdmin to administrator the linux mysql server >remotely but i am unable to connect it. -- Mitsunobu Kaneko mailto:[EMAIL PROTECTED] Join Network Total Service - 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 Cygwin
Katelyn Sweet writes: > Are there c libraries that for mySQL (connecting, query and sort) that the > Cygwin compiler is compatible with? > Kate > Hi! Somewhere on Contrib or Link pages on our site there is a link to the site devoted to building MySQL with Cygwin. Also, after 3.23.37, there should not be any problem that you build it yourself, provided you upgrade to gcc 2.95.2. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
building advice needed on database structure
I have a database project, historic building materials... I've designed 4 Tables like this (there are more fields which I didn't listed here): table products - primary key(productid) - product description ... table category - primary key(categoryid) - category description table subcategory - primary key (Subcatid) - subcatdescription table subtype - primary key (suptypeid) - subtype description now I like to join those tables. For example I got the product of a single door (there are other doors which are double doors. This product belongs to subtype single doors, which than belongs to the subcategory doors and category historic building material out of wood. My aim is to have a hyperlink which shows me the categorys if click on it it shows me the subcategorys and than the subtype and than the products which belong to all this. So if I now create another table called for example table Ids - productID - categoryID - subcatID - subtypeID will I be able to join those together and get all I want to achive building it like this? Or do I have to many tables to join together? Also the Id's make up my product code say for example category b.m.o of wood makes number 10 (20, 30, 40 for others) subcategoryid will be 1 for doors (2,3,4 there after) subtype also 1 (2,3,4) and than the products will be 1, 2 , 3 etc. My logic doesn't let me think of any other way. So if anyone has a good suggestion on how to go about this please let me know. Thank you so much if you find the time to help me out here. Regards Petra [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
resultset problem
hi, i have a problem with mysql 2.23.36. so far it everything works fine but since today, i get wrong resultsets from my sql-selects - even if i try them direct over the mysql sql-editor. one minute it works fine and the next minute an empty or incomplete recordset is returned. can somebody help me with this problem please??? kerstin - 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
Every host is localhost
Hi (Re: mysql 3.23.33 ) I have got mysql running fine with the only problem that every connections made to it through a web browser (using cgi scripts) are considered as coming from localhost. In this way, I cannot limit the machines that should be allowed access. I read the manual pages, cleaned up user and host tables to remove all the default settings but the problem persists. The name of the server is being picked up from my scripts in the my ($dbh) = DBI->connect(.:localhost/machine's name,...)... All other machines for which permission was granted are being ignored and granting users permission to connect from localhost/its real name allows access from any host which is not what I wanted. Wherever the connection comes from, the log file shows: Connect username@localhost dbname Query ... or Connect username@machinename dbname Query ... Any idea?? Thanks Sam - 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: C-ISAM / MySQL integration.
DAN LYDIARD writes: > I have a program that creates C-ISAM files and I want to access the data via > mysql. > > I have a question about integrating a C-ISAM library into the mysql source. > I noticed that mysql uses myisam files, but I'm wondering what steps would > be involved to have it support C-ISAM. > Would creating a wrapper for the myisam library be enough (or rewriting the > myisam lib functions for c-isam files)? > > > Thanks. > HI! Look into all available archives. There was one user one year ago or more, that has added C-ISAM support to MySQL for his own use. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
install probs - socket error
Hi I tried a rh7 automatic install and it died when I tried to run it. Then I tried installing rh7 without mysql and doing a source install. It ran: configure make make install mysql_install_db all fine. Although I'm a little doubtful about the last one cause it didn't seem to take much time. But if I try: scripts/mysql.server start I get command not found. (yes the file is there) And if I just type: mysql I get: "Can't connect to local Mysql server through socket 'var/lib/mysql/mysql.sock' 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. TIA Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL and Cygwin
Are there c libraries that for mySQL (connecting, query and sort) that the Cygwin compiler is compatible with? Kate - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error: Didn't find any fields in table 'name'
Ide, Jim writes: > > Pentium III 667 mhz, 256mb ram, 20 gb hd > OpenBSD 2.7 > MySQL 3.22.32 (installed with pkg_add mysql-3.22.32.tgz) > started with: > safe_mysqld --user=mysql > /dev/null & > > I have several text files that look like this: > use mydb; > create table mytable ( > (field defs) > ); > > I run: > mysql < file.sql > > Then I run: > mysql mydb > > mysql displays: > 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 'table1' > Didn't find any fields in table 'table2' > Didn't find any fields in table 'table3' > Didn't find any fields in table 'table4' > Didn't find any fields in table 'table5' > Didn't find any fields in table 'table6' > Didn't find any fields in table 'table7' > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 28 to server version: 3.22.32 > > Type 'help' for help. > > mysql> > > When I go to the data directory and type > ls -l *.ISD > many of the *.ISD files are zero length. > > Why am I using OpenBSD 2.7? Because MySQL doesn't work on OpenBSD 2.8 > because of a bug in OpenBSD (http://www.mysql.com/doc/O/p/OpenBSD_2.8.html) > > Please help! > Thanks - > Jim > Hi! The above can not work on any system. create table mytable ( (field defs) ); This will cause parsing error on any system. If the aobve is just an abbreviation, then you have most probably a permission problem. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help needed on mysql!!
Help! I have set up a web server with PHP4, RH7 and MySQL 3.23.32. After surfing for sometime, the browser will be in a forever loading mode. I use mysqladmin processlist to take a look and I saw processes with the command "sleep" (it could be just 1 "sleep" process). Everytime I encounter this, I have to restart httpd server. Qn: How can I optimize apache, or php or mysql so that it won't "sleep"? Where should I modify to have no such problem again? With a better machine config with same os/softwareconfiguration, it seems to have no such problem...does that mean it is due to hardware? Please help. TIA!! Regards - 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
"It does exactly what it says in the tin" > ERROR 1044: ACCESS DENIED FOR USER : '[EMAIL PROTECTED]' TO DATABASE 'CART' You'll have to get permission to create the database. If you are the MySQL admin, lookup "grant" in order to give user "ABHI" access. Something like: grant all on cart.* to [EMAIL PROTECTED] identified by "somePassword" If you are not, you will need to ask your ISP / DB admin to do this for you. Hope this helps. Ben - Original Message - From: "Anoop k gupta" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 11:08 AM Subject: MySQL Problem > Hi Everybody, > > I need your help. > Thanks .. > > I was trying to create database on MySQL > but it is giving error. > > 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' > > > > > > _ > Chat with your friends as soon as they come online. Get Rediff Bol at > http://bol.rediff.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: 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
MySQL Problem
Hi Everybody, I need your help. Thanks .. I was trying to create database on MySQL but it is giving error. 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' _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.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: Query syyntax error, help needed
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html here says that mysql does not support sub-selects thus you see errors. also here shows you that how to rewrite sub-selects. - Original Message - From: "Nicolas Villatte" <[EMAIL PROTECTED]> To: "Mysql (E-mail)" <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 5:35 PM Subject: Query syyntax error, help needed > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Query syyntax error, help needed > > SELECT descpays.libelle FROM descpays WHERE descpays.pays_id IN > (SELECT pays.pays_id FROM pays where pays.pays_ref IS NULL) > > I cannot find the error. > please could someone help me ? > > -BEGIN PGP SIGNATURE- > Version: PGP 7.0.4 > > iQA/AwUBOt1fx4iKIkRfAqJVEQJlKgCgtXPrXclGAkFo3C/A1U01GQBPLUwAoI4H > gMmlG7Cg16eRhxeuQbHg8Jfx > =W/NV > -END PGP SIGNATURE- > > > > - > 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
Reg. DBI error
I'm using MySQL on OpenBSD 2.7 and I'm accessing it throhgh DBI/DBD. While filling a large table with data I finally get the error : "Got error 22 from table handler" while trying to do an insert statment. The table file is about 4G so I assume the file is 'full'. Can anyone confirm that the error message really tries to convey that? Secondly, can I get around it? Would a start with "--big-tables" help? -- Aigars - 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: Query syyntax error, help needed
On 18-Apr-01 Nicolas Villatte wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Query syyntax error, help needed > > SELECT descpays.libelle FROM descpays WHERE descpays.pays_id IN > (SELECT pays.pays_id FROM pays where pays.pays_ref IS NULL) > > I cannot find the error. > please could someone help me ? paste as one line in your browser: http://www.mysql.com/documentation/mysql/bychapter/ manual_Compatibility.html#Missing_Sub-selects -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query syyntax error, help needed
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Query syyntax error, help needed SELECT descpays.libelle FROM descpays WHERE descpays.pays_id IN (SELECT pays.pays_id FROM pays where pays.pays_ref IS NULL) I cannot find the error. please could someone help me ? -BEGIN PGP SIGNATURE- Version: PGP 7.0.4 iQA/AwUBOt1fx4iKIkRfAqJVEQJlKgCgtXPrXclGAkFo3C/A1U01GQBPLUwAoI4H gMmlG7Cg16eRhxeuQbHg8Jfx =W/NV -END PGP SIGNATURE- - 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: Possible bug in 3.23.32 or later
As Far as I can remember it is explicitly said in the Manual that inserting a negative value in an autoincrement field is a Bad Thing - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 6:14 AM Subject: Possible bug in 3.23.32 or later > >Description: > When i insert into a negative integer into primary key (id int) field, it works fine. > However, the next insert i do without specifing the id explicitly and relying on mysql to > generate the next number in the sequence (should be 1) will use the upper bound (2^32 - 1) > Then every other insert after that will not insert since there are no id's available. > > > >How-To-Repeat: > > CREATE TABLE category > ( > idINT NOT NULL AUTO_INCRE17;6, > name VARCHAR(50) NOT NULL, > code VARCHAR(50) NOT NULL, > description TEXT, > picture VARCHAR(50), > parentINT NOT NULL DEFAULT 0, > activeTINYINT, > members INT NOT NULL DEFAULT 0, > storeid INT, > feature1 INT NOT NULL DEFAULT 0, > feature2 INT NOT NULL DEFAULT 0, > priority INT, > KEY (code), > KEY (name), > PRIMARY KEY (id) > )\g > > > INSERT INTO category (id,name,code,description,picture,parent,active,members,storeid,feature1,fea ture2) VALUES (-10,'NEW','NEW','All new products','none',-1,0,0,1,0,0); > > Then try: > INSERT INTO category (name,code,description,picture,parent,active,members,storeid,feature1,featur e2) VALUES ('test','test','All test products','none',-1,0,0,1,0,0); > > That should make the id 2^32 -1 (or something aroudn there). > > That id should be 1!!! > > > >Fix: > > > > >Submitter-Id: > >Originator: Duane Homick > >Organization: > Inline Internet Systems, Inc. > > >MySQL support: none > >Synopsis: bug in primary key insert with negative integers > >Severity: serious > >Priority: medium > >Category: mysql > >Class: sw-bug > >Release: mysql-3.23.32 (TCX binary) > > >Environment: > > > - > 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