Help! Can't restore database after koha update
Our small school district library server needed updating (it was running Ubuntu 11.10 which was having problems and was no longer supported). So I upgraded to Ubuntu 14.04LTS and decided to upgrade Koha at the same time (from 3.06 to 3.18). The OS upgrade went smoothly. For the Koha upgrade, I did a mysqldump of the library database (I also backed up the complete user folder as a secondary fallback). I then upgraded Koha which went fine (there were a couple of fiddles on getting Apache2 happy, but they were documented in this group or on the wiki). The problem has been that I can't seem to properly restore the library database. Before the restore,Koha runs but has no books or patrons. When I looked in the /var/lib/mysql/koha_paclibrary folder (paclibrary is our database), I saw about 150 files, nearly all .frm files with a size of 12 blocks each. I followed the instructions at http://kohageek.pbworks.com/w/page/60452540/How%20to%20move%20your%20koha%20... and did the following: sudo su mysql -uroot -p
drop database koha_paclibrary; (response was Query OK, 178 rows affected) create database koha_paclibrary; (response was Query OK, 1 row affected) quit; mysql -uroot -p koha_paclibrary < jan11dump.sql (which took a few minutes, but returned to the prompt with no errors)
Now at this point I again looked in the folder /var/lib/mysql/koha_paclibrary and there is only one file (db.opt) with a size of 4 blocks. I thought at first that the dump was wrong or small, but I checked and jan11dump.sql is 81800 blocks and looks like it has all our info inside. I tried running koha at this point on the web interface and it only gave me the installer, as though koha had not been installed at all. I tried a variety of things and then decided to uninstall koha, mysql, and apache (with sudo apt-get --purge remove) The uninstall seemed clean. And I reinstalled koha and everything happened as before. No errors except the dump won't restore properly. Can anyone give me pointers as to where to go from here? Is there a log of the mysql restore that would give me details? I looked but couldn't find one. At the moment, our library is at a standstill. Help! ________________________________________________ Gwyan Rhabyt Director, Multimedia Graduate Program Professor, Art Department California State University East Bay and President of the Board of Trustees, Pacific Elementary School District
On 23 January 2015 at 08:02, Gwyan Rhabyt <gwyan.rhabyt@csueastbay.edu> wrote:
Our small school district library server needed updating (it was running Ubuntu 11.10 which was having problems and was no longer supported). So I upgraded to Ubuntu 14.04LTS and decided to upgrade Koha at the same time (from 3.06 to 3.18). The OS upgrade went smoothly.
For the Koha upgrade, I did a mysqldump of the library database (I also backed up the complete user folder as a secondary fallback). I then upgraded Koha which went fine (there were a couple of fiddles on getting Apache2 happy, but they were documented in this group or on the wiki).
The problem has been that I can't seem to properly restore the library database. Before the restore,Koha runs but has no books or patrons. When I looked in the /var/lib/mysql/koha_paclibrary folder (paclibrary is our database), I saw about 150 files, nearly all .frm files with a size of 12 blocks each. I followed the instructions at
http://kohageek.pbworks.com/w/page/60452540/How%20to%20move%20your%20koha%20... and did the following: sudo su mysql -uroot -p
drop database koha_paclibrary; (response was Query OK, 178 rows affected) create database koha_paclibrary; (response was Query OK, 1 row affected) quit; mysql -uroot -p koha_paclibrary < jan11dump.sql (which took a few minutes, but returned to the prompt with no errors)
Now at this point I again looked in the folder /var/lib/mysql/koha_paclibrary and there is only one file (db.opt) with a size of 4 blocks. I thought at first that the dump was wrong or small, but I checked and jan11dump.sql is 81800 blocks and looks like it has all our info inside.
I tried running koha at this point on the web interface and it only gave me the installer, as though koha had not been installed at all.
Are you sure it wasn't trying to upgrade your DB, when you logged into the web installer, what did it say next? And what message are you getting at the OPAC, the library is in maintenance mode? Also, if you do mysql -uroot -p koha_paclibrary You will be in mysql what does show tables; show you? Try select * from items limit 10; Do you get results? Chris
Sorry to be slow in replying. I'm a volunteer and only in the school one or two days a week. Are you sure it wasn't trying to upgrade your DB, when you logged into the web installer, what did it say next? At 10.20.4.48:8080, it says: Koha Web installer › Step 1 You are about to install Koha. Please pick your language from the following list. If your language is not listed, please inform your systems administrator. Click 'Next' to continue But I have already installed Koha once, so I didn't continue And what message are you getting at the OPAC, the library is in maintenance mode? No, I'm getting a blank Apache page: Index of / [image: [ICO]]Name <http://10.20.4.48/?C=N;O=D>Last modified <http://10.20.4.48/?C=M;O=A>Size <http://10.20.4.48/?C=S;O=A>Description <http://10.20.4.48/?C=D;O=A> ------------------------------ ------------------------------ Apache/2.4.7 (Ubuntu) Server at 10.20.4.48 Port 80 Also, if you do mysql -uroot -p koha_paclibrary You will be in mysql what does show tables; show you? Nothing (just a prompt) Try select * from items limit 10; Do you get results? No, just Empty set (0.00 sec); ... Now if I do follow the Koha Web Installer path: It says: Web Installer Step 2 Database settings database type: mysql database name: koha_paclibrary database host: localhost database port: 3306 (probably OK if blank) database user: koha_paclibrary Connection established Database koha_paclibrary exists. User koha_paclibrary has ll required privileges on database koha_paclibrary Then (Step 3) it says we are ready to create the database tables and fill them with some default data. Then (still Step 3): Success Database tables created. (however if I go to mysql in terminal and type "show tables" I still get nothing) Then (still Step 3) I am being asked to select my MARC flavor. I choose Marc21 Then I Select Default settings and click "Import" (it takes a while) Then I given a list of mandatory data added and mysql data added and I am told All done! Click Finish. At this point I can log in as the database administrator, but there are no libraries, no patron categories, nothing. Also I still have a blank page from the OPAC view. I am clearly missing something in my process. Thanks for your suggestions. I took time off my day job, so I'll be in today, tomorrow, and Saturday trying to solve this. Thanks for any help you can provide. ________________________________________________ Gwyan Rhabyt Director, Multimedia Graduate Program Professor, Art Department California State University East Bay and President of the Board of Trustees, Pacific Elementary School District On Thu, Jan 22, 2015 at 5:29 PM, Chris Cormack <chris@bigballofwax.co.nz> wrote:
On 23 January 2015 at 08:02, Gwyan Rhabyt <gwyan.rhabyt@csueastbay.edu> wrote:
Our small school district library server needed updating (it was running Ubuntu 11.10 which was having problems and was no longer supported). So I upgraded to Ubuntu 14.04LTS and decided to upgrade Koha at the same time (from 3.06 to 3.18). The OS upgrade went smoothly.
For the Koha upgrade, I did a mysqldump of the library database (I also backed up the complete user folder as a secondary fallback). I then upgraded Koha which went fine (there were a couple of fiddles on getting Apache2 happy, but they were documented in this group or on the wiki).
The problem has been that I can't seem to properly restore the library database. Before the restore,Koha runs but has no books or patrons. When I looked in the /var/lib/mysql/koha_paclibrary folder (paclibrary is our database), I saw about 150 files, nearly all .frm files with a size of 12 blocks each. I followed the instructions at
http://kohageek.pbworks.com/w/page/60452540/How%20to%20move%20your%20koha%20... and did the following: sudo su mysql -uroot -p
drop database koha_paclibrary; (response was Query OK, 178 rows affected) create database koha_paclibrary; (response was Query OK, 1 row affected) quit; mysql -uroot -p koha_paclibrary < jan11dump.sql (which took a few minutes, but returned to the prompt with no errors)
Now at this point I again looked in the folder /var/lib/mysql/koha_paclibrary and there is only one file (db.opt) with a size of 4 blocks. I thought at first that the dump was wrong or small, but I checked and jan11dump.sql is 81800 blocks and looks like it has all our info inside.
I tried running koha at this point on the web interface and it only gave me the installer, as though koha had not been installed at all.
Are you sure it wasn't trying to upgrade your DB, when you logged into the web installer, what did it say next?
And what message are you getting at the OPAC, the library is in maintenance mode?
Also, if you do
mysql -uroot -p koha_paclibrary
You will be in mysql
what does show tables; show you?
Try select * from items limit 10;
Do you get results?
Chris
Hi, that doesn't read good. Just a thought: did you check it's really the web installer and not the database update screen? The login page will look exactly the same, as it's prompting you to update the database structure to match the new version. Also, did you check your sql backup file in an editor? Is it big enough and is the data in there? Katrin Am 22.01.2015 um 20:02 schrieb Gwyan Rhabyt:
Our small school district library server needed updating (it was running Ubuntu 11.10 which was having problems and was no longer supported). So I upgraded to Ubuntu 14.04LTS and decided to upgrade Koha at the same time (from 3.06 to 3.18). The OS upgrade went smoothly.
For the Koha upgrade, I did a mysqldump of the library database (I also backed up the complete user folder as a secondary fallback). I then upgraded Koha which went fine (there were a couple of fiddles on getting Apache2 happy, but they were documented in this group or on the wiki).
The problem has been that I can't seem to properly restore the library database. Before the restore,Koha runs but has no books or patrons. When I looked in the /var/lib/mysql/koha_paclibrary folder (paclibrary is our database), I saw about 150 files, nearly all .frm files with a size of 12 blocks each. I followed the instructions at http://kohageek.pbworks.com/w/page/60452540/How%20to%20move%20your%20koha%20... and did the following: sudo su mysql -uroot -p
drop database koha_paclibrary; (response was Query OK, 178 rows affected) create database koha_paclibrary; (response was Query OK, 1 row affected) quit; mysql -uroot -p koha_paclibrary < jan11dump.sql (which took a few minutes, but returned to the prompt with no errors)
Now at this point I again looked in the folder /var/lib/mysql/koha_paclibrary and there is only one file (db.opt) with a size of 4 blocks. I thought at first that the dump was wrong or small, but I checked and jan11dump.sql is 81800 blocks and looks like it has all our info inside.
I tried running koha at this point on the web interface and it only gave me the installer, as though koha had not been installed at all.
I tried a variety of things and then decided to uninstall koha, mysql, and apache (with sudo apt-get --purge remove) The uninstall seemed clean. And I reinstalled koha and everything happened as before. No errors except the dump won't restore properly.
Can anyone give me pointers as to where to go from here? Is there a log of the mysql restore that would give me details? I looked but couldn't find one.
At the moment, our library is at a standstill. Help!
________________________________________________ Gwyan Rhabyt
Director, Multimedia Graduate Program Professor, Art Department California State University East Bay and President of the Board of Trustees, Pacific Elementary School District _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Chris Cormack -
Gwyan Rhabyt -
Katrin Fischer