Duplicate database for test at same machine

------=_NextPart_000_0042_01C59805.88836CA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Everbody !

I need to test one application in another database Mysql.
I'd like to copy only structure from one database for another database =
at same machine.
Can I to do this using Mysqldump ? If not, how i can to do this ?

Environment:

Win2000 Pro
MySQL 4.1.10a-nt-log via TCP/IP

Thank a lot

Ezequiel Marin
GVM - Inform=E1tica S/S LTDA
Brazil / Ja=FA / SP
(14)-3621-7111
www.gvmsistemas.com.br
suporte@gvmsistemas.com.br
Visual Dataflex 11.0
------=_NextPart_000_0042_01C59805.88836CA0--

RE: Duplicate database for test at same machine

Ezequiel,
As you said, you can use the mysqldump utility to export the data to =
another
database. If you type $> mysqldump mydatabase mytable, the program will
output the sql statements needed to create mytable (the table =
structure) and
the sql statements needed to insert all the data. If you JUST want the =
table
structure, issue the --no-data (-d) option.
Here is a link to the documentation for mysqldump
http://dev.mysql.com/doc/mysql/en/mysqldump.html

Good luck=20

-----Mensaje original-----
De: GVM - UOL [mailto:gvm.jau@uol.com.br]=20
Enviado el: Mi=E9rcoles, 03 de Agosto de 2005 06:30 a.m.
Para: win32@lists.mysql.com
Asunto: Duplicate database for test at same machine

Hi Everbody !

I need to test one application in another database Mysql.
I'd like to copy only structure from one database for another database =
at
same machine.
Can I to do this using Mysqldump ? If not, how i can to do this ?

Environment:

Win2000 Pro
MySQL 4.1.10a-nt-log via TCP/IP

Thank a lot

Ezequiel Marin
GVM - Inform=E1tica S/S LTDA
Brazil / Ja=FA / SP
(14)-3621-7111
www.gvmsistemas.com.br
suporte@gvmsistemas.com.br
Visual Dataflex 11.0

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org