By pstein on

Assume I want to backup my Drupal DB with the well known phpMyAdmin tool.

Here I can check whether I want to export the SQL statements WITH prepended
DROP TABLE/VIEW/PROCEDURE/...
statements or now.

Usually (for other databases) I enable this option in order to ensure to get a clean database.

Whats the recommendation for Drupal DB ?

If I later re-import the previously saved DB should I overwrite all the existing stuff?

Peter

Comments

pwaterz’s picture

pwaterz commented

Just you export db, and then use import db in phpmyadmin. One thing I recconmend doing before exporting is clearing your cache. No need to bring all that serialized data. If you have trouble importing using phpmyadmin, I suggest using the command line to import it, it's not that hard. If you have error on import, which sometimes you can get a corrupt cache table. You can add -f to you import on the command line.

PJW

pstein’s picture

pstein commented

>Just you export db,...

This was NOT the question!
The question was should I export it WITH prepended ''DROP TABLE'' statements or WITHOUT?

pwaterz’s picture

pwaterz commented

Google it!!!!!!!!!

PJW