Re: reports? from MySQL (oops, on a Mac)

Date |Wed, 29 Aug 2001 03:15:50 -0400 >From |[EMAIL PROTECTED] Hello! G> dumb question: what do i put for macintosh G4/450 OS X? I all case you need 3 things - X Window, gcc, Mysql. I use Siag on OS/2, MS Windows and all Unixes - so it's will work with MacOS X.

Re: reports? from MySQL (oops, on a Mac)

so, does this mean: siag works in Mac OS X, but in X Windows, i.e., XonX? and, do i then have to use MySQL for X Windows (XFree86) system also or can i use the same MySQL i have for/on OS X itself? thank you. At 12:22 PM +0500 8/29/01, Grigory Bakunov wrote: >Date |Wed, 29 Aug 2001 03:15:50 -

mysql BLOB field -- need help

I'm exhausted by the BLOB field in MySQL. I cann't get the content of the BLOB field. Is there anyone who will kindly point out the correct direction for me? A piece of code will be especially appreciated. I'm using VC and ADO. Thanks. ---

Re: Roles

Date |Tue, 28 Aug 2001 09:41:02 -0700 >From |John Meyer <[EMAIL PROTECTED]> Hello! JM> In Oracle, I remember working with roles that I could assign to a user. Is JM> there such a mechanism, or are there plans to implement such a mechanism, JM> in MySQL. If you mean level based priveleges the

Re: Please..Desperate for Help |||||||

Date |Tue, 28 Aug 2001 12:30:25 -0400 >From |<[EMAIL PROTECTED]> Hello! N> I am trying to install the "dbf2mysql" converter and really N> getting a headache. Someone told me that I need to N> install the "Include files and libraries for MySQL" and I N> have been searching frantically all over

Re: show create table URGENT

Date |Tue, 28 Aug 2001 23:43:16 +0200 >From |"Martin Jeremic" <[EMAIL PROTECTED]> Hello! MJ> This is really stupid, but I can remember how to save results of "SHOW MJ> CREATE TABLE tbl_name" and "SHOW COLUMNS FROM tbl_name" in to text file. I'm MJ> running mysql 23.41 on Win2k. MJ> Thanks in ad

Re: Root password revisited

Date |Tue, 28 Aug 2001 19:09:49 -0700 >From |"Gregg Baker" <[EMAIL PROTECTED]> Hello! GB> Hi all, I got a "No Database Chosen". What's the syntax for adding the GB> database? I tried *.*, mysql, and test between UPDATE and user but all GB> returned syntax error. GB> Thanks much, Gregg GB> UPDA

RE: mySQL

Thomas, What is the connection string you are using? Bruce -Original Message- From: Thomas Ekegren Christensen [mailto:[EMAIL PROTECTED]] Sent: Tue, 28 August 2001 18:43 To: [EMAIL PROTECTED] Subject: mySQL Hi mySQL, I have a huge problem and unfortunately my Domain Hosting Services

Re: reports? from MySQL (oops, on a Mac)

Date |Wed, 29 Aug 2001 03:33:45 -0400 >From |[EMAIL PROTECTED] Hello! G> so, does this mean: G> siag works in Mac OS X, but in X Windows, i.e., XonX? yes. G> and, do i then have to use MySQL for X Windows (XFree86) system also G> or can i use the same MySQL i have for/on OS X itself? you can

Re: mysql BLOB field -- need help

On 29-Aug-01, Zhenjiang Guo wrote: > I'm exhausted by the BLOB field in MySQL. > I cann't get the content of the BLOB field. > Is there anyone who will kindly point out the correct direction for me? > A piece of code will be especially appreciated. > I'm using VC and ADO. > Thanks. As far as I

Re: MySQL + ODBC + palm + security?

Why not just setup a ssh tunnel and replicate? brett Venu wrote: > Hi !!! > > Can anyone has the answer for him ? How we can have a secure data transfer > over the web using MySQL and its APIs ? He is desperately needed some idea > in order to take further steps with MySQL ? > > Regards > Ven

Re: MySQL Still a wise choice for developers?

Hi, just a quick note. > A) There's no *point* in keeping the image in the database. > A DBMS is all about searching, comparing, relations, etc. You > get *none* of these by storing the image data in the DB. Correct if you have a small amount of images, problem if you have thousands of these p

Re: MySQL + ODBC + palm + security?

If the webbrowser is your client program and you access the database via the webserver. Wy not use http commands "POST" or "GET" to transmitt the sensitive data to the www server runnning encrypted transmission via "https://"; /Peter Brett Geer wrote: > > Why not just setup a ssh tunnel and

Re: FULLTEXT exact match queries?

Hi! On Aug 28, Alok K. Dhir wrote: > > > select * from Laws WHERE MATCH(Line) AGAINST ('growth > > hormone') AND Line like '%growth hormone%' ORDER BY ID; > > This defeats the purpose of the fulltext index, don't you think? > > Al Not really, as fulltext index is used to find the documents t

Re: mysql BLOB field -- need help

Yes, I tried a TEXT field. Error occurs when calling Recordset->Fields->GetItem(0L)->AppendChunk(lSize). But the same code runs well when I changed to an Access table. Thanks On Wed, 29 Aug 2001 10:18:54 +0200 Carl Troein <[EMAIL PROTECTED]> wrote: > > As far as I know a BLOB is just a TEXT w

Re: Root password revisited

At 17:44 28-8-01 -0700, Gregg Baker wrote: >Hi all, I just joined list. I spent a couple hours in the archive and >decided MySQL better improve their install message regarding setting the >root password! Half the posts are about it going badly. ;) When installing from source you will get a messag

ANNOUNCE: moodss-14.5

Hi everybody: here is a new version of moodss. Check it out! (or at least the screenshots at http://jfontain.free.fr/moodss3.gif or http://jfontain.free.fr/moodss4.gif :). ### CHANGES ### --- version 14.5 --- added panes to thresholds dialog box for easier user interaction thresholds dialog b

Re: MySQLgui problems

Stefan Murariu writes: > > > [EMAIL PROTECTED] wrote: > > >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,table > > > >If you

Re: MySQLGUI Version 1.7.5 Question and Comment

Marion Berryman writes: > I've been trying out MySQLGUI Version 1.7.5, and it seems to work fine on my Win >98SE client. I do have a question about the menu entries under Commands, Tables for >"Edit table" and "Create tables". I've searched through the help file and didn't >find any mention of

Re: problems compiling on FreeBSD 3.3 (mysql-3.23.41)

Angel Behar writes: > I just update the gcc version and still the same problem : > > absa# gcc -v > Reading specs from > /usr/local/lib/gcc-lib/i386-unknown-freebsd3.3/3.0.1/specs > Configured with: ../configure --enable-languages=c++ > Thread model: posix > gcc version 3.0.1 > > > Any Ideas ?

Setting User Privilges ? Confused !!

I am pretty new to MySQL, in fact that also covers Linux as well. I have Mandrake 8.0 which I have installed MySQL using the RPM format. I plan to write code (python) to access the database to manage what data it may hold. The server automatically starts on boot - which is fine. To be able t

Lost Root password

Dear List, I have lost the root password to my MySQL installation. What is the quickest way to remedy this situation, uninstall and reinstall MySQL or what???. My installation runs on a RaQ4 server. Thanks for your help in advance Regards Temi == Tel: +44(0)702 112 0990 * Fax: +44(0)8707 44

Re: Lost Root password

At 03:39 29-8-01 -0700, temi odurinde wrote: >Dear List, >I have lost the root password to my MySQL installation. What is the >quickest way to remedy this situation, uninstall and reinstall MySQL or >what???. My installation runs on a RaQ4 server. Take a look at the manual and this lists archi

Re: compiling mysql with InnoDB for AMD Athlon cpu

Stanislav Dmitrenko writes: > G'day, > > Is it possible to compile mysql with InnoDB for AMD Athlon processor ? > Error produced during compilation follows: > > make[4]: Entering directory `/usr/local/src/mysql-3.23.41/innobase/sync' > gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../includ

[Fwd: Maximum number of keys]

Hi, Sorry to repost my question but I did not get any answer. What is the maximum number of keys for a MyISAM table (without rebuilding mysqld from source), 16 as specified in error message or 32 as in doc. ? Thanks Original Message Subject: Maximum number of keys Date: Tue,

Use of the MySQL logo - licensing agreement

I've been looking at upgrading the logo on several of my personal web sites to the new, cooler logo, so I popped over to http://www.mysql.com/downloads/logos.html, which led me to http://www.mysql.com/company/trademark.html and the shock of my life: [...] Generally, no person or entity may use an

Re: Use of the MySQL logo - licensing agreement

This is just a WAG ... but do you suppose this is a result of the flap with NuSphere? Gerry - Original Message - From: "Ed Carp" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 6:27 AM Subject: Use of the MySQL logo - licensing agreement I've been looking a

RE: Use of the MySQL logo - licensing agreement

> This is just a WAG ... but do you suppose this is a result of the > flap with > NuSphere? I agree - but man, have they ever screwed it up for the rest of us! For this great database engine to be led around by the nose by lawyers is sad. I mean, I understand protecting the corporate jewels, but

RE: Use of the MySQL logo - licensing agreement

Ed: I would hope that someone from MySQL AB will address this. It is particularly important to those of us who purchased blocks of licenses under TcX's OEM arrangement. We have an OEM agreement for another software product with a Canadian company. The written agreement is very simple, but grants

RE: Use of the MySQL logo - licensing agreement

Gerald Jensen writes: > Ed: > > I would hope that someone from MySQL AB will address this. It is > particularly important to those of us who purchased blocks of licenses under > TcX's OEM arrangement. > > We have an OEM agreement for another software product with a Canadian > company. The writte

Re: MySQL Web Site Changes

The new web site looks great and none of the old functionality has been lost. Except ... On the documentation listing for one-page-per-chapter and one-big-page, the keywords and commands, like 'SELECT' and 'GRANT' used to be in a different color (purple in that case) which made it very easy to s

RE: Use of the MySQL logo - licensing agreement

Sinisa: I'm not looking for anything to be cleared out (as in removed). My point, and I believe Ed's point, is that I'm not clear on use of the MySQL logo in my software, printed material, etc. Gerry -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Wednesday

Server overload problems

Hi people, Can you tell me how to monitor the server load and the mysql processes for a a normal user on a shared Linux sistem. We've launched a new version of our BestJobs.ro site (more complex in sql queries than the last version) and it apperar that is crasching the machine, by overloading it

RE: Use of the MySQL logo - licensing agreement

> My point, and I believe Ed's point, is that I'm not clear on use of the > MySQL logo in my software, printed material, etc. What concerns me is that the new logo licensing stuff is so restrictive, *anyone* who even displays the logo on a web site ("powered by MySQL") has to get WRITTEN PERMISSI

RE: Use of the MySQL logo - licensing agreement

>Does that make any sense? I'm not trying to slam MySQL, I'm just concerned >about displaying the logo on a web site that says "powered by MySQL" or >modifying the logo like folks used to do to produce all kinds of cool >enhancements to the name MySQL. Did you try to get permission?? I'll bet i

RE: Use of the MySQL logo - licensing agreement

Unfortunately if they don't have something in place like this, then a company can come along and hijack the 'mySQL' name/logo for their own ends. A company has to make a sincere effort to protect its trademarks else it will fall into the public domain. Then a NuSpherish company can come along, use

Re: Setting User Privilges ? Confused !!

By default you have record for anonimous user with any name and no pass in your access tables, thats lock access any other user from localhost with password to database. Just delete this anonimous user from mysql access tables On Wed 29 Aug 2001 13:08, Peter Moscatt wrote: > I am pretty new to

Join Problem

I've been staring at the following query for a day. I'm sure it's something obvious but I just don't see it. There are two table, Recipes which contains one row per recipe. The second in Ingredients while holds one row per ingredient. The Ingredients table has a field containing t

Re: RE: Use of the MySQL logo - licensing agreement

B. van Ouwerkerk ([EMAIL PROTECTED]) writes: > Now.. what would you prefer.. many forks all using the same logo or that > they require you to ask for their permission. Actually, I'd prefer a bunch of derivitive logos, like before, so I could choose the best-looking database logo based on my web

im puzzled

Hi , this is my query SELECT users.uid FROM users, picks WHERE users.uid = picks.user_id; this works correctly. The results are what they are supposed to be: However, when I change the = sign to a <> or !=, The results are completely incorrect. -- picks.user_i

RE: Join Problem

You could try using an AND in the WHERE statement. EG. SELECT DISTINCT R.ID, R.CatCode, R.Title FROM Recipes R, Ingredients I WHERE I.Description LIKE "%$SearchKey%" AND R.ID = I.ID; Hope this helps. Andrew Murphy -Original Message- From: Urb LeJeune [mailto:[EMAIL PRO

Primary Key pairs and auto-incrementing

I want to create a table with two Primary Keys. The first key is a category field, and the second is auto-incremented. Example: Key 1=Chapter name, Key 2 =section number. For example, (Chapter1, 1) (Chapter1, 2) (Chapter1, 3) then with a new Cheaper, I want to restart the auto-incremented field

Re: Server overload problems

Catalin Tenita ([EMAIL PROTECTED]) writes: > Hi people, > > Can you tell me how to monitor the server load and the mysql processes for a > a normal user on a shared Linux sistem. For monitoring the machine itself, I usually use "top". For monitoring the database, I like "mysqladmin processlist

Re: Lost Root password

temi odurinde ([EMAIL PROTECTED]) writes: > Dear List, > I have lost the root password to my MySQL installation. What is the quickest way to >remedy this situation, uninstall and reinstall MySQL or what???. My installation >runs on a RaQ4 server. The quickest way is to RTFM :) The searchable

RE: Use of the MySQL logo - licensing agreement

Gerald Jensen writes: > Sinisa: > > I'm not looking for anything to be cleared out (as in removed). > > My point, and I believe Ed's point, is that I'm not clear on use of the > MySQL logo in my software, printed material, etc. > > Gerry > You are quite correct. This issue will be set straig

Re: MySQL Web Site Changes

Philip Molter writes: > The new web site looks great and none of the old functionality has been > lost. > > Except ... > > On the documentation listing for one-page-per-chapter and one-big-page, > the keywords and commands, like 'SELECT' and 'GRANT' used to be in a > different color (purple in t

Problem running mysql_install_db

Platform: Solaris 2.6 SPARC I am attempting to install the binary distribution of MySQL on a Sun Netra 1120 running Solaris 2.6. The file I downloaded is: mysql-3.23.39-sparc-sun-solaris2.6.tar I used GNU tar to unpack the distribution. When I try running the script my_install_db, I get the f

Re: im puzzled

And that is correct. You are getting each users.uid that doesn't match each picks.userid. Jeremy Morano wrote: > Hi , > > this is my query > > SELECT users.uid FROM users, picks WHERE users.uid = picks.user_id; > > this works correctly. The results are what they are supposed to be: > However,

RE: RE: Use of the MySQL logo - licensing agreement

Why not get MySQL to make a series of slightly different logos you can choose from like Sun and other companies do. Some are colour, others greyscale, and some are inverse for placement on black backgrounds. Andrew Murphy -Original Message- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent:

multiple PRI indexes

is it generally recommended / a good idea to have more than one PRI index in the same table? i've never seen that before until today while trying to track down bugs in someone else's system and noticed a table with 2 PRI indexes. will this cause any problems? tia. ~shawn

Re: im puzzled

At 10:36 AM -0400 8/29/01, Jeremy Morano wrote: >Hi , > >this is my query > >SELECT users.uid FROM users, picks WHERE users.uid = picks.user_id; > >this works correctly. The results are what they are supposed to be: >However, when I change the = sign to a <> or !=, The results are completely >inco

RE: multiple PRI indexes

> is it generally recommended / a good idea to have more than one PRI index > in the same table? i've never seen that before until today while trying > to track down bugs in someone else's system and noticed a table with 2 PRI > indexes. will this cause any problems? It shouldn't cause any prob

RE: Primary Key pairs and auto-incrementing

> I want to create a table with two Primary Keys. The first key is > a category > field, and the second is auto-incremented. Example: Key > 1=Chapter name, Key > 2 =section number. For example, (Chapter1, 1) (Chapter1, 2) (Chapter1, 3) > then with a new Cheaper, I want to restart the auto-incre

Re: im puzzled

I suspect he wants: SELECT users.uid FROM users LEFT JOIN picks ON users.uid = picks.user_id WHERE picks.user_id IS NULL Paul DuBois wrote: > At 10:36 AM -0400 8/29/01, Jeremy Morano wrote: > >> Hi , >> >> this is my query >> >> SELECT users.uid FROM users, picks WHERE users.uid = picks.user

Re: Lost Root password

i don't know how your RaQ4 works, but on the Qube3 I had a time getting mySQL to shut down.. it did not show up in the list of processes running... ended up using "killall mysql", then restarted the mysql in "safe" mode.. issue a set password query to update root password, and you are on your way!

Replication problems involving time

Am I the only one that thinks that mysql ought to replicate NOW, CURRENT_DATE, etc. as the time when those actual inserts happened not as NOW,CURRENT_DATE,etc. If you are replicating accross a distance (12,15,20 hops) and there is a connectivity problem, then you end up with data that is out of s

Problems getting into MySQL.com

Is anybody else not able to get onto mysql.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

Re: [MySQL] Problems getting into MySQL.com

Philip Daggett wrote: > Is anybody else not able to get onto mysql.com??? Looks like, it'd be down... -- W | I haven't lost my mind; it's backed up on tape somewhere. + Ashley M. Kirchner .

RE: Problems getting into MySQL.com

Seems dead from where I am in the UK, Was up earlier (3PM GMT). Strange -Original Message- From: Philip Daggett [mailto:[EMAIL PROTECTED]] Sent: 29 August 2001 17:51 To: [EMAIL PROTECTED] Subject: Problems getting into MySQL.com Is anybody else not able to get onto mysql.com???

Re: Problems getting into MySQL.com

Philip Daggett writes: > Is anybody else not able to get onto mysql.com??? Hi, We're working on it. The eth card seems to have bombed, and the admins at our hosting facility (andover, where slashdot and freshmeat are) are working on it ASAP. Matt -- For technical support contracts, visit

Re: Problems getting into MySQL.com

yes, i just tried and failed - Original Message - From: "Philip Daggett" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 9:50 AM Subject: Problems getting into MySQL.com > Is anybody else not able to get onto mysql.com??? > > > --

Re: multiple PRI indexes

At 10:33 AM -0500 8/29/01, shawn reed wrote: >is it generally recommended / a good idea to have more than one PRI index >in the same table? i've never seen that before until today while trying >to track down bugs in someone else's system and noticed a table with 2 PRI >indexes. will this cause a

Re: Primary Key pairs and auto-incrementing

At 10:37 AM -0400 8/29/01, Ferrara, Joseph C wrote: >I want to create a table with two Primary Keys. The first key is a category >field, and the second is auto-incremented. Example: Key 1=Chapter name, Key >2 =section number. For example, (Chapter1, 1) (Chapter1, 2) (Chapter1, 3) >then with a n

Re: [MySQL] Problems getting into MySQL.com

seems like a dns problem... anybody knows mysql.com's ip? - Original Message - From: "Ashley M. Kirchner" <[EMAIL PROTECTED]> To: "Philip Daggett" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 2:54 PM Subject: Re: [MySQL] Problems getting into MySQL.com >

RE: [MySQL] Problems getting into MySQL.com

Name:www.mysql.com Address: 64.28.67.70 at least according to my NSlookup.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:22 PM To: [EMAIL PROTECTED]; Philip Daggett Cc: [EMAIL PROTECTED] Subject: Re: [MySQL] Problems getti

Re: [MySQL] Problems getting into MySQL.com

it's up again. with a content management system. nice work, guys. it was down for a good cause, after all... great! new site ;) rds mau - Original Message - From: "Sica, Bill" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 2:29 PM Subject: RE: [MySQL] Proble

Re: Use of the MySQL logo - licensing agreement

Sinisa Milivojevic wrote: > > Gerald Jensen writes: > > Sinisa: > > > > I'm not looking for anything to be cleared out (as in removed). > > > > My point, and I believe Ed's point, is that I'm not clear on use of the > > MySQL logo in my software, printed material, etc. > > > > Gerry > > > > You

Re: multiple PRI indexes

He may mean a composite primary key, which is a primary key based on two columns. On whether this is a good idea or not it's really a question of whether you want to use natural or surrogate keys on your tables. A composite key is typically a natural key. A natural key is a key with information

SQL Problem

i have a MySQL DB whit this tabel: Id ColPoint CntDateTime Cnt1 Cnt2 Cntx. Cnt32 11 2001-08-01 00:05:0012 14 21 2001-08-01 00:10:0011 12 31 2001-08-01 00:15:00109 41 2001-08-01 00:20:000

Group by

i have a tabel whit 5 min counting Id CntDateTime Cnt1 1 2001-08-01 00:05:0012 2 2001-08-01 00:10:0011 3 2001-08-01 00:15:0010 4 2001-08-01 00:20:000 5 2001-08-01 00:25:006 6 2001-08-01 00:30:0014 7 2001-08-01 00:35:0011 . . What i want is to make a Se

RE: RE: Use of the MySQL logo - licensing agreement

At 16:10 29-8-01 +0100, Andrew Murphy wrote: >Why not get MySQL to make a series of slightly different logos you can >choose from like Sun and other companies do. Some are colour, others >greyscale, and some are inverse for placement on black backgrounds. It would still violate their trademark ca

RE: cannot get mysqld to start

Dana, Thanks for looking into this further. I did all that, and ran the command mysql_install_db instead of mysql_install_db --user=mysql & as they said in the install guide! I have no clue of the difference between the two and reason why it should work on one and not on another. Would apprec

Hot Backups

What's the best way of doing a hot backup on a database? Our server is set up in such a way that it's not a simple matter to shut down apache/mysql and do the backup then. So, is it safe to just copy the mysql directories, or is there some recommended procedure for this? Matthew Walker System Adm

Re: Hot Backups

The way I am planning on doing it is setting up another server that I replicated to and backing that server up. I would like to hear how other people are backing up servers without interupting service. Dave On Wed, Aug 29, 2001 at 12:50:06PM -0600, Matthew Walker wrote: > What's the best way of

Re: SQL Problem

SELECT (t1.cnt1 + t2.cnt3 - t3.cnt11) FROM table t1, table t2, table t3 WHERE t1.ColPoint=1 AND t2.ColPoint=5 AND t3.ColPoint=2 AND t1.id=1 AND t2.id=t1.id AND t3.id=t1.id Of course, self joins can be expensive, this grows in complexity as you need to add/subtract more counts ,and this is not ge

Re: Hot Backups

I'm doing a mysqldump and then backing up the resulting text file. Works fine, doesn't interupt anything, and doesn't have any problems with a live server. IIRC, mysqldump locks a table before it dumps, so there won't be any funny records. Or course, mysqldump could catch the database in the

Re: Hot Backups

Any problems with data inconsistencies? Dave On Wed, Aug 29, 2001 at 10:52:26AM -0800, Joshua J. Kugler wrote: > I'm doing a mysqldump and then backing up the resulting text file. Works > fine, doesn't interupt anything, and doesn't have any problems with a live > server. IIRC, mysqldump lock

Re: Hot Backups

Didn't read your last item before I fired my last message off. If mysqldump locks the table before it dumps then it is interupting service. If I have a high number of transactions they're blocked until the lock is released. Dave On Wed, Aug 29, 2001 at 10:52:26AM -0800, Joshua J. Kugler wrote: >

RE: Group by

On 29-Aug-2001 Morten Søndergaard wrote: > i have a tabel whit 5 min counting > > Id CntDateTime Cnt1 > 1 2001-08-01 00:05:0012 > 2 2001-08-01 00:10:0011 > 3 2001-08-01 00:15:0010 > 4 2001-08-01 00:20:000 > 5 2001-08-01 00:25:006 > 6 2001-08-01 00:30:0014

RE: Hot Backups

I've tried using mysqldump, and it doesn't seem to be working on our computer. A little more info on our setup is in order, I think. We're running on Iserver, and have a virtual BSD machine. Most of the binaries are in the 'true' machine's folders, and a few are in our virtual machine's folders.

RE: Hot Backups

First of all, I'd like to point to the documentation =] http://www.mysql.com/doc/B/a/Backup.html The other option not mentioned there but that another list member suggested is the best way to backup a live database. The above two methods work, but with larger databases, having the tables locked

Re: cannot get mysqld to start

Quoteth the install guide: shell> cd mysql_installation_directory shell> ./bin/mysql_install_db shell> ./bin/safe_mysqld --user=mysql & This is always the way to start a fresh mysql install. Note that safe_mysqld gets the --user arg ( and is run in the background with & ). Also remember to set y

RE: cannot get mysqld to start

HMM. Now I dont know why I always failed to get mysql up with the 'right' command... I am looking into setting my root password right now But please tell me if I am doing something wrong by running just safe_mysqld instead of with the parameters... Thanks, Sheena. -Original Message-

discussion: mysql licensing issue and funding issues

I would like to comment on the following mysql.com question "We have made our product available at zero price under the GNU General Public Licence (GPL), and we also sell it under a commercial licence to those who do not wish to be bound by the terms of the GPL." Out of curiosity, how does t

Re: discussion: mysql licensing issue and funding issues

Neil Zanella <[EMAIL PROTECTED]> writes: > I would like to comment on the following mysql.com question > > "We have made our product available at zero price under the GNU > General Public Licence (GPL), and we also sell it under a commercial > licence to those who do not wish to be bound by t

Re: New kid on the block ...

Hi, We have developped commercial windows application using a software called DataEase. We need a more professional development system and are presently researching such a product. I checked the MySQL manual and the field types needed are supported. Our basic question is whether or not MySQL can

RE: Setting User Privileges ? Confused !!

I have the same problem and have looked all over for the solution. You have to delete the anonymous user from which table? I would assume the users table? -Original Message- From: Roman Festchook [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 10:05 To: Peter Moscatt; MySQL

MERGE TABLES

I'm not sure if this is a bug or if this is the way MERGE TABLES works in MySQL. It seems that if I have an INDEX in a field (id for instance), and I try to SELECT using a WHERE id=NUMBER, it will fail, even though that NUMBER is a valid id. ID is an int unsigned field with a key on it. However,

Licensing terms for an Intranet site

If I'm using MySQL for an intranet site within my corporation, is there any licensing required? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Re: Licensing terms for an Intranet site

On Wed, Aug 29, 2001 at 02:17:56PM -0700, John Meyer wrote: > If I'm using MySQL for an intranet site within my corporation, is > there any licensing required? Nope. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408

RE: Licensing terms for an Intranet site

"For normal internal use, MySQL costs nothing. You do not have to pay us (them) if you do not want to." -Original Message- From: John Meyer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 5:18 PM To: [EMAIL PROTECTED] Subject: Licensing terms for an Intranet site If I'm usin

RE: discussion: mysql licensing issue and funding issues

> I would like to comment on the following mysql.com question > > "We have made our product available at zero price under the GNU > General Public Licence (GPL), and we also sell it under a commercial > licence to those who do not wish to be bound by the terms of the GPL." > > Out of curiosit

Newbie question

I have put a new web server and would like to put a board on it. But when I try to I get an error. I know it is a sql error. On the install I did the configure with apache but I got a few errors. Not sure if I did it right. Well at this point I need it configured for PHP4 and MySql. PHP4 is workin

mysqld as root

Wasn't there something awhile back that was supposed to prevent running the daemon as root? When the daemon was started through safe_mysqld it would tell you to select a user as root you had to use --user=root, this seems to be gone! from the manual: F.2.26 Changes in release 3.23.15  To start

Re: Newbie question

Tom Hicks <[EMAIL PROTECTED]> writes: > I have put a new web server and would like to put a board on it. But when I > try to I get an error. I know it is a sql error. On the install I did the > configure with apache but I got a few errors. Not sure if I did it right. > Well at this point I need i

RE: Newbie question

Is php compiled with the mysql option? -Mensaje original- De: Tom Hicks [mailto:[EMAIL PROTECTED]] Enviado el: Wednesday, August 29, 2001 13:43 Para: '[EMAIL PROTECTED]' Asunto: Newbie question I have put a new web server and would like to put a board on it. But when I try to I get an

Alter table Query

STEP 1: status ->SUCCESS --- mysql> CREATE TABLE pod_rating select h.he_headend_id 'Cable Plant',sk.tf_air_date,d.em_dma DMA,d.em_tv_households 'Households TVs',d.em_us_percent Population,p.tf_title 'Program Name',sk.tf_air_time Time,st.tf_station_call_sign Network from prog_rec p,stat_rec

Changing auto_increment field in mysql to start at 1000

I tried this: update customers set row_id='1000' where row_id='1'; but that only changed the one field in the table and the other ones stayed the same =(. Could someone please tell me the correct way to do this Armando -

Re: MERGE TABLES

Hi! On Aug 29, Johnny Withers wrote: > I'm not sure if this is a bug or if this is the way MERGE TABLES works > in MySQL. > > It seems that if I have an INDEX in a field (id for instance), and I try > to > SELECT using a WHERE id=NUMBER, it will fail, even though that NUMBER is > a > valid id. I

Entering data through access

I attempted to enter data into a msyql database using Access 2000. I type in data into a field, hit enter and the data is replaced with "#Deleted". If I close out the table and open it back up again in Access, the data that I typed is there. So the data gets entered correctly. Anyone know how

  1   2   >