Backup your db Remeber to backup your db Import the backup in another database, change wp-config.php to use this new database and see if everithing is ok. (Importing is successfull? Site appear without any change?) WordPress uses a prefix for table names. The default is ‘wp_’ but clever guys change it with something else. (The … Read more
Set up a staging database on an online host and connect remotely from your various local dev environments. Might get a little confusing sharing 1 DB between many installs though.
The others are not needed as you point out. Btw, what you could do is, conditionally set the user/pass based on the requested page. As in unprivileged with select/insert/update/delete for normal usage, and privileged with definition/index related stuff in addition when visiting the upgrade page.
Does the WordPress installation has to use an exclusive database? If there are no table name conflicts, WordPress can share a database. Preventing conflicts is just a matter of setting a database prefix on install. By default, that prefix is wp_ but you can change it to anything you want within reasonable character limits. It … Read more
I broke database after reuploading local version – what exactly happened? Database error
Calling update_user_meta inside of another function doesn’t work
It may be a wrong approach, but without creating a plugin, one of my seniors, once did a WordPress Shopping Cart project by creating extra tables for her custom purposes. What she did is to follow the other existing tables in WordPress database. Suppose what wp_posts table has by default is an ID. She opened … Read more
featured image not showing up with mysql_connect
yes Patrick, you need to install wordpress again in that directory and add a new databases or just use the existing one just put in mind that u should not use the same prefix which you used in your root installation, and after that just pop any en or english link in your root site … Read more
This sounds like you have a hierarchical post type. You will have trouble with hierarchical post types with large numbers of posts because query results have to be sorted/resorted. Register you post type with hierarchical set to false, if you can.