Re: backup mysql using crontab

2001-04-02 Thread Lars Heidieker
Pete Harlan wrote: > > Probably because you need to redirect your output into the file AFTER all > > the options. Rewrite your command like this: > > In which shell? In SunOS /bin/sh, or in bash, the shell strips out > the redirection, and the program sees what's left. It doesn't matter > where

ODBC Issue

2001-04-02 Thread gopinath
Hi, We are using Mysql for the last 4 months. We are happy on following your solutions and by your valuable support rendered to us. We now have an issue. Either Mysql or ODBC for Mysql doesn't work. This happens often. When we reinstall, then it works. ODBC for Mysql was working till afternoon

Re: How to recover from accidental 'drop database mysql'

2001-04-02 Thread Mohamad Ilhami
On Mon, 2 Apr 2001, Anonymous Individual wrote: > Greetings: > > I accidently dropped (my thunderous stupidity!!!) our mysql > database. There were a few usernames and other databases. > > I expected hell to break loose (it may still happen!), but > strangely enough, I noticed that I was still

MySQL + Ad Software

2001-04-02 Thread Ryan Shrout
Does anyone know of any cheap for free software, using PHP or CGI, that uses MySQL for its backend that is a good, quality ad software program? I have tried phpAds from phpwizard.net but it does have the option to put % on ads and things like that, which I really need. Even if you know of one

RE: How to recover from accidental 'drop database mysql'

2001-04-02 Thread Quentin Bennett
Hi, Its called your backup tape. Quentin -Original Message- From: Anonymous Individual [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 3 April 2001 4:16 p.m. To: [EMAIL PROTECTED] Subject: How to recover from accidental 'drop database mysql' Greetings: I accidently dropped (my thunderous s

How to recover from accidental 'drop database mysql'

2001-04-02 Thread Anonymous Individual
Greetings: I accidently dropped (my thunderous stupidity!!!) our mysql database. There were a few usernames and other databases. I expected hell to break loose (it may still happen!), but strangely enough, I noticed that I was still able to login, probably because mysql server caches usernames,

Re: MySQL Security

2001-04-02 Thread Van
Taing Nguon wrote: > > Dear sir or madam > > MySQL user's account is not related to user's account on Linux System, so they >can be different. > > My problem is that I use perl DBI to interact MySQL server as belows: > > -- > use DBI; > $dbh = DBI->connect("DBI:mysql:DatabaseName","$u

Re: Importing

2001-04-02 Thread ryc
I believe the problem is with your use of "LOCAL". This is telling the server to try to load the file on the computer it is running on. If this is not where the file is on the computer running mysqld this could explain why it cant read it. Try removing the "LOCAL" part, you also might want to enab

MySQL Security

2001-04-02 Thread Taing Nguon
Dear sir or madam MySQL user's account is not related to user's account on Linux System, so they can be different. My problem is that I use perl DBI to interact MySQL server as belows: -- use DBI; $dbh = DBI->connect("DBI:mysql:DatabaseName","$user","$password"); --- So $user and

NEW "MAKE" BUG? sigcontext.h

2001-04-02 Thread Derek Sivers
Doing a "make" on the newest MySQL stable 3.23.36 source tarball - on a stock Cobalt RaQ3 (Linux 386) which I've installed MySQL on many times before. Got this strange error: gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O6 -DDBUG_OFF -c readline.c In file include

Re: SQL : multiple SELECT and missing rows.

2001-04-02 Thread Kevin C. Miller
You want to use the "LEFT JOIN" syntax. A general outline would be: SELECT [your fields] FROM accounts LEFT JOIN addresses ON addresses.ID = accounts.ID WHERE ... ORDER ... LIMIT ... This would select all addresses.ID's, including those where accounts.ID is NULL. -Kevin --On Tuesday, April 03

Re: speed problems

2001-04-02 Thread Hank Leininger
On 2001-03-21, Viljo Marrandi <[EMAIL PROTECTED]> wrote: > No, only one SELECT with 3 joins. Just in case i send this query again: > SELECT f.foto_id, f.imgname, f.path FROM foto f, indeks k1, indeks k2 > WHERE f.foto_id = k1.foto_id AND k1.word = 'mati' AND f.foto_id = > k2.foto_id AND k2.word

Re: multiple SELECT and missing rows.

2001-04-02 Thread Rolf Hopkins
This is best done with a LEFT JOIN. Please read up the manual about it. - Original Message - From: "Maxim Maletsky" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "'PHP General List. (E-mail)'" <[EMAIL PROTECTED]> Sent: Tuesday, April 03, 2001 9:41 Subject: SQL : multiple SELECT and missin

Re: [PHP] SQL : multiple SELECT and missing rows.

2001-04-02 Thread Steve Werby
"Maxim Maletsky" <[EMAIL PROTECTED]> wrote: > As you can see, the main data is in 'accounts', the 'addresses.ID' is UNIQUE > and corresponds to 'accounts.ID'. The fact is that not every account has an > address registered with it. > FROM > accounts, > addresses You're doing a straight join. You

SQL : multiple SELECT and missing rows.

2001-04-02 Thread Maxim Maletsky
Hello Guys, I have a (very simple?) SQL question. I'm more then sure the answer to it is whether "just do this..." or "It's impossible man, how could you even get that into your mind..." I have this database design: (it's more complex of course, but you get an idea) Table 'account

Re: mysql reports time incorrectly.

2001-04-02 Thread Steve Werby
"Craig Washburn" <[EMAIL PROTECTED]> wrote: > using 3.23.28-gamma on win2000. > > With the change over to daylights savings, the system time was increased by > one hour. MySQL is still reporting the time to be one hour ago. > > eg, it is now 20:08 pm (just double checked it through bios) Doing a S

Selecting certain fields

2001-04-02 Thread Rolf Hopkins
Hi all, I suppose this is more of a feature request for the mysql developers. I have a user who only has read access to a few columns of one table. This table is very large so that it means that the columns, this user has access to, is still quite large. If I do a SELECT * FROM... returns an

Re: mysql reports time incorrectly.

2001-04-02 Thread Paul D. Smith
%% Craig Washburn <[EMAIL PROTECTED]> writes: cw> using 3.23.28-gamma on win2000. cw> With the change over to daylights savings, the system time was cw> increased by one hour. MySQL is still reporting the time to be one cw> hour ago. cw> eg, it is now 20:08 pm (just double checked it

mysql reports time incorrectly.

2001-04-02 Thread Craig Washburn
using 3.23.28-gamma on win2000. With the change over to daylights savings, the system time was increased by one hour. MySQL is still reporting the time to be one hour ago. eg, it is now 20:08 pm (just double checked it through bios) Doing a SELECT NOW() reports it to be 19:08. I've tried shut

Re: speed problems

2001-04-02 Thread Aigars Grins
> [..] Why this is > s slow with BSD we still don't know (like i said in my first mail, > same query was 3 secs or ~20 sec on Linux) I haven't followed the entire thread so feel free to diss me.. There was problem with the userland threading under early OpenBSD 2.8 versions (including the 's

Re: time and date

2001-04-02 Thread Jason Brooke
Add a date/time column and dump the current time into it when you do an insert jason - Original Message - From: "chris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 03, 2002 11:26 AM Subject: time and date > Is there a way to store the time and date that a record

Re: time and date

2001-04-02 Thread Thalis A. Kalfigopoulos
Check the manual for the TIMESTAMP datatype. Will hold the last update time per record abd therefore the insert time that you want. regards, thalis -- No excellent soul is exempt from a mixture of madness. -- Aristotle On Tu

Re: time and date

2001-04-02 Thread Lindsay Adams
It's in the manual. Check the datatypes section, and the now() mysql function. On 4/2/02 6:26 PM, "chris" <[EMAIL PROTECTED]> wrote: > Is there a way to store the time and date that a record was added within > MySQL? I want to show the time and date on some of my records and can't seem > to figu

time and date

2001-04-02 Thread chris
Is there a way to store the time and date that a record was added within MySQL? I want to show the time and date on some of my records and can't seem to figure out an easy way to do it. Thanks! -Chris - Before posting, please c

RE: Time function

2001-04-02 Thread Oson, Chris M.
rekha, mysql> select date_format(dateEntered, "%m-%d-%Y %H:%I") as dateEntered, -> date_format(date_add(dateEntered, interval 2 hour), "%m-%d-%Y %H:%I") as '2 Hours Later' -> from newsStories where storyID = 1122; +--+--+ | dateEntered | 2 Hours Later

problem compiling on Sol 8 - I don't know where to go from here.

2001-04-02 Thread David McCall
checking for crypt.h... yes checking for alloca.h... yes checking for floor in -lm... yes checking for gethostbyname_r in -lnsl_r... no checking for gethostbyname_r in -lnsl... yes checking for socket in -lsocket... yes checking for p2open in -lgen... yes checking for bind in -lbind... no checking

Re: Converting Access to MySQL

2001-04-02 Thread Luis
Thank you for the help, but I'm a newbie on MySQL . Some of the stuff i been reading tells me to download MyODBC or i could make a txt file out of access when exporting. If i try to inport a all the fields from access to mysql do i have to create a database plus tables that are the same as in wi

Re: About the upper limit of data storage...

2001-04-02 Thread Steve Werby
"Dhirendra Pal Singh" <[EMAIL PROTECTED]> wrote: > Some one told me that the upper limit of MySql data storage is 1 Gb of data. The limit depends on the operating system. On some operating systems it's 2 GB, on others it's much higher. Search the mailing list at http://marc.theaimsgroup.com/?l=

Re: Time function

2001-04-02 Thread Steve Werby
"Rekha Das" <[EMAIL PROTECTED]> wrote: > What time function should I use to add 2 hours to a time value I am getting > from the database ? Convert the time to seconds, add 7200 seconds (2 hours), then convert back to time format. SELECT SEC_TO_TIME(TIME_TO_SEC(my_time_field) +7200); -- Steve We

Re: Converting Access to MySQL

2001-04-02 Thread Bryce Jackson
Luis, This is an easy one. Go here ftp://ftp.informate.co.nz/pub/ and download one of the scripts, the instructions are in the script. It will create a text file that has the sql commands needed to create and fill your mySQL tables with your Access info. You can exec the script from the mySQL pro

after changing master-host in my.cnf, slave remained committed to old master.info

2001-04-02 Thread Meng Weng Wong
i initially had a master-host=A defined in my.cnf. later i changed that to master-host=B. i was mystified when i got a connection error: Slave thread: error connecting to master:Host 'dumbo.pobox.com' is not allowed to connect to this MySQL server(0), retry in 60 sec i spent much time pro

About the upper limit of data storage...

2001-04-02 Thread Dhirendra Pal Singh
Hi all, Some one told me that the upper limit of MySql data storage is 1 Gb of data. As I am new so I am not sure of this. If any gurus of MySql can please tell me about it, it would be great. Regards Dp Balcom Systems & Technologies, Inc. (408)468-6608

Time function

2001-04-02 Thread Rekha Das
What time function should I use to add 2 hours to a time value I am getting from the database ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list arch

Importing

2001-04-02 Thread Ian Ford
I'm tring to import a text file to mysql. The problem I am having is that the mysql database is located on a seperate server from the web site. I can do query's and inserts but I can not get the mysql server to grab a txt file from the web server and load it into the database. I have been usin

mysqld silently quits on date-related query

2001-04-02 Thread Allen Hopkins
>Description: We just upgraded our Sun Ultra 60's to Solaris 8, and in so doing, We upgraded MySQL from 3.22.32 to 3.23.36 (installed from source package). The new version of the server quits with status 1, and no error log output, when we do the following query: select * from foo

Binlog has bad magic number

2001-04-02 Thread Jim Ziegler
What causes: 010402 17:08:56 Error reading packet from server: Binlog has bad magic number, fire your magician (read_errno 0,server_errno=65535) in the err log of a replication slave? is it related to: 010402 17:10:34 create_table_from_dump::failed in handler::net_read_dump() 010402 17:10:3

Re: Update TimeStamp

2001-04-02 Thread Steve Werby
"Jason Frisvold" <[EMAIL PROTECTED]> wrote: > Is there any way to query a mySQL database for the last time it was updated? > I need this ability to trigger a "restart" in some other applications that > create config files and such for MRTG... Create a field with type DATETIME and update it when a

Re: Update TimeStamp

2001-04-02 Thread Gerald Clark
select _timestamp from mytable order by _timestamp desc limit 1; Jason Frisvold wrote: > > Is there any way to query a mySQL database for the last time it was updated? > I need this ability to trigger a "restart" in some other applications that > create config files and such for MRTG... > > T

Help!! New Win32 mySQL User

2001-04-02 Thread Greg Miller
I am a newbie to the mySQL world and am having some difficulties with it. I am running a Win2K network (Win2K Pro, Win2K Adv. Server) using TCP/IP. I loaded mySQL on both a server and a workstation. I was able to get the server going (mysqld-nt --install, net start mysql), and was able to log

Converting Access to MySQL

2001-04-02 Thread Luis
Hello to all, I was wondering if anyone could help me out with a little project i have going. I have a database in access 7.0 I would like to transfor all the fields, tables, plus information it has to mysql running on a linux box (rh 7.0) running mysql. now how would i go about that? is there a

Re: unable to get access

2001-04-02 Thread Wade DeWerff
yes it was an old install, strange, it seems to want to connect now. bizarre - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request t

Re: Newbie question

2001-04-02 Thread B. van Ouwerkerk
>I've installed mysql 3.22.32 and created a test table via mysql. now, when >I try to run > >safe_mysqld --log & Do you run this while you already could connect via mysql?? if so, then your server was already running.. No need to start it twice.. Also, checkout www.devshed.com and the fine My

Re: unable to get access

2001-04-02 Thread B. van Ouwerkerk
> I cant get access into mysql. I get access denied for user when >trying to log into mysql as root with password. Anyone help? You did go through the complete installation?? Including the create_db stuff and the root password setting stuff.. If not, read the manual.. it will help you to ge

Re: backup mysql using crontab

2001-04-02 Thread Pete Harlan
> Probably because you need to redirect your output into the file AFTER all > the options. Rewrite your command like this: In which shell? In SunOS /bin/sh, or in bash, the shell strips out the redirection, and the program sees what's left. It doesn't matter where the redirection is; it can eve

Update TimeStamp

2001-04-02 Thread Jason Frisvold
Is there any way to query a mySQL database for the last time it was updated? I need this ability to trigger a "restart" in some other applications that create config files and such for MRTG... Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata

Re: Newbie question

2001-04-02 Thread Steve Werby
It seems like those directories are owned by someone other than the user that MySQL runs under. chown them to the user MySQL runs under. In the future, posting info about MySQL ownership, who you're logged in as when running safe_mysqld, ownership and permissions on problem files, OS, etc. will

Re: Calculations in a field?

2001-04-02 Thread Steve Werby
"Mike Roberts" <[EMAIL PROTECTED]> wrote: > Is there any way to make one field in a table calculate another field. > I'm making a DB that calculates commissions. So in the money_made > field would have the # of sales (sales field) times whatever the commission > would be. If you're updating exist

unable to get access

2001-04-02 Thread Wade DeWerff
I cant get access into mysql. I get access denied for user when trying to log into mysql as root with password. Anyone help? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.m

problems

2001-04-02 Thread Osus
Hi, I have one site developed with php+mysql. We have about 10.000 visits per day with more or less 250/300 users on prime time. When users increase over 200 mysql starts runing some errors and restarting... Number of processes running now: 0 010402 21:33:13 mysqld restarted /usr/sbin/mysql

Newbie question

2001-04-02 Thread Graham Nichols
Hi, I've installed mysql 3.22.32 and created a test table via mysql. now, when I try to run safe_mysqld --log & I get the error message [[EMAIL PROTECTED]]$ Starting mysqld daemon with databases from /usr/local/var ./scripts/safe_mysqld: /usr/local/var/www.server-1.com.err: Permission denied r

Calculations in a field?

2001-04-02 Thread Mike Roberts
Is there any way to make one field in a table calculate another field. I'm making a DB that calculates commissions. So in the money_made field would have the # of sales (sales field) times whatever the commission would be. - Be

indexing in mysql

2001-04-02 Thread amod bhate
Hi everyone, I am having trouble to understand how exactly indexing for BLOBS work in mysql through servlets? Can someone send me some sample code which indexes BLOBS in some table in mysql with resect to some parameters thru servlet and mm-mysql.jdbc1.2c driver? Thanks Amod ___

Re: daylight savings

2001-04-02 Thread Tom Yarrish
This is an issue with the msvcrt.dll file on Windows Platforms...see this link: http://archives.neohapsis.com/archives/ntbugtraq/1998-1999/msg00255.html (It's an old one too) Thanks, Tom -- #!/usr/bin/perl -w # 526-byte qrpff, Keith Winstein and Marc Horowitz <[EMAIL PROTECTED]> # MPEG 2 PS VO

RE: Mysql and MS Access

2001-04-02 Thread JHDrexler
Verify that you have a primary key and a DateTime Stamp field for your table. I do this with a Serial field {Serial int(11) not null Primary Key auto_increment} as the first field and {DateChanged (TimeStamp)} as the second field for each table that I intend on accessing from MSAccess.

Re: Error message: [Incorrect information in file: './ts1/tbl_status.frm']

2001-04-02 Thread Silvio Picano
>> Might the NFS dependence be a problem? >Yes, it could , particularly if you do not have --skip-locking as >mysqld startup or if some other processes access the files. >Regards, >Sinisa Hi Sinisa, What does "some other processes access the files" mean? Are you thinking like automated system

FP exception in sql/sql_select.cc on osf1/4.0f + gcc 2.95.2

2001-04-02 Thread nick
>Description: On mysql-3.23.33 on Tru64 4.0f, using gcc 2.95.2 (any optimisation level), sql_select.cc will raise a FP exception at line 1785 of sql/sql_select.cc, quoted here: : if (tmp < best_time - records/(double) TIME_FOR_COMPARE) At the time that the

daylight savings

2001-04-02 Thread Srinivas Mulpuri
I have a problem with my time (now()) in mysql running on WIN98 (also in WIN NT). After the daylight savings, the time on the WIN machines is changed by 1 hour. But still the now() function returns a time as if there is no change for daylight savings. Timezone parameter is currently set to Centra

Re: ---- Virus Detected ----

2001-04-02 Thread Chris Worth
they are the morons that babbled about a LINUX/WINDOZE hybrid virus nothing that they say has credibility. On Sat, 31 Mar 2001 18:36:19 -0500, Gary Huntress wrote: >I have received several of the same messages, and I too believe that I'm >virus free (I just updated and ran NAV). > >Since the

Grant/Revoke dialog doesn't open

2001-04-02 Thread skick
I am havving the same problem. I even tried compiling a version. If it is a window manager problem then how do I fix it. It seems like it should work wiith both the kde 2.0 window manager and the enlightenment window manager that is part on gnome. -

Trying to compile/build MySQL on SUSEv7.0 running on S/390

2001-04-02 Thread Leo McCarthy
Hello, The configure program doesnt recognize my machine type. I am running SuSe v7.0 on a S/390 mainframe. uname -m returns S390, uname -s returns Linux and uname -p returns unknown. When I try to configure I get: Checking host system type... Invalid configuration `s390-unknown-linux-gnu': ma

TimeZone problem

2001-04-02 Thread Jocelyn Bernier
We are currently running MySQL 3.23.33 on a Windows NT 4 SP6 machine. Yesterday we changed for Eastern Daily Saving but mysql still running with timezone of Eastern Standard Time. I checked in the doc and only found that I should change the variable TZ with a new value. How can I chan

Re: Strange Error Message, I need explaination.

2001-04-02 Thread Lindsay Adams
You are logged in as root, but what user is mysqld running as? If you stop the database, you can manually remove the test dir from the datadir. Or fix the permissions on your directories in the datadir, so that mysqld can add/remove directories and files. Look in your my.cnf file to find out wha

Re: backup mysql using crontab

2001-04-02 Thread John Barton
mysqldump --flush-logs -u root -pmarkloky --add-drop-table shuncheong > /backup/shuncheong.sql You have to put username and password as an argument to mysqldump, before your redirection John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Tue, 3 Apr 2001, Mark Lo (

Re: backup mysql using crontab

2001-04-02 Thread Steve Werby
"Mark Lo (3)" <[EMAIL PROTECTED]> wrote: >I would like to know how to backup mysql using crontab or cron jog. > > I have add a line in my crontab file : > mysqldump --flush-logs --add-drop-table shuncheong > > /backup/shuncheong.sql -u root -pmarkloky; > > but I got nothing in shuncheong.sql

Re: backup mysql using crontab

2001-04-02 Thread Lindsay Adams
Probably because you need to redirect your output into the file AFTER all the options. Rewrite your command like this: mysqldump --flush-logs --add-drop-table -u root -p markloky shuncheong > /backup/shuncheong.sql See if that works. The way you had it written, you weren't passing the -u and

Re: backup mysql using crontab

2001-04-02 Thread Lars Heidieker
Hi, the cammod looks wiered to me try something like mysqldump --flush-logs --add-drop-table -u root -pmarkloky shuncheong > /backup/shuncheong.sql lars "Mark Lo (3)" wrote: > Hi, > >I would like to know how to backup mysql using crontab or cron jog. > > I have add a line in my crontab fi

Strange Error Message, I need explaination.

2001-04-02 Thread Mike Mike
Hello, When I try to drop a database as follows: mysql> drop database test; I get an error message of ERROR 1010: Error dropping database (can't rmdir './test', errno: 39) How do I fix this problem or even how do I delete the database. I'm using RedHat 6.2 and MySQL version: 3.22.32 and i'm lo

Re: Lock objects

2001-04-02 Thread Gerald Clark
Einav Lavi-Lapidot wrote: > > I want to work with an object that provides numbers, like sequence in Oracle > database. > Is there anything similar ? > Of course, the object should be locked every time a specific user wants to > get the next value. ( again, like sequence in oracle ). > Thanks a lo

Re: safe-mysqld segfaults every 10 minutes

2001-04-02 Thread Ivan Lamouret
Gerald Clark wrote: > I would check to see what chron is doing every 10 minutes. > > > Ivan Lamouret wrote: > > > > >Description: > > > > safe_myqld keeps restarting the server until it eventually dies (number of running >process 0). [...] > > Note that it is always exactly 10, 20, 30, etc, p

Yahoo! Auto Response

2001-04-02 Thread joseph9775
I will be back Saturday night. Thanks, Joseph Say I'm Hot! - Post Your Picture! http://www.sayimhot.com Original Message: X-Track: 16: 40 Received: from web.mysql.com (HELO www.mysql.com) (192.58.197.162) by mta137.mail.yahoo.com with SMTP; 31 Mar 2001 09:07:07 -0800

problem with "LOAD TABLE" command

2001-04-02 Thread Jim Ziegler
why do i get: mysql> load table aca from master; ERROR 1189: Net error reading from master the error log shows: 010402 11:37:10 create_table_from_dump::failed in handler::net_read_dump() 010402 11:37:10 fetch_nx_table: failed on create table status shows: mysql> status -- mysql V

Lock objects

2001-04-02 Thread Einav Lavi-Lapidot
I want to work with an object that provides numbers, like sequence in Oracle database. Is there anything similar ? Of course, the object should be locked every time a specific user wants to get the next value. ( again, like sequence in oracle ). Thanks a lot. Einav. Einav Lavi-Pdut software

Re: email only two columns

2001-04-02 Thread Vivek Khera
> "PM" == Prasad Mhatre <[EMAIL PROTECTED]> writes: PM> Is it possible to mail only three columns from a database ? Third column PM> being email ID? PM> I need to send email to all with a valid email ID in a database. MySQL doesn't send email. Perhaps you need to write a program that queri

Re: possible deady(dead lock)

2001-04-02 Thread Gerald Clark
The manual chapter 7.32 declares it to be deadlock free. Did you read the manual? Kurt Washington wrote: > > here is an example in perl > my $sthLock = $dbh->prepare("LOCK TABLES table1 WRITE, table2 WRITE") > > could there ever be a possibility of a race condition or dead lock > where you ha

Re: possible deady(dead lock)

2001-04-02 Thread Kurt Washington
here is an example in perl my $sthLock = $dbh->prepare("LOCK TABLES table1 WRITE, table2 WRITE") could there ever be a possibility of a race condition or dead lock where you have two threads that access the code almost at the same time One gets a lock on table one and another gets a lock on t

Re: Innobase on WinNt.

2001-04-02 Thread Sinisa Milivojevic
Leonard Coonan writes: > I am trying to install Mysql (3.23.36) on windows NT. I have installed the > software, but cannot find how to use the Innobase table structure. Can > someone please point me in the right direction (apart from installing it on > something else). I have tried putting

Mirroring/Failover for MySQL (Was "Need examples of companies using mysql")

2001-04-02 Thread Jason Saunders
Hi Steve, To achieve mirroring, MySQL can be run in a master/slave replication ring with two servers (look up replication in the manual). That way you can split reads and writes over both servers and get better read performance, and also more resilience. The way to achieve transparent failove

Re: MySQL 3.23.36 is relased

2001-04-02 Thread Benjamin Pflugmann
Hi. >From the download page http://www.mysql.com/downloads/mysql-3.23.html: -- MySQL 3.23.34a and newer source releases include the full source for Berkeley DB and Innobase tables; By using these table handler you can use transa

Re: SELECT ... FOR UPDATE

2001-04-02 Thread nigel wood
On Mon, 02 Apr 2001, Richard Ellerbrock wrote: > From the manual: > > If you are using FOR UPDATE on a table handler with page/row locks, the examined >rows will be write locked. > > I agree that this does not tell me much. When are the rows unlocked? > educated guess select for update

Re: can't get MySQL 3.23.37

2001-04-02 Thread Benjamin Pflugmann
Hi. On Mon, Apr 02, 2001 at 03:35:43PM +0700, [EMAIL PROTECTED] wrote: > > Hi, > I can't find MySQL 3.23.37. Please tellme where I can dl it. Where is the > really latest release? According to http://www.mysql.com/downloads/mysql-3.23.html the latest release is 3.23.36. I assume you have read a

Re: Innobase on WinNt.

2001-04-02 Thread Dan Nelson
In the last episode (Apr 02), Leonard Coonan said: > I am trying to install Mysql (3.23.36) on windows NT. I have > installed the software, but cannot find how to use the Innobase table > structure. Can someone please point me in the right direction (apart > from installing it on something else)

Re: Termcap not found in install...

2001-04-02 Thread Gerald Clark
It would be nice to know what you are running. If Linux, the termcap files should be on your install CD. Package name and installation methods vary with supplier and version. Pedro Fonseca wrote: > > Hi everybody... > I'm pretty much trying to install MySQL by compiling the sources (I like to >

Re: possible deady

2001-04-02 Thread Gerald Clark
Kurt Washington wrote: > > I am curious if any knows of possible deadlock > conditions that can ocurr when using the lock tables command in MySQL when > you are referenceing multiple tables? > _ > Get your FREE download of MSN Explor

Re: Can't recover a bad corrupeted table...

2001-04-02 Thread Bob Hall
>Hello Bob, first at all thank you for your support. > >Bob Hall wrote: > >>Let me see if I understand you correctly. You created a new table >>(CREATE TABLE?) and you imported data from a file that had nothing >>to do with MySQL (comma or tab delimited file?), and therefore >>couldn't be affec

Re: Is updating a subsection of a field possible?

2001-04-02 Thread Bob Hall
Sir, use the Replace function. Regex isn't necessary. >I've got a table with 500+ records in it now... and I need to update just a >small section of one of the fields (an URL) to change a parameter on it... > >I know I'm probably going to be told "NO", but I thought I'd ask before I go >start wri

Database instance

2001-04-02 Thread peterli
I am planning for a migration from MS-SQL MY-SQL. Does Mysql support database instance? How can I configure Mysql to support transaction rollback ? Regards Peter Li This message was sent through MyMail http://www.mymail.com.au -

Re: SELECT ... FOR UPDATE

2001-04-02 Thread Richard Ellerbrock
>From the manual: If you are using FOR UPDATE on a table handler with page/row locks, the examined rows will be write locked. I agree that this does not tell me much. When are the rows unlocked? -- Richard Ellerbrock [EMAIL PROTECTED] >>> Andrew Gould <[EMAIL PROTECTED]> 2001/04/02 03:56:33

Re: how to copy the mysql bin and data dir to another machine and make it work without the lib files?..

2001-04-02 Thread Gerald Clark
jagadeesh wrote: Get a good beginners book for your operating system and read it. One clue might be 'tar'. Anothe clue might be 'tape drive'. Perhaps 'NFS' is a clue. I just don't know, because I have no 'clue' as to what you are running, or what the other machine is running. > > hi > i have i

SELECT ... FOR UPDATE

2001-04-02 Thread Andrew Gould
I am, at this moment, installing MySQL version 3.23.36. I noted that the "SELECT...FOR UPDATE" feature has been added. What does this do and how is it used? The online manual simply mentions that it exists; but doesn't explain what it is or how to use it. Thanks, Andrew Gould ___

Re: Can't recover a bad corrupeted table...

2001-04-02 Thread Gerald Clark
'date' is a reserved word. Try renaming your date column, and see if the problem remains. Antonio Gulli wrote: > > Hello Bob, first at all thank you for your support. > > Bob Hall wrote: > > > Let me see if I understand you correctly. You created a new table > > (CREATE TABLE?) and you importe

Re: MySQL 3.23.36 is relased

2001-04-02 Thread B. van Ouwerkerk
>Everyone: why did the volume of the source distribution jump from >something like 5+ MB to 10+ MB ? This is not likely from a bugfix. Am I >downloading lots of new stuff I will probably not use? http://www.mysql.com/downloads/mysql-3.23.html says: MySQL 3.23.34a and newer source releases includ

Can't Compile mod_auth_mysql

2001-04-02 Thread Rob Trevor
Hi I've been trying to compile mod_auth_mysql for Apache 1.3.19 and MySQL 3.23.33 on AIX 4.1.1. I've given up trying to get it to work as a DSO+APXS using the configure script that comes with mod_auth_mysql. (I seem to end up with a Makefile which calls apxs without any '-c' option anywhere.)

Performance question

2001-04-02 Thread Raf Geusens
Hi, I've got a question 'bout the number of number of writes a MySQLserver can handle in a second. I've written a program which contains the following code: typedef struct { MYSQL * connection; char * database; } con; int resolveq

Re: MySQL 3.23.36 is relased

2001-04-02 Thread Thomas Spahni
On Tue, 27 Mar 2001, Michael Widenius wrote: > This release should fix the final bugs we accidently got into 3.23.34 > and a long security bug that has been in MySQL a long time! Thanks, Monty! Everyone: why did the volume of the source distribution jump from something like 5+ MB to 10+ MB ? Th

Re: Need examples of companies using mysql

2001-04-02 Thread Anthony R. J. Ball
> Unless you're going to have a LOT of users accessing a HUGE database, the > system you've outlined below will be overkill (do you have any current usage > statistics ? Are you using the system (is it an E450 ?) for any other > applications/processes ?). It would be, if it was dedicated to

Re: Need examples of companies using mysql

2001-04-02 Thread Anthony R. J. Ball
HAHA! You'll be a good example, since I'm pretty sure you buy data from us... hehe. FT Interactive Data > We use MySQL quite a lot and even manage to generate money once in a > while... > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (40

RE: mysqldump hangs

2001-04-02 Thread Ide, Jim
FYI, I tested MySQL 3.23.36 with the same setup as below. I got identical results. -Original Message- From: Ide, Jim Sent: Saturday, March 31, 2001 4:59 PM To: '[EMAIL PROTECTED]' Subject: mysqldump hangs OpenBSD 2.8 swap partition is 256mb /tmp partition is 1gb Pentium III 667mhz, 25

Win 2000 apache module

2001-04-02 Thread Nick
Can someone tell me where / how to get the Windows 2000 equivalent of the mod_auth_mysql.so in Linux. Thanks Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

New user for MySql

2001-04-02 Thread hanan khader
Hi friends... Iam a new user for MySql, please I want to ask the folloing: First, My OS is WINNT4 Server. the name of the server is SERVER1. I have installed mysql-3.32.32-win, and installed also myodbc-2.50.3, as zip files then run the setup as recommended. Okey, now, I have installed it on

User table problem

2001-04-02 Thread Siim Einfeldt aka Itpunk
Hi, I have a problem with mysql users. I can`t connect to database with any user when I use password. Eg, if from the command line I try to connect like mysql -h myhost -u myuser -p and then on the password line write my password, it gives permission denied... If I try to go in just without

  1   2   >