New csv files not showing via phpmyadmin

[keepingbusy]

Hi

I had a list of about 58000 titles on our website. I tried to clear these using myphpadmin, then selecting the relevant table and clicking on empty. I then uploaded new csv files (which have worked perfectly before) but now when you visit the website, the old lists are still there.

Please can someone suggest what is going on here?

Thank you
Lee

 

[guelphdad]

use TRUNCATE to clear the old data from your tables and LOAD DATA LOCAL INFILE to import your csv.

 

[keepingbusy]

Thanks guelphdad, I'll try that

Lee


Windows XP
Visual FoxPro Version 6 & 9

http://www.customsoftware.co.uk

 

[keepingbusy]

guelphdad

All sorted, many thanks

Lee