![]() ![]() Have pulled those files from off Retrospect, but have not yet Made The Attempt To Replace the Database (I’ll keep you posted here, because I’m sure others will be interested in finding out how it’s done). Different than my phpmyadmin do database dump procedure that I do from time to time on live server sites. It’s MacOS / Retrospect backup of the folder and files where MAMP writes the database. That’s what geek women ask for for their birthdays from their geek men: A backup system that just works. (I am so thrilled to be able to say that! Backups Tu Thurs and Saturday am in the wee hours. I have a backup from about 12 hours before all this happened. (I guess if I wanted to make a really clean roll back, I could get the disk image from last backup of /Applications/MAMP/db/mysql/ee_thisdatabase and roll back to that point.)Īny advice for what to do would be greatly appreciated. However, I have been backing it up through regular backups. I have not been backing up this local MAMP-based database by doing periodic SQL dumps. Query: ALTER TABLE exp_matrix_data ADD col_id_16 TEXTīut this time, the new field did NOT get created.įROM THIS POINT, WHERE DO I TROUBLESHOOT?ĭo I hang out in phpmyadmin/ mySQL and do things like check/repair/analyze/of flush the tables? Complete the process, click Submit.ĭescription: Duplicate column name ‘col_id_16’ Got similar message, but it did get created okay.Ĭ) Now attempting to create third field, a Matrix field. The strange thing, though, is that the field did get added OK, despite the message.ī) Did that again with a new text area field. Query: ALTER TABLE exp_weblog_data ADD COLUMN field_id_43 text NOT NULL ![]() So I go about attempting to re-create my work.Īfter filling out the items for a new text field, I click Submit button.ĭescription: Duplicate column name ‘field_id_43’ Restarted, launched MAMP, VirtualHostX, and set about starting again where I left off.Įxcept all the fields I created in today’s session are not there. ![]() I shut down as many apps as I could (including MAMP, VirtualHostX) and tried to reboot system (terminal: sudo shutdown -r now), but computer wouldn’t shutdown. Couldn’t force quit Safari, nor another app. Somehow that browser crash was bad enough to bring many things down. Don’t really flinch at this browser crash because they’ve happened before.) Incidentally, this crash happened when I attempted to do file upload inside of image matrix on the publish page. In midst of doing first test publish to 1 of new weblogs (with new field group, etc.), I managed to crash Safari browser (Safari crashes happen often enough due to ridiculous # of windows/tabs I keep open. Today I added some new fieldgroups, some new fields, two new weblogs, one new category group. I play with it on MAMP, figure stuff out, then duplicate efforts on live site. Install is a sandbox-y version of a site that’s also live. Have EE 1.6.8 running in MAMP environment on MacOS 10.5 computer. I need help figuring out how to troubleshoot the situation I’ve gotten myself into. ![]()
0 Comments
Leave a Reply. |