Most reliable way to backup a database?

What's the most reliable way of backing up a large MySQL database?

I'm considering phpMyAdmin. Under Export, what settings should I use?

Specifically -

Data:
Complete inserts
Extended inserts
Use delayed inserts
Use ignore inserts
Use hexadecimal for binary fields
Export type

Thanks

 

 

 

 

Top