Just throwing this out there for the archives.
Installing 5.0.17 MySQL Client on a FreeBSD VPS2 Virtual server from
Verio kept throwing an error looking for zlib.la in the zlib library.
This system didn't have a system wide zlib installed, so the bundled
library kept trying to be used
I am trying to maintain one master list of countries and the states
within those countries. I'd like to keep this info in a common
database, to be used by 2 or three other databases on the same host,
using foreign keys to make sure that all the country/state data matches
up to the master
sol beach wrote:
Why in the world are you trying to keep multiple copies of the data?
Why can't you just access the 'master database'?
On 12/16/05, Scott Plumlee [EMAIL PROTECTED] wrote:
I am trying to maintain one master list of countries and the states
within those countries. I'd like
I'm trying to think of the ways I can accomplish having a master
database of countries and states/provinces that I can reference in
several other databases.
I'd like to have a table of countries available for selection by the
users in a web app, but I'm not sure of the best way to then allow
I'm not clear on best practice to use on a database containing both
MyISAM and InnoDB tables. For the MyISAM tables, it seems better to use
mysqldump --opt, thus getting the --lock-tables option, but for the
InnoDB the --single-transaction is preferred. Since they are mutually
exclusive, is
-Original Message-
From: Scott Plumlee [mailto:[EMAIL PROTECTED]
Sent: Friday, June 17, 2005 10:21 AM
To: mysql@lists.mysql.com
Subject: Backup database with MyISAM and InnoDB tables together
I'm not clear on best practice to use on a database containing both
MyISAM and InnoDB
notes:
http://dev.mysql.com/doc/mysql/en/News-4.1.2.html
Jim Winstead
MySQL AB
--
Scott Plumlee
PGP Public key: http://plumlee.org/pgp/ D64C 47D9 B855 5829 D22A D390
F8E2 9B58 9CBF 1F8D
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
the timestamp and inserted info
4. Find the row and id from table1 where the hash of the timestamp
value from step 1 and the data in the row match the hash from step 3
5. Put the id value into table 2
Seems like a lot of work to do to find the answer. Any gurus got an idea?
Scott Plumlee
PGP Public key
Scott Plumlee wrote:
I've looked through the PHP Cookbook and the MySQL cookbook and haven't
seen a solution. I've thought about trying to make some unique hash
with the data to be inserted but if there's another identical set of
data, then the hash would match. I can't use a timestamp
Found that function right after I posted. Thanks, it should do exactly
what I need.
Roger Baklund wrote:
* Scott Plumlee
I've got two separate tables, each with id fields that are
auto-increment. The created fields below are timestamps. The tables
are Innodb tables using transactions
the table values are
between those two values.
--
Scott Plumlee
PGP Public key: http://plumlee.org/pgp/ D64C 47D9 B855 5829 D22A D390
F8E2 9B58 9CBF 1F8D
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(dat_and_tim).
I will add the the PHP Cookbook and the MySQL Cookbook are godsends and
that's where I got the solution. Grab a copy of these to help out -
I've got a project due in a week and I'm using these non-stop.
--
Scott Plumlee
PGP Public key: http://plumlee.org/pgp/ D64C 47D9 B855 5829 D22A
12 matches
Mail list logo