Best way to duplicate tables to another DB using PHP
| From: | David Yee | Date: | Tue, 02 Oct 2001 21:22:05 +0000 |
| Subject: | Best way to duplicate tables to another DB using PHP | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-69642@lists.php.net to get a copy of this message | ||
Hi guys. What do you suggest is the best (fastest, most efficient) way to
duplicate a table from one database to another using PHP? I have a windows
machine setup with ODBC for this old school DB (Pervasive SQL 7) and I would
like to duplicate some of the tables into a Linux box with MySQL for some
datawarehousing purposes. The largest table is about 30K records. I'm not
sure if something like a "select *" and then doing a foreach record insert
into MySQL would be the best way. Thanks for any suggestions.
David