When you first start on a new web project amongst a group of people someone is likely to create a github project. Rather than then all individually creating a new project on your machine you can do the following…
1) Browse to your sites folder in Terminal. We’ll create a new folder for this new project in the next step.
2) use the command
git clone email@example.com:whatever folder-name to not only clone the existing github repo, but also to create the folder you want it in
cd folder-name to navigate to that folder
git add remote remote-name firstname.lastname@example.org:whatever to add a new remote
And you’re done.
As an added option, if you have already created the folder you would like then you can replace 2) above with navigating to that folder, then…
git clone email@example.com:whatever . note the . character to define ‘current folder’
Every time I upgrade OS X something breaks with apache or php or both.
The steps for me to fix it this time was…
* Open your httpd.conf file
* uncomment the Load php5 module
* uncomment the load vhosts module
* duplicate Guest.conf to harrybailey.conf – replace harrybailey with your username obviously
* edit harrybailey.conf to read:
Options Indexes MultiViews
Allow from all
Note: as Michal mentions below you may want to add +FollowSymLinks to your options too. This allows the system to follow any symbolic links you have set up.
AGAIN – replace harrybailey with your username.
* save the file
You may also get a php error which includes…
“It is not safe to rely on the system’s timezone settings”
The fix for that is
* navigate to /etc/ and rename php.ini.default to php.ini
* edit your new php.ini file – find “;date.timezone = ” (no brackets)
* update it to read “date.timezone = Europe/London” (no brackets) – if you aren’t on GMT then find your relevant timezone string and use that
* save the file
* open terminal
* submit the line:
sudo apachectl restart
That did it for me. Hopefully it will do it for you too.
I was first seeing the default html file in the /Library/Webserver/Documents folder
I was then seeing 403 errors for all vhosts that I has setup
Personally I saw these problems after upgrading from Lion (10.7) to Mountain Lion (10.8)
I was trying to find the quickest way to export both structure and data from all tables of a database from Navicat Premium and came up with these steps:
* Use the backup tool to create a backup of your database
* Right click the backup and select to Extract SQL…
* Save to wherever you like
You can now use that .sql file to create a new database wherever you like.
If you have a lot of data in a mysql table and you’d like to duplicate some of the rows – maybe with a change or two as well – then here is the sql you’ll need…
INSERT INTO table (column1, column2,column3, column4)
SELECT column1, 234, column4, NOW()
WHERE id IN (6,7)
You have some choices…
You can copy or clone from one table to another by changing the table names above.
You can define your own values. Examples of 234 and NOW() are above.
You can include or drop the WHERE clause to choose which (if not all) rows to clone
Update: This actually doesn’t work as I’d hoped. Because flickr reports an error each time, eventually IFTTT disables the recipe after a few hours of calls. Back to the drawing board.
I’ve been trying to get IFTTT (if this then that) to send a call to a php script file when a trigger goes off for months. The problem wasn’t getting it to work in the first place, but for it not to leave any artifacts hanging around, or repercussions as I call them. I wanted the script to be triggered and that to be the end of it, with no files being created or errors being recorded.
An example of the problem would be the IFTTT Google Docs channel. You can upload a file to google docs from a url. You can define that url to be your php script and then tell your script to return a 404 (after it’s done its coding goodness) but when you view Google Docs a new file has still been created. If you want to use this for a large number of pings, you’re going to end up with a folder full of pointless files and a waste of your disc space. The Evernote and WordPress channels are a similar story. Even when you attempt to fail the call to your url (with a 404 or 503) they still create a note or post.
Continue Reading… »