Picking up on the end of this thread which I found very useful, I have tried to set up bigdump. I have a database and a table called employees (used for testing). i can upload a employees.csv file that has 6 fields. When I try to import it I have an error message: Can anyone shed any light on this? Thank you
it's because you have a , in your name John Smith, so it's acting as there is 6 fields, when there is only 5. Or less your fields have a first name, and a last name.
Cant tell without knowing the database structure. Please post the structure here and ill tell you whats wrong.
Use ftp to transfer the file and for the error, you should be using single quote around your values and make sure the columns match in the rows and table schema.
I know it's been mentioned 100 times but bigdump is a must have file for any developer. I use this for all large website migrations.