恢复旧的MySQL备份 [英] Restoring an old MySQL backup

问题描述

我有一个2007年以来的大文件，其中包含MySQL数据库的备份(作为SQL脚本).用于未知版本的MediaWiki.

I have a large file from 2007 containing a backup (as a SQL Script) of a MySQL Database. It's for an unknown version of MediaWiki.

-- phpMyAdmin SQL Dump
-- version 2.6.2-Debian-3sarge3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Aug 29, 2007 at 12:42 PM
-- Server version: 4.0.24
-- PHP Version: 4.3.10-19

我曾尝试安装 mysql-5.5.8-win32 和 mysql-workbench-gpl-5.2.31a-win32 ，但遇到语法错误.有没有一种使旧脚本兼容的简便方法，还是我最好使用旧版本的MySQL?较旧版本的开发工具仍然可用吗?

I've tried installing mysql-5.5.8-win32 and mysql-workbench-gpl-5.2.31a-win32 but am getting syntax errors. Is there an easy way of making the old script compatible, or am I better of using an older version of MySQL? Are the dev tools still available for the older versions?

我正在寻找最快，最简单的选项，因为我只想还原它以保存一些旧的原始数据，而不是完全设置它.

I am looking for the quickest simplest option as I only want to restore it to get hold of some old raw data, not to set it up fully.

推荐答案

实际显示错误是值得的.

It would be worth to actually showing the error.

但是无论如何，如果语法确实存在问题，SET sql_mode = MYSQL40可能会为您提供帮助.以前可能不是关键字的东西现在可能有问题，在这种情况下，您必须将其转义.

But anyway, SET sql_mode = MYSQL40 might help you if the syntax is really a problem. There might be issue with something what was not keyword before and now is, you would have to escape it in this case.

这篇关于恢复旧的MySQL备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！