将备份的SQL Anywhere 10 .db文件导入MySQL 5.1 [英] Import backed-up SQL Anywhere 10 .db file into 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?

推荐答案

没有人会提供答案，因为（a）非法，并且（b）非法违反网站规则。

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:

• 这意味着第一个选择是获取ASA的许可证，而不是使用MySQL。只需一个命令即可将.DB文件加载到其中。

• 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

合法访问意味着可以同时访问建筑物和许可证，从而可以访问.DB文件。服务器和通过您使用的任何客户端的数据。

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.

回复评论

1. 烦恼是该行业生活的一部分。如果数据库组可能已经决定不允许您使用某些东西；这是您或您的老板必须在软件外部处理的公司安全策略。

1. 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.

为什么ASA团队不能仅仅让您访问ASA数据库？然后，您可以连接并做任何您想做的事情；看一下数据库；更好地了解它；随时获取当前数据，无需进行复制。制作数据库副本是一件愚蠢的事情（公司拥有两个数据副本，需要对其进行支持，维护，管理和同步）。切勿掉以轻心。

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

如果您坚持使用MySQL：

If you stick with MySQL at your end:

1. 然后，您需要它们以可以导入的格式导出数据库。我不明白为什么您必须告诉他们要使用哪个命令，他们应该很好地了解他们的命令。也有不同的方法来获得相同的结果。如果他们需要帮助，请给他们这个链接。您还应该阅读并理解本章内容：

1. 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:

链接到Sybase ASA用户指南/ Ch 21导入和导出数据

• 获取他们为您提供：
  
  
  
  • 数据进行建模，因此您可以在MySQL端创建自己的数据库，并了解要加载的表顺序
  
  
  • 以字符格式（通常为CSV）导出的每个表，这样您就可以将每个表加载到表中
  
  
  • 它们使用了什么命令，以便您知道期望什么以及如何处理它们发送给您的导出文件。
    
    。
  
  
  • Get them to provide you with:
    • the Data Model, so you can create your own db on the MySQL side, and understand the table sequence to load
    • each of their tables exported in a character format (usually CSV), so that you can load each into your tables
    • what command they used, so that you know what to expect and how to treat the export files they send you.
      .

    这篇关于将备份的SQL Anywhere 10 .db文件导入MySQL 5.1的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！