Resetting the database

Discussion in 'Installation/Configuration' started by keV, Aug 20, 2008.

  1. keV

    keV New Member

    when I ran my install everything compiled and installed correctly except the mysql database was not loaded. I figured out how to load it manually and now it all works fine. These commands should wipe the database and reset it to default for anyone who wishes to do so without doing a complete reinstall of ISPConfig.

    mysqldump -u[USERNAME] -p[PASSWORD] --add-drop-table --no-data [DATABASE] | grep ^DROP | mysql -u[USERNAME] -p[PASSWORD] [DATABASE]
    tar -O -x install_ispconfig/db_ispconfig.sql -f ISPConfig-2.2.24.tar.gz | mysql -u[USERNAME] -p[PASSWORD] [DATABASE]
    First command wipes it, second command reloads the default from the tar.gz file.
    Note: the second command must be run from the same directory as the tar.gz file, works with ISPConfig-2.2.24.tar.gz, should work with other versions by modifying the command to point to the versions sourcefile.
  2. falko

    falko Super Moderator ISPConfig Developer

    This does not work because it will leave the isp_server table empty. :eek: This table is filled by the installer.

Share This Page