Command line cheat sheet

MySQL commands

Import and export

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

Export ALL data to SQL dump file

mysql -uroot -pPW1234 --all-databases > dump.sql

Service control [LINUX]

Start/stop server

sudo service mysqld start

sudo service mysqld stop

User management

Add extra user with readonly access to all databases

mysql -uroot -pPW1234

• GRANT SELECT ON *.* TO 'remoteuser'.'195.67.11.34' IDENTIFIED BY 'PW1234';
• FLUSH PRIVILEGES;
• exit

Tomcat commands

Start/stop server

sudo /etc/init.d/tomcat6 stop

sudo /etc/init.d/tomcat6 start

Edit connection string

sudo nano /usr/share/tomcat/conf/Catalina/localhost/TempusServa.xml

Edit server settings

sudo nano /usr/share/tomcat/conf/server.xml