Migrate Existing database from Linux to Windows.

Installation, upgrades and general tech issues for Windows pre-Vista

Migrate Existing database from Linux to Windows.

by mgordon » Thu Nov 05, 2009 10:32 am

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
mgordon  

Re: Migrate Existing database from Linux to Windows.

by admin » Sat Nov 07, 2009 4:36 pm

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
admin Site Admin  


Return to Windows XP/2003 Issues