将备份的 SQL Anywhere 10 .db 文件导入 MySQL 5.1
我有一周前数据库的备份。我需要将其导入 MySQL，而无需访问原始数据库服务器。尽管我的老板知道我远不是一个数据库管理员；我该怎么做？
I have a backup of a database from a week ago. I need to import this into MySQL without access to the original database server. Despite my boss's knowledge that I am nowhere near a database administrator; how do I do this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
没有人会提供答案，因为（a）这是非法的，（b）它违反网站规则。
如果您拥有对数据库服务器的合法访问权限：
这意味着第一个选择是获取 ASA 许可证，而不是使用 MySQL。只需一个命令即可将 .DB 文件加载到其中
，
合法访问意味着对建筑物的访问以及许可证的访问，该许可证将允许您通过使用的任何客户端访问服务器和数据。
评论回复
烦恼是职业生活的一部分。如果数据库组很可能已经决定不允许您拥有某些东西；这是公司的安全策略，您或您的老板必须在软件之外处理这些问题。
为什么 ASA 团队不能直接授予您访问 ASA 数据库的权限？然后你就可以连接并做任何你想做的事；查看数据库；更好地理解它；随时获取当前数据，无需复制。制作数据库的副本是一件愚蠢的事情（公司有两个需要支持、维护、管理和同步的数据副本）。不应轻视此决定
如果您最终坚持使用 MySQL：
链接Sybase ASA 用户指南/第 21 章导入和导出数据
.
No one will provide an answer because (a) it is illegal, and (b) it is against the website rules.
If you have legal access to the database server:
which means the first option is to get a licence for ASA, rather than using MySQL. It takes one single command to load the .DB file into it
legal access means both access to the building and to a licence which will allow you to access the server and the data via whatever client you use.
Responses to Comments
Annoyances are part of life in the profession. If the db group may well have decided that you are not permitted to have something; that is company security policy that you or your boss have to deal with outside the software.
Why can't the ASA Team just give you access to the ASA database ? Then you can connect and do whatever you want; have a look at database; understand it better; get current data at any time, without making a copy. Making a copy of a database is a stupid thing to do (the corporation then has two copies of data that it needs to be supported, maintained, administered and synchronised). The dicsion should not be taken lightly
If you stick with MySQL at your end:
Then you need them to export the database in a format that you can import. I do not see why you have to tell them which command[s] to use, they should know their commands well. Also there are different ways of getting the same result. If they need help, give them this link. You should also read and understand this chapter:
Link to Sybase ASA Users Guide/Ch 21 Importing and Exporting Data
.
您不需要数据库的 MySQL 副本。 SQL Anywhere 提供了一个开发人员版本，您可以免费使用。它仅在开发过程中合法 - 而不是生产 - 但听起来这会满足您的需求。
您可以在此处找到该文件的下载： http://www.sybase.com/detail?id= 1016644
You don't need a copy of MySQL for the database. SQL Anywhere provides a developer version which you can use free of charge. It's only legal in development - not production - but it sounds like this would suit your needs.
You can find a download of that here: http://www.sybase.com/detail?id=1016644