RE: [PHP-DB] Import/Export data
| From: | Peter Lovatt | Date: | Thu, 18 Apr 2002 22:20:24 +0000 |
| Subject: | RE: [PHP-DB] Import/Export data | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18660@lists.php.net to get a copy of this message | ||
Hi
The most universal way would be to export the table to CSV format. You can
then use
LOAD DATA INFILE phpMyAdmin to load it into the database.
http://www.mysql.com/doc/L/O/LOAD_DATA.html
HTH
Peter
-----------------------------------------------
Excellence in internet and open source software
-----------------------------------------------
Sunmaia
www.sunmaia.net
info@sunmaia.net
tel. 0121-242-1473
-----------------------------------------------
> -----Original Message-----
> From: Rosen Marinov [mailto:rosen@pernikinfo.com]
> Sent: 18 April 2002 17:28
> To: php-db@lists.php.net
> Subject: [PHP-DB] Import/Export data
>
>
> Hi,
> How can I import/Export data to MySQL database using PHP
> following formats:
> EDI, Access, Excel ?
>
> Where can I find information about this ?
>
> Thanks,
> Rosen Marinov
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>