I am looking for some help on a MySQL issue. We have a site that has been running on Drupal for over a year and we recently moved that site to a new server. The old server had MySQL 4.0, and the new server MySQL 4.1. This has caused a number of odd characters to appear in the site content, namely: Â. For example:
"Before we started this website, we were like normal people... we just kinda slopped the food on our plates, sat down, prayed, and started eating. Suddenly, we were trying to make every plate look beautiful. "
mref on the Drupal IRC chat had suggested I give inconv a shot. So I
1. Did a mysqldump
2. Ran iconv (iconv -f iso-8859-15 -t utf8 oldlatin.sql > newtest.sql)
3. Restored the database
Steps 1 and 2 appeared to work, but I got an odd error on step 3.
ERROR 1153 (08S01) at line 994: Got a packet bigger than 'max_allowed_packet' by tes
I checked PHPMyAdmin (I am kind of a commandline newb) and that database was partially restored. The original MySQL file restores fine, but after running iconv I get that error.
What would others suggest at this point? I was reading up on how to change the packet size but I am looking for some advice. Is going through the process of having the server admin changing the packet size going to help?
Will the new database after the inconv solve my problems?
What do I need to know to get an existing site to run on MySQL 4.1? I would image a number of people have had this issue with MySQL 4.1/5.0 becoming more and more popular and both transitioning to from Latin1 to UTF8.
Thanks for your time and any assistance you can offer.
Comments
=-=
another option:
upload the sql file to your server, file a support request with your host informing them where the sql file is and ask them to import it for you.
or
try and become a command line not so newb : ) and try getting the DB populated that way.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
I am using the commandline ;)
I was populating the database through the commandline. I ran:
mysql -u [user] -p[password] [database] < /home/user/public_html/newtest.sql
This works fine with the DB before running iconv, but I get the error afterwards. The server is my dad's server, so there is no direct ticket request unfortunately.
As for the command line, maybe you could give me a tip on how to populate that database in a way to avoid the "max_allowed_packet". Maybe toss me a towel ;)
To toss it out: Have you ran into the Latin1/UTF8 issue before or this specific error? Niether of the introductory books on MySQL I have deal with this sort of issue, so I am kind of at the mercy of those with a better knowledge of MySQL.
=-=
what is line 994 ?
before you did your DB dump did you empty the sessions table, the cache tables and the watchdog table ? this would make the mysql file much smaller.
since the server is yours, investigate increasing the max_packets_allowed in your my.ini file
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )