hi,
whats the quickest way to get data into a mysql database?
i'l be handling files with upto 1,000,000 records and up until now i've been using ms access (which i really want to get away from).
i've tried using php to read the data file, record at a time and then add it to a table but that was really slow.
is there a direct way to do it straigt from mysql, like in access i would just "import".
thanks.
whats the quickest way to get data into a mysql database?
i'l be handling files with upto 1,000,000 records and up until now i've been using ms access (which i really want to get away from).
i've tried using php to read the data file, record at a time and then add it to a table but that was really slow.
is there a direct way to do it straigt from mysql, like in access i would just "import".
thanks.