Transferring WP to new host account: database upload question
-
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 INTOwp_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.