I was able to to the following, based on the post above:
sudo apt-get install sysv-rc-conf
sudo sysv-rc-conf
mark the 6 column for mysqld or mysql.server (6 = reboot)
Note: I tried sudo update-rc.d mysql.server defaults and it didn't work. It gave me the following error: System start/stop links for /etc/init.d/mysql.server already exist.
if(`table`.`start`='0000-00-00','',`table`.`start`) That's the part of my query that was increasing the execution time by 10x. I changed it to just `table`.`start` (without the IF statement) and the query was 10x faster.
Error: Can't find out if NetworkManager is running: Failed to connect to socket /var/run/dbus/system_bus_socket: No such file or directory. The following fixed the problem: apt-get install dbus (if you already have dbus installed: sudo service dbus start) /etc/init.d/network-manager start
What caused the error?: /etc/init.d/network restart
# If is there another instance already running: # display the message “Another instance is already running, quitting.”, and return -1 error code. me = SingleInstance()
That's a guide to making WinSCP send a dummy command every 30 seconds to keep your connection alive. It's way better than constantly having to type in your password.
I wanted to run a script every 20 minutes, so I put this into my crontab: 20 * * * * sh script.sh
That's wrong. That only runs it once every hour 20 minutes into the hour. For example, "20,40 * * * * sh bash.sh" would run it twice - 20 and 40 minutes into the hour.
To run the script every 20 minutes like I was expecting: */20 * * * * sh script.sh