How to export MySql database

Problems with the Windows version of XAMPP, questions, comments, and anything related.

How to export MySql database

Postby wingted » 23. May 2013 15:48

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
 
Posts: 16
Joined: 26. March 2009 20:30

Re: How to export MySql database

Postby Altrea » 23. May 2013 16:01

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.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6545
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64

Re: How to export MySql database

Postby hackattack142 » 24. May 2013 00:17

Hello,

To chime in about the download location, that is determined by your web browser settings, not phpmyadmin or any other XAMPP component.
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 702
Joined: 20. May 2011 23:29
XAMPP Version: 5.6.3
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: How to export MySql database

Postby Altrea » 24. May 2013 04:02

More to read about MySQL Backup in the official MySQL Manual:
http://dev.mysql.com/doc/refman/5.5/en/ ... thods.html
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6545
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 50 guests