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: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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 don't have access to
 mysqldump.
 
 Thanks!
 
 -Erich-
 
 
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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 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 don't have access to
 mysqldump.

 Thanks!

 -Erich-


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]