Quote:
Originally Posted by ShocK
|
THANKS A LOT MAN,
I read and considered to have problem in my host,
So i changed host, the new host doesn't accept my contents of sql file in phpmyadmin and gives below error:
Error
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
--
http://www.phpmyadmin.net
--
-- --------------------------------------------------------
--
-- Table structure for table `articles`
--
CREATE TABLE `pqdb_articles` (
`article_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`article_title` varchar( 255 ) NOT NULL default '',
`article_text` mediumtext NOT NULL ,
`article_cat` mediumint( 9 ) NOT NULL default '0',
`article_meta_key` mediumtext NOT NULL ,
`article_meta_desc` mediumtext NOT NULL ,
PRIMARY KEY ( `article_id` )
) TYPE = MYISAM AUTO_INCREMENT =50972;
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 'TYPE=MyISAM AUTO_INCREMENT=50972' at line 19
PLS TRY TO SOLVE MY ERROR
CLEAN AND STEP BY STEP INSTRUCTIONS WILL BE APPERECIATED
THANKS IN ADVANCE