Hi Joshua, Joshua Ferraro wrote:

Hi Greg,

Probably the safest way to proceed is to install Koha on the new server, then just mysqldump the Koha database on the old server and restore it to the new server. Something like this:

# mysqldump -ukohaadmin -pmypass --add-drop-table Koha > koha.sql # scp koha.sql myuser@newserver.com:

Then on the new server:

# mysql -ukohaadmin -pmypass Koha < /home/myuser/koha.sql

Hope that helps, let us know how it goes.

Fantastic, I will give it a shot and see how we go!

Cheers,

-- Joshua Ferraro VENDOR SERVICES FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

On Wed, Jan 18, 2006 at 06:16:07PM +1100, Greg Vickers wrote:

...

Hi all,

We ae running Koha on a dodgy spare desktop that we scrounged up, now we have a nice shiny Dell server to run it on.

What is the easiest method of transferring the data from the old server to the new server? (Using Koha 2.2.4 on both servers.) I'm guessing that all I have to do is install Koha on the new server (meet prerequisites etc) and move across the MySQL data to the new server. Am I missing something critical?

Thanks, Greg _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Would the following instruction work for stand alone koha on windows? Would myuser@newserver.com still applicable to Koha on Windows' C drive? Greg Vickers <daehenoc@optusnet.com.au> wrote: Joshua Ferraro wrote:

Hi Greg,

Probably the safest way to proceed is to install Koha on the new server, then just mysqldump the Koha database on the old server and restore it to the new server. Something like this:

# mysqldump -ukohaadmin -pmypass --add-drop-table Koha > koha.sql # scp koha.sql myuser@newserver.com:

Then on the new server:

# mysql -ukohaadmin -pmypass Koha < /home/myuser/koha.sql

Hope that helps, let us know how it goes.

Cheers,

WIN! All data transferred successfully! Thank you Joshua, you are a champion :) _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha --------------------------------- Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.