Migrate Existing database from Linux to Windows.

[mgordon]

Hi all,

I have a NolaPro installation on a Linux box. I want to migrate that installation back onto a Windows environment. Is there a way that I can connect a fresh installation of NolaPro to an existing database? Or is there a php file configuration that has to be done which directs the software to the correct database?

As Nola runs with an apache module, I'm more than happy to use this as its webserver. Any help or direction on this matter is gratefully appreciated.

Many Thanks,

Michael

[admin]

Michael,

This can be done by backing up your database on the Linux machine and importing it into your Windows install.

To backup your database on Linux, navigate to your MySQL databases using terminal and enter the following:

mysqldump -u root -p nolapro > nolapro_backup.sql (where nolapro is the name of your NolaPro database).

After NolaPro is installed on Windows, import your backup using the command prompt:

Type: cd C:\Program Files\Noguska\NolaPro\Apache\mysql\bin
Import the database by typing: mysql -uroot nolapro < nolapro_backup.sql