Package: phpmyadmin
Version: 4:4.6.2-2
Severity: important
Dear Maintainer,
*** Reporter, please consider answering these questions, where appropriate ***
* What led up to the situation
* What exactly did you do (or not do) that was effective (or
ineffective)?
* What was the outcome of this action?
* What outcome did you expect instead?
*** End of the template - remove these template lines ***
I selected a database with foreign key constraints and then navigated to
the Export tab in phpmyadmin. On export, none of the foreign key
constraints or indices (I use a few fulltext indexes) were be included,
which is something I expected.
Even after trying different options in the export dialog I could not get
phpmyadmin to export foreign key constraints. Instead it only exported
the structure of each table and view along with inserts for the data.
-- System Information:
Debian Release: stretch/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 4.6.0-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages phpmyadmin depends on:
ii dbconfig-common 2.0.4
ii dbconfig-no-thanks 2.0.4
ii debconf [debconf-2.0] 1.5.59
ii libjs-sphinxdoc 1.3.6-2
ii perl5.22.2-1
ii php-gettext 1.0.11-3
ii php-mbstring1:7.0+41
ii php-mysql 1:7.0+41
ii php-phpseclib 2.0.2-1
ii php7.0 [php]7.0.7-4
ii php7.0-cli [php-cli]7.0.7-4
ii php7.0-json [php-json] 7.0.7-4
ii php7.0-mbstring [php-mbstring] 7.0.7-4
ii php7.0-xml [php-xml]7.0.7-4
ii ucf 3.0036
Versions of packages phpmyadmin recommends:
ii apache2 [httpd] 2.4.20-2
pn php-bz2
pn php-gd
ii php-tcpdf6.2.12+dfsg2-1
pn php-zip
Versions of packages phpmyadmin suggests:
ii chromium [www-browser] 51.0.2704.79-1
ii epiphany-browser [www-browser] 3.20.2-2
ii firefox-esr [www-browser] 45.2.0esr-1
ii mariadb-server-10.0 [virtual-mysql-server] 10.0.25-1
ii w3m [www-browser] 0.5.3-28
-- debconf information:
phpmyadmin/db/app-user: phpmyadmin
phpmyadmin/purge: false
phpmyadmin/database-type: mysql
phpmyadmin/upgrade-error: abort
phpmyadmin/remote/host:
phpmyadmin/db/dbname: phpmyadmin
phpmyadmin/remote/newhost:
* phpmyadmin/dbconfig-install: true
phpmyadmin/remote/port:
phpmyadmin/install-error: abort
phpmyadmin/dbconfig-reinstall: false
phpmyadmin/internal/reconfiguring: false
phpmyadmin/internal/skip-preseed: true
phpmyadmin/missing-db-package-error: abort
phpmyadmin/mysql/admin-user: root
phpmyadmin/passwords-do-not-match:
phpmyadmin/dbconfig-upgrade: true
phpmyadmin/remove-error: abort
phpmyadmin/setup-username: admin
phpmyadmin/dbconfig-remove:
phpmyadmin/mysql/method: Unix socket
phpmyadmin/upgrade-backup: true
* phpmyadmin/reconfigure-webserver: apache2