[Deskaheh-sysadmin] Uploading backup to new dadaIMC install

[John Milton]

In the example given below, what would the valuse for:

bigmuddyimc-database-user
and
bigmuddyimc-database

be for hamiltons site on deskaheh, then i could restore our database...

Thanks

pabs wrote:
> On Sun, 2005-07-10 at 07:14 -0700, treesong at treesong.org wrote:
> 
> 
>>One of my fellow techies here at BMIMC has set up a local server that we
>>hope to transition to. He has successfully installed dadaIMC on the new
>>server. We also have the backup file from our Deskaheh database, which
>>I believe is named:
>>
>>bigmuddyimc_dump.sql.gz
>>
>>My question is this -- how do we use this backup file to put our site's
>>data on the new server? i.e. how do we replace the default/blank
>>dadaIMC data on the new  installation with the dumped data from our
>>Deskaheh installation? And once we've done this, are there any other
>>considerations in performing the transfer? [I know that we'll have to
>>transfer some image files which I hope will be easy to find, but
>>anything other than that?]
> 
> 
> On the command line (on the new machine) type this:
> 
> gunzip bigmuddyimc_dump.sql.gz 
> mysql -p -u bigmuddyimc-database-user bigmuddyimc-database < bigmuddyimc_dump.sql
> 
> Here, replace bigmuddyimc-database-user and bigmuddyimc-database with
> the appropriate values. It will prompt you for the password to use.
> 
> Now enter the database user and password into imc_dbinfo.inc
> 
> Image (and other) files will be easy to transfer:
> 
> (on deskaheh):
> cd ~
> tar zcf bigmuddy-images.tar.gz /www/dadaIMC/bigmuddy/usermedia/
> (on the new machine)
> cd <path-to-dadaimc>
> scp deskaheh.indymedia.org:bigmuddy-images.tar.gz .
> tar zxf bigmuddy-images.tar.gz
> 
> Then verify that everything is working and email dns at lists.indymedia.org
> to transfer the domain to the new IP address.
> 
> 
>>Our initial goal with this new server was to use it as a "test server" /
>>"mirror" in the event of any future Deskaheh outages. But since Deskaheh
>>seems to be up poop creek without a paddle anyway, we may as well just
>>treat it as our new server and hope for the best. If  the new server
>>works well, we may move away from Deskaheh entirely -- but I'll get
>>back to you on that once the "if" is resolved. :) Our collective is
>>very eager to get our site "live" again, so any help would be
>>appreciated.
> 
> 
> Do you think your server would be able to take imc-hamilton as well?
> dadaIMC isn't so popular with many techs these days, so it would be good
> if you were able to.
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Deskaheh-sysadmin mailing list
> Deskaheh-sysadmin at lists.indymedia.org
> http://lists.indymedia.org/mailman/listinfo/deskaheh-sysadmin

-- 
Peace: John Milton

Email: john at johnmilton.ca
Web: johnmilton.ca

PGP encrypted mail is welcome, my key is here: 
http://www.hwcn.org/~aa492/security.htm