Apache Friends Support Forum

After being unable to recover my DB recently, I see the need to do a backup. In PhpMyAdmin, I see an Export button. I opened it up and did an export to a .sql file. However it did not save it in the right place. By default, it saved it in my "users/downloads" directory. I would think it should be saved in the "xampp/mysql/backup" folder. Is that correct? Now, my question is, how do I save it to a folder of my choice?

Also, is Export the same as a backup? I want to make sure I don't loose any data in the future.

Thanks for any help.

Ted

wingted wrote:In PhpMyAdmin, I see an Export button. I opened it up and did an export to a .sql file. However it did not save it in the right place. By default, it saved it in my "users/downloads" directory.

That's the correct behavior of the phpmyadmin export functionality.

wingted wrote:is Export the same as a backup? I want to make sure I don't loose any data in the future.

An export is a type of backup. It depends on the settings in the export mask what and how much the backup contains.

Hello,

To chime in about the download location, that is determined by your web browser settings, not phpmyadmin or any other XAMPP component.

More to read about MySQL Backup in the official MySQL Manual:
http://dev.mysql.com/doc/refman/5.5/en/ ... thods.html