• https://tax-problem-debt.com/blog/

    First off, I don’t understand databases.

    I’ve just transferred a client’s web site from one hosting company to another. I have a back up of their old WP databases — they are called information_scheme.sql, mtaadmin_blog.sql and mtaadmin_wordpress.sql. The new database is named tax1014107150522 and there’s also information_schema. Do I import the old infoschema & the mtaadmin_wordpress.sql?

    When I attempt to upload mtaadmin_wordpress.sql to the new WP database I get the error message below. Can you tell me what I’m doing wrong? Also, does the information_scheme contain anything I need to upload?

    SQL query:

    — — Dumping data for table wp_comments — INSERT INTO wp_comments (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id) VALUES (210, 572, ‘nursing schools’, ‘[email protected]’, ‘https://www.nursingschoolsinfo.com/’, ‘173.233.65.154’, ‘2010-05-19 22:37:36’, ‘2010-05-20 04:37:36’, ‘Great site. A lot of useful information here. I’m sending it to some friends!’, 0, ‘spam’, ‘Mozilla/2.0 (compatible; MSIE 3.02; Windows CE; 240×320)’, ”, 0, 0), (199, 511, ‘mbt shoes’, ‘[email protected]’, ‘https://www.cozymbtshoes.com’, ‘218.6.8.86’, ‘2010-05-10 19:39:57’, ‘2010-05-11 01:39:57’, ‘great share, great article, very usefull for me…thank you’, 0, ‘spam’, ‘Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; MRA 4.3 (build 01218); .NET CLR 1.1.4322)’, ”, 0, 0), (198, […]

    MySQL said: Documentation
    #1062 – Duplicate entry ‘210’ for key 1

  • The topic ‘Transferring WP to new host account: database upload question’ is closed to new replies.