phpMyAdmin exported database screwie
-
Maybe this is really a phpMyAdmin problem – or a problem with my soon to be former hosting service… but I figured I’d try here.
I’m moving hosts so today I exported my database using phpMyAdmin’s export tab. I followed the directions from here and all seemed fine.
I figured I might as well try to import it into my own local machine (PowerBook) through my own installation of phpMyAdmin to make sure it worked.
So I created a database and clicked on the SQL tab, selected the .sql file and clicked ‘go’ and got this result…
—-
ERROR 1064 at line 2: 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 ‘cat_IDint(4) NOT NULL auto_increment,
cat_name
varchar(55
dparmetDB3
----
I tried doing it directly through the command line and got the same message.
From my very limited knowledge of MySQL, it's telling me something is wrong near line 2. Here's what's at the top of the file if it means anything to anyone
----
-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 17, 2004 at 07:44 PM
-- Server version: 4.0.20
-- PHP Version: 4.3.10
--
-- Database:
wp_categories
--
-- --------------------------------------------------------
--
-- Table structure for table
wp_categories
--
CREATE TABLE(
cat_ID
int(4) NOT NULL auto_increment,
cat_name
varchar(55) NOT NULL default '',
category_nicename
varchar(200) NOT NULL default '',
category_description
text NOT NULL,
category_parent
int(4) NOT NULL default '0',
cat_ID
PRIMARY KEY (),
cat_name
UNIQUE KEY(
cat_name),
category_nicename
KEY(
category_nicename`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;
——
does this make sense to anyone?
thanks
david parmet
- The topic ‘phpMyAdmin exported database screwie’ is closed to new replies.