Re: Strange results from a query

In both mysql 4.0.20 and 4.1.4a-gamma, I get mysql> CREATE TABLE master (col1 INT NOT NULL); Query OK, 0 rows affected (0.09 sec) mysql> CREATE TABLE sub (col1 INT NOT NULL, a CHAR(1) NULL, b CHAR(1) NULL, c SMALLINT); Query OK, 0 rows affected (0.01 sec) mysql> INSERT INTO MASTER (col1) VALUES (

Re: flush and flush delay

Right, MySQL would be configured so that the data directory is on the RAM disk. On power-up you would recreate the RAM disk, fill it with the last backup from the flashdisk, then start mysqld. You would, of course, lose everything since the last backup, but you said that was OK for your app.

Re: mysql 4.1 + debian

Ron Gilbert wrote: I got 4.1 from the debian site, 4.1 that is on the mysql site is a RPM and I've had no luck installing rpm's on debian, even using alien. No, it's *available* as an RPM, but the *first* thing on the MySQL download page is a binary for Linux packaged as a tar file. Why not just u

Re: mysql 4.1 + debian

No, I did not see the reply, sorry, I just saw the original message. I got 4.1 from the debian site, 4.1 that is on the mysql site is a RPM and I've had no luck installing rpm's on debian, even using alien. Ron On Oct 31, 2004, at 12:02 PM, Michael Stassen wrote: If you're talking about the earli

Re: mysql 4.1 + debian

If you're talking about the earlier message on this list, did you read the reply ? It doesn't appear you've installed the official MySQL binary package, as it's not labeled "experimental". I'd suggest downloading an official binary from the MySQL downloads

Re: libmysqlclient.so.12 client libraries for OS X

MySQL does not come in pieces for Mac OS X. The whole thing comes in one Mac OS X binary package in PKG format, downloaded as a disk image (.dmg) file . The installer puts everything in /usr/local/mysql-VERSION, with a symbolic link

RE: synchronizing mysql database in two different places

As suggested by Karam, please refer to http://dev.mysql.com/doc/mysql/en/Replication_Implementation.html for additional information. -Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED] Sent: Sunday, October 31, 2004 1:29 PM To: Eko Budiharto; [EMAIL PROTECTED] Subject: Re: syn

Re: synchronizing mysql database in two diferrent places

Hello, You might try MySQL's inbuilt replication feature. If you want a more simple approach, might take a look at SQLyog's Data Sync Wizard. More information can be found at http://www.webyog.com I think they have a article on the same subject in SitePoint. You might google it. Karam --- Eko

libmysqlclient.so.12 client libraries for OS X

Where is there an OS X equivalent of: "MySQL-client-VERSION.i386.rpm The standard MySQL client programs. You probably always want to install this package." which is referred to here: http://dev.mysql.com/doc/mysql/en/Linux-RPM.html Specifically, I am looking for libmysqlclient.so.12 since you can

Linker Error

I'm using 4.0.20a on Windows 98. My program compiler successfully but gives a linker error: C:\SC\BIN\..\lib\mysqlclient.lib(default) Offset 955A0H Record Type 00C3 Error 16: Index Range --- errorlevel 1 --- errorlevel 1   Regards Premal.

Re: Converting table type

> At 11:06 -0500 10/30/04, Michael Satterwhite wrote: > >On Saturday 30 October 2004 10:58 am, Paul DuBois wrote: > >> > >> What output does the following statement produce? > >> > >> SHOW VARIABLES LIKE 'have_innodb'; > >> > >> If YES, the ALTER TABLE statement should have worked. > >> If N

MySQL Control Center and Linux box connection

I have Linux box running Red Hat and 3.23. I install MySQL Contorl Center and trying connect to the mysql on Linux box. When I try to connect I receive the error message. ERROR: HOST 'ip address' is not allowed to connect to this MySQL server. What I'm doing wrong here? TH -- MySQL General Ma

prepared statements and server restart

I tried to browse through the documentation to figure out what happens with prepared statements if the server is restarted while the prepared statement is assigned an ID and is being used repeatedly. The client then silently reconnects (reconnect flag is set). Is the expected behaviour for the

mysql 4.1 + debian

I just installed debian (test) and am trying to get mysql 4.1 working. The only deb package for 4.1 that I could find was "experimental", which might explain the problem I am having. When I start the server, I get the following in my syslog: Oct 31 01:35:22 cove1 mysqld_safe[2523]: started Oct