Help! Hanging mysql

2002-01-25 Thread Rune Sandbakken
p and down around 20. Any ideas? Rune Sandbakken Solfaktor.com Gran Canaria - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To re

Re: Checking if Replication really works

2002-01-18 Thread Rune Sandbakken
Henning Sprang wrote: > sascha mantscheff wrote: > >> I'm not using replication, but for a test if it really works I would >> do some data manipulations on the master and afterwards a complete >> mysqldump of master and replica and diff the result. > ok, this is an new and interesting idea, h

Re: What should I set in the mysql.user?

2002-01-18 Thread Rune Sandbakken
Takacs Istvan wrote: > What should I set in the mysql.user and mysql.db tables into the > Host field if I want to enable the connections just from the same > server not from everywhere? > '%', or 'localhost', or 'www.servername.com' ??? The safest and easiest way is to use the --skip-networkin

Re: auto_increment

2002-01-15 Thread Rune Sandbakken
Ben Curran wrote: > If one has created a table, with a key using auto_increment, how does one > Insert data into it? Data is automatically inserted for you ;-) > If my table consists of (inID (primary key, auto incremented), employeeID > (foreign key) time, date). > if I use > $dbh->do("IN