exporting DB via phpMyAdmin - settings

[fenton]

Hi there,

just wanted to ask if the predefined settings for exporting a PW database are recommended or if anything should be changed e.g.:

thanks a lot, cheers

[Wanze]

Looks good to me. I never changed any of the default settings for a simple sql export

Cheers

[fenton]

thanks!

[kongondo]

I never even go to the advanced settings...The simple export works fine for me..

[fenton]

I never even go to the advanced settings...The simple export works fine for me..

this is the regular interface for exporting in XAMPP (no option for simple settings)

[kongondo]

What I meant is I use the " Quick - display only the minimal options". I think you are using "Custom - display all possible options"? Below is the screen I see on XAMPP using the Quick Export...

[fenton]

hey kongondo,

guess I use another version of XAMPP (http://www.apachefriends.org) v.1.7.4, since I don't have that option and my interface looks different

love your avatar btw!

[kongondo]

I'm on XAMPP version 1.7.7.

Avatar: Thx...yeah...thx to Horst for the avatar

[OrganizedFellow]

Wouldn't it be simpler to export the database using some PHP script?

I've always thought that to be a better idea.

[kongondo]

Why reinvent the wheel? Of course you can do that. I just prefer using phpMyAdmin for this

[Wanze]

Wouldn't it be simpler to export the database using some PHP script?

I've always thought that to be a better idea.

Why simpler?

When transfering a site locally to the server, I'm always using phpmyadmin.

Export all data to a mysql file takes me one minute, importing is just as easy.

I think it doesn't matter how you export your stuff - more important is (if there's no other backup running) to do it at all

[OrganizedFellow]

Why simpler?

Using phpmyadmin:

1. mywebsite.com

2. go to mywebsite.com/phpmyadmin and select database and click export and click GO.

DONE!  

Using php script:

1. mywebsite.com/securebackup

DONE!  

NOTE: I've actually been using adminer (http://www.adminer.org/) instead of phpmyadmin. Super tiny script. Fast. Easy  

[ryan]

When exporting with PHPMyAdmin, I sometimes have to uncheck the "use extended inserts" in order to get it to import somewhere else. Apparently the maximum query length can vary from server to server, and avoiding extended inserts reduces or eliminates that problem (at the expense of a slightly larger SQL file).