problem importing Vanilla data to bbPress on localhost
-
Hi friends,
I’m attempting to convert over from Vanilla 2.0 to bbPress. I’d like to test first on my local machine, so I’m trying the Import Forums option in my local WP install.
My question: Should there be any problem importing from a live instance to my local?
I’m in PHPMyAdmin and quadruple checking all my settings, so as far as I can tell, I’m inputting all the database settings within bbPress correctly. Sadly, once I start the conversion, I get the “No xxxxxx” set of errors.
What are some common database setting mistakes, just in case I might be overlooking some options? Also, could it be that I’m importing to my local machine and that’s causing the problem (I assume not)?
Let me know if I can provide any more info to make this easier (screenshots, server info, etc)
Thanks!
-
Your issue will be that you are trying to import a ‘remote’ database, you need to make a copy of the database and add it to your local MySQL instance.
Open up your database in phpMyAdmin, hit ‘Check All’ to select all the tables then select ‘Export’ from the dropdown.
https://i.cloudup.com/MVzze12453.png
On your local MySQL phpMyAdmin open up the ‘Databases’ page and create a new database with the same database name as your remote database, just type the name and hit ‘Create’
https://i.cloudup.com/ISiSMdHDDS.png
Open up this new database and select ‘Import’ and click ‘Choose file’ to grab the file you exported above and you now have a local copy of your database.
Let me know if you hit any other snags 😉
- You must be logged in to reply to this topic.
