I would like to Backup the whole database (tables, views, routines) using PHPMyAdmin, but I''ve got only tables. I already selected some options such as:
- Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT
- Add CREATE PROCEDURE / FUNCTION / EVENT
Please anyone tell me how to backup the whole database using PHPMyAdmin?
I use:
- Apache/2.2.17 (Ubuntu)
- MySQL: 5.1.54
- PHPMyAdmin: 3.3.10deb1
Thanks!
解决方案First of all open the phpMyAdmin.
Click Export in the Menu to get to backup your MySql database.
Make sure that you have selected to export your entire database, and not just one table.
Select"SQL"-> for output format, Check "Structure" and "Add AUTO_INCREMENT" value. Check "Enclose table and field name with backquotes". Check "DATA", check use "hexadecimal for binary field". Export type set to "INSERT".
Check "Save as file", do not change the file name, use compression if you want. Then click "GO".