Pandora FMS Community

How to Restore DB?

vdelburgo · 12 nov 2007, 18:33 · 6 mensajes · 84 visitas

  1. Inicio del debate

    Hello, I have a problem: I'm upgrading from 1.2 to 1.3 and when I go to step 4, appears the message: Schema manipulation (FAILS) Populating new schema and converting data (FAILS) Created new config file at 'include/config.php' (FAILS) There was some problems. Installation is not completed. Please correct failures, and restore original DB before trying again. ERROR: Duplicate entry '3' for key 1. My question is, how can I restore the DB? Thanks and regards, VICTOR

  2. Hello, I have a problem: I'm upgrading from 1.2 to 1.3 and when I go to step 4, appears the message: Schema manipulation (FAILS) Populating new schema and converting data (FAILS) Created new config file at 'include/config.php' (FAILS) There was some problems. Installation is not completed. Please correct failures, and restore original DB before trying again. ERROR: Duplicate entry '3' for key 1. My question is, how can I restore the DB? Thanks and regards, VICTOR

    I hope you had followed the upgrade documentation at : (Link not available anymore) So, all you need is there, and I only could wish good luck ;-)

  3. Yes, I had followed the upgrade documentation... I execute the upgrade.php, but fails here: Schema manipulation (FAILS) Populating new schema and converting data (FAILS) Created new config file at 'include/config.php' (FAILS) There was some problems. Installation is not completed. Please correct failures, and restore original DB before trying again. ERROR: Duplicate entry '3' for key 1. Now, I had restored the DB with 'mysql pandora < pandora_1.2_backup.sql' but I don't know how to pass the 'schema manipulation' step and I don't know how to repair the error of 'duplicate entry...' Can you help me? Thanks Thanks

  4. Yes, I had followed the upgrade documentation... I execute the upgrade.php, but fails here: Schema manipulation (FAILS) Populating new schema and converting data (FAILS) Created new config file at 'include/config.php' (FAILS) There was some problems. Installation is not completed. Please correct failures, and restore original DB before trying again. ERROR: Duplicate entry '3' for key 1. Now, I had restored the DB with 'mysql pandora < pandora_1.2_backup.sql' but I don't know how to pass the 'schema manipulation' step and I don't know how to repair the error of 'duplicate entry...' Can you help me? Thanks Thanks

    First at all, be sure that you have a recent MySQL dump of your database :-). If automatic upgrade fails, this is because any problem or inconsistency in your actual database. Dont worry, could be fixed. You will need to simulate the database upgrade step by step, to find the problem and fix it before making the automatic upgrade. Using a mysql console. In your pandora 1.3 console package, you will see a file called "pandoradbdata_12_to_13.sql", open it in a text processor. Open a mySQL console on another window, with: mysql -u xxxx -pyyyy pandora Where xxx is the user used to manage pandora database, and yyy it's password. Now just copy line by line from SQL code to Mysql console. You should find a line that fails. Then you will find the problem in your database. Now you've to follow several steps: a) Fix your database (you need to know some SQL to understand and fix the problem). Write the solution down in a paper or textfile. b) Rollback again your database with your data. c) Fix your database with solution finded in step (a). d) Execute upgrade tool. Now should work because database problem has been fixed. I hope this helps. If you cannot solve problem in step (a) because you don't understand the SQL problem, please post here and I'll try to help you.

  5. Thanks nil, now it works... another question: after the update, what have to do I? Have I to install any more? Thanks and regards, VICTOR

  6. Thanks nil, now it works... another question: after the update, what have to do I? Have I to install any more? Thanks and regards, VICTOR

    It's done ! :-)

Entra en tu cuenta para publicar.