Host your own web site on your desktop over ADSL broadband

On certain occasions, you need to create your own web server and try to connect to it over the Internet. This applies to any sort of server you wish to host like, Secured Shell, OpenVPN, database server and so on. If you are using an ADSL broadband connection from your ISP (Internet Service Provider), then … Continue reading Host your own web site on your desktop over ADSL broadband

Dump MySQL tables to text file for backup

$ mysqldump address --add-drop-database --add-drop-table --add-locks --complete-insert --flush-privileges -R --triggers > /home/user/addressdump.mysql Repeat above for every table in your system. You can also put it in a batch file for a series of tables. This is the only way to restore databases if you upgrade to MySQL to a major version. This was an exception, … Continue reading Dump MySQL tables to text file for backup