Back Home

Open Designs

Community. Driven.

General Talk: [Resolved] Problem With phpMyAdmin

Bottom of Page

1 to 3 of 3

  1.  
    •  
      CommentAuthoracousticsam
    • CommentTimeJan 21st 2007 edited by acousticsam on the 21st January 2007 at 14:01:26 EST
     
    Hi all,

    I'm in the process of moving my WordPress blog to a new server. (I had it hosted for free at AwardSpace before now, but I'm actually paying for a real domain this timetongue)

    I've uploaded a brand new WordPress installation to my new host, and I just want to transfer my posts and comments from my old host to the new one.

    I exported the wp_posts and wp_comments tables from my old host and saved them on my hard drive. Then I went in to phpMyAdmin on my new host, clicked the "wp_posts" link on the left, and uploaded the wp_posts.sql file from my computer using the form at the bottom of the page. I did the same with the wp_comments.sql file.

    I got error messages both times, the screenshots are below.

    Now when I login to my phpMyAdmin on the new host, both the wp_posts and wp_comments links are absent from the side menu where it lists the other tables.

    Here are the screenshots:
    wp_posts error page
    wp_comments error page


    Any help would be very, very much appreciated.

    Thanks in advance,

    Sam
    • CommentAuthorsage
    • CommentTimeJan 21st 2007 edited by sage on the 21st January 2007 at 11:44:05 EST
     
    Is there any reason you are using DEFAULT Charset as latin1. If not, open your wp_posts.sql and change

    )ENGINE = MYISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=57

    to

    )ENGINE = MYISAM AUTO_INCREMENT=57

    and then try to reimport.

    Do the same for wp_comments.sql

    Cheers,
    Ganesh Gunasegaran
  3.  
    Thanks, Ganesh, it worked perfectly after removing the "DEFAULT CHARSET=latin1". I don't even know why it was there... must have been something that AwardSpace automatically put in the file. Well, I'm just glad I won't have to deal with the hassle of free hosts ever again.

1 to 3 of 3

  1.