Move database from ipage to bluehost

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 🙂