mysqldump

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


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;

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.