Database - Read For Learn

I have found that the following works for connecting the database via the theme’s functions.php file. I placed this code snippet at the end of the existing code in the file. Even though the fatal error threw several line errors when trying to access the site, it only came down to wpdb having an extra … Read more

Is it safe to convert tables from MyISAM to InnoDB?

Database error Deadlock found when trying to get lock; try restarting

WordPress site uses MyISAM, should I switch to InnoDB necessary?

You should have switched to InnoDB at some point in the past decade, but now is as good a time as you are going to find. 🙂 mysqldump will work the same way. MyISAM could not be backed up while the database is running either. Databases generally cannot be backed up by running using a … Read more

How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?

Something tells me that it could be the maximum script execution timing out perhaps. The amount of memory your inserts are consuming could also be the culprit. Are you getting any error messages, blank screens or anything like that? You could try adding the following above where you’re calling the wp_insert_post() function: set_time_limit(0);

Merge two databases: OLD SITE -> NEW SITE

Try using the export/import feature visit Tools Export Screen.

What is the most secure way to set up the MySQL user in WPMU?

I am setting up Subdomain based MU on my domain. Just remember, what used to be called “WordPress MU” is now “WordPress Multisite.” It’s not a separate application, just a configuration setting you use within WordPress. Will I be better off setting the MySQL user’s domain as localhost, 127.0.0.1 or with a wildcard %.mydomain.com? Which … Read more

can database and media folder be moved to a different drive?

DISCLAIMER : Only a MySQL DBA, not WordPress expert You could migrate the database as follows: Very first thing is to locate the my.ini for MySQL. Search all data volumes until you locate my.ini Next, login to MySQL and run SHOW VARIABLES LIKE ‘datadir’; This will tell you what folder MySQL data is stored. For … Read more

+ More

Find duplicate posts with same slug and author

Keeping database within limits, please help!

Connect Second Database to WordPress