mysqldump

Updating drupal

Here's what I need to to to update drupal (minor updates, e.g. from 7.18 to 7.19) on my Ubuntu server. I have installed drupal from the drupal source itself and not from the Ubuntu repository (because the Ubuntu repository is usually quite old and not updated as frequently). Actually the update is quite painless; I am sure somebody automated that already somewhere...
cd /var/www
su
wget http://ftp.drupal.org/files/projects/drupal-7.19.tar.gz
tar -xvzf drupal-7.19.tar.gz
chown -R jeltsch:www-data drupal-7.19

Migrating the Mad Thought Blog to a new server (mysql, php)

  1. Dump the database data mysqldump --host=localhost --user=root -p journal >journal.sql
  2. Create the databse on the new machine mysql -u root -p CREATE DATABASE journal;
  3. Import the data into the database mysql -p -h localhost journal < journal.sql
  4. Create the user 'journal' GRANT ALL PRIVILEGES ON *.* TO 'journal'@'localhost' IDENTIFIED BY 'journal' WITH GRANT OPTION;

How to backup mysql databases (mysqlhotcopy, mysqldump)

There are different possibilities. If you have access to the machine where mysql is running, you should use:
mysqlhotcopy On our RedHat 8 server you just type:
/usr/bin/mysqlhotcopy --user=root --password=sdjksjd journal /path/to/backup/directory Alternatively:
/usr/local/mysql/bin/mysqldump --user=username -p phpgedview >phpgedview The path of the command is specific for the mysql install on a MacOS X machine.