Re: copying the structure of a blank table in mysql
| From: | Analysis & Solutions | Date: | Mon, 24 Jun 2002 05:01:46 +0000 |
| Subject: | Re: copying the structure of a blank table in mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-103535@lists.php.net to get a copy of this message | ||
Phil:
On Sun, Jun 23, 2002 at 11:14:22PM -0400, Phil Schwarzmann wrote:
> Anyone have a link (or the code) to copy the structure of a blank table
> to a new table using mysql?
It's far simpler to do this from a command line on the system using the
utilities of the database vendor, such as mysqldump, and then importing
the stuff into the database, again from the command line.
Look at the documentation of the database you're using.
--Dan
--
PHP classes that make web design easier
SQL Solution | Layout Solution | Form Solution
sqlsolution.info | layoutsolution.info | formsolution.info
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409