ALTER TABLE `tablename` AUTO_INCREMENT =0
Will reset the auto_increment to the lowest value in the table.
ALTER TABLE `tablename` AUTO_INCREMENT =0
Will reset the auto_increment to the lowest value in the table.
Here’s a nifty little application that saves you from the drudgery of interfacing with the terminal on your Mac to show hidden files. Sure you can open Terminal and enter:
defaults write com.apple.Finder AppleShowAllFiles YES
and then:
killall FINDER
Enter again.
However, you can drag this app to your dock and do this with just a few clicks. For those of us that need to locate .htaccess files, but don’t want to look at .DS_Store files all day – this is a great productivity enhancer.
“If you are a webmaster, software developer, or advanced user, you may find yourself having to frequently switch between SHOW ALL FILES and HIDE HIDDEN FILES on your Mac. This can be done with a few lines in UNIX… but why not save yourself the time and use this free desktop application.”
http://gotoes.org/sales/ShowHiddenFilesMacOSX/How_To_Show_Hidden_Files.php
This is a great add-on for Firefox which makes organizing many tabs a breeze. If you’re like me sometimes you have 30 tabs open. With this installed you can display your tabs as a nested list on the left or right.
Chris Coyier shows you how to properly load jQuery for use in your WordPress pages, and explains how you can put jQuery into “no conflict” mode and use a different shortcut instead of the default “$”.
If you’ve been getting nowhere trying to implement jQuery in WordPress, getting ‘$ is not defined’ and ‘$ is not a function’ errors, check this article out.
http://digwp.com/2009/06/including-jquery-in-wordpress-the-right-way/
As previously mentioned here – I have a client who is unfortunate enough to have 30+ sites hosted on Media Temple’s Grid Service (GS).
This outage began Monday, May 4th, 2009 at 7:35 pm EST, so right now that’s 39 HOURS of DOWNTIME!
Freakin’ unbelievable. I reccommend MOSSO – tell them jwhelan sent you for a sweet discount on your first month.
For $20 a month, why anyone expects different I’ll never know. But now for the second time in as many months, Media Temple has completely crapped out. I’m fortunate not to have any eggs in their basket, but have a client who’s hosted there.
mt Media Temple » Weblog » #754 gs Grid-Service Cluster.02 Web availability.
Their last big outage in March was 36+ hours for many customers. This outage now going on well over 12 hours. Sites don’t load and return 403 errors.
I wonder how many more of these outages MT can have before there’s no customers left.
Update : Going on 24 hours, my client’s sites are still down. We’re migrating them as fast as possible, and he’ll learn from this and ditch Media Temple like a hot stinky potato.
Another interesting post: http://mtcustomers.wordpress.com/2009/05/05/cluster-2-back-customer-care-migration-recap/
Great article by Jacob Cass that says…
Logo design in today’s world is totally under rated. People do not understand how important a good logo is and how valuable it is to their business and this is why I am going to outline some very important facts telling you exactly why logo design should not cost $5 and why your logo is not something you should take lightly.
This article details using Fondu to convert your Mac true type fonts – which are stored in OS X specific .dfont containers – to the PC friendly .ttf format.