SQL Buddy - can't import Database

  • Hello,


    I have a problem with SQL-Buddy.


    I exported my Database from my old Server with phpmyadmin.


    No I want to import the Database in OMV/SQL Buddy but it wont work! After choose the .sql file SQL Buddy says "Import..." but nothing happens.


    No idea what i can do to get SQL Buddy import my Database.
    Service is running, the Management-Site seems to work properly, I'm logged in as root.


    Anyone who can help me out?


    Thank you very much!


    grtz
    CmdA

    • Offizieller Beitrag

    I'll have to do some testing but until then, you can do:


    mysql -u root -p database_name < export.sql

    omv 7.0.5-1 sandworm | 64 bit | 6.8 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.13 | compose 7.1.4 | k8s 7.1.0-3 | cputemp 7.0.1 | mergerfs 7.0.4


    omv-extras.org plugins source code and issue tracker - github - changelogs


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

    • Offizieller Beitrag

    Did you have the database created when you tried to import?

    omv 7.0.5-1 sandworm | 64 bit | 6.8 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.13 | compose 7.1.4 | k8s 7.1.0-3 | cputemp 7.0.1 | mergerfs 7.0.4


    omv-extras.org plugins source code and issue tracker - github - changelogs


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

  • Yes, I tried both.
    Without any existing Database and I've created a DB and tried then to import, nearly same result.
    When there was a Database SQLBuddy imported the first table but leaves it empty and aborted then.

    • Offizieller Beitrag

    Setting up a new VM. I will try it.

    omv 7.0.5-1 sandworm | 64 bit | 6.8 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.13 | compose 7.1.4 | k8s 7.1.0-3 | cputemp 7.0.1 | mergerfs 7.0.4


    omv-extras.org plugins source code and issue tracker - github - changelogs


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!