Page 1 of 1

Reinitialize mysql with existing database

Posted: 26 Jul 2014 16:56
by himbrr
Hi all,

is it possible to install mysql with an existing database?

I had a mysql db running on a nas4free full installation. Now I have migrated to nas4free embedded.
So I have to install mysql again, but I want to use the old database.

Do you have any tipps about this?
Should I install mysql on the system itself or install it in a jail?
Whats the best practice in this case?

Cheers,
himbrr

Re: Reinitialize mysql with existing database

Posted: 26 Jul 2014 16:56
by himbrr
DELETED

Re: Reinitialize mysql with existing database

Posted: 26 Jul 2014 17:33
by b0ssman
i would just dump the database using mysqldump and reimport it on the new system

Re: Reinitialize mysql with existing database

Posted: 27 Jul 2014 13:37
by himbrr
The old system isn't running anymore, so I can't backup the databases from mysql directly.
I still have the database folder from mysql, but I can't get mysql running on nas4free embedded...

Re: Reinitialize mysql with existing database

Posted: 29 Jul 2014 04:57
by dreamcat4
himbrr wrote:but I can't get mysql running on nas4free embedded...
install Finch, create a jail, and type "pkg install mysql-server". That will give you mysql.
Not so sure how you are going to import / export your 'mysql folder'. Ask elsewhere.