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

Getting MySQL has gone away when importing a .sql file

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Not a Bug
        • Affects Version/s: 10.0.11
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None
        • Environment:
          Windows Server 2008 R2

          Description

          I keep getting this error and I can't get a .sql file to be imported.

          I'm using Heidi SQL to do this.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Try to increase max_allowed_packet value both on the server side and on the client side.

                Show
                elenst Elena Stepanova added a comment - Try to increase max_allowed_packet value both on the server side and on the client side.
                Hide
                Permalink
                jfha73 Jorge F. Hernandez added a comment - - edited

                I did, I changed my.ini in the data folder to 2048M but it still says:

                +--------------------+------------------+
| Variable_name          | Value      |
+--------------------+------------------+
| max_allowed_packet | 1048576 |
+--------------------+------------------+
                Show
                jfha73 Jorge F. Hernandez added a comment - - edited I did, I changed my.ini in the data folder to 2048M but it still says: +--------------------+------------------+ | Variable_name | Value | +--------------------+------------------+ | max_allowed_packet | 1048576 | +--------------------+------------------+
                Hide
                Permalink
                jfha73 Jorge F. Hernandez added a comment - - edited

                Weird because I have another server configured exactly the same and the other one says:

                +--------------------+------------+
| Variable_name      | Value      |
+--------------------+------------+
| max_allowed_packet | 1073741824 |
+--------------------+------------+
                Show
                jfha73 Jorge F. Hernandez added a comment - - edited Weird because I have another server configured exactly the same and the other one says: +--------------------+------------+ | Variable_name | Value | +--------------------+------------+ | max_allowed_packet | 1073741824 | +--------------------+------------+
                Hide
                Permalink
                jfha73 Jorge F. Hernandez added a comment -

                I just uninstalled it, re-installed it, added max_allowed_packet line again and it worked.

                I wonder why it didn't work the first time.

                Show
                jfha73 Jorge F. Hernandez added a comment - I just uninstalled it, re-installed it, added max_allowed_packet line again and it worked. I wonder why it didn't work the first time.
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Maybe there was another ini file or another section in the ini file that overrode your settings.
                Anyway, I assume it's not an issue for the time being. If you have the problem again, please feel free to comment to re-open the report.

                Show
                elenst Elena Stepanova added a comment - Maybe there was another ini file or another section in the ini file that overrode your settings. Anyway, I assume it's not an issue for the time being. If you have the problem again, please feel free to comment to re-open the report.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    jfha73 Jorge F. Hernandez
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: