Blog Documentation Book a Demo
Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

importing a database

minimumminimum
edited August 2006 in Vanilla 1.0 Help
after trying to move vanilla from my old server to my new one and having no luck i decided to try to just do a fresh installl, wipe the database and then try to import the old database using phpmyadmin. its not wokring though and i'm getting this error... -- Table structure for table `LUM_Category` -- CREATE TABLE `LUM_Category` ( `CategoryID` int( 2 ) NOT NULL AUTO_INCREMENT , `Name` varchar( 100 ) NOT NULL default '', `Description` text NOT NULL , `Order` int( 11 ) NOT NULL default '0', PRIMARY KEY ( `CategoryID` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =14; ...any ideas on how to import an old database into a clean one?

Comments

  • ithcyithcy New
    edit the sql file, take out the "ENGINE = MYISAM DEFAULT CHARSET = latin1" and try to import it again.
  • minimumminimum
    i tried removing that and the "AUTO_INCREMENT=14" that was on the same line and neither worked. :(
  • DinoboffDinoboff
    what is the error message?
This discussion has been closed.