RE: Copy database to a file

2006-06-20 Thread J.R. Bullington
The command is mysqldump

Here's the man file on it:

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
 

-Original Message-
From: Karl Larsen [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 20, 2006 3:09 PM
To: mysql@lists.mysql.com
Subject: Copy database to a file

I have been reading the Reference and saw how to convert my database
tables and stuff to the words that made them and puts it into a file. 
But now I need it I can't find it.

If you know how please send along how or a page(s) in the Reference.


Karl

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



smime.p7s
Description: S/MIME cryptographic signature


RE: Copy database to a file

2006-06-20 Thread Thomas Amundsen
I'm running MySQL server 5.0...???

mysql mysqldump --help;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that
corresponds to your MySQL server version for the right syntax to use
near 'mysql
dump --help' at line 1

-Original Message-
From: J.R. Bullington [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 20, 2006 11:32 AM
To: mysql@lists.mysql.com
Subject: RE: Copy database to a file

The command is mysqldump

Here's the man file on it:

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
 

-Original Message-
From: Karl Larsen [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 20, 2006 3:09 PM
To: mysql@lists.mysql.com
Subject: Copy database to a file

I have been reading the Reference and saw how to convert my database
tables and stuff to the words that made them and puts it into a file. 
But now I need it I can't find it.

If you know how please send along how or a page(s) in the Reference.


Karl

--
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: Copy database to a file

2006-06-20 Thread Jørn Dahl-Stamnes
On Tuesday 20 June 2006 21:37, Thomas Amundsen wrote:
 I'm running MySQL server 5.0...???

 mysql mysqldump --help;
 ERROR 1064 (42000): You have an error in your SQL syntax; check the
 manual that
 corresponds to your MySQL server version for the right syntax to use
 near 'mysql
 dump --help' at line 1

Exit mysql and run mysqldump from the shell.

-- 
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/

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