Re: Prinitng MySQL Structure from ssh

2006-04-07 Thread Mark Sargent
Duncan Hill wrote: mysqldump is a shell command, not a mysql command. Hi All, oops, what a blunder. lol. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Prinitng MySQL Structure from ssh

2006-04-07 Thread alexj
hey, run mysqldump from your command prompt and not you mysql prompt. [EMAIL PROTECTED]:~> mysqldump --no-data osc -u admin -- MySQL dump 10.9 -- -- Host: localhostDatabase: osc Thanx Alex On Fri, 7 Apr 2006, Mark Sargent wrote: > alexj wrote: > > try mysqldump --no-data -u > Hi

Re: Prinitng MySQL Structure from ssh

2006-04-07 Thread Dominik Klein
mysql> mysqldump --no-data osc -u admin; ERROR 1064: You have an error in your SQL syntax near 'mysqldump --no-data osc -u admin' at line 1 You are supposed to execute that from a shell, not from within mysql Client. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Prinitng MySQL Structure from ssh

2006-04-07 Thread Duncan Hill
On Friday 07 April 2006 10:30, Mark Sargent wrote: > alexj wrote: > > try mysqldump --no-data -u > > Hi All, > > thanx, but get the following, > > mysql> mysqldump --no-data osc -u admin; > ERROR 1064: You have an error in your SQL syntax near 'mysqldump > --no-data osc -u admin' at line 1 mysql

Re: Prinitng MySQL Structure from ssh

2006-04-07 Thread Mark Sargent
alexj wrote: try mysqldump --no-data -u Hi All, thanx, but get the following, mysql> mysqldump --no-data osc -u admin; ERROR 1064: You have an error in your SQL syntax near 'mysqldump --no-data osc -u admin' at line 1 Cheers. Mark Sargent -- MySQL General Mailing List For list archive

Re: Prinitng MySQL Structure from ssh

2006-04-07 Thread alexj
try mysqldump --no-data -u Thanx Alex On Fri, 7 Apr 2006, Mark Sargent wrote: > Hi All, > > we have cli access to our MySQL database via ssh in the Admin GUI > and were wondering how to print the complete structure of a DB. I > searched the documents on MySQL homepage but couldn't find anythi

Prinitng MySQL Structure from ssh

2006-04-07 Thread Mark Sargent
Hi All, we have cli access to our MySQL database via ssh in the Admin GUI and were wondering how to print the complete structure of a DB. I searched the documents on MySQL homepage but couldn't find anything specific. Anyone know how to do this? Cheers. Mark Sargent. -- MySQL General Mail