Jump to content

Archived

This topic is now archived and is closed to further replies.

markian

help about mysql

Recommended Posts

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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
[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 ?

Share this post


Link to post
Share on other sites
"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.

Share this post


Link to post
Share on other sites
[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..

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.