Export Database from phpMyAdmin - Which Settings to Use

[phpguy98]

I'm not a db guy, but I just want to make sure I'm backingup up my mySql database correctly for php melody. Here's a screenshot below, using the default settings. Does this look correct? Should there be anything else checked or unchecked? Thanks!

[chatflash]

As you say, you are not a DB guy, i suggest to do this inside your phpmelody admin panel "System->Backup Database"

[Trace]

The default settings as shown on the screenshot are fine for backups

[phpguy98]

Ok. Thanks Trace!

[dtouch]

Can anyone post the exact settings anyways?

[dhunt]

Can anyone post the exact settings anyways?

I think you just did.

I am having difficulty in understanding your question, though.

Daryl

[dtouch]

I did export db via phpmyadmin without changing default settings.
I was asking if there is any settings to be altered for correct export of db via phpmyadmin like first post?

[dhunt]

I did export db via phpmyadmin without changing default settings.
I was asking if there is any settings to be altered for correct export of db via phpmyadmin like first post?

No, the default works fine. I did a phpmel sql backup, screwed the pooch on an update, took it back to 1.6.6 and used the sql I backed up to load things back the way they were. No harm done. And I will not load up 1.6.7. 1.6.6 seems to be a bit more stable. I will wait until 1.7 comes out and then do a test site. If it works fine then I move from 1.6.6 to 1.7.

So you did good

Daryl

[dtouch]

Ok thanks.. and my site is workin just fine after moving servers..