mysqldump would work pretty well if the source DB is mysql, but it's a DB I have to 
access via ODBC on a windows box instead.  And this particular DB doesn't seem to have 
a command line interface to export a table that I can call from PHP.  

David
  ----- Original Message ----- 
  From: sagar N Chand 
  To: David Yee 
  Sent: Wednesday, October 03, 2001 6:09 AM
  Subject: Re: [PHP] Best way to duplicate tables to another DB using PHP


  use mysql statement mysql_dump thru php.

  /sagar

    ----- Original Message ----- 
    From: David Yee 
    To: [EMAIL PROTECTED] 
    Sent: Wednesday, October 03, 2001 2:52 AM
    Subject: [PHP] Best way to duplicate tables to another DB using PHP


    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


    -- 
    PHP General Mailing List (http://www.php.net/)
    To unsubscribe, e-mail: [EMAIL PROTECTED]
    For additional commands, e-mail: [EMAIL PROTECTED]
    To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to