Database backup question (phpMyAdmin)
jason342 - September 19, 2007 - 15:35
I'm not too familiar with database backups and their technical know how.
I have a question about the Structure. I backup with 'Structure’ and everything under it 'ticked'. Add Drop table, Add if Not Exists, Add Auto Increment value, Enclose table and field names...
Is this good for backing up?
Drupal 5.2
Anyone?
Anyone?
I always had 'Add
I always had 'Add AUTO_INCREMENT value' and 'Enclose table and field names with backquotes' selected and never had any problems.
You don't need 'Add CREATE PROCEDURE / FUNCTION' because Drupal does not use procedures. Select it if you have extended the database with some procedures used by some third party module.
'Add DROP TABLE / DROP VIEW' and 'Add IF NOT EXISTS' are good if you want to either restore a database which already has some tables in it which will be deleted or you want to restore a database which has some tables you want to keep.
--
Alexandru Badiu
Web: http://www.voidberg.org
YM: voidberg / Skype: alex.badiu