Linux-Noob Forums
mysql 4.1 -> 4.0 - Printable Version

+- Linux-Noob Forums (https://www.linux-noob.com/forums)
+-- Forum: Linux Server Administration (https://www.linux-noob.com/forums/forum-8.html)
+--- Forum: LAMP (https://www.linux-noob.com/forums/forum-83.html)
+--- Thread: mysql 4.1 -> 4.0 (/thread-2640.html)



mysql 4.1 -> 4.0 - hijinks - 2005-05-19


here is a little perl line i had to do to convert a default mysqldump from 4.1 to make it import into a 4.0 server. I know there are options in mysqldump to make it 4.0 ready but i didn't want to re-download a 400meg dump file

 



Code:
perl -pe "s/DEFAULT\ CHARSET\=latin1//g" forum.sql > forum2.sql




 

just in case someone needs it.. probably not though :)