#3689 #1231 - Variable 'character_set_client' can't be set to the

3.5.1
open
nobody
Normal
2015-03-31
2012-10-03
Manicko
No

I'm trying to export database from local machine with phpmyadmin ver 3.5.1 and import on remote server working with phpmyadmin ver 3.3.9 (the same, after updating to 3.5.1).

The import goes in two steps as there is time limitation for processing scripts on the server (so it breaks in the middle and need to be resumed from this point).

In the end of the import I'm getting the error

SQL query:

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

MySQL said:

#1231 - Variable 'character_set_client' can't be set to the value of 'NULL'

Problem disappear after return to 3.3.9 version. Could only suppose that there is a problem with export in newer version of phpmyadmin.

Discussion

  • Marc Delisle

    Marc Delisle - 2015-02-15
    • Priority: 5 --> Normal
     
  • Madhura Jayaratne

    • assigned_to: Madhura Jayaratne
     
  • Madhura Jayaratne

    • assigned_to: Madhura Jayaratne --> nobody
     
  • Madhura Jayaratne

    The bug is present in version 4.4 as well.
    I did not find a clean way to fix this.

     

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

Sign up for the SourceForge newsletter:





No, thanks