Re: [vchkpw] SQL data
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
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
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
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.