New Zenner
- Join Date:
- May 2006
- Posts:
- 51
- Plugin Contributions:
- 0
Database Copy
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:
#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
-
What is the "CHARSET=latin1"
-
Can I just remove all the "DEFAULT CHARSET=latin1" references and not affect anything?
-
What is a good way to deal with this?
Thanks.