Jump to content


Photo

help about mysql


  • Please log in to reply
4 replies to this topic

#1 markian

markian
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 18 July 2006 - 05:49 PM

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

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 18 July 2006 - 06:21 PM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 markian

markian
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 18 July 2006 - 07:27 PM

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.


you mean bro like this ?

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


then ill report this to the hosting company so that they can upgrade ?

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 18 July 2006 - 08:55 PM

"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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#5 markian

markian
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 19 July 2006 - 06:02 PM

"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.


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..




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users