Backup fails

tvasilopo
2016-10-21
2016-10-21
  • tvasilopo

    tvasilopo - 2016-10-21

    Hi to all,

    I am trying to get a backup from the database using the command

    mysqldump -u gestioip -p gestioip > backup_gestioip.sql

    but it fails with the following traceback;

    Sorry, command-not-found has crashed! Please file a bug report at:
    https://bugs.launchpad.net/command-not-found/+filebug
    Please include the following information with the report:

    command-not-found version: 0.3
    Python version: 3.4.3 final 0
    Distributor ID: Ubuntu
    Description: Ubuntu 14.04.4 LTS
    Release: 14.04
    Codename: trusty
    Exception information:

    'utf-8' codec can't encode character '\udcc2' in position 9: surrogates not allowed
    Traceback (most recent call last):
    File "/usr/lib/python3/dist-packages/CommandNotFound/util.py", line 24, in crash_guard
    callback()
    File "/usr/lib/command-not-found", line 90, in main
    if not cnf.advise(args[0], options.ignore_installed) and not options.no_failure_msg:
    File "/usr/lib/python3/dist-packages/CommandNotFound/CommandNotFound.py", line 265, in advise
    packages = self.getPackages(command)
    File "/usr/lib/python3/dist-packages/CommandNotFound/CommandNotFound.py", line 157, in getPackages
    result.update([(pkg, db.component) for pkg in db.lookup(command)])
    File "/usr/lib/python3/dist-packages/CommandNotFound/CommandNotFound.py", line 85, in lookup
    result = self.db.lookup(command)
    File "/usr/lib/python3/dist-packages/CommandNotFound/CommandNotFound.py", line 41, in lookup
    key = key.encode('utf-8')
    UnicodeEncodeError: 'utf-8' codec can't encode character '\udcc2' in position 9: surrogates not allowed

    any ideas?

    Thanks

     
  • Marc Uebel

    Marc Uebel - 2016-10-21

    Hi
    check if mysqldump is installed on your system.
    This problem is not in realation with gestioip.
    Search the internet for the message "Sorry, command-not-found has crashed"
    Thanks,
    Marc

     
  • tvasilopo

    tvasilopo - 2016-10-21

    Hi Marc,

    mysqldump is installed in my system, but I think I found the problem.

    I used my sudo passwd for mysql connection that I created during installation.

    I know, the traceback seems irrelevant to that, but I did not make any other change to my system.

    Thanks a lot for your quick response

     
  • tvasilopo

    tvasilopo - 2016-10-21

    Marc I have another question,

    When I recover the backup file I create with the command that is shown inside manual, does this mean that with a new session towards gestioip database in apache server I will have the backup version depicted (from a first try it did not seem to work for me)?

    In other words, If I backup my networks, then delete them through GUI and execute the recover, will I have the networks in GUI again?

    Thanks

     
  • Marc Uebel

    Marc Uebel - 2016-10-21

    With the command mysqldump you make a backup of the actual state of all objects in the DB. When you recover this file, you will recover all entries which where in the DB in the moment you made the backup.
    Thanks,
    Marc

     
  • tvasilopo

    tvasilopo - 2016-10-21

    Thanks Marc for everything, backup and restore works fine!

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks