Import mysqldump file to existing WP database

  • Resolved hillaryharris1635

    (@hillaryharris1635)


    10 years, 5 months ago

    I need to import a mysqldump file (65MB) into a new install of WordPress and VERY green when it comes to knowledge of MySQL. The file contains approx 350 members of a previous site (not WordPress) that need to be imported into what will be a new members site on WordPress (with BuddyPress).

    I have been googling and researching and just completely lost so thought I would reach out to the WP community to see if anyone has any ‘Import mysqldump files for Dummies’ advice or even straight forward articles to point me to.

    I started with importing using phpMyAdmin via the Cpanel but the upload limit is 50MB and my file is 65MB and cannot be split.

    My other thought is – how much work will be involved after the data is installed to map it to the new site. I haven’t yet started building the profile fields for members assuming it might be better to work with what is being imported.

    Can anyone help or advise? Thank you!

Viewing 1 replies (of 1 total)
  • Thread Starter hillaryharris1635

    (@hillaryharris1635)

    I’ve worked out how to upload the file by compressing the mysqldump further so that phpMyAdmin could handle it. I used a tool called Gui Tar https://www.macupdate.com/app/mac/14503/gui-tar which compressed the file down to 12MB from 65MB so could now be handled by phpMyAdmin from within my host’s Control Panel. I compressed it as .bz2 file which uploaded just fine!

    Hopefully this helps someone else.

Viewing 1 replies (of 1 total)
  • The topic ‘Import mysqldump file to existing WP database’ is closed to new replies.