14,962
edits
Linux commands: Difference between revisions
Jump to navigation
Jump to search
m
→mysql operation
| Line 108: | Line 108: | ||
== mysql operation == | == mysql operation == | ||
=== import MySql sql | === import MySql sql file === | ||
{{exclaim}} Notice: existing database will be overwritten | {{exclaim}} Notice: existing database will be overwritten | ||
* {{Gd}} Import the compressed *.sql file with gzip (especially for BIG sql file). It will show a progress bar and estimate time to complete the mysql command: | * {{Gd}} Import the compressed *.sql file with gzip (especially for BIG sql file). It will show a progress bar and estimate time to complete the mysql command: | ||
| Line 129: | Line 129: | ||
*# enter {{kbd | key = <nowiki>password</nowiki> }} and press {{kbd | key = <nowiki>Enter</nowiki> }} | *# enter {{kbd | key = <nowiki>password</nowiki> }} and press {{kbd | key = <nowiki>Enter</nowiki> }} | ||
=== export MySql sql | === export MySql sql file === | ||
* export the *.sql file | * export the *.sql file | ||
*# {{kbd | key = <nowiki>mysqldump -h localhost -u username -p DATA-BASE-NAME > /path/to/database.sql </nowiki>}} | *# {{kbd | key = <nowiki>mysqldump -h localhost -u username -p DATA-BASE-NAME > /path/to/database.sql </nowiki>}} | ||