By jason342 on

I just noticed phpMyadmin had a makeover with a more new robust interface.

I read somewhere that it's good to backup 'checking' all the following under 'structure' (so that's what i've been doing):

-Add DROP TABLE (check)
-Add IF NOT EXISTS (check)
-Add AUTO_INCREMENT value (check)
-Enclose table and field names with backquotes (check)

Since the makeover I notice a new option:

-Add CREATE PROCEDURE / FUNCTION (When backing up, do I check this too?)

Thanks

⋅ Categories: Drupal 5.x

Comments

pbarnett’s picture

pbarnett commented

As far as I know, you'd only need this if you have stored procedures in your database; Drupal doesn't, so you shouldn't need to check this...

Pete.

jason342’s picture

jason342 commented

So what about the other 4, at the top.

Are they perfectly ok to check?

pbarnett’s picture

pbarnett commented

Well, I don't bother with the auto-increment myself; but yes, they are perfectly OK to check.

Make sure that 'Use hexadecimal for binary fields' is set in the data section too.

Pete.

jason342’s picture

jason342 commented

Thanks Pete.

What is Add AUTO_INCREMENT value? Is this not important to check?

There really should be an article to explain what Drupal needs in terms of backing up and which boxes to check. There's none.

Ryan Palmer’s picture

Ryan Palmer commented

You could always make one.

Step 1: Experiment
Step 2: Document

pbarnett’s picture

pbarnett commented

Drupal doesn't use autoincrement AFAIK; it has its own sequence tables for that.

I generally make sure I check the 'Drop Table' and 'If Not Exists' boxes to ensure that the whole thing gets rewritten, and the 'Save as file' and 'gzipped' options, plus an strftime template for the filename (My test site is on a Windows box; I can't just type 'ls -rt' :-)

Pete.

jason342’s picture

jason342 commented

Hey Pete

Make sure that 'Use hexadecimal for binary fields' is set in the data section too.

Hey Pete I can't see that anywhere. All I see in the section you talking about is "Use hexadecimal for BLOB"

Is that what you mean?

pbarnett’s picture

pbarnett commented

Yeah, I guess that's it :-)

I'm using 2.10.1 for Windows, so some labels may be slightly different.

Pete.