Tech

Posts tagged with

MySQL backup and restore

To backup a single database: mysqldump --user=root --password=password mydb > mydb.sql Yes it is no typo, there is no space between the -p and the password! You may like to add this to the my.cfg file in etc to avoid [mysqldump] events ignore-table=mysql.events If you didn’t use the …

Read more →

Change permissions on files only

find . -type f -print0 | xargs -0 chmod 444 Change the type from f to d if you only want to change the permissions on the directories, Plus the permission of course. find . -type d -print0 | xargs -0 chmod 755

Read more →

List all files starting with upper case

find . -type f -name ‘[[:upper:]]*’ If you want to change files to all lower case, e.g. your mp3 music files then run the following script. The -i option for the mv command stands for interactive, i.e. it will prompt for your approval. #!/bin/sh if [ $# -eq 0 ] ; then echo Usage: $0 …

Read more →

Update a Mediawiki

Download the new mediawiki from their website to the html directory wget http://download.wikimedia.org/mediawiki/1.17/mediawiki-1.17.0.tar.gz Extract the download and type tar -zxvf mediawiki-1.17.0.tar.gz to extract the file to the current directory. Rename the extracted directory to something …

Read more →