There are times when you need to backup your database or even copy the complete database to another server. If you are unlucky, you cannot use the mysqldump tool to make a copy of the complete database at once because that would bring down the server completely. It would also be nice to be able to rsync over the data to another server (the staging server). Then having one huge dump file is also sub-optimal. . . .

A couple of weeks ago I thought the price of the mobile pipes and tubes had come down far enough to give them a try. So I went over to the local pipes and tubes distributor and shackled myself to a year-long agreement with them. I was totally happy the first train trip home, doing a video chat with Ben. All seemed to work quite well, apart from the occasional connection drop (there's always one between Arnhem and Ede). . . .

So here we are again. I hope you have gotten the hang of cleaning your TYPO3 installation and are reaping the benefits. If you are like me, you dont like to repeat yourself. All this typing on the command line, can't we automate this? The vacume cleaner in the image here cleans your rooms on its own. We would like TYPO3 to do that too. The problem is that we are not sure if we want to really blindly delete and cleanup all the records found by the. . .

When you run a TYPO3 installation for several months you tend to create and delete a lot of pages and a lot of page content. Relations between elements are created and severed. When pages and records are deleted in TYPO3, they are not really deleted from the database. The 'deleted' field in the table is merely set to 1. So over time your table will accumulate a lot of deleted records. . . .

TYPO3 ships with a default .htaccess file and also with a simplified version in the /misc directory. Both files contain a mod_rewrite setup to help you set up your site so your content can be reached using nice readable URI's. The default _.htaccess file that you can get from the TYPO3 dummy package has always worked for me. I have never had any trouble setting up realurl using this file and thus never gave it a lot of attention. . . .