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
I have had problems previously with database export and character munging, though I haven’t experienced them in a while. I’ll have a search and update here if there’s anything useful.
Update: try step #2 here: www.orthogonalthought.com/blog/index.php/2007/05/mysql-database-migration-and-special-characters/
Update 2: also, did you see this?: stackoverflow.com/questions/3583691/mysqldump-and-restore-with-special-characters-øæåØÆÅ
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.
Last edited by gaekwad (2015-03-25 10:39:59)
Offline
Re: [resolved] Local dump file from remote source: the harrowing journey
Thanks again, Pete. The Raspberry Pi scenario sounds interesting, though probably not a complete solution for me due to my mobile work habits. I’m in no hurry to add to my reading list at the moment, but I would like to see that when you’re done writing it.
In the meantime, I’ll replace my local instance of mysql, because it’s clearly outdated and there’s nothing on it to worry about ruining yet.
In that vein, I just found this, Homebrew, which might be the exception for something extra to install. Then this insightful piece about cleaning out the old mysql crap using brew, and then there’s a script (via here), that “handles the entire automated installation of MySQL” on Yosemite, or I can just do it the old fashioned way again with Yosemite in mind.
I’m goin’ in…
Offline
Re: [resolved] Local dump file from remote source: the harrowing journey
I’ve heard good things about Homebrew, but never used it.
Note with Yosemite and MySQL that the startup script might not run properly, resulting in an installed-but-stopped instance. In which case, see the top answer here for a fix.
Offline
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.
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