[Laconica-dev] Database Changes

[Evan Prodromou]

Mike Cochrane wrote:
> For those running from Evan's darcs repo - here's the SQL to update your 
> database after Evan's changes today.
>   
Hey, so, I use the following script to update my database. I realize 
it's pretty heavy-duty, but it makes sure to clear out the cruft, and 
even on Identi.ca it only takes a couple of seconds. First argument is 
the database name, second argument is the path to laconica.sql.

> #!/bin/bash
>
> export DB=$1
> export SCR=$2
>
> mysqldump -u root --password="yourpass" -c -t --hex-blob $DB > 
> /tmp/$DB.sql
> mysqladmin -u root --password="yourpass" -f drop $DB
> mysqladmin -u root --password="yourpass" create $DB
> mysql -u root --password="yourpass" $DB < $SCR
> mysql -u root --password="yourpass" $DB < /tmp/$DB.sql

Just in case anyone's interested.

-Evan