Migrate to new Installation

I have have a current installation of invoice ninja V5 …

In my current installation, i got some bug after some update ( Thread here : Column not found: 1054 Unknown column 'current_hours' and here : Column not found: 1054 Unknown column ‘current_hours’ · invoiceninja/invoiceninja · Discussion #10726 · GitHub ) …

It’s actually working but There’s still some weird stuff that i’m not sure if it’s normal Behavior of Invoice Ninja or if something else is still break in my installation …

BTW, my old server is due to change so i was thinking about doing a fresh installation of invoice Ninja and Import my data into it …

The Migration procedure a found out actually talk about simply do a MySQL DUMP and move the folder public/storage folder …

As i suspect some problem within my MySQL structures and wish to eliminate it, i would prefer to let Fresh invoice ninja install do his job of creating the structure and import Data into it …

So is there a way within invoice Ninja to export all my informations in a clean way or the best way would be to do an export from phpmyadmin without having the structure embed into the .sql file ???

Hi,

Using mysqldump is the best option but you can also export your data/settings as JSON to transfer it to a new install.

Note: if you do use mysqldump it’s important to copy over the APP_KEY from the original .env file.