Yes I had thought I should use tools to copy, but I have had problems with mysqldump. I successfully created a dump file, but when I execute this file on an empty database I got: C:\xampp\xampp\mysql\bin>mysql -uroot db2 < test1.txtERROR 1064 at line 54: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'on date NOT NULL default '0000-00-00', PRIMARY KEY (staff,shrefering I presume to CREATE TABLE shift ( staff char(20) NOT NULL default '', shift char(1) NOT NULL default '', client char(20) default NULL, role char(1) default NULL, on date NOT NULL default '0000-00-00', PRIMARY KEY (staff,shift,on),... etc Could it be that the version of mysqldump that has been installed is not in step with the server or are there some issues with SQL generated by mysqldump. I have MySQL 4.0.18 and the mysqldump is : mysqldump Ver 9.10 Distrib 4.0.17, for Win95/Win98 (i32)By Igor Romanenko, Monty, Jani & Sinisa This is not an installation I have control over. Soryy to be a pain, any ideas? Andrew H
