I need help transferring a SQL database. I currently have my website database on a SQL 4.0.27 (vdeck) and want to transfer it to a new server (VPS) which has SQL 4.1.2

I have imported the database to my desktop computer. It will not let me import to the new server. I have to edit/reconfigurate.

Any suggestions, comments, advice, help would be greatly appreciated.

Ed

ed.sistrunk@sistrunk.net

you will have to specify more about what you are having trouble with. there should be no difficulty importing into the new database.

how are you attempting to do it? with the mysql client? phpmyadmin? something else?

are you getting error messages?

guelphdad,

I am using phpmyadmin. I have IPOWER as a host. My current server and database is 4.0.27. I am trying to move the database to a VPS which is using plesk and has MYSQL 4.1.2. The first error I got was:

Error
SQL query:
--
-- Dumping data for table `wp_linkcategories`
--
INSERT INTO `wp_linkcategories`
VALUES (
'1', '', 'N', 'Y', 'N', 'Y', 'Y', 'rand', N, 0x3c6c693e, 0x3c6272202f3e, 0x3c2f6c693e, '-1'
);
MySQL said:
#1054 - Unknown column 'N' in 'field list'


I tried again and got this error:
Error
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 16, 2007 at 12:52 PM
-- Server version: 4.0.27
-- PHP Version: 4.4.1
--
-- Database: `sistrunk_wordpress`
--
-- --------------------------------------------------------
--
-- Table structure for table `wp_categories`
--
CREATE TABLE `wp_categories` (
`cat_ID` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
`cat_name` varchar( 55 ) NOT NULL default '',
`category_nicename` varchar( 200 ) NOT NULL default '',
`category_description` longtext NOT NULL ,
`category_parent` bigint( 20 ) NOT NULL default '0',
`category_count` bigint( 20 ) NOT NULL default '0',
PRIMARY KEY ( `cat_ID` ) ,
KEY `category_nicename` ( `category_nicename` )
) TYPE = MYISAM AUTO_INCREMENT =22;
MySQL said:

I contacted my host provider and they stated that I would have to edit the database before it will install in the new 4.1.2 version.

do you see the N that is unquoted? that is the problem. That may be what they are talking about needing to edit.

This is what the link category says:

--
-- Dumping data for table `wp_linkcategories`
--

INSERT INTO `wp_linkcategories` VALUES ('1', '', 'N', 'Y', 'N', 'Y', 'Y', 'rand', N, 0x3c6c693e, 0x3c6272202f3e, 0x3c2f6c693e, '-1');
INSERT INTO `wp_linkcategories` VALUES ('2', 0x576869746520486f757365203038, 'N', 'N', 'N', 'N', 'N', 'name', N, 0x3c6c693e, 0x3c6272202f3e, 0x3c2f6c693e, '-1');
INSERT INTO `wp_linkcategories` VALUES ('3', 0x52657075626c6963616e204f7267616e697a6174696f6e73 , 'N', 'N', 'N', 'N', 'N', 'name', N, 0x3c6c693e, 0x3c6272202f3e, 0x3c2f6c693e, '-1');
INSERT INTO `wp_linkcategories` VALUES ('4', 0x436f6e73657276617469766520426c6f6773, 'N', 'N', 'N', 'N', 'N', 'name', N, 0x3c6c693e, 0x3c6272202f3e, 0x3c2f6c693e, '-1');
INSERT INTO `wp_linkcategories` VALUES ('5', 0x4f7468657220426c6f6773, 'N', 'N', 'N', 'N', 'N', 'name', N, 0x3c6c693e, 0x3c6272202f3e, 0x3c2f6c693e, '-1');
INSERT INTO `wp_linkcategories` VALUES ('6', 0x4d75736963, 'N', 'N', 'N', 'N', 'N', 'name', N, 0x3c6c693e, 0x3c6272202f3e, 0x3c2f6c693e, '-1');
INSERT INTO `wp_linkcategories` VALUES ('7', 0x43687269737469616e20426c6f677320616e64204f726761 6e697a6174696f6e73, 'N', 'N', 'N', 'N', 'N', 'name', N, 0x3c6c693e, 0x3c6272202f3e, 0x3c2f6c693e, '-1');

-- --------------------------------------------------------

I have save the SQL database to my desktop computer. What program do I need to open it with and edit

Ok interesting. What you are attempting to insert is a non-string value (because you're not using the ' identifier for the value N). What is the layout of your wp_linkcategories table? Is this an ENUM value or a string?
I believe I may have an answer for you, however it is dependent on what your wp_linkcategories table looks like.

aschk,

How do I find out if it is a enum value or string?

Ed
ed.sistrunk@sistrunk.net

mebbe I'm being dumb here but I count 13 values you want to insert yet your DDL suggests that you have only 6 columns in your DDL

also oddly you are not fully encapsulating text columns

a suggestion:
have you tried exporting the structure as well as the data (I find it often helps to export them separately, then load them separately so that problems on re-creating the schema are separated from the data).

Who created the database?

You need to show us the WP_LINKCATEGORIES table DDL.

(healdem this is where the 13 values go NOT in the wp_categories that was posted).

If you find the CREATE TABLE wp_linkcategories bit then you can see if it's an ENUM value or a VARCHAR.

good point, well made.. I'd assumed that edsistrunk had posted the DDL for the table he was having problems with... more fool me