Read Our Reviews

Bold City Design is rated 5 out of 5.0 stars based on 11 review(s).

---

These guys are full of energy and great ideas.  They are local to the area and have a great reputation but also young enough to bring new technology and fresh ideas.  We had previously been working with another company on website marketing but the relationship had grown stale.  The same thing again and again and the results simply were not there.  Bold City has provided great direction and a new plan that we’re excited to see through.  I would certainly recommend them to others.

- Tess Riley

---

We hired Bold City to handle a marketing campaign for a newly released product we were rolling out.  We searched high and low before making a decision but the reviews & portfolio of Bold City coupled with cost considerations made this decision a no-brainer.  Bold City has been terrific crafting both an organic marketing campaign and PPC campaign to help drive our product sales.  While still in the early stages, we’re already seeing results and are looking forward to 2019!

- Tom Karol

---

Cabe and crew have been nothing but professional and highly organized throughout our entire website design project with them.  They had excellent recommendations in terms of content and flow of our website.  We would definitely recommend them to others.

- Mark Dawson

---

We LOVE Bold City.  If you’ve been searching for a web design company and afraid you’ll choose the wrong one, stop worrying!  You’ve found them.  Just don’t get too busy and forget about us :).

- Haley Walter

---

We’re a Jacksonville based technology company that needed to outsource a WordPress project.  A previous employee we had moved on from the company and we had nobody that understood our internal WordPress system.  Bold City really impressed me by how quickly they were able to pickup where our employee had left off.  They had several recommendations that improved our processes and made the system run better.  They were fair with pricing and will continue to be our go to company for any and all WordPress related questions or work.  Great job guys!

- Bob Turner

---

I’ve been working with Cabe on and off for nearly a decade.  We met on a mutual project and I’ve continued to keep him close due to his understanding of WordPress and ability to handle pretty much anything I throw at him custom development-wise.  Me being based in Canada, we’ve never actually met face to face but his communication skills are hard to find in a developer.  I don’t believe he’s ever missed a deadline and he’s always been willing to work with me to solve complex problems.  I can’t say enough about his ability to organize complex issues down to simple processes.  I’m sure Bold City follows his attention to detail and fulfillment of their promises.  I would recommend them to anybody.

- Kirby Sampson

---

The best of the best.  You’ve earned a client for life.  For anybody else looking, these guys know their stuff. Fast, affordable and understand that times money. 

- James McConnell

---

Can I give them 6 stars?!? These guys rock.  Local St. Augustine company that is always available when you need them.  If you’re looking for a great web design company you’ve just found it!

- Lucy Keller

---

We’re big fans of Bold City and have been since we started our website back in 2014.  Always very easy to get a hold of and give honest answers to our questions.  Fair with pricing and very reliable.  What else could you ask for?

- Mary Acumen

---

We had been with our previous web design company for nearly 5 years.  They were good but we didn’t feel like what they were doing was working.  We decided to make the switch to Bold City and the change of pace has been better than expected.  Great communication and bringing fresh ideas to our business and marketing.  If you’re looking to make change or starting a new business I would highly recommend Bold City.

- Jane Thomas

---

Trust me, your go to guys when it comes to website design.  As a general contractor, I wouldn’t call myself tech savvy.  These guys were efficient at explaining the process and delivered on every promise they made.  They know what their talking about and do great work.  Would recommend them to anybody.

- Greg Rodgers

How to Delete WordPress Post Revisions the Correct Way

How to Delete WordPress Post Revisions the Correct Way

This post was originally created on our sister site WP Cover.
View Original Article
November 20, 2018

WordPress post revisions is a great feature that comes built into WordPress.  It allows us to quickly backtrack to a previous version of a post, page or custom post type if we make a mistake while editing.

At the same time, if not regularly monitored, post revisions can cause your database to increase is size drastically and as a result slow down your site.  People have posted lots of tutorials on how to delete post revisions and unfortunately most of them are the same and NOT the correct way to complete a cleanup.  Some of these sites that publish these tutorials are big name WordPress sites and should be ashamed to share blatantly wrong information.  There are also numerous plugins that claim to delete revisions.  I can’t comment on whether these plugins do it the right or wrong way so my advice would be to follow the instructions below.

All around the internet, you’ll find this basic SQL statement that you should run to delete post revisions:

DELETE FROM wp_posts WHERE post_type = "revision";

DON’T DO IT

While the above statement will clear out just the post revisions, it doesn’t delete all the other data that is stored along with the post such as post meta and taxonomy relationships. In today’s modern development world, most post meta tables are larger than the post table so simply deleting revisions from the post table does not even tackle the main component of your database bloat. Here is the correct SQL statement you should run:

DELETE a,b,c FROM wp_posts a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a.post_type = 'revision'

The above statement will delete the data from the posts table, post meta table and the term relationships table effectively clearing all data associated with post revisions.

This is another example why you always need to remain on your toes and don’t simply copy and paste tutorials even when they are from well known WordPress publishers. There’s a lot of bad information floating around out there on WordPress. Don’t fall victim to it!

Save this correct information and bookmark this page so you can start cleaning up your revisions the right way!

The post How to Delete WordPress Post Revisions the Correct Way appeared first on WP Cover.

Share Your Thoughts

FREE: 10 Step Guide To Choosing A Web Design Company

FREE: 10 Step Guide To Choosing A Web Design Company

Download your free e-book. Learn the questions you should be asking prior to partnering with a web design company. Enter your email address and we'll send it to you right away!

We've sent the e-book to your email address!