Move database to a new machine
Posted by: Helene Wallis
Date: August 21, 2022 04:08PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Move database to a new machine
149
August 21, 2022 04:08PM
45
August 30, 2022 04:15AM


Sorry, only registered users may post in this forum.

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.