Difference between revisions of "Command line cheat sheet"
Jump to navigation
Jump to search
old>Admin |
old>Admin |
||
| Line 3: | Line 3: | ||
Import data from a SQL dump file to a specific database: | Import data from a SQL dump file to a specific database: | ||
<blockquote> | <blockquote> | ||
mysql -uroot -pPW1234 tslive < dumpLive.sql | mysql -uroot -pPW1234 --default_character_set utf8 tslive < dumpLive.sql | ||
</blockquote> | </blockquote> | ||
Export data | Export data to SQL dump file from selected databases | ||
<blockquote> | <blockquote> | ||
mysql -uroot -pPW1234 --databases tslive tstest tsbase > dump.sql | mysql -uroot -pPW1234 --databases tslive tstest tsbase > dump.sql | ||
Revision as of 00:34, 22 February 2013
MySQL commands
Import data from a SQL dump file to a specific database:
mysql -uroot -pPW1234 --default_character_set utf8 tslive < dumpLive.sql
Export data to SQL dump file from selected databases
mysql -uroot -pPW1234 --databases tslive tstest tsbase > dump.sql
Start and stop linux
Start services
sudo service mysqld start sudo /etc/init.d/tomcat6 start
Stop services
sudo /etc/init.d/tomcat6 stop sudo service mysqld stop
Tomcat linux
Edit connection string
sudo nano /usr/share/tomcat/conf/Catalina/localhost/TempusServa.xml
Edit server settings
sudo nano /usr/share/tomcat/conf/server.xml