Restore Database from SQL file into New Installation

Thanks Kovah,

I did the sql import using mysql cli client and it seems to have worked. Everything is back, invoices, clients, products, user accounts. The only problem I have found is when I go to System Settings there is no stylesheets for the page.

This is using v1.4.4

I am going to post in the HOWTO section for how to do the restore.

EDIT: The stylesheet problem was mcrypt php module not being activated (add extension=mcrypt.so to php.ini, restart apache)

I have only found one minor problem with this. In Settings -> Updates the version of InvoicePlane seems to show the version that the tables were created on. Examples, my wife’s IP install was first 1.2.1, so hers shows the current version as 1.2.1. My install show 1.4.3 but I have installed 1.4.4 to both new installations. Could it be because the SQL files tells it to “DROP IF EXISTS” for the tables?

1 Like