Re: Move database to a new machine
Posted by: Peter Brawley
Date: August 21, 2022 04:49PM

A MySQL database isn't a file. It's an object created & maintained by the MySQL RDBMS.

Simplest way to copy the db from your desktop instance of MySQL with mysqldump ...

mysqldump -uUSR -pPWD db -K -E -R >db.sql

... where USR & PWD are your MySQL username & passowrd, then import that file of SQL cmds into your MySQL server instance with the source cmd in that instance's mysql client program running on the server, eg ...

source path_to_db_sql (no terminating semicolon)

Options: ReplyQuote


Subject
Views
Written By
Posted
339
August 21, 2022 04:08PM
Re: Move database to a new machine
164
August 21, 2022 04:49PM
171
August 30, 2022 04:15AM


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.