Command line cheat sheet

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