Find Jobs
Hire Freelancers

Merge Word Press same name table in phpmyadmin, two wp_posts.sql into one

$30-250 USD

Completed
Posted over 9 years ago

$30-250 USD

Paid on delivery
Merge Word Press same name table in phpmyadmin, two [login to view URL] into one I have two wp_posts tables, both are already uploaded to myphpadmin. One is labeled wp_posts_new, but they bot need to be merged into wp_posts_new. Tried to import the new [login to view URL] into the current wp_posts but got error: Error SQL query: -- -- Dumping data for table `wp_posts` -- INSERT INTO `wp_posts` (`ID`, `post_author`, `post_date`, `post_date_gmt`, `post_content`, `post_title`, `post_excerpt`, `post_status`, `comment_status`, `ping_status`, `post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`, `post_modified_gmt`, `post_content_filtered`, `post_parent`, `guid`, `menu_order`, `post_type`, `post_mime_type`, `comment_count`) VALUES (4, 1, '2011-06-04 09:36:15', '2011-06-04 09:36:15', '<img class="alignnone size-full wp-image-63" title="featured_home" src="http://"website".com/wp-content/uploads/2011/09/[login to view URL]" alt="" width="941" height="506" />', 'Home', '', 'publish', 'open', 'open', '', 'home', '', '', '2011-09-21 22:49:13', '2011-09-22 05:49:13', '', 0, 'http://"website".com/?page_id=4', 0, 'page', '', 0), (5, 1, '2011-06-04 09:36:11', '2011-06-04 09:36:11', '', 'Auto Draft', '', 'inherit', 'open', 'open', '', '4-revision', '', '', '2011-06-04 09:36:11', '2011-06-04 09:36:11', '',[...] MySQL said: Documentation #1062 - Duplicate entry '4' for key 'PRIMARY' Not sure how to fix myself. Need within one day.
Project ID: 6958258

About the project

10 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Dear Sir/MA, I ca get your required task done and I am ready to start immediately. Thank you Adeola
$45 USD in 1 day
4.9 (468 reviews)
7.8
7.8
10 freelancers are bidding on average $69 USD for this job
User Avatar
hello sir, i can do your project.... please accept my bid so that i can start it... i m expert in this type of project... u can also see my portfolio... please sir accept my bid.. please hope u will do i m waiting for your response.. thank you.. :)
$60 USD in 0 day
5.0 (577 reviews)
7.6
7.6
User Avatar
Need cpanel and phpmyadmin access so i can fix it for you asap. please discuss with me first before awarding me asap thanks
$35 USD in 1 day
4.9 (355 reviews)
7.7
7.7
User Avatar
Already worked on lots of projects with excellent reviews you can check lets start..............................
$55 USD in 1 day
5.0 (109 reviews)
7.2
7.2
User Avatar
Hello, I could complete this work with a fixed payment $125 I am currently starting my own Virtual Assistant company and fee reflects the fact that I'm trying to create client base and reputation, I have a experience more than 6 years and English language background, both of which will be beneficial for this job. I would also always available for on-going work should you require it. Thanks, Regards, Web Bolt Technologies. CEO - Vaqas Uddin
$138 USD in 2 days
4.8 (287 reviews)
6.9
6.9
User Avatar
Hi , You could do this manually but depending on the number of posts that's a lotta work. What i wanna do is simple enough. I wanna make a script to do it . It'll get all info from table2, recreate the sql .. insert into table1. Once finished it will remove table2. Or i will from admin :) Considering the number of reviews we both have milestone release on completion is fine with me. I don't even need access to the site. If you just send me the 2 sqls i can send you 1 :) Ideally of course you can give me full access (FTP / phpmyadmin / WP-admin) .. but i can manage with just the sqls and i send you back the script used, the combined sql and a small instructions txt for future use. Warm regards, George
$60 USD in 1 day
5.0 (70 reviews)
6.2
6.2

About the client

Flag of UNITED STATES
Centennial, United States
5.0
122
Payment method verified
Member since Jan 18, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.