Data Explorer: Remote Database

Hi Richard,

Did you create the table you designed in the Data Designer? When you save a table design in the Data Designer the physical table is not created immediately. The plugin lets you work on your design until you are ready. After that you need to explicitly create the table (click on button CREATE TABLE). This is different from tools like phpMyAdmin where changes are directly reflected in your physical database. Please let me know if this helps.

Best regards,
Peter

Did you create the table you designed in the Data Designer?

No I didn’t.
I’m using MySQL Workbench to manage my database. When I started using your Data Access plugin I created a connection to the remote database and upon doing so the tables and views already present in the DB appeared in the Data Designer. I was then able to display the content of a specific view which is what I wanted. All great so far.
A couple of weeks later I went ahead and created three new tables via Workbench thinking that it would be possible to have these tables show up in the Data Access page by ‘refreshing’ the connection but no, hence my original question.
Can I achieve what I want by removing the original remote connection and creating a new one?

Hi Richard,

>>> Can I achieve what I want by removing the original remote connection and creating a new one?

That should not make any difference. WP Data Access does not save your data dictionary. It reads the dictionary in real time.

>>> A couple of weeks later I went ahead and created three new tables via Workbench thinking that it would be possible to have these tables show up in the Data Access page by ‘refreshing’ the connection but no, hence my original question.

That is what I would expect as well. Were the tables create with the same user account? If not, you might need to give the user access rights. Can you check that please?

Thanks,
Peter

Were the tables create with the same user account? If not, you might need to give the user access rights.

All the tables were created using the database administrator account. However, the plugin connects to the DB with an user account that only has CRUD access. I’ll change the connection string to see what happens.
Thanks for the head’s up on this.

Hi Peter,
I’ve resolved this problem. All I had to do was to edit the connection (I just changed the connection name), clicked ‘save’, then ‘test’ and all 29 tables were displayed.

Thanks for your update Richard!

Just to be sure, did you recreate the remote database connection with the same user account and credentials?

Thanks,
Peter

Please accept my apologies for raising an issue when there was none. I’ve since had an Eureka! moment remembering that when I first installed the WPDA plugin I had checked ‘Show only selected tables’ in the ‘Table access’ options (please see the pic in the link below). Changing it to ‘Show all tables’ displayed the ‘missing’ tables.
Data Access Settings: Select tables

I’m still finding my way around the plugin which is taking me a while because there are so many clever facets to it.
Best wishes,
Richard

No problem Richard, I’m glad it is solved! ??

Have a nice weekend,
Peter