just do:
mysqldump <options> db_name > db_name.sql
Your database tables and contents will be dumped into db_name.sql
Tylre
----- Original Message -----
From: ah <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 12:19 PM
Subject: constraint question
> hi
>
> I am using mysql 3.23.29 under windows 2000.I have a table:
>
> create table
>
ies(
> libID bigint NOT NULL AUTO_INCREMENT ,
> lib_datsvrID bigint null ,
> primary key (libID),
> constraint FK_LIBRAR_REF_584_DATASE foreign key (lib_datsvrID) references
>DataServers (datsvrID))
>
> I want to know how to view the constraints defined for libraries.
>
> I have another question: i want to do a backup of my database using mysqldump.
> what's the syntax of mysqldump database (under windows)
>
> thanks for help
> cheers
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
