Move database to a new machine
I need to move the database I just created on my desktop so it resides on our server. I see the commands for doing that--
mysqladmin -h 'other_hostname' create db_name
mysqldump db_name | mysql -h 'other_hostname' db_name
But I'm not sure how to specify 'other-hostname.' I know how to address our server, of course, but only in terms of its network name and directory names. Part of the problem is that I don't know where the database lives on my desktop, so I'm not sure how to specify a location on our server. I see the Workbench and shell apps, but nothing that tells me where the database itself is located.
Subject
Views
Written By
Posted
Move database to a new machine
451
August 21, 2022 04:08PM
233
August 21, 2022 04:49PM
205
August 22, 2022 04:37AM
240
August 30, 2022 04:15AM
215
August 22, 2022 10:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.