Re: Move database to a new machine
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)
Subject
Views
Written By
Posted
193
August 21, 2022 04:08PM
Re: Move database to a new machine
78
August 21, 2022 04:49PM
74
August 22, 2022 04:37AM
70
August 30, 2022 04:15AM
76
August 22, 2022 10:08AM
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.