1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

need wordpress specialist

Discussion in 'Hire a Freelancer' started by louisp2500, Dec 30, 2016.

  1. louisp2500

    louisp2500 Regular Member

    Joined:
    Feb 24, 2011
    Messages:
    378
    Likes Received:
    58
    Hi i have problem with my old wordpress site, i cant upload my old SQL file to my new wordpress site, im getting following error

    CREATE TABLE IF NOT EXISTS `wp_commentmeta` (
    `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
    `meta_key` varchar(255) DEFAULT NULL,
    `meta_value` longtext,
    PRIMARY KEY (`meta_id`),
    KEY `comment_id` (`comment_id`),
    KEY `meta_key` (`meta_key`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=219 ;



    Can anyone solve this problem?
     
  2. bahman2000

    bahman2000 Junior Member

    Joined:
    Oct 31, 2011
    Messages:
    116
    Likes Received:
    11
    I can help you . 9 euro . with paypal
     
  3. louisp2500

    louisp2500 Regular Member

    Joined:
    Feb 24, 2011
    Messages:
    378
    Likes Received:
    58
    Lets try then, i have send pm
     
  4. luc1f3r.n008

    luc1f3r.n008 Jr. VIP Jr. VIP

    Joined:
    Dec 30, 2012
    Messages:
    449
    Likes Received:
    81
    Gender:
    Male
    Location:
    Heart of BHW
    Home Page:
    Create database with same db name also username as old db.
    90% cases it should work.
     
  5. Henry Cooper

    Henry Cooper Regular Member

    Joined:
    Jun 27, 2016
    Messages:
    208
    Likes Received:
    91
    Gender:
    Male
    Home Page:
    Thats not an error, thats a SQL Query. What is the error?
     
  6. luc1f3r.n008

    luc1f3r.n008 Jr. VIP Jr. VIP

    Joined:
    Dec 30, 2012
    Messages:
    449
    Likes Received:
    81
    Gender:
    Male
    Location:
    Heart of BHW
    Home Page:
    Exactly. OP missed actual error message.
    I got the similar error yesterday while migrating a site. thats why i have assumed the error is same looking at OPs statement.
    Hi i have problem with my old wordpress site, i cant upload my old SQL file to my new wordpress site, im getting following error
     
  7. louisp2500

    louisp2500 Regular Member

    Joined:
    Feb 24, 2011
    Messages:
    378
    Likes Received:
    58
    Hi i have tried that now

    Stil getting this

    "CREATE TABLE IF NOT EXISTS `wp_commentmeta` ( `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0', `meta_key` varchar(255) DEFAULT NULL, `meta_value` longtext, PRIMARY KEY (`meta_id`), KEY `comment_id` (`comment_id`), KEY `meta_key` (`meta_key`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=219 ;
     
  8. louisp2500

    louisp2500 Regular Member

    Joined:
    Feb 24, 2011
    Messages:
    378
    Likes Received:
    58
    So what should i do?
     
  9. nichew

    nichew Registered Member

    Joined:
    Nov 30, 2016
    Messages:
    68
    Likes Received:
    3
    Occupation:
    Domain investor
    Home Page:
    Using the xml import/export option will be better
     
  10. rk8998

    rk8998 Registered Member

    Joined:
    May 4, 2016
    Messages:
    78
    Likes Received:
    28
    Gender:
    Male
    Occupation:
    Website Developer
    Location:
    Asia
    did the new wordpress site had database already created? if yes, try drop the wp_commentmeta db row
     
  11. iamcholo

    iamcholo Registered Member

    Joined:
    Oct 2, 2015
    Messages:
    80
    Likes Received:
    21
    Don't know what it's the sql error. But if you don't care your old table, drop it like this:

    Code:
    DROP TABLE wp_commentmeta;
    Code:
    CREATE TABLE IF NOT EXISTS `wp_commentmeta` ( `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0', `meta_key` varchar(255) DEFAULT NULL, `meta_value` longtext, PRIMARY KEY (`meta_id`), KEY `comment_id` (`comment_id`), KEY `meta_key` (`meta_key`) ) ENGINE=MyISAM;
    
     
  12. staypositive

    staypositive Jr. VIP Jr. VIP

    Joined:
    Jul 28, 2015
    Messages:
    993
    Likes Received:
    134
    Occupation:
    Hiring content writer & VA for links building, PM
    hi

    if its not null that means u already have the database name exist.
    pls try create a new database name and then import the sql.
    also, make sure u import it in the subset table to avoid clashing ur master file in phpmyadmin.

    which hosting u using? u can ask the hosting company to do it for u, just upload it to ftp file server