reading some of the posts below, yes this is the one piece of info which is left out of this tutorial. Just do a search for the terms above, it clears it up. (or just delete the top of the sql file)
dude you saved me, thanks a billion!!!!! also something you might want to mention..
when you export the original database, it puts this at the top:
CREATE DATABASE `********` DEFAULT CHARACTER SET latin1 COLLATE
thus, when you try and import the database again mysql tries to make that database again. You need to remove this whole header in order to re-import into the empty database (and not create a new one)
for more info do a google search for "problems moving database with phpmyadmin"
Just want to say thanks for this 2 part WP migration tutorial. It was thorough, explained WHY you were doing things, not just HOW and that made it an excellent tutorial and saved me a lot of time and grief! Thanks for spending your time helping.
@Cyberbronco that is for moving content. If you want to move the entire site to a new domain it gets a bit more complicated. Especially if your not even doing a blog, and you are doing cms.
you've done a great job, VERY VERY impressed.
skymiles99 7 months ago
This was exactly what I needed to work through a transfer without losing any information. Thanks!
123Rasmussens 10 months ago
reading some of the posts below, yes this is the one piece of info which is left out of this tutorial. Just do a search for the terms above, it clears it up. (or just delete the top of the sql file)
awnold1 11 months ago
dude you saved me, thanks a billion!!!!! also something you might want to mention..
when you export the original database, it puts this at the top:
CREATE DATABASE `********` DEFAULT CHARACTER SET latin1 COLLATE
thus, when you try and import the database again mysql tries to make that database again. You need to remove this whole header in order to re-import into the empty database (and not create a new one)
for more info do a google search for "problems moving database with phpmyadmin"
awnold1 11 months ago
Thanks very much, moving to a different host, helped a lot, cheers.
MEGADETHTHRETH 1 year ago
many, may thanks, keep up the good work!
active120 1 year ago
Just want to say thanks for this 2 part WP migration tutorial. It was thorough, explained WHY you were doing things, not just HOW and that made it an excellent tutorial and saved me a lot of time and grief! Thanks for spending your time helping.
therealchrisboggs 1 year ago
@Cyberbronco that is for moving content. If you want to move the entire site to a new domain it gets a bit more complicated. Especially if your not even doing a blog, and you are doing cms.
liftgates 1 year ago
Hey) I've got the solution to this problem.
You need to comment (or delete) the "Create Database part" and "Use" part.
Andyeeee 2 years ago
I have the same problem as markovacs
Andyeeee 2 years ago