Restore the database of NGL

[Saren (Cambodia)]

I have installed newly NGL version 3.0 and at that time I have installed postgresql version 8.3.
Now I want to restore my previous backup database (NewGenLib27-10-2012.backup).
By instructed on this link (http://www.slideshare.net/Ashoksatapathy/backup-and-restore-ngl-database), I already drop schema on newgenlib and I got this error message (WARNING: errors ignored on restore: 1889).

Please guided me how to restore it.
With my best regard,
- Saren

[Verus Open Source Support]

Respected Saren,
1. Can you tell us whether the backup you have is Compressed or Plain?
2. The link you have sent holds good for compressed backup
3. Please check the number of Tables. To know whether data migration is complete, the last table must have foreign keys present

Alternatively, we will be very happy to help you to do this process. Please send us your details to support<attherate>verussolutions.biz

Regards
Siddartha

On 12/19/2012 09:08 AM, saren [via NewGenLib] wrote:

I have installed newly NGL version 3.0 and at that time I have installed postgresql version 8.3.
Now I want to restore my previous backup database (NewGenLib27-10-2012.backup).
By instructed on this link (http://www.slideshare.net/Ashoksatapathy/backup-and-restore-ngl-database), I already drop schema on newgenlib and I got this error message (WARNING: errors ignored on restore: 1889).

Please guided me how to restore it.
With my best regard,
- Saren

---

If you reply to this email, your message will be added to the discussion below:

http://forums.newgenlib.org/Restore-the-database-of-NGL-tp7573375.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML

[Saren (Cambodia)]

It is nether compress nor plain. It has extension .backup.
I'm sure that it has the way to restore kind of .backup file, but I don't know how to do it.
The guy from NGL used to help me on this.
Please click on the link bellow to download my backup file
NewGenLib27-10-2012.backup

With my best regard,
- Saren

[Verus Open Source Support]

1. Open PgAdmin3. Go to Databases->newgenlib->Tables
2. Scroll down to the last table. union_catalogue_satellite_list. Select this table. You will get its details on the right hand side.
3. Compare it with the screen shot I am attaching.

If there are the same, then your restoration process is successful


On 12/19/2012 12:49 PM, saren [via NewGenLib] wrote:

It is nether compress nor plain. It has extension .backup.
I'm sure that it has the way to restore kind of .backup file, but I don't know how to do it.
The guy from NGL used to help me on this.
Please click on the link bellow to download my backup file
NewGenLib27-10-2012.backup

With my best regard,
- Saren

---

If you reply to this email, your message will be added to the discussion below:

http://forums.newgenlib.org/Restore-the-database-of-NGL-tp7573375p7573377.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML

[Saren (Cambodia)]

Thank for your assist,
That is great that I have successfully restore all backup data.
But I have one more problem, I got the error when I go to http://localhost:8080/newgenlibctxt.
Please see the screen shot bellow.Error_NGL.png

[Verus Open Source Support]

Hi,
Your database must be upgraded. Since you have restored the database after installation, your database schema is still old. Please follow the below steps.
Step 1: Copy the below 3 files into C: drive
1. C:/InstallNGL3.0/scripts/AddedScripts.sql
2. C:/InstallNGL3.0/upgrade303/V304AddedScripts.sql
3. C:/InstallNGL3.0/upgrade303/SearchForm.sql


Step 2: Open your Command Prompt (Start->Run->Type command cmd-> Press Enter)
1. Type the following commands one after one
C:
cd \
cd "Program Files"
cd Postgresql
cd 8.3
cd bin
psql -d newgenlib -U postgres

The last command will prompt you to enter password. Enter newgenlib as password. This will connect you to newgenlib database using psql tool. Now type the following commands

\i C:/AddedScripts.sql
\i C:/V304AddedScripts.sql
\i C:/SearchForm.sql

Now Refresh your OPAC. I also hope you have run Indexer

Regards
NewGenLib Open Source Support Team

On 12/20/2012 07:46 AM, saren [via NewGenLib] wrote:

Thank for your assist,
That is great that I have successfully restore all backup data.
But I have one more problem, I got the error when I go to http://localhost:8080/newgenlibctxt.
Please see the screen shot bellow.Error_NGL.png

---

If you reply to this email, your message will be added to the discussion below:

http://forums.newgenlib.org/Restore-the-database-of-NGL-tp7573375p7573379.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML

[Saren (Cambodia)]

It is work.
But I got one more problem, I'm not able to log in into the Library Back End.
Before when I go to http://localhost:8080/newgenlibctxt/LaunchApplication, the user name is 1 and password is abc but now it doesn't work.
Do we have the way to change this username and password?

Best Regard,
- Saren

[Verus Open Source Support]

1. Please download the attached sql file.
2. Open PgAdmin3.
3. Select newgenlib database in PgAdmin3
4. Click on SQL button. This will open SQL Editor
5. Click on Open file button and select the file downloaded in Step 1
6. Click on Green Triangle in SQL Editor or press F5

Now try to Login into application

On 12/20/2012 02:28 PM, saren [via NewGenLib] wrote:

It is work.
But I got one more problem, I'm not able to log in into the Library Back End.
Before when I go to http://localhost:8080/newgenlibctxt/LaunchApplication, the user name is 1 and password is abc but now it doesn't work.
Do we have the way to change this username and password?

Best Regard,
- Saren

---

If you reply to this email, your message will be added to the discussion below:

http://forums.newgenlib.org/Restore-the-database-of-NGL-tp7573375p7573381.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML