Difference between revisions of "Command line cheat sheet"

Revision as of 01:47, 22 February 2013

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

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 1: / Line 1: @@
 == MySQL commands ==
+=== Import and export ===
 Import data from a SQL dump file to a specific database:
@@ Line 15: / Line 17: @@
 mysql -uroot -pPW1234 --all-databases > dump.sql
 </blockquote>
+=== Service control ===
 Start/stop server
 <blockquote>sudo service mysqld start</blockquote>
 <blockquote>sudo service mysqld stop</blockquote>
+=== User management ===
+Add extra user with readonly access to all databases
+<blockquote>
+mysql -uroot -pPW1234
+* GRANT SELECT ON *.* TO 'remoteuser'.'195.67.11.34' IDENTIFIED BY 'PW1234';
+* FLUSH PRIVILEGES;
+* exit
+</blockquote>
 == Tomcat commands ==