17 Jun
2004
17 Jun
'04
4:09 p.m.
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)