Re: [vchkpw] SQL data

2003-07-31 Thread Rudi Ahlers
Thanx


Kind Regards
Rudi Ahlers
Oc Software Support
+27 (11) 661-9000

The basic difference between an ordinary man and a warrior is that a
warrior takes everything as a challenge while an ordinary man takes
everything either as a blessing or a curse.

- Original Message -
From: Scott Helms [EMAIL PROTECTED]
To: Rudi Ahlers [EMAIL PROTECTED]
Cc: VpopMail [EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 4:26 PM
Subject: Re: [vchkpw] SQL data


Rudi,

Here is the base way of doing it without any data.

mysqldump -d DATABASENAME  backup-file.sql


You can read this back into MySQL with:


mysql DATABASENAME  backup-file.sql

Check here for more options for mysqldump:

http://www.mysql.com/doc/en/mysqldump.html

Scott Helms


On Mon, 2001-07-30 at 09:20, Rudi Ahlers wrote:
 I know this is not entirely an SQL mailing list, but how do I dump only my
 database table layout? I don't want a dump of all the data


 Kind Regards
 Rudi Ahlers
 Oc Software Support
 +27 (11) 661-9000

 The basic difference between an ordinary man and a warrior is that a
 warrior takes everything as a challenge while an ordinary man takes
 everything either as a blessing or a curse.











[vchkpw] SQL data

2003-07-30 Thread Rudi Ahlers
I know this is not entirely an SQL mailing list, but how do I dump only my
database table layout? I don't want a dump of all the data


Kind Regards
Rudi Ahlers
Océ Software Support
+27 (11) 661-9000

The basic difference between an ordinary man and a warrior is that a
warrior takes everything as a challenge while an ordinary man takes
everything either as a blessing or a curse.





Re: [vchkpw] SQL data

2003-07-30 Thread Justin Heesemann
On Monday 30 July 2001 15:20, Rudi Ahlers wrote:
 I know this is not entirely an SQL mailing list, but how do I dump
 only my database table layout? I don't want a dump of all the data


man mysqldump 

...
-d|--no-data
  No row information.
---

so i assume   mysqldump -d databaseyouwanttodump
does the job


and this really is not entirely a SQL mailing list.

-- 
Mit internetten Grüßen / Best Regards
---
Justin Heesemannionium Technologies
[EMAIL PROTECTED]www.ionium.org





Re: [vchkpw] SQL data

2003-07-30 Thread Scott Helms
Rudi,

Here is the base way of doing it without any data.

mysqldump -d DATABASENAME  backup-file.sql


You can read this back into MySQL with:


mysql DATABASENAME  backup-file.sql

Check here for more options for mysqldump:

http://www.mysql.com/doc/en/mysqldump.html

Scott Helms


On Mon, 2001-07-30 at 09:20, Rudi Ahlers wrote:
 I know this is not entirely an SQL mailing list, but how do I dump only my
 database table layout? I don't want a dump of all the data
 
 
 Kind Regards
 Rudi Ahlers
 Oc Software Support
 +27 (11) 661-9000
 
 The basic difference between an ordinary man and a warrior is that a
 warrior takes everything as a challenge while an ordinary man takes
 everything either as a blessing or a curse.