XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module troubleshooting 
  4.  / Database backup and restore 3.0 (error restoring)
Register
1
svaha
Database backup and restore 3.0 (error restoring)

  • 2006/5/29 12:17

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


I used to fill the database of my testsite with the data of my production site with a sql-file broken down in manageble small parts, so I would not get a time out.


Now I used database backup module, but I keep getting this error :

Quote:
Processing file: bkp0605291418_x7chat2_users.gz

Starting at the line: 1

Error at the line 2502: );

Query: CREATE TABLE xxxxxxx_bb_posts_text ( post_id int(8) unsigned DEFAULT '0' NOT NULL, post_text text, post_edit text, PRIMARY KEY (post_id), KEY search (post_text) );

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

Stopped on error



I tried this with several options on and off but the error remains, so the database on my test site is now messed up, but more important, the backup I make from my production site is useless.

Any ideas would be very much welcome
What doesn't kill me,
makes me stronger.

http://exm.amevita.eu
http://www.amevita.eu
http://www.alohaspirit.nl
2
svaha
Re: Database backup and restore 3.0 (error restoring)

  • 2006/5/30 20:25

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


little bumpy
What doesn't kill me,
makes me stronger.

http://exm.amevita.eu
http://www.amevita.eu
http://www.alohaspirit.nl
3
svaha
Re: Database backup and restore 3.0 (error restoring)

  • 2006/6/1 13:48

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


I still have this error, so backups of my site are useless and I can't install new / updated modules because if something happens to the database I can't restore it.

Could this be an error in CBB 3.01?


[edit] When I choose to repair the database I get this:

.....
......
spiritforum.blabla..repair...status...OK
TABLE ..Op ...Msg type..Msg text
spiritforum.blabla..repair...status...OK

[/edit]
What doesn't kill me,
makes me stronger.

http://exm.amevita.eu
http://www.amevita.eu
http://www.alohaspirit.nl
4
svaha
Re: Database backup and restore 3.0 (error restoring)

  • 2006/6/1 14:20

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


This is how the table is in the sql database :

Veld  Type Attributen Null Standaardwaarde Extra Actie 
   post_id  int(8)  UNSIGNED Nee  0                
   post_text  text   Ja  NULL                
   post_edit  text   Ja  NULL                
 Selecteer alles  /  Deselecteer alles     Met geselecteerd:       
 


    Indices : [Documentatie]
Sleutelnaam Type Kardinaliteit Actie Veld 
PRIMARY  PRIMARY  2032   Verwijderen  Wijzigen  post_id  
search  FULLTEXT  2032   Verwijderen  Wijzigen  post_text  

Creëer een index op kolommen        Ruimte gebruik : Type Gebruik 
Data 2.739 KB 
Index 1.286 KB 
Totaal 4.025 KB 
   Rij statistiek : Opdrachten Waarde 
Formatteren dynamisch  
Rijen 2.032  
Lengte van de rij ø 1.380  
Grootte van de rij ø 2.028 Bytes  
Creation 16 Feb 2006 om 23:46  
Last update 01 Jun 2006 om 16:14  
Last check 01 Jun 2006 om 16:14  
 

--------------------------------------------------------------------------------
What doesn't kill me,
makes me stronger.

http://exm.amevita.eu
http://www.amevita.eu
http://www.alohaspirit.nl
5
svaha
Re: Database backup and restore 3.0 (error restoring)

  • 2006/6/2 10:30

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


Bump
What doesn't kill me,
makes me stronger.

http://exm.amevita.eu
http://www.amevita.eu
http://www.alohaspirit.nl
6
jdseymour
Re: Database backup and restore 3.0 (error restoring)

What MySQL version are you using? Did you try a manual import through phpmyadmin to see if you get more information?
7
svaha
Re: Database backup and restore 3.0 (error restoring)

  • 2006/6/2 21:56

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


Thank you for your reply, I discovered that it's possible on another testsite I have on onsmart.com to import a sql file of max. 15 Mb and it worked.

Now I know that I can import the sql-file, pitty though that gzip format gives errors on my other sites.

Again thank you.
What doesn't kill me,
makes me stronger.

http://exm.amevita.eu
http://www.amevita.eu
http://www.alohaspirit.nl

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

245 user(s) are online (177 user(s) are browsing Support Forums)

Members: 0

Guests: 245

more...

Donat-O-Meter

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

Latest GitHub Commits