[Koha] Migrate all Koha data from old server to new server

[khurram]

Carol Ku <carolcool01 at ...> writes:

> 
> 
> Would the following instruction work for stand alone koha on windows? 
Would myuser-3OOmeqoDtxV54TAoqtyWWQ at public.gmane.org still applicable to
Koha on Windows' C drive?Greg Vickers
<daehenoc-sFbbPxZDHXw0n/F98K4Iww at public.gmane.org> 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-3OOmeqoDtxV54TAoqtyWWQ at public.gmane.org:>>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
listKoha-MiqU8s9CcdeGg0aVt5PjEHTaI6DYlTYJ at public.gmane.orghttp://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 
> 
> 
> 		Yahoo! Photos 
> Ring in the New Year with Photo Calendars. Add photos, events, holidays,
whatever.
> 
> _______________________________________________
> Koha mailing list
> Koha at ...
> http://lists.katipo.co.nz/mailman/listinfo/koha
> 


ERROR 1064 (42000) at line 20: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near '(14) NOT NULL,
  KEY acctsborridx (borrowernumber),
  KEY timeidx (timestamp)
) ' at line 11