MySQL said: Documentation
#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' at line 6
I would be very greatful is someone could fix me a fix.
I backed the mysql up via the admincp using "Database Backup"
I am trying to run this sql file in phpmyadmin, is there anyway of editing the sql file to make this work (without using ssh)?
Kind regards
Danny
Try a backup from phpMyAdmin, see http://www.vbulletin.com/forum/showthread.php?t=172971
Try removing the "DEFAULT CHARSET = latin1" bit from the query, and the semi-colon.
I am unable to backup from phpmyadmin because that’s the reason we are moving servers (no support and phpmyadmin config is not correct so you want get on phpmyadmin)
I have tried using cpanels mysql backup feature but still errors. I am totally lost. Do you know if I could fix this just by editing the sql I am running.
Thanks
Danny
See what Paul wrote, in post five. ;)
You need to remove the mysql 4.1 specific formating, namely the character encoding.
Thank you very much for your help!
I have sorted it out, took me a while to do all the edits.