Is there a straightforward way to share/sync multiple WP instances with a single database? I work collaboratively with several developers on custom themed sites. We use git to keep our files in order and it’s all fine in the early stages, but once content, plugins etc. start coming into play, we have issues with staying in sync with content.
How do I detect errors when using $wpdb->get_results()?
I created a plugin and want to add a function to delete my tables from the database when a user deletes my plugin. I created a function that deletes tables from the DB when a user deactivates my plugin, but I don’t want that. Here is the code:
I’m following this to make my plugin auto-create a table when the plugin is activated, but what happens is that while all the tables (the whole db) are utf8_general_ci, the newly created table is latin1_swedish_ci… Why isn’t it also utf8? I thought it would also be utf8 by default since I have:
I know there are tools like pingdom.com and uptimerobot.com that will monitor your site and let you know if they’re down, but I find that my WordPress site is experiencing the dreaded “error establishing a database connection” more often than desired, and I’d like to get some sort of notification when that happens (but not in the form of a user complaint!). Pingdom and Uptimerobot do not consider that an error, and thus do not push any notifications.
I got a message from Hostgator about my account being suspended because of the load it put on their servers. This is about the fifth time this has happened. I am on a shared server.
It is broadly accepted that developers should test updates through a staging site before releasing them to the live server, however once the development updates require modifications in WordPress DB, things get complicated, as users in the live site will update the DB too.
I’ve long wished WordPress would support SQL Server, but it would also really amazing if it supported MongoDB (for example.)
I have a MySQL database with 71 tables. It houses news, galleries, slideshow data, page content, products, customers, shipping, discount codes, ( basically a full store build on a PHP shop). I want to migrate over to WP. I’m new to wordpress, how easy/difficult will this be? I can do a SQL dump of the … Read more
I am using WordPress 3 and would like to backup the database to my computer (a Mac). My webhost is using PHP safe mode, so that sometimes limits what plugins I can use. What is a good way to do a database backup? Is it possible to be automated? Are incremental backups recommended/easy? Obviously I then need to test restoring form a backup.