RE: Getting timestamp to work with Perl CGI

A timestamp is just a scalar. Perl could care less about field types, because everything is ultimatly just a scalar or a list to perl. there may be module on cpan.org that handles intricacies of mySQL timestamps... #perl -MCPAN -e shell cpan>i mySQL or cpan>i timestamp etc Jim -Original M

Re: Getting timestamp to work with Perl CGI

Digging further into the scripts supplied to me by a third person, it looks like the CGI Perl interface could care less about field types. So, ignore the following. MB >How does one get the MySQL timestamp type to work with the Perl CGI interface >script? > >I've been trying a couple of things,

LAST_INSERT_ID() and INSERT DELAYED

I have a daemon which uses MySQL (INSERT INTO) to log. The problem is, whenever I try to do anything with the log table that takes a long time, it makes the daemon freeze until the table is free again. I'm thinking of making the daemon use INSERT DELAYED instead, so that it won't get blocked. But,

ADODB XML Update Recordset

Has anyone any luck performing batch update with a persisted ADO XML recordset? I'm trying to save data from one MySQL server and then upload/insert to another. I'm trying to get these persisted XML recordsets to work, but having no luck. Any ideas? Karl ---

Getting timestamp to work with Perl CGI

How does one get the MySQL timestamp type to work with the Perl CGI interface script? I've been trying a couple of things, but all I get back is zeros for the value of the field. Does the CGI interface even support timestamp? MB -- e-mail: [EMAIL PROTECTED] /~\ The ASCI

mysql lost connection

filter-fodder: mysql, query Hi, I have a persistent connection. but when a query fails for whatever reason, ( eg. user doesnt have permission to delete a row ) I lose the connection. HOW can I stop this happening, and WHY is it happening? Donna -

Re: replication hell.

I know it runs on 3306 :) I can telnet to the host on port 3306. - Chris On Sat, 14 Dec 2002, Grant Cooper wrote: > Mysql works on port 3306 by default. > > for example, my mysql server is on 10.10.10.1 so you would use this command > to test your mysql server. > > telnet 10.10.10.1 3306 > > yo

Re: replication hell.

Mysql works on port 3306 by default. for example, my mysql server is on 10.10.10.1 so you would use this command to test your mysql server. telnet 10.10.10.1 3306 you will get special garbage or host not allowed if testing a remote server. But at least you know your mysql server is open. You co

replication hell.

Greetings, I have followed the replication section of the mysql manual, and all went fine except replication will not happen. In my logs I find: 021215 0:33:32 Slave thread: error connecting to master: Can't connect to MySQL server on '192.168.1.9' (22) (22), retry in 60 sec I can teln

MySQL 4 for Mandrake 9

Hi Can anyone recommend a binary source for Mandrake 9, or the correct options to compile and install the latest version of MySQL on Mandrake 9. I appreciate that the 'standard' Redhat 386 binaries will work, but I would rather stick to Mandrakes specific (pentium) version. Simon -- Simon Wi

Re: Connecting M. Access Forms to insert data into mysql

I've installed about 12 client gui's and here's my conclusion. DBQwikEdit - has the best editor for Data Entry - nice form to add one record at a time - similar to access forms (I want this) - As far as I can tell, is the only product that has this feture http://www.mysqlstudio.com/ - nice for ma

Connecting M. Access Forms to insert data into mysql

I am trying to find a package to insert data. And was wondering if I can use odbc drivers to connect Access to mysql in real time? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.

RE: DBI or CGI perl error?

You are missing a comma update music set cut = '' , mamended = '20021214013349' where mrecno = '1' HTH Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net te

Re: DBI or CGI perl error?

At 20:34 -0600 12/14/02, Vidiot wrote: My database layout is as follows: mysql> show columns from music; +---+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+---+ | mrecno

Re: INSERT confirmation? PHP

At 20:08 -0500 12/14/02, Michael T. Babcock wrote: Peter Lovatt wrote: mysql_insert_id should do it! According to documentation somewhere, last insert can sometimes return a different value than the most recent insert if the most recent insert failed. Why is this a problem? If the most rec

DBI or CGI perl error?

My database layout is as follows: mysql> show columns from music; +---+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+---+ | mrecno| int(6)| | PRI | 0

MySQL losing connection on WinXP

Hello, I have an application that reads and writes to a local MySQL database. On Wondows 2000, I have no problems, but on WinXP I am running into a situation where after executing 3000-4000 "select" queries, all of a sudden the application cannot connect to MySQL. I am using the ZeosLib components

running mysql (mysql users)

I wish to attempt to clarify one of my earlier questions: Most things I've read say to establish a "mysql" user -I take it this is to run the daemon(mysqld?) under? Is the above user one that will be created in the users table of the mysql db? What mysql privileges does such a user need? Also,

Re: INSERT confirmation? PHP

Peter Lovatt wrote: mysql_insert_id should do it! According to documentation somewhere, last insert can sometimes return a different value than the most recent insert if the most recent insert failed. What is a better solution? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibr

Binary Compilers? (was: Compiling MySQL binary?)

Maybe it's just me, but I'm getting this sinking feeling I just asked another "google" question! :-/ How about I simplify my request to any recommendations for compiler(s) that would be suitable to compile binaries for Mac OS X's Darwin 6.1 and/or... Windows XP... Thank you! Brian -- Brian S.

Re: MySQL doesn't use named pipe on Win2K

At 00:49 15/12/2002 +0100, Stefan Hinz wrote: Hi, Dear list, MySQL 4.0.5 seems to be the first version that does not use named pipes on my Win2K box ... Use the --enable-named-pipe at command prompt or in your configuration file my.ini/my.cnf: Microsoft Windows 2000 [Versão 5.00.2195] (C) Cop

Binary Compilers? (was: Compiling MySQL binary?)

Maybe it's just me, but I'm getting this sinking feeling I just asked another "google" question! :-/ How about I simplify my request to any recommendations for compiler(s) that would be suitable to compile Binaries for Mac OS X's Darwin 6.1 and/or... Windows XP... Thank you! Brian -- Brian S.

Re: MySQL crashes with foreign key restraints

Dear Heikki, > are you sure you used the script: > CREATE TABLE Projekt( > ... Yep. I tried 4.0.1 (on Win98), 4.0.3 and 4.0.4 (on Win2K with SP2), and tonight I tried 4.0.5a-max-nt on Win2K (with SP2, but another machine). Here's the result: C:\mysql\bin>mysql -usuperuser -p projekt < my.dump.pr

MySQL doesn't use named pipe on Win2K

Dear list, MySQL 4.0.5 seems to be the first version that does not use named pipes on my Win2K box ... Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. C:\mysql\bin>mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 395 t

RE: INSERT confirmation? PHP

hi mysql_insert_id http://www.php.net/manual/en/function.mysql-insert-id.php should do it! Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1

INSERT confirmation? PHP

I'm designing a user database for PHP 4 and MySQL 3.32 or whatever. Users enter a class and it's workshops for their students. The 'Class' table has fields 'Name' and 'ID'. ID is the primary key and its an auto-incremented integer The 'Workshop' table has a field ID, Number, ClassID, Date, etc.

RE: Root user password changing

After loging in mysql as root, enter the command: SET PASSWORD FOR root=password('the_new_password'); > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Saturday, December 14, 2002 5:07 PM > To: [EMAIL PROTECTED] > Subject: Root user password changing >

Re: chroot() in 3.23.54

Hi! On Dec 13, Andrew Rucker Jones wrote: > Hi everyone, > First off, please include my personal e-mail address in any responses, > as i am not subscribed to the list. > I run MySQL with the chroot option. Up until 3.23.54, it worked fine. Up until 3.23.54 it simply didn't work, as

Re: weird auto increment behaviour (bug???)

On Friday 13 December 2002 20:43, you wrote: Hi Sean, this is not a bug: http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html For MyISAM and BDB tables you can specify AUTO_INCREMENT on secondary column in a multi-column key. In this case the generated value for the autoincrement column i

MySQL on Mac OS X S 10.2

Well, I think I ALMOST have figured out how to get the Apple installed MySQL running on Mac OS X Server 10.2 (not an XServe). I have it running but still have some issues: (Apple installs the mysql in /usr/share as opposed to /usr/local... as far as I can tell.) I am having trouble with 2 thi

RE: Using MS Access as front end to mysql database

Yup, agreed. MySQLODBC works over TCP/IP fine. I'm currently tunneling through a Linksys router to a database I have at home. If your provider is unwilling to compromise, it maybe time to look for another host. There are plenty of MySQL and MS SQL hosts who allow TCP/IP connections. At 11

Re: MySQL crashes with foreign key restraints

Stefan, are you sure you used the script: CREATE TABLE Projekt( id SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (id)) TYPE=InnoDB; CREATE TABLE Teilnehmer( id SMALLINT UNSIGNED NOT NULL, pid SMALLINT UNSIGNED, FOREIGN KEY (pid) REFERENCES Projekt (id), PRIMARY KEY (id), INDEX IDX_Teilnehmer_1 (pid))

Root user password changing

how exactly do I change the Root user's password for mysql? like this? : mysqladmin -u root -p'newpasswd' ? (without a space between -p and 'newpasswd' ?) and, if that is correct, I guess I'd then be presented with a prompt for the old passwd, right? Then, the new one would take effect? T

Re: MySQL crashes with foreign key restraints

Dear Heikki, thanks for the hint! > please upgrade to 4.0.5 and test again. > 4.0.1 is a very old alpha release, and lots of bugs have been fixed since. But please note what I said about 4.0.3: >> P.S. I tried the same with 4.0.3-max-nt on a Win2K box. Here, the server >> doesn't crash, but the

RE: Using MS Access as front end to mysql database

they can do it. they just dont want to. firewall rules can be established to allow connects to the mysql port from only the ip's assoc with your remote offices, etc etc the answer is you can do what you want. You just need a business partner who can service his customer properly. mysqlODBC can do

Re: Fastest way to get the number of rows in a table ?

Dear Christophe, >Type: InnoDB >Rows: 603 << 700 != 603 >> > How do you explain the difference between "count(*): 700" and "Rows: 603" You don't have to explain this, the manual does ;-) http://www.mysql.com/documentation/mysql/bychapter/manual_T

âÍ¡ÒÈ·Ò§¸ØÃСԨ 15/12/2002 0:46:16

Dear mysql , á¹Ð¹Ó¸ØáԨ International e-Business ! àÃÕ¹ÃÙéÇÔ¸Õ¡Ò÷ӧҹ ¸ØáԨ¹Ò¹ÒªÒµÔ º¹ Internet àÃÕ¹ÃÙéá¼¹¡Ò÷ӧҹà¾ÔèÁÃÒÂä´é¾ÔàÈÉã¹áµèÅÐà´×͹ á¼¹·ÓÃÒÂä´éÍÂèÒ§¨ÃÔ§¨Ñ§áºº·Ó§Ò¹¹Í¡àÇÅÒ 17,000 ¶Ö§ 100,000 ºÒ·/à´×͹ àÇÅÒ·Õèµéͧãªé : 7-14 ªÁ./ÊÑ»´ÒËì á¼¹·ÓÃÒÂä´éÍÂèÒ§¨ÃÔ§¨Ñ§áºº·Ó§Ò¹àµçÁàÇÅÒ 50,000

Re: MySQL 3.23.54 safe_mysqld fix

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 12 Dec 2002, Nick wrote: > The following code is incorrect in safe_mysqld on 3.23.54 at least (that > is all I have checked) > > Line 162: > if $NOHUP_NICENESS -gt 0 > then > $NOHUP_NICENESS="nice --$NOHUP_NICENESS nohup" > > > T

Portuguese Characters

Hi. I'm using MySql+MyODBC. When reading data in VB (ADO) from the database, the Portuguese characteres (çÇáãé, etcc) appear in a strange way. Any Ideas? Regards Luis Damas [EMAIL PROTECTED] - Before posting, please check: ht

slave pukes with hostname change

Hi, How can I prevent this and what causes it? I am using mysql 4.02 on FreeBSD. This is running as a slave. When I change my machine's hostname mysql starts up fine, but when I slave start replication I get an unable to initial Master.info error. If I change the hostname back to the old hostn

English version of EasyPHP ??

I want to install EasyPHP with Apache-MySQL-PHP on a Windows laptop for use over the holidays... I am a newbie at all this. I installed EasyPHP on an extra Windows Desktop here to try it and all the doc's are in French. (It also installed phpmyadmin... doc's for this also in French) 1 - Is there

Different thread states in 3.23.54

Hi. Version 3.23.54 seems to run the mysqld processes in the "SN" state (as opposed to "S" state that the previous versions did) - negative nice values. There is no reference to anything like this in the change logs - any reasons why? Please cc reply to my email address. Cheers, Luci

Re: Fastest way to get the number of rows in a table ?

The numbers reported by SHOW TABLE STATUS in the case of an InnoDb table are *approximate*, not the real count. "Note that the statistics SHOW gives about InnoDB tables are only approximate: they are used in SQL optimization. Table and index reserved sizes in bytes are accurate, though. " See s

RE: Addendum to the MySQL 3.23.54 release

Does this also affects the 3.23.54 source? Or only the binary packages? With kind regards, Richard Pijnenburg Klik-on Internet Solutions > -Original Message- > From: Lenz Grimmer [mailto:[EMAIL PROTECTED]] > Sent: 13 December 2002 16:19 > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED];

Automatically totalling columns.

Hi, I have two tables, one with peoples names in it and one with data associated to these people. What I need to do is to be able to automatically total certain items in the data table that correspond with a name in the first table and then update the name table.. i.e. This is a crude example, bu

RE: BEGINNER: in mysql, better to do 1 table for one relationship, even with a one to one relation ?

Using the ALTER statement: Step 1.- DROP the primary key Step 2.- ADD the new primary key Adolfo > -Original Message- > From: Alliax [mailto:[EMAIL PROTECTED]] > Sent: Saturday, December 14, 2002 9:54 AM > To: Adolfo Bello; [EMAIL PROTECTED] > Subject: RE: BEGINNER: in mysql, better to d

Re: REGEXP emal address query

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Richard -- ...and then Richard Baskett said... % % Ok finally found the answer after many hours of searching :) Here is the % MySQL query that works great! % % SELECT * FROM table_name % WHERE Email NOT % REGEXP "^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z

RE: BEGINNER: in mysql, better to do 1 table for one relationship, even with a one to one relation ?

Hello, you're right, creating the table with 2 primary keys works fine. What I was doing is try to convert my personID and carID fields into primary, and it says: Error MySQL : Invalid SQL: ALTER TABLE `varmalinalliax`.`tgl_rel_rest_card` CHANGE `restID` `restID` INT (11) DEFAULT '0' NOT NULL , CH

Re: Error rebuilding 3.23.54 source rpm, glibc 2.1?

Hi > I've got an older redhat 6.2 box that has glibc 2.1.3-28 on it. > The binary rpm's won't install (needs glibc 2.2), and rebuilding the > source rpm gives: > [...] > error: Bad exit status from /var/tmp/rpm-tmp.94268 (%build) You don't need a newer glibc version but a newer compiler. RedHat

Unable to start mysqld

>Description: Running most or all of the mysql binaries results in the error: dynamic linker: my_print_defaults: relocation error: symbol not found: main illed I've installed pthreads 3.5c, but am unsure of their proper destination. >How-To-Repeat: ./mysqld >Fix: >Submitter-Id: >Originator

RE: BEGINNER: in mysql, better to do 1 table for one relationship, even with a one to one relation ?

Could you post your create table statement? It should be something like: CREATE TABLE relation_person_car( personID int 11 NOT NULL, carID int 11 NOT NULL, PRIMARY KEY (personID,carID) ); > -Original Message- > From: Alliax [mailto:[EMAIL PROTECTED]] > Sent: Satu

RE: Nested MySQL Statements

Not until version 4.1 > -Original Message- > From: Peter Vertes [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 13, 2002 8:43 AM > To: MySQL Help List (E-mail) > Subject: Nested MySQL Statements > > > Hello All, > > Is it possible to do nested select statements with MySQL > ?

RE: BEGINNER: in mysql, better to do 1 table for one relationship, even with a one to one relation ?

Hello, I've tried your way, but my SQL reports error, that I have specified more than ONE primary key, so I can't do the primary key on both fields. Is that a mySQL 3.X limitation ? My tables are ISAM. Following your advice, I've deleted the relation_person_carID, so only cardID and personID are le

The InnoDB on raw devices...

I'm trying to use InnoDB on raw device under Windows XP Prof. my innodb_data_file_path is : innodb_data_file_path = /dev/hda2:5Gnewraw but mysql not create a database :( any idea ? my system is : MySQL 3.23.54 on Windows XP Tnks, sql,query ---

re: MySQL Help - Initial Configuration

On Friday 13 December 2002 22:19, Benjamin Fisher wrote: > I'm fairly new to MySQL, and RDBMS's in general, but not to system > administration nor linux. I'm running Gentoo, and I can't seem to get > mySQL to work. [skip] > My guess, it can't find the pid to stop it with. > > And the file /var/r

Re: relational is relational is relational, but ...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, all -- ...and then David T-G said... % % I apologize in advance for asking kindergarten-level questions on the % list, but my head is getting really bruised from this one. I'm trying to I still don't understand it all ;-) but I have a somewh

re: MySQL4 user table not showing GRANT privileges correctly

On Saturday 14 December 2002 02:49, John Dell wrote: > Using MySQL 4.0.5a, GRANT is correctly adding users (and the privileges are > working), but when you view the mysql.user table, all privileges are > showing up as 'N', when some of them should be 'Y'. Anybody seen this or > understand what's g

re: RE: MySQLd-nt -3.23.53 Max

On Friday 13 December 2002 04:47, Charles Mabbott wrote: > I have some Access pages hooked to web, but a newbe with this [mysql] on > laptop. Running NT, windows office '98. I have found some stuff going > through tutorial, which I am impressed at how much is really working > right out of the bo

re: Nested MySQL Statements

On Friday 13 December 2002 14:43, Peter Vertes wrote: > Is it possible to do nested select statements with MySQL ? Basically > I'm trying to display the last 5 rows that got inserted into a table. My > SQL query looks like this: > > select * from tablename limit ((select count(*) from tablen

MySQL 3.23.54-max GLIBC errors

I am currently running MySQL3.23.53-max with no problems, well my_print_default complains about the same thing that MySQL-3.23.54 complains about, but MySQLd runs fine. I am attempting to upgrade to MySQL3.23.54 (mysql-max-3.23.54-pc-linux-i686.tar.gz) and MySQLd does not run at all, below are the

Major upgrade

Hi, I just became the database admin on this server, my first job was to upgrade the mysql install, it was running 3.22.30, I upgraded it to 3.23.54 Seemed to go OK, just want to check... I moved all the databases from var in the old install to data in the new install... all the databases seem t

RE: a simple query

SELECT a.Name,b.Name,c.Name FROM your_table a LEFT OUTER JOIN your_table b ON a.Code=b.ParentFemale LEFT OUTER JOIN your_table c ON a.Code=c.ParentMale > -Original Message- > From: Fam. Tarniceru [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 13, 2002 3:39 PM > To: MySQL Mailing List

Problem opening/finding default database when running mysqld through'safe_mysqld &' command...

>Description: Firstly, I don't believe this is a bug, but I really can't figure it out. I've installed MySQL through the Red Hat 8 distribution CDs. When I run safe_mysqld, I have the following message: [root@localhost bin]# safe_mysqld & [1] 25488 [root@localhost bin]# Starting mysqld

bug hpux 11.00

[wht20] >./mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1064 You have an error in your SQL syntax near 'TE TABLE db ( Host char(60) binary DEFAUL

weird auto increment behaviour (bug???)

Hi all, I have recently encountered some strange (to me) behaviour with an auto increment column. It resulted because of an oversight in table creation. Here is some SQL statements that will illustrate my issue: CREATE TABLE test ( ID INT AUTO_INCREMENT, Name CHAR(30), KEY (Name, ID) )

DEMO TIME: Need best options for source/smp/raid/x86 need to do a demo

Well I opened my big mouth and now have to do a demo of MySQL on an old server that was destined for the dumpster. It has 4 Pentium III, 512 MB of memory (bus unknown), an HP 3 channel RAID controller (Megatrends?), and 8 SCSI disks in an external array. I've configured the disks to have 4 disks

Load Data Local Infile

Thanks for the suggestions. So far I haven't been able to get this to work except on the client command line. I'm trying to use some PHP scripts with mysql_connect() and have added MYSQL_OPT_LOCAL_INFILE to the connection script as well, but no go. I added [client} local-infile=1 [mysql] local

Fastest way to get the number of rows in a table ?

Hi. I need to know the number of rows in a table. "select count(*) from a_table" works fine but it is slow when the table is big. I am trying instead "show table status like 'a_table'". The column 'Rows' should give me the number of rows in the table 'a_table'. This works fine for most of the ta

re: order results by count of searched expression

On Thursday 12 December 2002 20:20, Martin Hudec wrote: > I am trying to figure out sql command for ordering results descending > by counts of searched expressions found in result. like this: > > $search="some"; > > TEXT | COUNTS | > - > Something has..| 4

re: combine data from two tables

On Thursday 12 December 2002 20:35, Mark Goodge wrote: > I'm hoping that someone can give me some pointers on this problem. I have > two tables that contain similar data (eg, people.employees and > people.volunteers). I need to run a select statement to retrieve names from > both tables, and then

mysql install

Hi, I'm running Redhat 8.0 and I'm installing apache, php, mysql, postgres, openssl etc. my first step is to install mysql. I want it to be perl enabled, which means I have downloaded, (this is in compliance with the INSTALL BINARY doc that comes with mysql), http://www.mysql.com/doc/en/Perl_inst

MySQL crashes with foreign key restraints

Dear list, I am using MySQL-max 4.0.1 on Win 98 Second Edition with InnoDB as default table type. Using DeZign, I created the following SQL file with three tables (I left out all those other CHAR and TEXT fields here): CREATE TABLE Projekt( id SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (id)); CREAT

Re: MySQL 3.23.54 is released

On Thu, 12 Dec 2002, Lenz Grimmer wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi, > Hello > MySQL 3.23.54, a new version of the world's most popular Open Source > Database, has been released. It is now available in source and binary > form for a number of platforms from our downl

Addendum to the MySQL 3.23.54 release

I get an error after adding the "test" bit: /usr/local/mysql/bin/safe_mysqld: 5=nice --5 nohup: command not found - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

Addendum to the MySQL 3.23.54 release

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, unfortunately the MySQL 3.23.54 release includes a buglet in the "mysqld_safe" startup script that can lead to a "syntax error" message on startup. This does only apply to the Unix binaries, the Windows packages are not affected by this - they do

Compiling MySQL binary?

Hello, I'm interested in compiling my own MySQL binaries but I'm not quite sure of what all I will need to do so. From what I understand, thus far, I will need a MySQL source package and a compiler. Is there anything else I will need to complete this task and does anyone have a recommendation

Using MS Access as front end to mysql database

We have been informed by our web hosting site that we cannot connect remotely to our mysql database using any kind of connection other than a script from a web page or phpMyAdmin. It is our intent to have our data stored in a mysql database on the web and use MS Access as the front end to the data

Re: access->mysql

MySQL-Front was super and has a built in utility. Can do it remotely or locally. To bad they stopped supporting it. - Original Message - From: "Sandeep Murphy" <[EMAIL PROTECTED]> To: "Crercio O. Silva" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]> Sent: Thursday, December 05, 200

Syntax error in safe_mysqld (and safe_mysqld.sh)

>Description: I found 3 syntax errors found in safe_mysqld (and safe_mysqld.sh), in both source and binary distribution of MySQL 3.23.54. Since syntax errors are appearent, so I just post the patch file here to fix it. diff -u -r mysql-3.23.54/scripts/safe_mysqld.sh mysql-3.23.54-fixsafe

Re: Question about MySQL and lwp_mutex_lock and lwp_mutex_wakeup

On Thu, 12 Dec 2002 18:41:05 -0700 Mariella Di Giacomo <[EMAIL PROTECTED]> wrote: > Hello, > > I am running MySQL 4.0.5b 64 bits on a Solaris 2.8. > The server used has 8 CPUs. > > MySQL DB has access (and menage) in that system 2DBs. > The first DB is only is accessed only through SELECTS and

Re: Syntax error in safe_mysqld (and safe_mysqld.sh)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Fri, 13 Dec 2002, imacat wrote: > >Description: > I found 3 syntax errors found in safe_mysqld (and safe_mysqld.sh), > in both source and binary distribution of MySQL 3.23.54. Since syntax errors > are appearent, so I just post the pa

RE: problem with replication

hi check the master-slave replication compatibility see http://www.mysql.com/doc/en/Replication_Implementation.html maxime -Message d'origine- De : Natale Babbo [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 12 décembre 2002 17:49 À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED] Objet : RE: probl

MySQL4 user table not showing GRANT privileges correctly

Hi, Using MySQL 4.0.5a, GRANT is correctly adding users (and the privileges are working), but when you view the mysql.user table, all privileges are showing up as 'N', when some of them should be 'Y'. Anybody seen this or understand what's going on? For example: GRANT SELECT ON dbname.* TO test

RE: MySQLd-nt -3.23.53 Max

I have some Access pages hooked to web, but a newbe with this [mysql] on laptop. Running NT, windows office '98. I have found some stuff going through tutorial, which I am impressed at how much is really working right out of the book. I am sure has been found. but I was not able to get [fo

Nested MySQL Statements

Hello All, Is it possible to do nested select statements with MySQL ? Basically I'm trying to display the last 5 rows that got inserted into a table. My SQL query looks like this: select * from tablename limit ((select count(*) from tablename) - 5), -1; In theory it works for me :) b

Re: The Manual on MySQL is not updated...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Thu, 12 Dec 2002, Jocelyn Fournier wrote: > About "bk -r get -Sq", after a bk pull, is "bk -r edit" still needed or > "bk -r get -Sq" could replace it ? I'd say it's still needed, if you want to be able to make modifications, too. By default,

Re: MySQL eats 99& CPU time problem help

Hi Shawn, Also under BSDi make sure you are not running out of file descriptors. MySQL behaves very badly on BSDi when file descriptors run out! Ken - Original Message - From: "shawn xu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 11, 2002 11:12 AM Subject: MyS

FW: Merge Tables Across Databases

Can you create a merge table whose component tables exist in other databases? I am able to create merge tables for tables that are in one database but I want to be able to aggregate data from multiple databases. I am using 3.23 but I am migrating to 4.0.5a next week, if that makes a difference. T

chroot() in 3.23.54

Hi everyone, First off, please include my personal e-mail address in any responses, as i am not subscribed to the list. I run MySQL with the chroot option. Up until 3.23.54, it worked fine. 3.23.54 changed the ordering in which some files were accessed (before or after chroot()), which messed

Re: Migration from Oracle

Its a small migration. -Satish Stefan Hinz wrote: > Dear Satish, > > > Thank you for your help. > > Your welcome. > > > I used MyODBC 3.51, and successfully migrated to MySQL. > > Is this a MySQL user stories case, or just a small migration? > > Regards, > -- > Stefan Hinz <[EMAIL PROTECTED]>

/usr/bin/safe_mysqld: 5: command not found (WAS: Re: 3.23.54 compile error)

I got that as well., and like the case below, MySQL is up and running just fine. I tried looking in safe_mysqld for a spurious '5' but couldn't find anything. Does anyone know what's up with the most recent safe_mysqld? j-- k- On Thursday 12 December 2002 17:16, Gabriele Carioli wrote

re: 4.0.5: can't disable any logs!

On Wednesday 11 December 2002 20:11, Nicolas MONNET (Tech) wrote: > No matter what I do on the command line for mysqld, or in my.cnf, ALL > logs get activated! > > I'm using the Gentoo ebuilds, with mysqld started from an svscan run > script for supervision. Just don't specify any --log, --bin-lo

Re: The InnoDB on raw devices...

Dyego, from the documentation of CreateFile in old Visual C++ docs I found the following description how to specify in Windows the name of a disk drive or a partition on a disk drive. The name you used below looks more a Linux way to specify a disk partition. Best regards, Heikki Tuuri Innobase

Re: MySQL crashes with foreign key restraints

Stefan, please upgrade to 4.0.5 and test again. 4.0.1 is a very old alpha release, and lots of bugs have been fixed since. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news

Re: [MySQL] InnoDB Lock status

Patricio, - Original Message - From: ""Patricio Díaz G."" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, December 13, 2002 4:20 AM Subject: [MySQL] InnoDB Lock status > I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi > in a WinXP box, mo

re: problem with replication

On Wednesday 11 December 2002 18:03, Natale Babbo wrote: > I have a problem with replication between two servers. > I created user repl on the master, I restored the > master's dump on the slave, I changed both my.cnf > settings but I got this error from slave .err file: > > MySql: ready for conne

Re: 3.23.54 compile error

i mean... "MySQL 3.23.54 safe_mysqld fix" thread, sorry! t GC> GC> When I start mysql with GC> GC> service mysql start GC> GC> I get this error: GC> GC> /usr/bin/safe_mysqld: 5: command not found GC> What's that? GC> GC> By the way mysql seems up and running... GC> GC> GC> GC> ---

MySQL Help - Initial Configuration

I'm fairly new to MySQL, and RDBMS's in general, but not to system administration nor linux. I'm running Gentoo, and I can't seem to get mySQL to work. Gallio root # /etc/init.d/mysql start * Starting mysqld... [ ok ] Then I: Gallio root # ps ax PID TTY STAT TIME COMMAND 1 ? S 0:04 init

Re: Compiling 3.23.54-1

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Thu, 12 Dec 2002, Mark Matthews wrote: > > Did the mysql team change tools versions? automake/autoconf? > > Yes. You need automake 1.5 / libtool 1.4. It appears this made it into > the CHANGES for the 4.0.x series, but not the 3.23.x series.

Error rebuilding 3.23.54 source rpm, glibc 2.1?

I've got an older redhat 6.2 box that has glibc 2.1.3-28 on it. The binary rpm's won't install (needs glibc 2.2), and rebuilding the source rpm gives: make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.54/readline' Making all in libmysql make[2]: Entering directory `/usr/src/redhat/BUIL

  1   2   >