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
455
August 21, 2022 04:08PM
Re: Move database to a new machine
233
August 21, 2022 04:49PM
206
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.