1
I have made a backup of my database using phpmyadmin from my production server (php 5.0.22, MySQL 5) and am trying to restore it to my local server (php 4.0.21, MySQL 4) using phpmyadmin. I keep getting the following errors:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8 AUTO_INCREMENT=2' at line 12
1. What is the "CHARSET=latin1"
2. Can I just remove all the "DEFAULT CHARSET=utf8" references and not affect anything?
3. What is a good way to deal with this?
Thanks.
