Read Our Reviews

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

---

Great company to do business with. Honest and fair with pricing. Our requests were small, needed some assistance with configuring email services but Bold City diagnosed the issues quickly and completed the work on time. We will be back for future help.

- John McAlpin

---

Cabe & team, we love you guys!  Keep up the great work.

- Marcus Yoker

---

It’s so difficult to find a technology contact that understands time is money.  We’ve gone through a few that did good work when you could get them on the phone but that was a rarity.  We would go 1+ weeks and not even get a response.  This was costing our business literally thousands of dollars due to issues with our website and email.  Bold City has been nothing but a blessing.  They return my calls and emails promptly and thus far (fingers crossed) have always met their promised deadlines.  If you’re looking for a company that understands the importance of communicating with their clients, you’ve found the one.  They have my recommendation.

- Abby Timmons

---

Who ya gonna call?! BOLD CITY! But seriously, nothing but a pleasure to work with.  We trust them completely and they have our business for life.

- Lona Mayer

---

Best website design company out there. USE. THESE. GUYS.  Affordable, fair, great communication and great work.

- Susan Johnson

---

As a technology company we know great work when we see it.  We had an internal learning system that was built by a previous employee.  When that employee moved on from the company we had nobody internal that understood WordPress enough to make changes and continue to improve the system.  We outsourced the project to Bold City, they took it head on and we’re able to make our required changes.  We plan to use them more in 2019.

- Mike Dawker

---

Bold City built us a fantastic website the showed off our company perfectly.  They recommended fantastic additions including the video on the homepage which really sets our site apart from anybody else.  We get soooo many compliments on our website and the new patients we’ve brought in have been fantastic.  Great work guys!

- Brittany Higgins

---

Great work as always!  We’ll be back when we need additional help.

- Jenny Walker

---

Cabe & team are awesome at what they do.  Fast, reliable and most importantly communication is A+.  Finding people that are able to communicate what they are doing and regularly hit promised deadlines is a rarity these days but Bold City delivers!

- David Ayers

---

Best WordPress designers out there!  If you’re on the fence about hiring them, jump off!  You’ve found the best company out there!

- Samantha Lloyd

---

I’m not a very tech savvy person so I wanted to find a web design company that could take my vision, turn it into a reality and handle the management.  Bold City has been terrific and I always know my website is working in the background.

- Jannis Darring

---

We’ve been working with Bold City for over 5 years and never have had a bad experience.  Quick and reliable, A+.

- Jane Walton

---

After extensive research, we hired Bold City to handle the re-design of our 10+ year old e-commerce website.  Bold City took every challenge we threw at them head on.  Going above and beyond just design, they assisted with payment processors, shipping and made several recommendations that have improved our bottom line.  Their in-depth knowledge has been  major reason for our continued success.

- Jonathan Vemus

---

Awesome, awesome, awesome!  Fast, reliable and very cost effective for our business.  Bold City took over our website from our previous designer who was retiring and the transfer process was seamless.

- Jennifer Handler

---

These guys were awesome.  We contacted them to move hosting providers as we were struggling with communication with our current host.  They transferred our site same day at no cost.  Cabe was terrific to work with and has been very easy to get in touch with since.

- Mark Gosling

---

You know how they say “you can’t havw FAST CHEAP AND QUALITY?” Well, you CAN with Bold City Agency. They do BEAUTIFUL work, in a timely manner AT A FAIR price! Couldn’t ask for a better agency!

- DJ / Lindsey

---

Great work!  The marketing results they delivered were fantastic and for once, 'made sense'.  I can't tell you how many times we've been told one thing and received something completely different.  Finally we have measurable results.

- Josh Utilis

---

Prompt accurate service

- Denny Dotson

---

Bold City is great. Super responsive and wonderful attention to detail. Highly recommend.

- Gwinn Volen

---

Awesome work!  Very responsive to emails and phone calls and delivers on promises.

- Mark Aston

---

Cabe and Bold City do great work! They do a great job helping our law firm with our website and online needs.

- John Ginn

---

Cabe was great to work with on my website design. Easy to talk to, he understood my vision/goals, great turnaround time, and able to reach easily. Thanks for a website that I love!

- Denise Maniakouras

---

Awesome stuff!  I love working with Bold City.

- Megan Donaldson

---

Highly recommend! Delivers on promises.

- Brittany Will

How to Delete WordPress Post Revisions the Correct Way

Nov 20, 2018

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.

Additional News

Perfect!

Let's get started. Fill out the form below to email us or request a call back.


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!