Hi,
You use the mysqldump command to create the file.
In your /etc/koha/koha-conf.xml file, you will have a section about
your mysql config:
<config>
<db_scheme>mysql</db_scheme>
<database>*kohadb*</database>
<hostname>localhost</hostname>
<port>3306</port>
<user>*koha*</user>
<pass>*kohapassword*</pass>
...
Take the database, user and password from that file, and type
something like this:
mysqldump -u[username] -p[password] [database] >
/root/TheFileYouWantToSave.sql
for example, if I wanted to save my file as "Koha-02-13-2015.sql"
using the credentials I have in my config file above, I would have:
mysqldump -u*koha* -p*kohapassword* *kohadb *>
/root/*Koha-02-13-2015.sql*
If you do not put the password on the commandline, it will prompt you
for it.
mysqldump -u*koha* -p *kohadb *> /root/*Koha-02-13-2015.sql*
- Tim
On 2/13/2015 7:34 AM, John Doane wrote:
Dear fellow KOHA users,
I am new to using KOHA but I have managed to use Josh Hertel’s virtual
machine with KOHA to get a system up and running. I would like to save a copy
of the sql file but I can’t seem to locate the actual database file! Any
suggestions on how to find it?
Any help would be greatly appreciated.
Cheers
John
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
http://lists.katipo.co.nz/mailman/listinfo/koha
