On 2019-06-20 11:34 a.m., Indranil Das Gupta wrote:
On Thu 20 Jun, 2019, 8:13 PM Yatheesh lis, <[email protected]> wrote:
Hi
1) what is deferencece B/w Koha backup vs -SQL backup.
None. It's the same MySQL database if you are talking about the database
backup generated by koha-run-backups script.
Respectfully, this could be misinterpreted. "-SQL" pure backup is done via:
mysqldump --user=your_kohadb_username --password=whatever your
koha_db_name > /wherever/backup/koha_dump_whatever
Note that this is best done using the "Koha" owner (not root) and is
agnostic as to whether you use Innodb or Isam as storage engine. I
haven't kept perfect track of all shell commands as 'koha-run-backups
script', but they were designed to do more or less exactly that, but
with a (default 2 day) over-write as a cron job.
However, the defaults used may
be different, for example whether syntaxes like "CREATE IF NOT EXIST" are
incorporated OR not in the backup etc.
This has nothing whatsoever to do with "backup" but with "restore" -- it
is a function of the opposite mysqldump < (rather than >) and is only
[potentially] relevant to *overwrite* a previous, differently
constructed and protected, database.
2) I have taken backup through koha and imported other system but it shows
only biblio records with out any item details why?
Does your "backup through [k]Koha" show your items? In other words, did
you have an existing library, with biblios and items, that you can
restore? Or, is it only your "imported other system" that fails (or
even breaks your old, possibly inexistent library)?
Regards -- Paul
Most likely case, that somehow the branchcode (s) defined are different
from the backup.
In case you are talking about *MARC* backup rather than a full db backup,
then either (a) your branchcodes are not same between the instances OR (b)
you have only exported the bibs and *not* the items.
3) to import -SQL backup should I know database name?
Yes.
Cheers
Indranil Das Gupta
L2C2 Technologies
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
