Author Topic: Cannot Import 4images database... Help!  (Read 3710 times)

0 Members and 1 Guest are viewing this topic.

Offline janick

  • Newbie
  • *
  • Posts: 31
    • View Profile
Cannot Import 4images database... Help!
« 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]

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
Re: Cannot Import 4images database... Help!
« Reply #1 on: December 14, 2006, 12:24:04 PM »
Did you tried to remove the part

Code: [Select]
DEFAULT CHARSET = latin1
from your dump?
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search