Mysql commands: Difference between revisions

From RAJ INFO
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 15: Line 15:
<pre>
<pre>
$ mysql -u $usr -p -h $host $db <$outfile
$ mysql -u $usr -p -h $host $db <$outfile
* Create a soft Link
ln -s /home/copperhills/copperhills /var/www/copperhills
</pre>
</pre>
[[Category:Bioinformatics]]
[[Category:Bioinformatics]]

Revision as of 15:02, 9 December 2018

  • GetInto from Shell
$ mysql -u $usr -p -h $host $db


  • GetDump
$ mysqldump -u $usr -p -h $host $db >$outfile 
  • RestoreDump
$ mysql -u $usr -p -h $host $db <$outfile


* Create a soft Link
ln -s /home/copperhills/copperhills /var/www/copperhills