Configure WordPress to use MariaDB over SSL?
I got it working after removing the quotes around MYSQLI_CLIENT_SSL. Before: define( ‘MYSQL_CLIENT_FLAGS’, ‘MYSQLI_CLIENT_SSL’ ); After: define( ‘MYSQL_CLIENT_FLAGS’, MYSQLI_CLIENT_SSL );
Database
Admin backend is very slow to create or edit posts by core meta query
Admin backend is very slow to create or edit posts by core meta query
Old Website SQL DB & files – is there a way to import to a new site?
As with any CMS that uses a database, WordPress stores content in the database so you wouldn’t see it in the files. It should be possible to recreate the site from what you have. If you’d like to work on it on your local machine then upload to a hosting account when you’re ready, LocalWP … Read more
update_post_meta returns ID, but nothing in the database
update_post_meta returns ID, but nothing in the database
WordPress cannot detect (present, loaded) mysqli
WordPress cannot detect (present, loaded) mysqli
mysql running over 200% CPU according to atop – pt-query-digest suggests slow running query is a lookup in wp_options for ‘autoload’ = yes
So the issue was actually a DDOS attack on our site. I used urlsnarf to see what requests were being placed and there were basically hundreds of POST request from about 20-30 or so IP addresses. Seems quite small scale for what I understood is a typical DDOS attack. It also explains why it took … Read more
$wpdb->get_results() query empty, but same query in phpmyadmin has results
$wpdb->get_results() query empty, but same query in phpmyadmin has results
Understanding Redundant postmeta Tables in WordPress Database
Is it normal to have multiple postmeta tables in a WordPress database? No, each site has a single post/user/term and comment meta table. A multisite will have a set of those tables for each site in the multisite, plus network/site meta tables. What could be the reason behind this duplication? WP wouldn’t duplicate the tables … Read more
After Import: Insert “Use” Statement in Database
It appears, at least in cPanel, the lines in question were not required in the export, with the unsurprising consequence of the other encapsulated sql statements defaulting to reference the current database only. Turns out to be convenient when more than one database is configured, so long as there are no statements that select objects … Read more
How to generate PDF dynamically based on values from the database in WordPress
Using the FPDF library (found at http://www.fpdf.org) you generate PDFs on the fly using any data from your WP site. function wpse60844_generate_pdf( $post ) { /* Define paths for where the PDF will be permanently or temporarily saved */ define( ‘FPDF_PATH’, plugin_dir_path( __DIR__ ) . ‘/fpdf/’ ); define( ‘SAVE_PATH’, plugin_dir_path( __DIR__ ) . ‘fpdf/pdfs/’ ); … Read more