New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

on 4.7.1, exporting of a whole database to SQL doesn't output the sql, outputs the html. #13403

Closed
barrycox opened this Issue Jun 22, 2017 · 5 comments

Comments

Projects
None yet
3 participants
@barrycox

barrycox commented Jun 22, 2017

Steps to reproduce

  1. pick a database (not table, a whole database) to export
  2. click 'export'
  3. click ok to export.

Expected behaviour

Tell us what should happen
should create a file called databasename.sql

Actual behaviour

Tell us what happens instead
created a file called just sql (no db name) and file has html in it, not sql/mysqldump format.

exporting individual tables or rows works, creating the correct file, only exporting an entire db does this. tried chrome and firefox with same result.

note that exporting json and xml do work on the export, but on the import (of xml... can't import json), i get that the xml file is not the proper format even when i don't modify it.

Server configuration

Database server:
Server: REMOVED...amazonaws.com via TCP/IP
Server type: MySQL
Server version: 5.6.34-log - MySQL Community Server (GPL)
Protocol version: 10
User: REMOVED
Server charset: UTF-8 Unicode (utf8)
Web server

Apache/2.4.6 (CentOS) PHP/5.6.30
Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503
PHP extension: mysqli curl mbstring
PHP version: 5.6.30
phpMyAdmin

Version information: 4.7.1 (up to date)

Client configuration

Browser:
tried chrome and firefox (latest)

Operating system:
windows 10

@ghost

This comment has been minimized.

Show comment
Hide comment
@ghost

ghost Jun 26, 2017

what is the content of the file named sql?

ghost commented Jun 26, 2017

what is the content of the file named sql?

@barrycox

This comment has been minimized.

Show comment
Hide comment
@barrycox

barrycox Jun 26, 2017

barrycox commented Jun 26, 2017

@ibennetch

This comment has been minimized.

Show comment
Hide comment
@ibennetch

ibennetch Jun 28, 2017

Member
Member

ibennetch commented Jun 28, 2017

@nijel

This comment has been minimized.

Show comment
Hide comment
@nijel

nijel Jul 17, 2017

Member

Is there any error in the generated HTML or in the server logs?

Member

nijel commented Jul 17, 2017

Is there any error in the generated HTML or in the server logs?

@nijel nijel self-assigned this Jul 17, 2017

@nijel nijel added the question label Jul 17, 2017

@nijel

This comment has been minimized.

Show comment
Hide comment
@nijel

nijel Aug 29, 2017

Member

This might have been fixed in 4.7.4 by 76f51a1, see #13600, but verification is welcome...

Member

nijel commented Aug 29, 2017

This might have been fixed in 4.7.4 by 76f51a1, see #13600, but verification is welcome...

@nijel nijel closed this Oct 3, 2017

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment