Can't restore backup
  • Hello,

    I'm trying to move a newscoop site from one server to another new on a different hosting provider.
    Old provider gave me this backup backup-newscoop-2013-08-25-01-36-36.tar.gz (it supposed to contain all html, files and sql database).
    The new server is: CentOS 6.4 + cPanel 11.x + PHP 5.3.27 and MySQL 5.1.70. The newscoop version installed is the same as the old server

    I'm running the restore script manually from the linux shell with root access, and this is what I got:

    --------------------------
    --------------------------

    ./newscoop-restore -b ../backup/backup-newscoop-2013-08-25-01-36-36.tar.gz -e

    Newscoop Restore Utility
    ------------------------
    * Initializing...
    * Temp directory: backup-newscoop-2013-08-25-01-36-36
    * Initialization done.
    * Extracting files into temp directory...done.
    * Backup database name is 'originaldb'.
    * Destination database name (to be replaced) is 'newdbname'.

    All files in the following directories will be deleted.
    (The backup files will be copied to these locations)
    /home/username/public_html/templates
    /home/username/public_html/images
    /home/username/public_html/files
    /home/username/public_html/templates_cache
    Are you sure you want to continue? (y/N) y
    * Removing files in /home/username/public_html/templates...done.
    * Removing files in /home/username/public_html/images...done.
    * Removing files in /home/username/public_html/files...done.
    * Removing files in /home/username/public_html/templates_cache...done.
    * Restoring templates...done.
    * Restoring images...

    done.
    * Restoring file attachments...done.
    * Upgrading templates...done.
    * Restoring the database username_db...
    Warning: mysql_list_dbs(): Unable to save MySQL query result in /home/username/public_html/bin/cli_script_lib.php on line 391

    Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/username/public_html/bin/cli_script_lib.php on line 392

    ERROR!
    Can't create database newdbname
    --------------------------

    Just in case, the new database have a new name, user and password different than the old one (that's why I use the -e option while restoring).

    Any clue about this error?

    Thanks
  • 2 Comments sorted by
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    try to restore the sql file from tarball manually
    other folders from tarball also can be copied manually

  • Thanks, got it fixed using a manual mysql dump.