Okay, so I had changed my host recently. I backed up my old database and am now trying to install it on my new host. I seem to have a problem though. Before I was using MySQL 4.1, however, my new host has 4.0.24. When I go to install my old database on this one, it comes up with the error below. Is there anyway for me to export my old database in a 4.0 compatible format? If not, how can I fix this problem?

Thanks,
Collin

-- phpMyAdmin SQL Dump
-- version 2.6.2-Debian-3sarge1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 25, 2006 at 02:49 PM
-- Server version: 4.1.11
-- PHP Version: 4.3.10-16
--
-- Database: `colliny2k_neo`
--
-- --------------------------------------------------------
--
-- Table structure for table `access`
--
CREATE TABLE `access` (
`aid` tinyint( 10 ) NOT NULL AUTO_INCREMENT ,
`mask` varchar( 255 ) NOT NULL default '',
`type` varchar( 255 ) NOT NULL default '',
`status` tinyint( 2 ) NOT NULL default '0',
PRIMARY KEY ( `aid` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;

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 CHARSET=utf8 AUTO_INCREMENT=1' at line 7

Comments

bs’s picture

Hi,
In phpmyadmin there is an option exporting to other database versions. Make sure to select proper version while exporting your data.

Anonymous’s picture

Okay, I found it. It was called MYSQL40 under the SQL export compatibility drop down menu. I guess the 40 rather than 4.0 confused me when I was looking before. Thanks.

//What is this exporting option called? Where is it located?

/* I went to my database. I selected Export at the top right. There are a lot of options on the Export page and I really don't know what most of them do. I looked to see if I saw any called MySQL 4.0 or anything that might be right, but I couldn't find any. */

egm’s picture

Just wanted to say thank you for posting this question and then following up. Solved my problem in a trice.

monstordh’s picture

Rock On! This worked perfectly! Thanks for sharing!