Announcement

Collapse
No announcement yet.

Moving Servers

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Moving Servers

    I am moving to my new dedicated server. I've uploaded the SQL file to my FTP and when running the restore command using SSH I get the following error

    ERROR 1064 at line 2. 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.

    Help please!

  • #2
    What MySQL version is your old and your new server running?

    What are the exact commands you've used to backup&restore?
    Want to take your board beyond the standard vBulletin features?
    Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

    Comment


    • #3
      try using the mysqldump --opt -hservername -uusername -p db name < /path/to/backup function from your old server.
      Joshua Combs
      Webmaster/Founder Quad4forums.com | ECOTECforum.com
      Streamline Web Solutions
      [email protected]

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X