1
ukandrewf
URGENT!! Xoops Backup & Restore Newbb2

I tried updating newbb to newbb2 then decided to go back. I'd made a backup of both the sql database and php before i did anything.

When I tried to restore the sql databases using the backups everything seemed to work very smoothly, occassionally it asked me to drop a table before restoring.

All worked well but..
when it came to xoops_bb_posts_text i got this...

Quote:
Processing file: bkp0604041701_xoops_bb_posts_text.gz

Starting at the line: 1

Error at the line 14: );

Query: CREATE TABLE xoops_bb_posts_text ( post_id int(8) unsigned NOT NULL auto_increment, post_text text, PRIMARY KEY (post_id), KEY search (post_text) );

MySQL: BLOB/TEXT column 'post_text' used in key specification without a key length

Stopped on error

Start from the beginning (DROP the old tables before restarting)


I dropped the table but even once done it still shows the same message when rerun.

Any ideas folks I urgently need a fix?

thanks

Andrew

2
MadFish
Re: URGENT!! Xoops Backup & Restore Newbb2
  • 2006/4/6 2:50

  • MadFish

  • Friend of XOOPS

  • Posts: 1056

  • Since: 2003/9/27


I've had a similar problem in trying to restore backups before. As the problem is something to do with creating tables, what I did was to i) remove the drop/create table statements from my backup, ii) reinstall the module (which creates the tables properly from the module's original sql file) and then iii) restore the backup (now data only) into the clean tables.

Good luck :)

Login

Who's Online

312 user(s) are online (208 user(s) are browsing Support Forums)


Members: 0


Guests: 312


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits