使用 phpMyAdmin 备份 MySQL
我在 PHP 编写的应用程序中使用了 MySQL。一段时间后，它的数据会很大，我需要对它们进行备份。另外，我需要可以在需要时恢复备份数据。我的问题是phpMyAdmin是否可以安全、完全地进行备份和恢复而不会丢失任何数据？
（我的数据库结构中有 MyISAM 和 innoDB）
另外，如果您知道任何其他 IDE 可以进行备份和恢复而不向最终用户显示数据库结构和表，请告诉我它们的名称。
谢谢。
I have used MySQL for my application written by PHP. After a time its data will be great and I need to make a backup from them. Also, I need I can restore the backup data whenever I need. My question is if phpMyAdmin can make backup and resotore it secure and completely without any data lose?
(I have both MyISAM and innoDB in my database structore)
Also, if you know any other IDE to make backup and restore it without showing the database structures and tables to the end-user, please tell me their names.
Thank you.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
如果您在自己的服务器上运行 MySQL，则可以复制数据库文件夹，但必须首先停止 MySQL 服务器。无论如何，我建议通过 phpMyAdmin（导出功能）或通过命令行（
mysqldump）转储数据库。使用后者，您可以编写一个批处理脚本，该脚本还可以压缩和加密转储文件的内容。If you're running MySQL on your own server you may copy the database folder, but the MySQL server would have to be stopped first. Anyway I'd recommend dumping the databases through phpMyAdmin (export function) or via the command line (
mysqldump). Using the latter, you may write a batch script that also compresses and encrypts the content of the dump file.使用内置的导入和导出？唯一的数据丢失是备份之后直到导入备份期间的所有数据。
安全吗？这是一个完全不同的话题。有太多事情需要考虑才能称为安全，但如果您使用 https 或在受信任的 LAN 上，那么是的，我想它是安全的。
我认为 MySQL Workbench 可以进行导出和导入。
Using the built in Import and Export? The only data loss would be everything after the backup until the time the backup was imported.
Securely? That's an entirely different topic. There's too many things to consider to call anything secure but if you're using https or on a trusted LAN, then yes, I guess it's secure.
I think MySQL Workbench can do exports and imports.
如果您希望更安全、定期备份 MySQL 数据库而不丢失数据到远程服务器或本地驱动器（本地硬盘或映射驱动器），那么您可以尝试 Vembu StoreGrid http://www.vembu.com/，一款受到全球 2700 多家服务提供商信赖的领先备份软件。通过选择整个数据库配置单个备份后，将在下次备份时自动备份新添加的数据库。此外，StoreGrid 仅备份下一个增量计划中更改的增量字节。
Vembu 为几乎所有人提供了解决方案，只需在下面查看：
对于服务提供商：StoreGrid 服务提供商版本
对于商业/办公室：StoreGrid 专业版
对于家庭用户：Vembu Home
对于不想拥有自己存储空间的经销商：Vembu Pro
对于托管提供商：StoreGrid 托管提供商版（尚未发布）
根据您的要求，我们建议使用专业版 http://storegrid.vembu.com/online-backup/network-backup.php。试试吧！
问候，
蒂利潘
vembu.com
If would you wish to backup MySQL database more securely and periodically without loss of data to remote server or local drive (local hard disk or mapped drive), then you can try Vembu StoreGrid http://www.vembu.com/, a leading backup software trusted by more than 2700 service providers world wide. Once you configured single backup by selecting entire database then automatically newly added database will be backedup on upon next backup time. Also, StoreGrid backups only the incremental bytes of changes on next incremental schedule.
Vembu has a solution for almost everyone, just check them below:
For Service Providers : StoreGrid Service Provider Edition
For Business/Offices : StoreGrid Professional Edition
For Home Users: Vembu Home
For Resellers who don't want to have their own storage : Vembu Pro
For Hosting Providers: StoreGrid Hosting Provider Edition (yet to be released)
For your requirement, we would suggest the Professional Edition http://storegrid.vembu.com/online-backup/network-backup.php of StoreGrid. Try it!!!
Regards,
Thileepan
vembu.com