customer data loss after update

Discussion in 'General' started by blocker, Mar 31, 2010.

  1. blocker

    blocker Member

    Hello,

    i have a problem after updating ispconfig2 to the newest version, all of the customer data is loss, i checked and there is a backup in the /tmp folder, whats the best way to proceed in this case, restore the ispc database or extract the customer data from the backup and import it in the f*cked up database?

    thanks in advance
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Have you edited the ispconfig database scheme or added a field or table in the ispconfig database?

    To restore it, use the backup file in /tmp to import the data into the ispconfig database again, e.g. with phpmyadmin or the mysql command on the shell.
     
  3. blocker

    blocker Member

    Hello,

    the client has reported to have added mobile phone field in the customer table... ill try now to import from the backup via phpmyadmin
     
  4. blocker

    blocker Member

    does not work it stops on the custom field kunde_mobile stating that there is no such field...
     
  5. createch

    createch New Member

    Try the following...
    1. add the custom field back to the table concerned.
    2. re-do the data import.

    Wish you good luck.
     
  6. blocker

    blocker Member

    success!

    i have created the missing field and imported the data only for the isp_kunde table... i hope this will be enough

    thanks for the help
     

Share This Page