phpMyAdmin can do this also. Can dump the data and structure to SQL Statements. The 
problem appears if the table for dumping is
100,000 rows or something bigger than the computer can get and start swapping.

Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
99%

----- Original Message -----
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Andrey Hristov'" <[EMAIL PROTECTED]>; "Adriana Matiaskova" <[EMAIL PROTECTED]>; 
<[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 5:29 PM
Subject: RE: [PHP-DB] Getting SQL queries from existing DB


> Use "mysqldump" utility (see MySQL manual, section 14.5)
>
>    shell> mysqldump [OPTIONS] database [tables]
>    OR    mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
>    OR    mysqldump [OPTIONS] --all-databases [OPTIONS]
>
>
> -----Original Message-----
> From: Andrey Hristov [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 27, 2001 1:40 AM
> To: Adriana Matiaskova; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Getting SQL queries from existing DB
>
>
> Get and install phpMyAdmin. It can dump to you, the stucture, the data or
> both. Then save them from the browser(better with lynx
> because you can get the source of a page piped). And pipe it to another
> "mysql", or use it in another phpMyAdmin.
>
> Andrey Hristov
> IcyGEN Corporation
> http://www.icygen.com
> 99%
>
> ----- Original Message -----
> From: "Adriana Matiaskova" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, August 26, 2001 12:39 PM
> Subject: [PHP-DB] Getting SQL queries from existing DB
>
>
> > Does anyone have some scripts/program for creating SQL queries from
> existing MySQL database? I mean, it will create queries like
> CREATE TALBES... to be able to make Database with the same structure.
> Thanks.
> >
> >
> > --
> > PHP Database 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]
> >
> >
>
>
> --
> PHP Database 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]
>


-- 
PHP Database 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