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

importing database with routines erratic

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Cannot Reproduce
    • 5.5.30
    • None
    • None
    • None
    • W7 Pro 64-bit w MariaDB 5.5.30 64-bit.

    Description

      Importing a database to MariaDB which contains database, w triggers and procedures yields error. This works fine between mysql 5.5.27 and 5.5.30, and it does not matter whether the dump is created on either mysql version. The error given is: "ERROR 1548 (HY000) at line 819: Cannot load from mysql.proc. The table is probably corrupted". Import command "prompt> mysql --user=root --password=MyPassword < weatherdata_dump.sql". Similar error if using mysqlworkbench. The database origins as "latin1". Testing stored procedure "call dailystats(2700);" (parameter is number of ago, 2005-10-04 - 2005-12-31). There seems to be no problems with the two tables, INSERTS et c work!. mysqldump batch is included - HOWEVER the minimized dump is 20MB - instructions required!

      Attachments

        Activity

          People

            elenst Elena Stepanova
            bagtjesen Ingemar Skarpås (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.