Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-31914

11.0.2 exporting of varchar/text fields fails from SQLYog

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 11.0.2
    • N/A
    • None
    • None
    • Windows 2019

    Description

      I use SQLyog in conjuction with MariaDB for Windows/IIS work. I've been using 10.9 for nearly a year just fine. I posted another seemingly unrelated issue for the same environment just now.

      SQLYog Community has a tool to copy database elements (tables, triggers, etc) to other databases/hosts. I use it regularly in development. Naturally, I assume it's letting MariaDB render the SQL

      However, when I try to copy from a server using MariaDB 11.0.2, I get an invalid syntax error, because none of the text-values (varchar, text in my case) are quoted. The same issue arises when I try to dump the database to sql. But I can do this fine from 10.9.

      I was able to use HeidiSQL from the same machine to backup my database, which i needed to do before I uninstalled and reinstalled the server to try to address the issue her and the issue in MDEV-31913 (fields have uneditable dropdown textareas)

      Attachments

        Activity

          People

            Unassigned Unassigned
            abblications Abigail Hicks
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.