Sorry,
The character set is:
CHARACTER SET utf8 COLLATE utf8_unicode_ci;
I do not know the syntax. Help please;
I tried to put the code between the backticks, example
CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE db220506006;
Is this correct?
I deeply appreciate your support!
bill
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.
