create export table script - php + mysql

ChicoMendez · 2007-07-17 12:30:59

hi i need to get an export script for a table on a database im using does anyone know where i could see sample code or a tutorial on how to create this script so as i can save the script into a variable and then run it on another database. tnx

17-07-2007 12:30PM

#1

ChicoMendez

Registered Users, Registered Users 2 Posts: 648 ✭✭✭

Join Date: July 2003

Posts: 364

hi

i need to get an export script for a table on a database im using

does anyone know where i could see sample code or a tutorial on how to create this script so as i can save the script into a variable and then run it on another database.

tnx

0

Comments

#2 17-07-2007 01:18PM

The Corinthian

Closed Accounts Posts: 19,772 ✭✭✭✭

Join Date: June 2001

Posts: 19148

If you have access to phpmyadmin you should be able to see the typical syntax used when you export a table using CREATE TABLE. Beyond that all you need is the mysql_list_fields function in PHP. The following links are all you realistically need:

http://ie2.php.net/manual/en/function.mysql-list-fields.php
http://dev.mysql.com/doc/refman/5.0/en/create-table.html

0