Pavnay

Sometimes it's useful to create a backup table before doing a datas update in a SQL script.
But if this script must be run frequently, the table must be timestamped. However, it's not possible to create a table using a function (as CREATE TABLE MyTable_CURDATE()).

When we create a network, a firewall must be required and it must be a gateway between our network and the internet.
Creating a gateway is easy, a simple Linux server with iptables is the only thing we needed :

To backup a SVN repository, there is dedicated tools which is svnadmin :





Here, all repositories from /var/lib/svn are compressed and backuped in a timestamped archive.

The network configuration can be hard if we can't manage the hardware which is provided as the switches.
There is many kinds of connection and a bad configuration can cause trouble and bad performance.

A common issue is the full / half duplex management and their auto-negociation.

To activate and deactivate the auto-negociation for a network interface, the mii-tools are very useful (here for eth0 ) :