Skip to content

Instantly share code, notes, and snippets.

@incredimike

incredimike/config.inc.php

Last active November 15, 2019 22:41
Show Gist options
  • Save incredimike/5292867 to your computer and use it in GitHub Desktop.
Save incredimike/5292867 to your computer and use it in GitHub Desktop.
Download ZIP
PHPMyAdmin - Export Zipped & Drop Tables / Databases by default
Raw
config.inc.php
<?php # Add the following to config.inc.php
$cfg['Export']['sql_drop_database'] = true;
$cfg['Export']['sql_drop_table'] = true;
$cfg['Export']['compression'] = 'zip';
@ish1301
Copy link

ish1301 commented Jul 26, 2013

+1 for line #4

@mnapoli
Copy link

mnapoli commented Nov 12, 2013

Nice, thanks for the tip. I've made a custom version: https://gist.github.com/mnapoli/7428000

Also, I write this config to /etc/phpmyadmin/conf.d/export.inc.php rather than editing config.inc.php, it's less error-prone.

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