markian Posted July 18, 2006 Share Posted July 18, 2006 sory iam still a noob.. i have some websites.. that using open source.. the hosting company told me that they are going to transfer to other server.. so.. iam going to transfer all my files to the new server and upload the mysql again.. but theres a problem.. the version of mysql on my old server is different with the new server.... what can i do ? i dnt now the commands in mysql... i dnt know where can i del the errors in there... is there any way ? or a converter something... ty Link to comment https://forums.phpfreaks.com/topic/14957-help-about-mysql/ Share on other sites More sharing options...
fenway Posted July 18, 2006 Share Posted July 18, 2006 Make sure you do a proper dump of your existing database with whatever tools your current host provides. Then read the refman, and look at what needs to be addressed as part of the upgrade. Link to comment https://forums.phpfreaks.com/topic/14957-help-about-mysql/#findComment-60049 Share on other sites More sharing options...
markian Posted July 18, 2006 Author Share Posted July 18, 2006 [quote author=fenway link=topic=101014.msg399356#msg399356 date=1153246918]Make sure you do a proper dump of your existing database with whatever tools your current host provides. Then read the refman, and look at what needs to be addressed as part of the upgrade.[/quote]you mean bro like this ? [quote]MySQL said: #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 13 [/quote]then ill report this to the hosting company so that they can upgrade ? Link to comment https://forums.phpfreaks.com/topic/14957-help-about-mysql/#findComment-60076 Share on other sites More sharing options...
fenway Posted July 18, 2006 Share Posted July 18, 2006 "They" probably won't do anything for you... you'll have to handle it yourself. In this particular case, you can change CHARSET to CHARACTER_SET in your dump and you'll be fine, but there will be other issues you have to address. Link to comment https://forums.phpfreaks.com/topic/14957-help-about-mysql/#findComment-60146 Share on other sites More sharing options...
markian Posted July 19, 2006 Author Share Posted July 19, 2006 [quote author=fenway link=topic=101014.msg399461#msg399461 date=1153256143]"They" probably won't do anything for you... you'll have to handle it yourself. In this particular case, you can change CHARSET to CHARACTER_SET in your dump and you'll be fine, but there will be other issues you have to address.[/quote] ohh okey... ty for that info.... i try to fix it... i hope you gonna help me if theres some erors again.. thanks u so much bro.. Link to comment https://forums.phpfreaks.com/topic/14957-help-about-mysql/#findComment-60576 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.