4images Forum & Community
4images Issues / Ausgaben => Installation, Update & Configuration => Topic started by: janick on December 05, 2006, 03:19:30 PM
-
Cannot Import 4images database... Help!
I have backup my database in old server,
i have buy new server, but I can´t import it? way?
any body help me??
I Like to have my old image and members to my new server..
[qcode]
Error
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
-- http://www.phpmyadmin.net
--
-- Vært: 127.0.0.1
-- Genereringstid: 25/11 2006 kl. 20:59:34
-- Serverversion: 4.1.11
-- PHP version: 5.0.4
--
-- Database: `web97959`
--
-- --------------------------------------------------------
--
-- Struktur-dump for tabellen `4images_ban`
--
CREATE TABLE `4images_ban` (
`id` mediumint( 12 ) NOT NULL AUTO_INCREMENT ,
`type` tinyint( 1 ) NOT NULL default '0',
`active` tinyint( 1 ) NOT NULL default '0',
`ip1_start` tinyint( 3 ) unsigned NOT NULL default '0',
`ip1_end` tinyint( 3 ) unsigned NOT NULL default '0',
`ip2_start` tinyint( 3 ) unsigned NOT NULL default '0',
`ip2_end` tinyint( 3 ) unsigned NOT NULL default '0',
`ip3_start` tinyint( 3 ) unsigned NOT NULL default '0',
`ip3_end` tinyint( 3 ) unsigned NOT NULL default '0',
`ip4_start` tinyint( 3 ) unsigned NOT NULL default '0',
`ip4_end` tinyint( 3 ) unsigned NOT NULL default '0',
`user_id` mediumint( 10 ) NOT NULL default '0',
`name` varchar( 255 ) NOT NULL default '',
`hostname` tinytext NOT NULL ,
`email` tinytext NOT NULL ,
`date` int( 11 ) NOT NULL default '0',
`expire` int( 11 ) NOT NULL default '0',
`message` text NOT NULL ,
`reason` text NOT NULL ,
PRIMARY KEY ( `id` ) ,
KEY `active` ( `active` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =22;
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=latin1 AUTO_INCREMENT=22' at line 23[/qcode]
-
Did you tried to remove the part
DEFAULT CHARSET = latin1
from your dump?