Re: mysql question --
| From: | Jason Caldwell | Date: | Sat, 13 Apr 2002 00:15:36 +0000 |
| Subject: | Re: mysql question -- | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-92827@lists.php.net to get a copy of this message | ||
Got it figured out --
--------------------
To export table structure:
C:> mysqldump -d {database name} {tables} >sqltextfile.sql
Then to import the new Table Structure:
To import table structure / data
C:> mysql {database name} <sqltextfile.sql
Just a note: If you want to copy the structure of an existing table with the
intent of
creating *another* table in the same DB with the same structure, then make
sure you edit the
"sqltextfile.sql" file and change the CREATE TABLE {table name} to something
else.
For example:
C:> mysqldump -d mydb subscribers >subscribers.sql
** edit the "subscribers.sql" text file and change the following line:
CREATE TABLE subscribers
to
CREATE TABLE subscribers2 (or whatever)
save... then
C:> mysql mydb <subscribers.sql
that's it...