#4095 (ok 4.0.8) NUL symbols added to the end of database dump file

[kaalis]

Hello,
I'm trying to export database and import into localhost.
I select 1 table, no compression, save output to file.
The same problem with 4.0.7-rc1.
Works perfect in 3.5.8.2.

Importing to localhost fails with:
----BEGIN CUT----
eNo1zDsKwzAURNGAu7eKWYAQlj+BqBNG2IanTyQlhvQp0rjP7iMbMuVwuDalkDQmhakDW6+h0EEp
yqXeDZH75jtrjHKUfU+PnBCygJmtLwJPW9H22eHCa2U2lbUUndEYZCuvFJd4GBHyURikumFbvS/E
xs8a753OODWX/35USB8h
----END CUT----
----BEGIN RAW----

ERROR: C1 C2 LEN: 1 2 11
STR:

MySQL: 5.5.33
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 4.0.6
PHP VER,OS: 5.4.19 WINNT
LANG: en
SQL:

----END RAW----

In the end of dump are these symbols - check attachment. After editing them out, import is successfull.
What could cause this?

Nothing fancy with server. Simple Mac OS X 10.5.8 Server running php 5.2.15, apache 2.2.17, mysql 5.0.92.
No .htaccess files that affects PMA installation.

Please, advice.

Thank you.

[Marc Delisle]

Cannot reproduce this on my test server. Can you reproduce it on http://demo.phpmyadmin.net?

[kaalis]

No, I can't.
What can I do to track this problem down myself? Is there a debug level that would help?

[franck]

Hello,

I have the same problem on shared server,
Version Apache 2.2.25
Version PHP 5.3.27
Version MySQL 5.5.33-31.1
phpMyAdmin SQL Dump version 4.0.5

I'm on ubuntu 12.04

Regards,

Franck

[plejad]

Look at the end of sql
problem is last, empty line

[kaalis]

Yes, I can read.
Problem is why this last line is in the dump...

[kaalis]

Also, i noted that
3.5.8.2 dump file is utf-8 w/o bom
4.0.7 dump file is ansi.

[kaalis]

Finally I commented 956. line in export.php in root PMA folder. (ver.4.0.7)
//PMA_Response::getInstance()->disable();

And now dump is saving as it should. Don't know conseqences by doing this... but it works :)

4.0.7 Dump file now is utf-8 w/o bom

[Marc Delisle]

Val,
I accept your solution. May I commit the patch in your name? and if so, what is your complete name, and which email address should I use in the commit?

[kaalis]

If it's possible to use only Val as name and valmiera-9[at]inbox.lv as email
or leave it anonymous ;)

[Marc Delisle]

Done:
https://github.com/phpmyadmin/phpmyadmin/commit/b717657de77db0b58179bdbdd88e23d0fc3d7ea6