I made a database in the localhost and uploaded images and everything
But when I tried to import the database to my site using the (phpmyadmin) errors comes
Error
#########
#########
SQL-query:
-- phpMyAdmin SQL Dump
-- version 2.6.1-rc2
--
http://www.phpmyadmin.net--
-- Host: localhost
-- Generation Time: Mar 15, 2005 at 11:41 AM
-- Server version: 4.1.8
-- PHP Version: 4.3.10
--
-- Database: `test`
--
-- --------------------------------------------------------
--
-- Table structure for table `4images_categories`
--
CREATE TABLE `4images_categories` (
`cat_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`cat_name` varchar( 255 ) NOT NULL default '',
`cat_description` text NOT NULL ,
`cat_parent_id` int( 10 ) unsigned NOT NULL default '0',
`cat_hits` int( 10 ) unsigned NOT NULL default '0',
`cat_order` int( 10 ) unsigned NOT NULL default '0',
`auth_viewcat` tinyint( 2 ) NOT NULL default '0',
`auth_viewimage` tinyint( 2 ) NOT NULL default '0',
`auth_download` tinyint( 2 ) NOT NULL default '0',
`auth_upload` tinyint( 2 ) NOT NULL default '0',
`auth_directupload` tinyint( 2 ) NOT NULL default '0',
`auth_vote` tinyint( 2 ) NOT NULL default '0',
`auth_sendpostcard` tinyint( 2 ) NOT NULL default '0',
`auth_readcomment` tinyint( 2 ) NOT NULL default '0',
`auth_postcomment` tinyint( 2 ) NOT NULL default '0',
`cat_image` mediumint( 8 ) NOT NULL default '0',
PRIMARY KEY ( `cat_id` ) ,
KEY `cat_parent_id` ( `cat_parent_id` ) ,
KEY `cat_order` ( `cat_order` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2
############
=====
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 AUTO_INCREMENT=2' at line 39