Today I have to move wordpress blog from ipad web host to bluehost. Everything work well except one thing :
database
Database error and after examine error message I found a way to overcome that problem.
1. Open sql from ipage exported file (created by phpmyadmin)
2. Open with editor (notepad or wordpad) and look for these lines :
— Database: `101_xmas`
—
CREATE DATABASE `101_xmas` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `101_xmas`;
Yes, italic things I set must be ignored by bluehost and to accomplish that thing you can add — in front of the lines.
save the file and reupload through phpmyadmin.
This time I see :
Import has been successfully finished, 30758 queries executed. (custsql-ipg09.eigbox.net.sql)
Good, I can continue to other work 🙂