When working with custom tables in WordPress, we need to have a way to clean the database if the users decide to delete our plugin or we need it ourselves. In this tutorial, we’ll use the same installer class from previous tutorials and update it with new methods.
Read MoreTag: database
Working with Custom Tables in WordPress – Meta Tables
WordPress has an API when working with custom meta tables but you have to follow the rules. We’ll cover what has to be done for those functions to work with your custom meta tables.
Read MoreWorking with Custom Tables in WordPress – Installing and Updating
Installing and updating custom tables in WordPress is done within the same function so you don’t have to worry about writing altering queries. In this tutorial, we will create a class that will help us work with installing and updating our own custom tables in WordPress.
Read MoreWorking with Custom Tables in WordPress – Introduction
When working on custom solutions or plugins in WordPress, custom tables can be a good solution because it will give you better performance than by using the default tables such as posts
or postmeta
.
How to Import Large Databases in Local by Flywheel Sites
Working with clients with WordPress sites can be difficult when you have to migrate their site locally so you can develop on it. If you’re using Local by Flywheel the site is hosted on Flywheel, you will have no problem. If their site is not a big one, you’ll also have no problem using some of the existing solutions such as WP Migrate DB Pro and alike. But what if your site has large databases (read tens of GB), what to do then?
In this tutorial, I’ll show you how to migrate such large databases in Local by Flywheel through SSH.