Tweak Export output to get exactly same result as with phpMyAdmin

[expired user #8743]'s profile image [expired user #8743] posted 9 years ago in Import/Export Permalink
Hi, I'm new user trying to find a simple tool to make easier to backup WordPress databases.

First I was trying to use Toad for MySQL. Although it is very powerful program it didn't have good way to back up whole DB the way phpMyAdmin does.

HeidiSQL creates backup very similar to phpMyAdmin with some small differences, so I hope there could be a way to get exact results.

One is these setting that are added to the backup file by phpMyAdmin:

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


Dump TIMESTAMP columns in UTC (enables TIMESTAMP columns to be dumped and reloaded between servers in different time zones)

Also I'm not sure if HeidiSQL is using these settings:

Enclose table and column names with backquotes (Protects column and table names formed with special characters or keywords)

CREATE TABLE options: AUTO_INCREMENT

Dump binary columns in hexadecimal notation (for example, "abc" becomes 0x616263)

These are default settings that most webhosting companies are using:

https://cloudup.com/cvSUDZX-yxi

Here you can see comparison of one exported table:

https://cloudup.com/c7L54ZV1NVt

Thank you!
ansgar's profile image ansgar posted 9 years ago Permalink
HeidiSQL does not aim to be a clone or something of pma. Instead, HeidiSQL intentionally leaves away various options which easily confuse newbies.
[expired user #8743]'s profile image [expired user #8743] posted 9 years ago Permalink
Hi, thank you for the answer. I'm not saying that HeidiSQL should be a clone, but that it would be nice to have ability fine-tune the output, so to be sure that backup will actually be useful.

As an example to mind comes the audio encoding tool RazorLame that has simple setting, but also has field for special keys that can be entered.

Please login to leave a reply, or register at first.