I have a backup of my database from PHP5/MySQL 5 using phpmyadmin that I want to restore to my test server that is PHP4/MySQL4 using phpmyadmin. I keep getting the following error the error:
1. What is the "CHARSET=latin1"Code:#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=latin1 AUTO_INCREMENT=2' at line 12
2. Can I just remove all the "DEFAULT CHARSET=latin1" references and not affect anything?
3. What is a good way to deal with this?