Difference between revisions of "Command line cheat sheet"

Latest revision as of 11:51, 10 December 2021

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

Start/stop server

sudo service mysqld start

sudo service mysqld stop

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

Start/stop server

sudo /etc/init.d/tomcat6 stop

sudo /etc/init.d/tomcat6 start

List running applications

ls -l /usr/share/tomcat/webapps/*.war

Edit connection string

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

Edit server settings

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

@@ Line 18: / Line 18: @@
 </blockquote>
-=== Service control ===
+=== Service control [LINUX] ===
 Start/stop server
@@ Line 29: / Line 29: @@
 <blockquote>
 mysql -uroot -pPW1234
-* GRANT SELECT ON *.* TO 'remoteuser'.'195.67.11.34' IDENTIFIED BY 'PW1234';
+* GRANT SELECT ON *.* TO 'remoteuser'@'195.67.11.34' IDENTIFIED BY 'PW1234';
 * FLUSH PRIVILEGES;
 * exit
 </blockquote>
-== Tomcat commands ==
+== Tomcat commands [LINUX] ==
 Start/stop server
 <blockquote>sudo /etc/init.d/tomcat6 stop</blockquote>
 <blockquote>sudo /etc/init.d/tomcat6 start</blockquote>
+List running applications
+<blockquote>
+ls -l /usr/share/tomcat/webapps/*.war
+</blockquote>
 Edit connection string