I am using XAMPP for Windows 1.6.4 with MySQL 5.0.45.
I have included a forum and a blog (for experience) and am trying to create a MySQL database to replace one running in Alpha5. I've dumped out the data as CSV files, run them through a program called CSV2SQL to produce SQL import files and am importing into a MyISAM database using phpMyAdmin.
This is the first file called authors, 2 fields authorno smallint(4) and author varchar(75). I have 2 indices - primary on authorno and unique on author.
ran the import several times, stopped by errors in data. Each time corrrected the error and removed the data already added. Got to 519 items in the table.
But now when I run it, it times out at 300 secs apparently 'waiting for localhost'. At first it was a complete transaction - no data added. I removed the transaction, making it individual lines. Same result - times out and does not add any data!
checking and repairing table - fine but no difference.
Can anybody suggest anything?
p.s. I used to be a programmer but am a tyro with MySQL and Apache
The only other thing is I have recently upgraded from xampp vn 1.5. Thanks to help from this forum, I exported my data, copied my htdocs directory, installed new 1.6.4 and imported the data back, after copying my htdocs directory. No real problems. Could this have any bearing on problem?
Thanks
I should have added: Windows XP IBM Intellistation with 2 x 599 Mhz and 256 Mb RAM (virtual 768)