i have a mysql database in 4.1.16 i need to downgrade it to work in 4.0.
in phpmyadmin, i use SQL export compatibility: mysql40 but i get an error when i run it on the server with 4.0 on it. does anyone know how i can fix it? how do i downgrade a database in 4.1 to run on 4.0?
the error is:
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4
-- Host: localhost
-- Generation Time: Jan 17, 2007 at 10:57 PM
-- Server version: 4.1.16
-- PHP Version: 4.4.3
-- Database: `wssw`
CREATE DATABASE `wssw` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci
MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line