It’s possible, but the live database should of course accept connections from “outside”. Very often, this is not the case by default (and the database on the live server will only accept connections/requests that come from the server itself) so you may have to set some permissions on the live server.
As an alternative, you could use a plugin that syncs databases with 1 or 2 clicks, so you can just keep working locally and then when you want to push your database to your live server, that’ll take just a minute.
Thanks for the input. The server tech is suggesting to me that it’s doable but I’m still waiting to see if it will happen …so I thought I would check here to see if it was even possible.
Can you suggest a really easy to use plug in that has a one time fee AND that backs up the db with the files. BackupBuddy has a ‘monthly’ charge I believe so I haven’t opted for that at this point. I’m so spoiled with Joomla sites and having Akeeba backup to use for free.
When it comes to database syncing (or saving as an .SQL file), one of the best ones is WP Migrate DB Pro. It’s not cheap ($90) but is worth it if you develop a bunch of sites: https://deliciousbrains.com/wp-migrate-db-pro/
There is also a free version but I’m not sure what the restrictions are for that one, to be honest: https://ww.wp.xz.cn/plugins/wp-migrate-db/
The plugin DUPLICATOR has a very good reputation at moving websites, it is free.
