RE: [PHP-DB] Getting SQL queries from existing DB
| From: | Rick Emery | Date: | Mon, 27 Aug 2001 14:29:03 +0000 |
| Subject: | RE: [PHP-DB] Getting SQL queries from existing DB | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11853@lists.php.net to get a copy of this message | ||
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:ahristov@icygen.com]
Sent: Monday, August 27, 2001 1:40 AM
To: Adriana Matiaskova; php-db@lists.php.net
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" <mati@host.sk>
To: <php-db@lists.php.net>
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: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net