Re: Getting SQL queries from existing DB
| From: | Andrey Hristov | Date: | Mon, 27 Aug 2001 14:36:16 +0000 |
| Subject: | Re: Getting SQL queries from existing DB | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11855@lists.php.net to get a copy of this message | ||
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" <remery@excel.com>
To: "'Andrey Hristov'" <ahristov@icygen.com>; "Adriana
Matiaskova" <mati@host.sk>; <php-db@lists.php.net>
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: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
>