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

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

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]

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  
 

--------------------------------------------------------------------------------

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

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.

Login

Who's Online

281 user(s) are online (249 user(s) are browsing Support Forums)


Members: 0


Guests: 281


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