Bzip2 export cannot be directly imported

[pma-import]

When importing sql files from a phpMyAdmin export, bzip2 doesn't import all the data. Uncompressed, zip and gzip seem to work, but bzip2 only imports 188 rows from 1408. Comparing the file from the bzip2 with the uncompressed shows an identical file, so I'm guessing something has gone wrong on the import.

There was a problem on 4.1.2 with imports as well (no queries were run when importing bzip2) but this seems to be working better (although not perfectly) under 4.1.3

PHP: 5.5.7
MySQL: 5.6.15
CentOS 6.5

---

• Original URL: https://sourceforge.net/p/phpmyadmin/bugs/4221/
• Original author: noodlesnz
• Found in version: 4.1.3

[pma-import]

Issue exists in 4.1.4 also.

---

• Original author: noodlesnz

[pma-import]

I made some tests under two differents PHP versions and I get the same result: at some point during the import, the feof() command returns true, meaning that we have reached end of file, but we haven't reached it yet.

---

• Original author: lem9

[pma-import]

• assigned_to: Marc Delisle

---

• Original author: lem9

[pma-import]

• assigned_to: Marc Delisle --> nobody

---

• Original author: lem9

[pma-import]

• assigned_to: Marc Delisle

---

• Original author: lem9

[pma-import]

For export files reaching a certain size (I tested with the sakila sample database, film table), there is an incompatibility between the bzip2 file produced by phpMyAdmin, and the bzread() function used to uncompress it at import time.

I found a workaround: decompress and recompress the file; for example:
bunzip2 film.sql.bz2
bzip2 film.sql
Then phpMyadmin has no problem to import. Nick, please confirm with your own file.

---

• Original author: lem9

[pma-import]

Also, with this in my configuration file:

$cfg['CompressOnFly'] = false;

I don't have the problem.

---

• Original author: lem9

[pma-import]

I can confirm that decompressing the file and recompressing it with bzip2 allows me to import it completely. So the problem must be the bzip2 export. I haven't had a chance to try the CompressOnFly setting yet.

---

• Original author: noodlesnz

[pma-import]

• summary: Import doesn't process bzip2 completely --> Bzip2 export cannot be directly imported

---

• Original author: lem9

[pma-import]

Bzip2 export feature was withdrawn, see 144e00e.

---

• Original author: lem9

[pma-import]

• summary: Bzip2 export cannot be directly imported --> (ok 4.1.5) Bzip2 export cannot be directly imported
• status: open --> resolved
• Priority: 5 --> 1

---

• Original author: lem9

[pma-import]

• Status: resolved --> fixed

---

• Original author: lem9