Update of /cvsroot/monetdb/sql
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv13004
Modified Files:
dump-restore.txt
Log Message:
propagated changes of Friday Nov 06 2009 - Monday Nov 09 2009
from the Nov2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/11/06 - sjoerd: dump-restore.txt,1.4.16.1
Updated dump instructions.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: dump-restore.txt
===================================================================
RCS file: /cvsroot/monetdb/sql/dump-restore.txt,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- dump-restore.txt 22 Aug 2007 06:22:04 -0000 1.4
+++ dump-restore.txt 8 Nov 2009 23:56:36 -0000 1.5
@@ -4,19 +4,20 @@
Start the SQL Server and SQL Client as usual.
In the SQL Client, type the following three commands. Type them
-without any extra white space:
+at the start of the line::
- >.../dump.sql
+ \>.../dump.sql
\D
- >
+ \>
-That is, first a line consisting of a greater than symbol followed by
-the absolute (!) path name of the file in which you want to store the
-dump. This will redirect future output to the file mentioned. Then a
-line consisting of just backslash-capital D. This command does the
-actual dump which is, because of the previous line, stored in the dump
-file. And finally a line with just a greater than symbol. This
-closes the file and redirects the output again to the screen.
+That is, first a line consisting of a backslash and greater than
+symbol followed by the path name of the file in which you want to
+store the dump. This will redirect future output to the file
+mentioned. Then a line consisting of just backslash-capital D. This
+command does the actual dump which is, because of the previous line,
+stored in the dump file. And finally a line with a backslash and
+greater than symbol. This closes the file and redirects the output
+back to the screen.
[Note: if you don't use the absolute path name of a file, the file
will be created in the directory where the SQL Client was started. On
@@ -24,9 +25,11 @@
therefore using an absolute path name is highly recommended.]
It is also possible to dump from the command line. Start a SQL
-Server, and then issue the command
+Server, and then issue the command::
- msqldump -umonetdb -Pmonetdb > dump.sql
+ msqldump -umonetdb > dump.sql
+
+You will need to provide the password (monetdb).
This command will connect to the SQL Server and dump the database into
the file dump.sql in the current directory.
@@ -39,14 +42,17 @@
Start the SQL Server and SQL Client as usual.
-In the SQL Client, type the following command.
+In the SQL Client, type the following command::
- <.../dump.sql
+ \<.../dump.sql
-That is, a less than symbol followed by the absolute (!) path name of
-the dump file that was produced using the dump instructions.
+That is, a backslash and less than symbol followed by the path name of
+the dump file that was produced using the dump instructions. Again,
+unless you use an absolute path name, the file name is relative to
+where the SQL client was started, which on Windows may not be where
+you expect.
It is also possible to restore from the command line. Start a SQL
-Server, and then issue the command
+Server, and then issue the command::
mclient -lsql -umonetdb -Pmonetdb < dump.sql
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
