badasswp

This plugin helps you migrate legacy SQL database tables to WordPress’ Custom Post Types (CPT). It provides a user-friendly UI interface that enables users upload an SQL file which is then parsed and converted to a CPT with meta data that is recognisable within WordPress.
If you ever need to migrate a non-WordPress database table into WP, look no further. This is exactly what you need!
<h4>✔️ Features</h4>
Our plugin comes with everything you need to easily migrate SQL tables to CPTs.
✔️ Import & Convert to CPT feature. 
✔️ Quick & Lightening Fast uploads. 
✔️ Friendly, User Interface (UI). 
✔️ Custom Post Type Capabilities. 
✔️ Error Loggging Capabilities. 
✔️ Custom Hooks to help you customize plugin behaviour. 
✔️ Available in mutiple langauges such as Arabic, Chinese, Hebrew, Hindi, Russian, German, Italian, Croatian, Spanish & French languages. 
✔️ Backward compatible, works with most WP versions.
<h4>✨ Getting Started</h4>
Head over to the SQL to CPT options page. Upload an SQL file of your choice by clicking on the Import SQL File. This would analyse your SQL table and show you the table name and table columns you are about to import. Once ready, click on the Convert to CPT button to complete the process.
On import completion, you should now be re-directed to the Custom Post Type page of your newly imported data!
You can get a taste of how this works, by using the <a href="https://tastewp.com/create/NMS/8.0/6.7.0/sql-to-cpt/twentytwentythree?ni=true&origin=wp" rel="nofollow ugc">demo</a> link.
<h4>⚡ Why SQL to CPT ?</h4>
<ol>
<li>Because you need something that works great and fast!</li>
<li>Because you want to port your data across platforms easily.</li>
<li>Because you don’t want to spend hours building custom software for this.</li>
<li>Because you think SQL to CPT is cool.</li>
</ol>
NB: At the moment, the SQL to CPT plugin currently does not provide a way for users to import more than one SQL table at a time, this feature should be available in future releases as well as the option to remove unused CPTs.
<h4>🔌🎨 Plug and Play or Customize</h4>
The SQL to CPT plugin is built to work right out of the box. Simply install, activate and start using.
Want to add your personal touch? All of our documentation can be found <a href="https://github.com/badasswp/sql-to-cpt" rel="nofollow ugc">here</a>. You can override the plugin’s behaviour with custom logic of your own using <a href="https://github.com/badasswp/sql-to-cpt?tab=readme-ov-file#hooks" rel="nofollow ugc">hooks</a>.
<h3>Contribute</h3>
If you’d like to contribute to the development of this plugin, you can find it on <a href="https://github.com/badasswp/sql-to-cpt" rel="nofollow ugc">GitHub</a>.
To build, clone repo and run <code>yarn install && yarn build</code>

SQL To CPT

Import & Convert SQL tables to Custom Post Types (CPT). Migrate legacy SQL table data to WordPress custom post types of your choice. It's super fast!

it2911

TiDB is a high-performance database that is compatible with the MySQL protocol. Since MySQL has deprecated the SQL_CALC_FOUND_ROWS function, TiDB also has no intention of offering the SQL_CALC_FOUND_ROWS function. This leads to an error in WordPress when using TiDB, indicating that SQL_CALC_FOUND_ROWS is not supported, and submissions cannot be displayed correctly.
WordPress is also currently working on this issue, but it seems that more time is needed. #47280 Remove usage of deprecated MySQL SQL_CALC_FOUND_ROWS from WP_Query
This plugin solves the issue of TiDB not providing the SQL_CALC_FOUND_ROWS function. Once this plugin is activated, parts of WP_Query that use SQL_CALC_FOUND_ROWS will be replaced with the COUNT(*) function.
This plugin is entirely based on the method mentioned by @akramipro in the article, and this solution works perfectly and addresses the issue. I’ve turned this method into a plugin so that those using TiDB can easily resolve this problem. Many thanks to @akramipro for the excellent work, and I hope the official WordPress team can address this issue sooner.
<h3>Contribute</h3>
Contribute to this plugin on <a href="https://github.com/pingcap/wordpress-tidb-plugin" rel="nofollow ugc">github.com/pingcap/wordpress-tidb-plugin</a>

TiDB Compatibility


This plugin is a must-have if you are running TiDB as the database instead of MySQL/MariaDB.


Must have for TiDB users

This plugin is an official tool provided by PingCAP, designed to solve compatibility issues between TiDB and WordPress.

SQL To CPT vs TiDB Compatibility