phpMyAdmin Backup Settings

[gjh42]

Thank you so much, DrByte, for putting all this info in one concise package!

[Wils]

As acomment if you have problems with:

MySQL said:

1007: Can't create database 'databaseName'. Database exists

This may because some hosts does not allow DROP for sequrity reasons. I have to comment out:

DROP DATABASE `dbbame`;
CREATE DATABASE `dbname`;

and only leave

USE dbname;

in the header. I also normally drop the tables manually before import. This is the only way I got it to work on some hosts, there may be other and better ways...

[kobra]

Thanks for all the experiences... I as well as many rely upon menu driven interfaces to manipulate their DB's. So when presented with a more terse interface become lost.

This is not an easy subject to address as there are many different types of interfaces, even when named simiarily one can be presented with a different set of choices or choices missing from what they have been accustomed to or have seen elsewhere.

While this forum is not for the specific purpose of making individuals MySQL experts, it is a necessary function for those that are maintaining, upgrading or moving their ZenCarts.

Thanks to Dr. Byte for the normally suggested phpMyadmin settings for accomplishing this. I am sure that it will assist many and hope that through searching tht this thread will be included.