Here are some quick changes you can make to Remote Desktop Connection options for better performance.
1. In the Display Tab, choose a lower color depth. The less colors, the better.
2. In the Local Resources tab, unselect Printers. I find the Clipboard option useful, so I keep that checked. If you don’t need to copy paste between your local and remote PC, you can disable this as well.
3. Still on the Local Resources tab, click on Remote Audio Settings. In the Remote audio playback section, click on “Do not play”.
4. In the Experience tab, uncheck all options except for “Persistent bitmap caching”.
And here’s an extra tip. If you find the need to transfer files between the local and remote PCs, you can go to the Local Resources tab and click on “More …”. From there you can select the drive you wish to use during the remote session.
Here’s how to delete files older than N days. We are using N = 7.
find /base-dir-to-delete -mtime +7 -type f -delete
You can test the command by removing “-delete”.
forfiles -p "c:\base-dir-to-delete" -s -m *.* /D -7 /C "cmd /c del @path"
You can test by replacing “del” with “echo”.
Here’s one way to create an automated MySQL backup process.
1. Login as root.
2. Create the MySQL option file /root/.my.cnf with the following contents. This will allow you to run mysqldump without passing the password parameter.
> vi /root/.my.cnf
3. Protect your MySQL password by limiting access to /root/.my.cnf.
> chmod 600 /root/.my.cnf
4. Create a backup script under cron.daily with the following contents. This will create a compressed database dump. The filename will contain the day of the week, which will automatically handle backup rotation.
mysqldump --defaults-extra-file=/root/.my.cnf -u YOUR_MYSQL_USERNAME YOUR_MYSQL_DATABASE > /root/backup/db/mysql-`date +%a`.sql
bzip2 -f /root/backup/db/mysql-`date +%a`.sql
> cd /etc/cron.daily
> vi mysqlbackup.cron
> chmod u+x mysqlbackup.cron