Mysql commands: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
* GetInto from Shell | |||
<pre> | |||
$ mysql -u $usr -p -h $host $db | |||
</pre> | |||
* GetDump | * GetDump | ||
< | <pre> | ||
$ mysqldump -u $usr -p -h $host $db >$outfile | $ mysqldump -u $usr -p -h $host $db >$outfile | ||
</ | </pre> | ||
* RestoreDump | * RestoreDump | ||
< | <pre> | ||
$ mysql -u $usr -p -h $host $db <$outfile | $ mysql -u $usr -p -h $host $db <$outfile | ||
</ | </pre> | ||
Revision as of 03:34, 7 September 2008
- 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