Re: SQL Server DB to mySQL DB
| From: | Christopher Allen | Date: | Thu, 25 Jan 2001 16:15:34 +0000 |
| Subject: | Re: SQL Server DB to mySQL DB | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-36640@lists.php.net to get a copy of this message | ||
Just did this to a 65mb fixed width file.
What I did was get it into a csv file via perl :)
Then I created the db table.
Then I used:
load data infile "/file.csv" into table blah fields terminated by ',' ;
then go ahead and create any indexes etc...
!works slick!
> Is there an easy way to do this? I know that SQL Server can export a comma
> delimited file, can mySQL import this? I imagine the PHP will be easy to
> modify as long as the field names are the same.