MSAccess --> MySQL - append query slows, then dies

2001-08-22 Thread Ide, James J Mr CMH/LGB
My setup: Dell PowerEdge 4200 with 512 mb ram, plenty of free disk space WinNT Server 4.0 with sp6 MS Access 97 MySQL 3.23.38-nt (installed binany from mysql-3_23_38-win.zip) MyODBC 2.50.38 (installed from myodbc-2_50_38-nt.zip) My objective: Copy data from two large MS Access 97 to MySQL tabl

simple SQL question

2001-01-25 Thread lgb
Hi, Sorry for the possible offtopic question I'm going to ask. I have got something similar (this is very simplicated situation of my problem but this is the core of my headache): CREATE TABLE cityname ( id BIGINT NOT NULL AUTO_INCREMENT, cname CHAR(50), INDEX i