MySQL Server on Windows Vista x64 Setup Guide, An Install That Works!!!

After hours of beat­ing our heads against a wall, we’ve finally come up with a solid MySQL install guide. It wasn’t easy, but it’s some­thing we needed, and obvi­ously some­thing our fel­low devel­op­ers needed. We spent hours read­ing through end­less threads with errors such as;

Can­not Cre­ate Win­dows Ser­vice for MySQL. Error:0,
Vista x64 could not start the ser­vice mysql,
Win­dows could not start the mysql ser­vice on local com­puter error 1067,
Can’t create/write to file,
Can’t con­nect to [local] MySQL server,
Table ‘tbl_name’ doesn’t exist,

Yet even after read­ing through what seemed like hun­dreds of cries for help, and just as many sup­posed fixes, we were still no closer to resolv­ing this issue. So after com­ing to the real­iza­tion that there was lit­tle help to be had online, we just attacked our install, and dealt with the issues one by one. After repeated failed installs, and botched setups, we were able to get MySQL loaded prop­erly. The setup instruc­tions you see below were repeat­able on 4 dif­fer­ent machines, when fol­lowed prop­erly. If you run into an issue, please let us know. Good luck with your setup.

(more…)

Sep 01, 2009 | Computer Repair and Networks | 8 Comments »

WordPress, Fatal error: Allowed memory size of 33554432 bytes exhausted

Dur­ing a rou­tine update to a Word­Press site we received the fol­low­ing error: Fatal error: Allowed mem­ory size of 33554432 bytes exhausted (tried to allo­cate 7680 bytes) in /home/website/public_html/wp-includes/functions.php on line 1342 Scary stuff, but no need to panic. Chances are your Word­Press install is quite well used with lots pages, posts, and plu­g­ins. First off, don’t start dis­abling plu­g­ins and hack­ing code. Fol­low these sim­ple steps and you’ll be updated in no time.

(more…)

Aug 03, 2009 | Wordpress | 4 Comments »