Last February you posted an article on working with custom database tables in WordPress. This is exactly the process I am looking for. I have created a database which tracks a few particulars about users and can calculate a few parameters for them based off data they provide. I want to ‘add’ this database to the WP database (or vice verse) so that I can have users log in and out via the custom database and then have access to some of the data in the tables.
If that makes sense and there is a better way to do this I am very open to change and learning (maybe its easier to have users use WordPress registration and then that grants them access to my database).
In your article, the requirements section, you mentioned that it would be required to merge an existing database into WordPress datebase or vice-versa.
I am relatively new to both WordPress and creating custom (anything) but learn quickly. I read the SSH backup article that was recommended and believe that the point of that was to show how to .TAR/.ZIP the WordPress database and then merge it with all other files on the site (including the database for the merge) using the command:
tar -vcf yourbackupfilename.tar
I don’t understand if that merges the databases though, so my question: Do you have anything copy on how to do such a merge?
If that does merge them then how do you access the table after this has happened?