Not WordPress related, so I am not sure if I have the right to reply in here, but still increase max_user_connections in my.cnf MySQL configuration file since you are just testing. There are number of causes for running out of connections, the most common ones involving when the Web/App server is creating unexpectedly large numbers … Read more
This is generally not a good idea. See this WordPress database diagram. You need to consider: posts that have categories or tags (terms), their relationships, term meta, and taxonomies posts that have authors (users) posts that have comments things that are actually posts that you might not realise are posts (eg. almost everything in WordPress … Read more
Yes, give them the four things you mentioned. The main thing would be the .xml file that is created when using the WordPress export feature. Keep in mind that you need to keep the media on your server too if you want them to be able to import it with the .xml file. The file … Read more
You only have 1 option here, which by most standards isn’t advised. You have to edit a core WordPress file: wp-db.php The reason is that there are no filters to change these and the code is kinda hard-coded. WordPress checks the availability of collation it selects though. If you need it just enough to setup … Read more
You may install WordPress for postgres. I am the maintainer of the project. The repository here: https://github.com/php4dev/heroku-wordpress
delete from `wp_terms` where `term_id` in ( SELECT `term_id` FROM `wp_term_taxonomy` WHERE `taxonomy` = ‘post_tag’ ) and `term_id` not like 1 The above Code was exactly what I was looking for.
What is your database encoding? Try to switch to utf8mb4. Alternatively, try to add one of these lines in your wp-config.php file: define(‘DB_CHARSET’, ‘latin1’); define(‘DB_COLLATE’, ”); or define(‘DB_CHARSET’, ‘utf8’); define(‘DB_COLLATE’, ”); or define(‘DB_CHARSET’, ‘utf8mb4’); define(‘DB_COLLATE’, ”);
While I am a big fan of tweaking wordpress as much as it could because it allows us to, I think the best way forward is to have the best algorithm before coding. Reading your question, I came across ” Actually, I have created two custom post type named ‘truck’ and ‘drivers’ “. Issue: Linking … Read more
It’s in the post meta table (usually wp_postmeta), with the page id in post_id, meta_key with _wp_page_template and meta_value with the template file name.
Pretty easy to do from phpMyadmin. I’ve used this tutorial before successfully.