Mysql commands: Difference between revisions

From RAJ INFO
Jump to navigation Jump to search
m New page: * GetDump <pre> $ mysqldump -u $usr -p -h $host $db >$outfile </pre> * RestoreDump <pre> $ mysql -u $usr -p -h $host $db <$outfile </pre>
 
mNo edit summary
Line 1: Line 1:
* GetDump
* GetDump
<pre>
<mysql>
$ mysqldump -u $usr -p -h $host $db >$outfile  
$ mysqldump -u $usr -p -h $host $db >$outfile  
</pre>
</mysql>


* RestoreDump
* RestoreDump


<pre>
<mysql>
$ mysql -u $usr -p -h $host $db <$outfile
$ mysql -u $usr -p -h $host $db <$outfile
</pre>
</mysql>

Revision as of 03:08, 24 August 2008

  • GetDump

<mysql> $ mysqldump -u $usr -p -h $host $db >$outfile </mysql>

  • RestoreDump

<mysql> $ mysql -u $usr -p -h $host $db <$outfile </mysql>