Dumping sql commands

2004-03-25 Thread Erich Beyrent
Hi there, I am running a website on a host who has blocked access to mysqldump. Is there any way I can show all the sql commands for creating and populating a table from within mysql? Again, I don't have access to mysqldump. Thanks! -Erich- -- MySQL General Mailing List For list archives:

Re: Dumping sql commands

2004-03-25 Thread Victor Pendleton
What do you have access to? SSH? ODBC? Port Access? On Thu, 25 Mar 2004, Erich Beyrent wrote: Hi there, I am running a website on a host who has blocked access to mysqldump. Is there any way I can show all the sql commands for creating and populating a table from within mysql? Again, I

Re: Dumping sql commands

2004-03-25 Thread John Hicks
On Thursday 25 March 2004 03:11 pm, Erich Beyrent wrote: Is there any way I can show all the sql commands for creating and populating a table from within mysql? Here's the first half of your task: SHOW CREATE TABLE MyTableName; --John On Thursday 25 March 2004 03:11 pm, Erich Beyrent