Invalid SQL: REPLACE INTO `swsessions` (`sessionid`, `ipaddress`, `lastactivity`, `useragent`, `isloggedin`, `sessiontype`, `typeid`, `dateline`, `status`) VALUES('i9qq26pkgxa4w9soajlxlcvo6b3fihg4', '54.205.14.21', '1409670850', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '0', '40', '0', '1409670850', '0'); (The table 'swsessions' is full) Ubersmith Technical Support Options and Contact Information
Support Center » Knowledgebase » Using Ubersmith's InnoDB conversion script
 Using Ubersmith's InnoDB conversion script
Solution As of Ubersmith 2.2, InnoDB is the MySQL database engine used by Ubersmith. While running through the normal Ubersmith upgrade wizard will convert your database from MyISAM to InnoDB format, some users with large databases may wish to use a conversion script we've developed for this purpose. The conversion script will convert the majority of your database tables to InnoDB, without the need for additional downtime. The syntax for the script is as follows:

php setup/preconvert.php --db=databasename --db-user=username --db-pass=password

In most cases, you will need to use the MySQL 'root' user to perform this operation, as the database SUPER privilege is required. Typically, the database name is simply 'ubersmith'. The script will convert as many of your database tables as possible, and running through the Ubersmith upgrade wizard will complete the remainder. Please note: We strongly advise making a backup of your Ubersmith database BEFORE running the conversion script or performing any upgrade.

If you encounter any problems with the conversion script, or have any questions, please contact Ubersmith support.


Article Details
Article ID: 147
Created On: 30 Jan 2012 03:03 PM

 This answer was helpful  This answer was not helpful

 Back
 Login [Lost Password] 
Email:
Password:
Remember Me:
 
 Search
 Article Options
Home | Don't Register | Knowledgebase | Troubleshooter | Downloads
Language: