Difference between revisions of "Command line cheat sheet"
Jump to navigation
Jump to search
old>Admin |
old>Admin |
||
| Line 9: | Line 9: | ||
<blockquote> | <blockquote> | ||
mysql -uroot -pPW1234 --databases tslive tstest tsbase > dump.sql | mysql -uroot -pPW1234 --databases tslive tstest tsbase > dump.sql | ||
</blockquote> | |||
Export ALL data to SQL dump file | |||
<blockquote> | |||
mysql -uroot -pPW1234 --all-databases > dump.sql | |||
</blockquote> | </blockquote> | ||
Revision as of 01:37, 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
Export ALL data to SQL dump file
mysql -uroot -pPW1234 --all-databases > dump.sql
LINUX Start and stop
Start services
sudo service mysqld start
sudo /etc/init.d/tomcat6 start
Stop services
sudo /etc/init.d/tomcat6 stop
sudo service mysqld stop
LINUX Tomcat
Edit connection string
sudo nano /usr/share/tomcat/conf/Catalina/localhost/TempusServa.xml
Edit server settings
sudo nano /usr/share/tomcat/conf/server.xml