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. . . .

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. . . .

I live on the command line quite a lot. Sometimes I wonder how the machine I am working on is holding up. A nice command to see what is going on is 'top'. Although it's quite resource hungry. A lighter alternative is 'uptime'. I don't like typing that command very often however. . . .