SQL
Ok – so I’ve used the module – and read about all the ways to do this without the module. My answer is a hybrid.
Here are some things I had to do.
Write a custom image import script
Why this didn’t happen during import I’m not clear. My script preserves post_parent, title, date modified and menu_order (weight).
Set the [...]
You can easily reset your root SQL password using the following method. These instructions are for Debian.
http://www.mydigitallife.info/2006/06/06/change-and-reset-mysql-root-password/
Stop MySQL
sudo /etc/init.d/mysql stop
Edit the MySQL start up script. Look for the line that starts the daemon.
sudo vi /etc/init.d/mysql
# /usr/bin/mysqld_safe > /dev/null 2>&1 &
/usr/bin/mysqld_safe –skip-grant-tables > /dev/null 2>&1 &
Start MySQL
sudo /etc/init.d/mysql start
Login to MySQL
mysql
Update the root password
use mysql;
show tables;
SELECT [...]
(mt) Set up authorized keys (to enable automatic login)
Copy your public key from the machine you want to backup to.
sh-3.2$ cat ~/.ssh/id_rsa.pub
Enable SSH and then SSH into (mt).
-bash-3.2$ cd
-bash-3.2$ whoami
[username]
-bash-3.2$ su
Password:
[root@domain domain.com]# mkdir .ssh
[root@domain domain.com]# chown [username] .ssh/
[root@domain domain.com]# exit
-bash-3.2$ vi .ssh/authorized_keys2
[paste in copied keys making sure you remove pasted in linebreaks]
-bash-3.2$ chmod 600 .ssh/authorized_keys2
Test [...]
# clone an existing database
$ mysql -u root -e “create database dbname_test”
$ mysqldump -u root dbname | mysql -u root dbname_test
# clone via ssh
$ mysqldump -u username -p’password’ db-name | ssh user@remote.box.com mysql -u username -p’password’ db-name
# fix a date that’s out by 11hrs (timezone offset)
UPDATE content_type_artbook
SET field_book_year_value = DATE_FORMAT(field_book_year_value + INTERVAL 11 HOUR, ‘%Y-%m-%dT%T’)
WHERE [...]
In September we ran a complete slice test of a Bluetooth annotation system for the Sydney Olympic Park Authority. The aim is to annotate public artworks that scatter the site using Bluetooth instead of convention didactic panels (signage to the layman).
We used small form MicroClient SNR computers running Debian and some funky Python scripts. The [...]