Skip to content
wpbeaches
  • Home
  • About
  • Services
  • Work
    • Template Library
    • Web Development
    • Portfolio
  • Contact
  • Blog
    • ACF
    • Beaver
      • Beaver Builder
      • Beaver Theme
      • Beaver Themer
    • Genesis
    • jQuery
    • macOS
    • WordPress
    • WooCommerce

Optimise wp_postmeta table and remove custom fields meta keys

October 24, 2017 - 2 Comments
remove-custom-fields-wordpress-database

Overtime a wp_postmeta WordPress database table may become bloated and use redundant custom field meta_keys. The table may have thousands of rows worth of dead data such as old custom fields. You can remove these keys quite quickly in the MySQL database once you know the key format, I recently took over a site that previously…

Read More
Categorized WordPress Tagged custom fields, database, meta_key, mysql, wp_postmeta

Add WordPress Admin Account to Database wp_users Table

October 14, 2017 - Leave A Comment

Here is a guide on how you can add in a newWordPress admin account username and password to the database. What you do need to do this have access to the WordPress database by having the database name and password. Also instead of adding an extra admin account you can just change the admin password…

Read More
Categorized WordPress Tagged mysql

How to Change the MySQL root Password in Linux or macOS via Command Line

April 19, 2016 - Leave A Comment
Remove Mysql Databse Macos

If you have forgot the MySQL root password, can’t remember or want to force it….. you can reset the mysql database password from the command line in either Linux or macOS as long as you know the root user password of the computer you are on, this is for MySQL 5.7 onwards: Stop MySQL sudo…

Read More
Categorized macOS Tagged mysql

Import a mysql database into macOS via Terminal

April 13, 2015 - Leave A Comment
Remove Mysql Databse Macos

Import a mysql/mariadb  database into macOS via the command line I have found that phpmydmin on the Mac has issues with the max upload file size limit and changing the value in php.ini doesn’t always do the trick. With mysql already installed a quick trip to the terminal will sort this out. Create the database…

Read More
Categorized macOS Tagged mysql, terminal

MySQL ERROR! The server quit without updating PID file

April 15, 2014 - Leave A Comment

ERROR! The server quit without updating PID file ERROR! MySQL server PID file could not be found! Getting these MySQL errors on your database server on macOS, there seems to be lots of solutions about how to fix this, Google hell, this more than likely happens if mysql is running and the OS is updated…

Read More
Categorized macOS Tagged mysql

Find out how many database queries per pageload in WordPress

April 12, 2014 - Leave A Comment

To find out how many WordPress mysql database queries a page requests and how long it takes the page to load whilst querying the database, you can add in a PHP function to a WordPress hook to find out. This can be displayed in either the source code of the html or rendered on the…

Read More
Categorized Database, WordPress Tagged database, mysql

Upgrade MySQL Database from 5.5 to 5.6 on macOS 10.8 Mountain Lion

October 28, 2013 - Leave A Comment
Remove Mysql Databse Macos

MySQL version 5.6.14 is available for download for OSX, a double click and install is available named Mac OS X ver. 10.7 (x86, 64-bit), DMG Archive. (Don’t worry about the 10.7 naming, Works fine in OSX 10.9 and OSX 10.8) Stop the MySQL Server sudo /usr/local/mysql/support-files/mysql.server stop Download and Launch the DMG There is no upgrade…

Read More
Categorized macOS Tagged mysql

Posts navigation

« PreviousPrevious page Page 1 Page 2
Get Beaver Builder Now!

Tags

ACF apache archive beaver beaver builder beaver theme beaver themer bootstrap cache category checkout cpt css customizer filter flexbox footer form genesis header homebrew htaccess iconfonts image javascript jquery loop markup menu meta mysql php pre_get_posts repeater search filter pro serverpilot shortcode slider taxonomy template UI/UX while widget woocommerce wp-cli

Donate

If you found something that helped you out and would like to make a donation, that's great

PowerPack Beaver Builder Addon

Our Location

We are based in the Northern Beaches of Sydney and work with both local and overseas based clients.

Work With Us

Let us know your web requirements, see our services and use the contact form to get in touch and start the ball rolling.

Check Us Out

  • Home
  • Blog
  • About
  • Services

© 2017 · NEIL GOWRAN · POWERED BY WORDPRESS, BEAVER, AND HOSTED ON RUNCLOUD AND RACKNERD

Scroll To Top