Forum Support

Shape 5
March 28, 2024, 03:52:54 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Shape 5 Forum
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: Error with MySql import  (Read 249 times)
garyk
Jr. Member
**
Offline Offline

Posts: 7



« on: October 17, 2011, 01:47:21 PM »

hi, i'm trying to import the Db for the Callie Rush template. I have downloaded with site shaper, modified what I want and exported the db. On the live site I have created a new db and imported the db from localhost.
Unfortunately I am getting db errors:

MySQL said: Documentation
#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 'USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9' at line 17

Has this something to do with my server where I am hosting the site?
Logged
mikek
Administrator
*****
Offline Offline

Posts: 28743



WWW
« Reply #1 on: October 18, 2011, 07:43:52 AM »

Hello,

Try doing is as a gzip export, the compression will be different. You should also make sure that your server is running a current version of mysql.
Logged

Mike Knott
------------
Shape 5 Team

- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2013, Simple Machines
Joomla Bridge by JoomlaHacks.com
Valid XHTML 1.0! Valid CSS!
Looking for the largest variety in template designs? Look no more. Never buy 1 theme again. Signups start at just $89 for access to all of our themes.
Send Us An Email
Please send us your questions and we will email you back as soon as we can. Product support questions should be posted in our support forums under the Help menu. Our staff will assist you from there.