Thread: Database transfer

I am trying to transfer my database to another server but the sql and phpadmin versions are different.

current: myphpadmin 2.9.0.2
sql 4.1.10
my new: myphpadmin 2.7.0-pl2
sql 4.0.16

I get an error when I try to import the old DB up to the new DB.
here is the error message below.

*****************error message***********************
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 20, 2007 at 11:34 PM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
-- Database: `*******_*******`
--
-- --------------------------------------------------------
--
-- Table structure for table `Admins`
--
CREATE TABLE `Admins` (

`Name` varchar( 10 ) NOT NULL default '',
`Password` varchar( 10 ) NOT NULL default '',
PRIMARY KEY ( `Name` )
) 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 5

*****************end error message***********************

How can I get this done.

try taking out all the ' ' and tehen see if that works..

Try to delete

PHP Code:

DEFAULT CHARSET = latin1 


from

Originally Posted by ifeallday1

CREATE TABLE `Admins` (

`Name` varchar( 10 ) NOT NULL default '',
`Password` varchar( 10 ) NOT NULL default '',
PRIMARY KEY ( `Name` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;