Menu
▾
▴
Re: [VuFind-Tech] Rebuilding VuFind --dumping mysql DB
|
From: Karla S. <sm...@wi...> - 2012-08-30 16:54:49
|
That did the trick! We're back on track now. Thanks! --Karla > -----Original Message----- > From: Tuan Nguyen [mailto:tu...@yo...] > Sent: Thursday, August 30, 2012 9:19 AM > To: Karla Smith > Cc: Demian Katz; vuf...@li... > Subject: Re: [VuFind-Tech] Rebuilding VuFind --dumping mysql DB > > Karla > > Try resetting the mysql root password as per the instructions here > http://www.linuxweblog.com/blogs/sandip/20060330/reset-mysql-root- > password > > > On 2012-08-30, at 10:14 AM, Karla Smith wrote: > > > Still no go. > > What gets me is that I can't get into mysql at all--not even as root, > not even to a > prompt or anything. > > > > I can't see what the databases are named (I know my naming > conventions, but someone else did the initial mysql install on this > machine). > > > > On my new server, I can at least see version info and get a prompt > just by typing "mysql". > > > > If I don't dump and copy the database, our patrons' favorites records > don't get moved, do they? > > -karla > > > >> -----Original Message----- > >> From: Tuan Nguyen [mailto:tu...@yo...] > >> Sent: Wednesday, August 29, 2012 4:46 PM > >> To: Karla Smith > >> Cc: Demian Katz; vuf...@li... > >> Subject: Re: [VuFind-Tech] Rebuilding VuFind --dumping mysql DB > >> > >> Karla, try -uvufind instead of root > >> > >> > >> > >> Sent from my iPhone > >> > >> On 2012-08-29, at 5:26 PM, Karla Smith <sm...@wi...> wrote: > >> > >>> Hi, > >>> Demian wrote: > >>>> you'll probably want to take > >>>> VuFind offline on the old server, dump the database, load it onto > >> the > >>>> new server > >>> > >>> So, when I tried dumping the database, using: > >>> sirsi@leela:/usr/local/vufind$ mysqldump -uuvufind -pvufind vufind > > > >>> vufind.sql > >>> > >>> I got this error: > >>> > >>> mysqldump: Got error: 1045: Access denied for user > 'root'@'localhost' > >> (using password: YES) when trying to connect > >>> > >>> I tried using sudo before the mysqldump, same error. I tried su- to > >> root -- same error. > >>> > >>> I tried using any and every user/password/dbname combo I could > think > >> of. > >>> > >>> There was one combo that got me a different error: > >>> mysqldump: Got error: 1044: Access denied for user > >> 'vufind'@'localhost' to database 'mysql' when selecting the database > >>> > >>> Then I thought, maybe I can find out some info from w/in mysql, so > I: > >>> root@leela:~# mysql > >>> > >>> and got: > >>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' > (using > >> password: NO) > >>> > >>> I tried as my "sirsi" user--same error. > >>> > >>> I am stumped. Any suggestions? > >>> > >>> --Karla > >>> Karla Smith, ILS Manager > >>> Winnefox Library System > >>> Oshkosh, WI 54904 > >>> > >>> > >>> > >>> > >>> > >>>> -----Original Message----- > >>>> From: Demian Katz [mailto:dem...@vi...] > >>>> Sent: Monday, August 27, 2012 10:11 AM > >>>> To: Karla Smith; vuf...@li... > >>>> Subject: RE: Rebuilding VuFind with SVN > >>>> > >>>> I'd recommend installing a clean copy of VuFind on the new server > >> (to > >>>> get all the dependencies in place), then simply overwrite the new > >>>> VuFind directory with the contents of your customized VuFind > >> directory > >>>> on the old server. As long as the new server uses the same file > >> paths > >>>> and passwords as the old server, transferring the files should be > >>>> enough to move all of your customizations over. You'll even get > >>>> the whole Solr index! The only piece that will require a bit of > >>>> offline time is transferring the MySQL database -- you'll probably > >>>> want to > >> take > >>>> VuFind offline on the old server, dump the database, load it onto > >> the > >>>> new server, then bring VuFind online on the new server... > >>>> otherwise you might run the risk of the database getting out of > sync. > >>>> > >>>> - Demian > >>>> > >>>>> -----Original Message----- > >>>>> From: Karla Smith [mailto:sm...@wi...] > >>>>> Sent: Monday, August 27, 2012 11:06 AM > >>>>> To: vuf...@li... > >>>>> Subject: [VuFind-Tech] Rebuilding VuFind with SVN > >>>>> > >>>>> Hi, > >>>>> So, assuming we get our 64-bit Ubuntu 12 server up and running, > >>>>> and Subversion properly installed (which will probably engender a > >>>>> new > >> set > >>>>> of questions), > >>>>> > >>>>> And, given that we don't want to take our current VuFind instance > >>>> down > >>>>> until the new one is ready... > >>>>> > >>>>> What is the best way to get our now highly customized VuFind onto > >> our > >>>>> new server? > >>>>> > >>>>> Thanks, > >>>>> --Karla > >>>>> Karla Smith, Automation Librarian > >>>>> Winnefox Library System > >>>>> Oshkosh, WI 54901 > >>>>> sm...@wi... > >>>>> ~"Don't worry about the world coming to an end today. It's > already > >>>>> tomorrow in Australia." - Charles Schulz > >>>>> > >>>>> > >>>>> > >>>>> ----------------------------------------------------------------- > - > >>>>> - > >> -- > >>>> - > >>>>> -------- > >>>>> Live Security Virtual Conference > >>>>> Exclusive live event will cover all the ways today's security and > >>>>> threat landscape has changed and how IT managers can respond. > >>>>> Discussions will include endpoint security, mobile security and > >>>>> the latest in malware threats. > >>>>> http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > >>>>> _______________________________________________ > >>>>> Vufind-tech mailing list > >>>>> Vuf...@li... > >>>>> https://lists.sourceforge.net/lists/listinfo/vufind-tech > >>>> > >>>> > >>> > >>> > >>> ------------------------------------------------------------------- > - > >>> - > >> --------- > >>> Live Security Virtual Conference > >>> Exclusive live event will cover all the ways today's security and > >>> threat landscape has changed and how IT managers can respond. > >> Discussions > >>> will include endpoint security, mobile security and the latest in > >> malware > >>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > >>> _______________________________________________ > >>> Vufind-tech mailing list > >>> Vuf...@li... > >>> https://lists.sourceforge.net/lists/listinfo/vufind-tech > >> > >> > > > > > |