MySQL Administrator备份:“兼容模式"，这到底在做什么? [英] MySQL Administrator Backups: "Compatibility Mode", What Exactly is this doing?
问题描述
在Mysql Administrator中，进行备份时，兼容模式"到底是什么?
我正在尝试将 webmin 生成的备份与 mysql管理员.我的数据已经有一些不一致的地方(我认为是滴答，逗号等)，我只是想尝试一下(反正它们将来可能会再次出现).当我尝试从备份中还原时，这些问题会产生错误.
现在，如果我从webmin生成备份，然后使用MySQL管理员还原它们，则备份将失败.但是，如果我使用MySQL Administrator生成备份并勾选兼容模式"，则转到MySQL管理员(另一个实例)并还原...就可以了！
根据MySQL，兼容模式"为；
兼容模式创建与旧版本的MySQL Administrator兼容的备份文件.
另一方面，
Webmin为我提供了以下兼容性选项:
- ANSI
- MySQL 3.2.3
- MySQL 4.0
- PostgreSQL
- Oracle
- Microsoft SQL
- DB2
- MaxDB
您说哪个最合适?我的数据集非常大，因此一个接一个地进行实验将花费相当长的时间(特别是在这种情况下，思维可能会胜过蛮力行为).
似乎正在执行ANSI，但我不是100％.
兼容模式-一种可帮助您创建与不同版本的MYSQL或其他数据库兼容的导出的模式.
您会看到，某些版本的MySQL具有在不同版本中使用的不同命令.因此，兼容模式允许您执行的操作是获取一个数据库并导出SQL以与另一版本的MySQL兼容.因此，您可能需要将MySQL 3服务器升级到4-此兼容模式允许导出数据库或单个表以创建可以导入MySQL 4版本服务器的SQL文件(也应在5中工作).
我也使用webmin，并运行MySQL5.我对MySQL 4使用兼容模式....我避免使用其他任何一种，因为我没有运行其他数据库.
就MySQL 3.x和4.x之间的MySQL命令而言，我认为CURRENT_TIMESTAMP从MySQL 3转换为4的方式有所变化，而且MySQL 3不支持字符集，根据此论坛的帖子，网址为: http://www.phpbuilder.com/board/showthread.php?t=10330692
In Mysql Administrator, when doing backups, what exactly is "Compatibility Mode"?
I'm trying to bridge backups generated by webmin with the upload tool available inside mysql administrator. My data already has a couple of inconsistencies (ticks, commas, etc, I think) I just wont try to kink out (they might just reappear in the future anyways). These kinks generate errors when I try to restore out of my backups.
Now, if I generate backups from webmin, and then use MySQL administrator to restore them, they fail. But if I generate the backups using MySQL Administrator AND tick "Compatibility Mode", then head over to MySQL administrator (another instance) and restore... it works!
According to MySQL, "Compatibility Mode" is;
Compatibility mode creates backup files that are compatible with older versions of MySQL Administrator.
Webmin, on the other hand, gives me the following options for compatibility:
- ANSI
- MySQL 3.2.3
- MySQL 4.0
- PostgreSQL
- Oracle
- Microsoft SQL
- DB2
- MaxDB
Which would you say is a best fit? My data set is very large, so it would take quite some time to experiment one by one (specially whence thinking might beat brute-forcing it).
Edit: seems like it's doing ANSI, but i'm not 100% on it.
Compatibility mode - the mode that helps you create exports compabible with different versions of MYSQL or other databases.
You see, some versions of MySQL had different commands that were used in various versions. So what compatibility mode allows you to do is take a database and export the SQL to be compatible with another version of MySQL. Thus, you may want to upgrade your MySQL 3 server to 4 - this compatibility mode allows for the export your database or individual tables to create a SQL file that can import into a MySQL 4 version server (should work in 5 also).
I use webmin, also, and run MySQL 5. I use compatibility mode for MySQL 4.... I steer clear of any of the other ones, because I'm not running those other databases.
As far as the MySQL commands that were different between MySQL 3.x and 4.x, I believe there were changes in regards to how CURRENT_TIMESTAMP is translated from MySQL 3 to 4, and also MySQL 3 doesn't support charsets, according to this forum post here: http://www.phpbuilder.com/board/showthread.php?t=10330692
这篇关于MySQL Administrator备份:“兼容模式"，这到底在做什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
