Is phpMyAdmin okay for Backup?

Re: Is phpMyAdmin okay for Backup?

by J m -
Number of replies: 0

I was able to restore only when I use in myPhpAdmin:

select all tables

SQL

checked add DROP TABLE

(data checked) Complete Inserts

- everything else was default

add auto_increment

enclose table

use hexadecimal for binary fields

export type INSERT

When I had just If Exists, I got an error.  One time with a duplicate key on dummy server, probably from test entries, and once with Table 'adodb_logsql' already exists.  So I just used drop in my export.