Re: regular backup database in mysql

hi i do this on windows2000 like that first I create directory Archive on local disk and in that dir some subdirs like mon,tue ... for every weekday then you should create ms-dos batch file e.g. back0.bat in root of disk c:\ and put commands in it: rem BACKUP mysqldump -h192.168.1.1 -uroot

Re: primary key based on unique value for two columns

sure you can CREATE TABLE xx (field1 INT NOT NULL,field2 INT NOT NULL,PRIMARY KEY (field1,field2)) and you have table xx with unique key in two fields hand primoz - Original Message - From: Brendin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 12, 2001 7:37 PM