如何将osCommerce数据库从v2.2升级到v2.3 [英] How do i upgrade osCommerce Database from v2.2 to v2.3
问题描述
在Oscommerce文件夹中，有一个名为upgrade-230.pdf的upgrade_guide.
Inside the Oscommerce folder there is an upgrade_guide called upgrade-230.pdf.
有话说
如果要升级到完整的v2.3版本，请仅执行(SQL)数据库更改，并将数据库与新的v2.3安装一起使用.
If you wish to upgrade to a full v2.3 version, perform only (SQL) Database Changes and use the database with a new v2.3 installation.
但是我该如何进行数据库更改以在新的v2.3中使用它?
But how do I make those Database Changes to use it with a new v2.3?
我认为我必须手动比较数据库架构并修改旧站点的备份.sql文件(添加/更改字段，添加表等，以匹配架构并修复相应的INSERT语句以进行匹配).然后，您可以简单地用恢复的旧数据库替换新安装的数据库.
I think I have to manually compare database schemas and modify the old site's backup .sql file (adding/changing fields, adding tables, etc., to match the schema and fixing the corresponding INSERT statements to match). Then you can simply replace the new installation's database with the restored old one.
在该文件中，只有一些SQL命令可以创建动作记录器:
In the file there are only some SQL-commands to create the action recorder:
CREATE TABLE action_recorder ( ...
在旧数据库备份中我还需要更改什么?
What else do I have to change in the old database backup?
推荐答案
数据库几乎相同，只有一些细微的差异可以用这些语句纠正，我在这里收集了所需的更改:
The databases are pretty much the same, only some small differences that you can correct with these statements, I collected the needed changes here:
或者您可以尝试社区插件 SQL从2.2MS升级到2.3.3 .
取决于您的旧版本，您可能需要或可能不需要全部.另外，在运行任何数据库之前，请确保对数据库进行备份
Depending on your old version you may or may not need all of it. Also, be sure to make a backup of your database before running any of this
这篇关于如何将osCommerce数据库从v2.2升级到v2.3的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
