Can anyone show an example MySQL command to import a text file into a table?
I have a massive qty of data to get into a MySQL database on a server over
the internet. Shouldn't I be able to do this with a bulk operation instead
of a script with many tens of thousands of INSERT statements? I can deliver
each tables data as comma delimited text files.
Do I need to start with an empty MySQL table or can I import the text table
directly?
I am working with a remote Apache server using an ssh telnet jailshell
window. I have to ftp compressed files since the amount of data is large
and the uplink speed is slow.
Any clues would be appreciated.
Thomas Bartkus
I have a massive qty of data to get into a MySQL database on a server over
the internet. Shouldn't I be able to do this with a bulk operation instead
of a script with many tens of thousands of INSERT statements? I can deliver
each tables data as comma delimited text files.
Do I need to start with an empty MySQL table or can I import the text table
directly?
I am working with a remote Apache server using an ssh telnet jailshell
window. I have to ftp compressed files since the amount of data is large
and the uplink speed is slow.
Any clues would be appreciated.
Thomas Bartkus