No, it's an SQL script. You can either paste it into phpmyadmin's SQL section or upload it there and phpmyadmin will run it for you.
Hope it works for you, Matt On Wed, Jul 29, 2009 at 1:05 PM, Sunny Chow<[email protected]> wrote: > Hi Matt > > Thank you for your reply. > > How do you run db/laconica.sql? Do you just insert in the path to the file > in the URL address bar on the browser? > > Regards > > Sunny Chow > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of PI.ly > Sent: Wednesday, July 29, 2009 8:44 PM > To: Sunny Chow > Cc: [email protected] > Subject: Re: [Laconica-dev] Upgrading to v0.80 - Help > > Hi Sunny, > > I just did this myself from 0.7.4, so maybe this will help you. Go > into PHPmyadmin for the database in question. Export the data. (I > exported it about 5 times in different ways just to be sure I wouldn't > destroy it.) Click on the database name, then click on the SQL tab at > the top of the screen. From there you can upload a set of SQL > instructions (like those contained in db/laconica.sql) and it'll > perform those instructions. I think for 0.7.3 you might have to drop > every table first, and then run db/laconica.sql, but I'm not certain > since I went from 0.7.4, which has a handy upgrade script > (db/074to080.sql). > > If you do have to rebuild your database completely, then you can > reinsert the data from the export file you made. However, if I > remember correctly, there was a one column difference in one of the > tables from 0.7.3 to 0.7.4 which caused me a headache. So maybe > someone could talk you through upgrading to 0.7.4 and then it's not > too difficult to jump to 0.8.0 > > -Matt Taylor > http://hap.pi.ly > > 2009/7/23 Sunny Chow <[email protected]>: >> Hi >> >> >> >> I wish to upgrade my site to Laconica 0.8.0 from 0.7.3. >> >> >> >> I'm not a programmer and have no idea how to do the upgrade and rebuild > the >> database from a mysql client, etc using the Readme's prescribed method of >> running a script as in: >> >> ./scripts/rebuilddb.sh rootuser rootpassword database db/laconica.sql >> >> >> >> I have access to cPanel and phpmyadmin - can I rebuild the database using >> these and if so, could you tell me how please? >> >> >> >> Thank you! >> >> >> >> - Sunny Chow >> >> www.tweetlah.sg >> >> >> >> >> >> _______________________________________________ >> Laconica-dev mailing list >> [email protected] >> http://mail.laconi.ca/mailman/listinfo/laconica-dev >> >> > > > > -- > Small Random Acts of Animal Kindness - Sponsor Beth http://ur1.ca/2g0r > What is this? http://snap.pi.ly/p1Hf2 > ( Create your short URLs at http://snap.pi.ly ) > > -- Small Random Acts of Animal Kindness - Sponsor Beth http://ur1.ca/2g0r What is this? http://snap.pi.ly/p1Hf2 ( Create your short URLs at http://snap.pi.ly ) _______________________________________________ Laconica-dev mailing list [email protected] http://mail.laconi.ca/mailman/listinfo/laconica-dev
