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
This is the old XigmaNAS forum in read only mode,
it will taken offline by the end of march 2021!
I like to aks Users and Admins to rewrite/take over important post from here into the new fresh main forum!
Its not possible for us to export from here and import it to the main forum!
it will taken offline by the end of march 2021!
I like to aks Users and Admins to rewrite/take over important post from here into the new fresh main forum!
Its not possible for us to export from here and import it to the main forum!
Reinitialize mysql with existing database
-
himbrr
- Advanced User
- Posts: 153
- Joined: 21 Oct 2012 21:16
- Location: Germany
- Status: Offline
Reinitialize mysql with existing database
Nas4Free 9.2.0.1.972, ASUS P8H77-I, 8GB RAM, Intel Celeron CPU G530 @ 2.40GHz, 5x 2TB WD Red, 1x 60GB OCZ Vertex 2
-
himbrr
- Advanced User
- Posts: 153
- Joined: 21 Oct 2012 21:16
- Location: Germany
- Status: Offline
Re: Reinitialize mysql with existing database
DELETED
Last edited by himbrr on 27 Jul 2014 13:35, edited 1 time in total.
Nas4Free 9.2.0.1.972, ASUS P8H77-I, 8GB RAM, Intel Celeron CPU G530 @ 2.40GHz, 5x 2TB WD Red, 1x 60GB OCZ Vertex 2
-
b0ssman
- Forum Moderator
- Posts: 2438
- Joined: 14 Feb 2013 08:34
- Location: Munich, Germany
- Status: Offline
Re: Reinitialize mysql with existing database
i would just dump the database using mysqldump and reimport it on the new system
Nas4Free 11.1.0.4.4517. Supermicro X10SLL-F, 16gb ECC, i3 4130, IBM M1015 with IT firmware. 4x 3tb WD Red, 4x 2TB Samsung F4, both GEOM AES 256 encrypted.
-
himbrr
- Advanced User
- Posts: 153
- Joined: 21 Oct 2012 21:16
- Location: Germany
- Status: Offline
Re: Reinitialize mysql with existing database
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...
I still have the database folder from mysql, but I can't get mysql running on nas4free embedded...
Nas4Free 9.2.0.1.972, ASUS P8H77-I, 8GB RAM, Intel Celeron CPU G530 @ 2.40GHz, 5x 2TB WD Red, 1x 60GB OCZ Vertex 2
-
dreamcat4
- experienced User
- Posts: 111
- Joined: 21 Mar 2014 21:59
- Status: Offline
Re: Reinitialize mysql with existing database
install Finch, create a jail, and type "pkg install mysql-server". That will give you mysql.himbrr wrote:but I can't get mysql running on nas4free embedded...
Not so sure how you are going to import / export your 'mysql folder'. Ask elsewhere.