Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: [resolved] Local dump file from remote source: the harrowing journey
gaekwad wrote #289376:
A propos nothing, I moved all my office development stuff from OS X localhost to a Raspberry Pi powered from a USB port on my router, and it’s an absolute game-changer. I’ve got a ~10k words walkthrough in progress if you’d like to take a look.
I’d be interested to read that, would you mind posting a link? (Or email me one through the forum link?)
Cheers
Offline
Re: [resolved] Local dump file from remote source: the harrowing journey
springworks wrote #289380:
I’d be interested to read that, would you mind posting a link? (Or email me one through the forum link?)
You have mail, sir.
Offline
Re: [resolved] Local dump file from remote source: the harrowing journey
Fantastic, thanks!
Offline
Re: [resolved] Local dump file from remote source: the harrowing journey
Destry wrote #289369:
- Web host: Ver 14.14 Distrib 5.6.13, for solaris11 (i386) using EditLine wrapper
- Local: Ver 14.14 Distrib 5.5.18, for osx10.6 (i386) using readline 5.1
Is now:
- Web host: Ver 14.14 Distrib 5.6.13, for solaris11 (i386) using EditLine wrapper
- mysql Ver 14.14 Distrib 5.6.23, for osx10.10 (x86_64) using EditLine wrapper
Homebrew is awesome, if just for that incredibly simple mysql removal/reinstall process. The people behind that have done an amazing job and offer a wonderful product. It’s nearly all automated, except the needed copy/paste commands into the command line, and the feedback help is spot on.
The Homebrew install of mysql is put in /usr/local/Cellar (the beer cellar) instead of /usr/local, but a trivial detail as long as you make note of where it’s at. It also doesn’t add the GUI start/stop feature for MySQL in System Preferences, like the mysql instructions here do, but I can live without that for the superior ease of everything else, and if I can just figure out what “add MySQL to launchctl” means then it should auto-start on launch anyway.
Next step is to import a dump file and see what happens.
Offline
Re: [resolved] Local dump file from remote source: the harrowing journey
gaekwad wrote #289376:
I moved all my office development stuff from OS X localhost to a Raspberry Pi
OT: Intriguing. Been looking for an excuse to flex my Pi’s muscles. Would be very interested in reading your doc, too, if you don’t mind.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Hire Txp Builders – finely-crafted code, design and Txp
Offline
Re: [resolved] Local dump file from remote source: the harrowing journey
“Database Unavailable.” When trying to access admin-side. Hmm..
MySQL is running. Database is created and dump file imported. So I must have a path error somewhere from the new mysql install, but I can’t think of where to look. Suggestions?
Offline
Re: [resolved] Local dump file from remote source: the harrowing journey
Ha! I forgot that installing a new instance of mysql erased the root user password, which was recorded in the Txp config file. So, access is back and I’m happy to report that upgrading the MySQL server has fully eliminated the character munging problem, as well the invisible copy. The harrowing journey has finally come to an end. Llots of self-lessons learned and, most importantly, written down for future reference. Celebrating with a glass now.
Moral of the story: To avoid character munging and other weirdness, keep your local mysql installs up to date (or at least closely matched in version with your host).
Offline
Re: [resolved] Local dump file from remote source: the harrowing journey
Bloke wrote #289395:
OT: Intriguing. Been looking for an excuse to flex my Pi’s muscles. Would be very interested in reading your doc, too, if you don’t mind.
Yep. I’ll send a work-in-progress over now.
Offline
Re: [resolved] Local dump file from remote source: the harrowing journey
Offline