Delete ISP DB after upgrade from 2.25 to 2.26

Discussion in 'Installation/Configuration' started by Ben, Aug 10, 2006.

  1. Ben

    Ben ISPConfig Developer ISPConfig Developer

    Hi,

    the following messages were quite strange
    and in the end my db was flushed... just fyi, maybe that's already known, I will investigate later on after restoring backup and doing my daily work ;)

    EDIT: K one hint for people having the same problem, the backup existing_db....sql in /tmp or ../ of the folder you installed, does not contain any DB Structure. That means if all of your tables in the ispconfig DB are gone, you have to add the strctury first and then truncate all tables... best thing is you still know the url of your phpMyAdmin otherwise truncating all tables will be a lot of typing ;)
    For the import then do just
    mysql -D db_ispconfig -u root -p
    the password is prompted afterwards.
     
    Last edited: Aug 10, 2006
  2. Ben

    Ben ISPConfig Developer ISPConfig Developer

    Ok the problem was that there were tow line wrogn in my my.cnf regarding the mysql block. So lines calling mysql did what ever in the world....

    So maybe (despite my stupudness misconfiguring the mysql cli stuff ;) ) we should check in the install routine if mysql works fine before doing anything to the DB?
    Sth like call "mysql -V" and if the Output is not like "mysql Ver" there could be an error. Maybe prompt the text to the user suggesting an error and ask him to continue or not?
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes, thats a good idea and maybe a check if the database backup really worked before we proceed with the installation.
     
  4. Ben

    Ben ISPConfig Developer ISPConfig Developer

    Well how can we verify that? Just check if then content is there?

    The Backup worked fine, what luck.

    what we could do in the backup is to store the strcutre. mysqldump as far as I know can store that with the if not table exists stuff, so there won't be a problem if the structure still exists...

    I will start fixing a bit, including some more error handling.
     
    Last edited: Aug 10, 2006

Share This Page