billcollins

I hope this helps someone. I spent hours trying to figure this out.

First, the new database already existed. After I downloaded a copy of the database from the old hosting service, I changed the name of the database to correspond with the new database, in an editor, removed the lines,CREATE DATABASE db220506006b DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci; USE db220506006b; and then imported the file into the new database via php manager. All the tables were correct. I also edited the wp-config file to correspond to the new database. I was also using custom permalinks….they needed to be updated. And then the site ran smoothly. Always make a backupcopy of the old database and the wp-config file. This worked for me. I am not an expert, I only trying to say what worked for me after hours of trying to work this out. If you find a better post, please use it. Have a great day.

Sorry,
The character set is:
CHARACTER SET utf8 COLLATE utf8_unicode_ci;

I do not know the syntax. Help please;

The plugin were not activated. When I activated the plugins, everything worked fine.