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
use export option
Hi,
In phpmyadmin there is an option exporting to other database versions. Make sure to select proper version while exporting your data.
What is this exporting
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. */
Thank you
Just wanted to say thank you for posting this question and then following up. Solved my problem in a trice.
Rock On!
Rock On! This worked perfectly! Thanks for sharing!