Results 1 to 10 of 10
  1. #1
    Join Date
    Jun 2007
    Posts
    4

    Unanswered: Help editing MYSQL 4.0.27 to 4.1.2

    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

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    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?

  3. #3
    Join Date
    Jun 2007
    Posts
    4
    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.

  4. #4
    Join Date
    Mar 2004
    Posts
    480
    do you see the N that is unquoted? that is the problem. That may be what they are talking about needing to edit.

  5. #5
    Join Date
    Jun 2007
    Posts
    4
    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

  6. #6
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    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.

  7. #7
    Join Date
    Jun 2007
    Posts
    4
    aschk,

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

    Ed
    ed.sistrunk@sistrunk.net

  8. #8
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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).
    I'd rather be riding on the Tiger 800 or the Norton

  9. #9
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    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.

  10. #10
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    good point, well made.. I'd assumed that edsistrunk had posted the DDL for the table he was having problems with... more fool me
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •