MySQL MYSQL数据库离线使用
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6474814/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
MYSQL Database offline use
提问by shingi
Is there a way to use a MYSQL database without the database management system.. Like use tables offline without installing the db management system on the machine.. If there is can you please point me in the right direction? Thank you!
有没有办法在没有数据库管理系统的情况下使用MYSQL数据库..就像在机器上不安装数据库管理系统的情况下离线使用表一样..如果有的话你能指出我正确的方向吗？谢谢！
采纳答案by bassneck
As far as I know, there is no way to do this.
据我所知，没有办法做到这一点。
However, there is a portable DBMS SQLIte. It comes in different ways and can be used on other platform with different programming languages.
但是，有一个可移植的 DBMS SQLIte。它以不同的方式出现，可以在具有不同编程语言的其他平台上使用。
After reading your comment, I'm almost sure, this is what you need. It's not that fast as MySQL I guess, but it works.
阅读您的评论后，我几乎可以肯定，这就是您所需要的。我猜它没有 MySQL 那么快，但它有效。
回答by user1202136
You can use The embedded MySQL Server Libraryto access MySQL data files without running the MySQL server.
您可以使用嵌入式 MySQL 服务器库访问 MySQL 数据文件，而无需运行 MySQL 服务器。
回答by bob-the-destroyer
If you've actually opened the table files in a hex or text editor, you'll see that you will definitely need the mysql application installed to make any sense of them to use them. Sure the records are all there in plain text (.myd files for myisam, the ibdata1 file for innodb tables), but it would be a complete time-waster devising a custom app to parse or update the file structure, as well as trying to tie in table structure contained in the related files for each table.
如果您实际上已经在十六进制或文本编辑器中打开了表文件，您将看到您肯定需要安装 mysql 应用程序才能理解它们以使用它们。确保所有记录都以纯文本形式存在（myisam 的 .myd 文件，innodb 表的 ibdata1 文件），但是设计自定义应用程序来解析或更新文件结构以及尝试配合每个表的相关文件中包含的表结构。
回答by LainIwakura
You can setup a database to work on your localhost. This will be offline unless you setup the front-end stuff to let the internet interact with it.
您可以设置一个数据库以在您的本地主机上工作。这将是离线的，除非你设置前端的东西让互联网与之交互。
What exactly do you mean "without the database management system"? You always need a way of interacting with it, even if it is offline. (Otherwise how can it work for you?)
“没有数据库管理系统”究竟是什么意思？您始终需要一种与它交互的方式，即使它处于离线状态。（否则怎么可能对你有用？）
回答by stefgosselin
The server side piece of the application, mysql-server, is needed at a minumum to run mysql. This server application comes with all the tools built-into manage the instance. I doubt you can prevent installation of this.
至少需要应用程序的服务器端部分 mysql-server 来运行 mysql。此服务器应用程序附带了所有用于管理实例的内置工具。我怀疑你能阻止安装这个。
