Hey, the phpmyadmin that comes with 3.2a has character set: ISO 8859-1 West European (latin1) collation: latin1_swedish_ci but I want to export my sql and put it on a server that I don't know what it has, but when I try to import the sql file onto the other server, it gives me this error: Error
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.6.3-rc1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 11, 2005 at 06:52 PM
-- Server version: 4.1.12
-- PHP Version: 5.0.4
--
-- Database: `site`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin`
--
CREATE TABLE `admin` (
`username` varchar( 255 ) default NULL ,
`email` varchar( 255 ) default NULL ,
`password` varchar( 255 ) default NULL ,
`vcode` varchar( 255 ) default NULL
) ENGINE = MYISAM DEFAULT CHARSET = latin1
MySQL said:
#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=latin1' at line 24