dbDelta() is very picky, below I’ve checked the requirements for dbDelta() in your code. As you can see below your code fails two of the requirements which most likely prevents dbDelta() from creating the tables. You must put each field on its own line in your SQL statement. CHECK You must have two spaces between … Read more
I don’t think WordPress can manage two databases at the same time (unless you tweak it significantly, by means of HyperDB1). So, you’d probably will like the job of abstracting two databases and making them look like one to WordPress to be done by the database functionality. WordPress can work mostly with MySQL (see WordPress … Read more
WP is not likely going to add this feature… From https://core.trac.wordpress.org/ticket/14644, the main reason given by Nacin is: This is a caching issue. Additionally, it also breaks URLs and such, which is why I don’t think administrators should be able to do it either. Seems simple enough to relegate to a plugin, or a straight … Read more
You can find any additional information in the usermeta table as meta_key meta_value pairs. Wordpress doesn’t create additional database columns for custom fields. That’s one of the great concepts that make WordPress so smart and flexible.
The short answer is — no, there is no simple way. WP is designed to work within a boundries of a single database as installed and with core exclusively manipulating that data. There are no concepts of database being manipulated partially and externally. The most common and reliable workflow is that you copy database from … Read more
If the database server is available publicly you should be able to use a MySQL client to interact with it. Sequel Pro is a good one for mac, check this list if you need something for windows or linux. If the database is only available locally on your web server, you might be able to … Read more
wordpress is designed around a database. You need the database to have the site load at all. It wouldn’t be possible to do what you’re asking. What you could do though is go to the internet archive www.archive.org and see if they have a visual representation of your site backed up there and you could … Read more
Are you sure you didn’t mean $wpdb->staff? By ommitting the $, the query now looks for a table called wpdb->staff, which isn’t valid SQL As an aside, had you considered using a custom post type/user meta instead of a custom table? Or even a custom taxonomy on users? Note as well that if you never … Read more
I found a post on Stack Overflow advising that converting a column from blob to text should result in no data loss. I didn’t really care about data loss since I wanted to remove the plugin data anyway, so I gave it a shot. On the Structure tab in phpMyAdmin, I edited the val column … Read more
Check your wp-config.php file and look for the table prefix. That should be wp6t_.