RE: [PHP] easy mysql question

On 09-Jul-01 [EMAIL PROTECTED] wrote: > Since I first made the tables for my site I've had to modify them quite a > bit. I always keep a copy of the commands I used to make the tables in case > I need to move a site. Is there a way to ask mysql to list the create table > commands? > $ mysqldump

Re: [PHP] easy mysql question

if you use phpMyAdmin you can dump the structure and data to a file and use phpMyAdmin to place it on a new machine At 10:48 PM 7/8/01 -0400, [EMAIL PROTECTED] wrote: >Since I first made the tables for my site I've had to modify them quite a >bit. I always keep a copy of the commands I used to m

Re: [PHP] easy mysql question

<[EMAIL PROTECTED]> wrote: > I need to move a site. Is there a way to ask mysql to list the create table > commands? mysqldump -d database or mysqldump -d database table mysqldump --help for more info. [Cough] I mentioned the mysql mailing list to you off-list Thursday... List-Subscribe:

Re: [PHP] easy mysql question

On Sunday 08 July 2001 21:48, [EMAIL PROTECTED] wrote: > Since I first made the tables for my site I've had to modify them quite a > bit. I always keep a copy of the commands I used to make the tables in case > I need to move a site. Is there a way to ask mysql to list the create table > commands?

RE: [PHP] easy mysql question

Do you mean to output the current structure of the table? Check out http://www.mysql.com/doc/m/y/mysqldump.html. Mysqldump will do that for you... If you mean a syntax reference, check www.mysql.com. If you didn't mean either of those things, Sorry => Ben -Original Message- From: [EMAI

Re: [PHP] Easy MySQL question

Joseph, here it is: Number of manpages in db: hope that's what you were looking for, Nicolas. "Paulson, Joseph V. \"Jay\"" wrote: > > Hello everyone-- > I've got a easy question that I can't seem to answer for myself. I'm > running a query in MySQL and want to know how m