[Koha] Moving

[Paul POULAIN]

Chris Cormack a écrit :

>>But what is the best way to transfer the data? I do not have huge amounts,
>>but it would be annoying to start again. Is Mysqldump the way to go?
>>    
>>
>mysqldump is the way id do it.
>  
>
Another solution, better for big amount of datas :
* mysql shutdown
* copy of the directory where is your DB (/var/mysql/your_koha_db maybe)
* mysql start

A lot faster on a big DB, where the sql rebuilding can take hours (for 
example, on a IDE disk, the Nelsonville DB, which is 1.4GB huge, needs 
14Hours to be restored. (with a SCSI disk, It needs only 3-4 hours. SCSI 
is 4 times faster in this case)

-- 
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)