Carol Ku <carolcool01@...> writes: > > > Would the following instruction work for stand alone koha on windows? Would [email protected] still applicable to Koha on Windows' C drive?Greg Vickers <daehenoc-sFbbPxZDHXw0n/[email protected]> 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 [email protected]:>>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 [email protected]http://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@... > 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 _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
