Author Topic: BLOB/TEXT column 'description' can't have a default value  (Read 161 times)

iosman123

  • Newbie
  • *
  • Posts: 6
    • View Profile
BLOB/TEXT column 'description' can't have a default value
« on: August 19, 2019, 11:58:55 AM »
Hello,

Got this error "Failed to import database construction. MySQL said: BLOB/TEXT column 'description' can't have a default value" During install on Ver 0.8. I am using Apache 2.X & MySQL 5.0.67. Any way out?

thanks
iosman


_________________________
0x800f0r1f
« Last Edit: August 20, 2019, 11:14:16 AM by iosman123 »

IanKern

  • Newbie
  • *
  • Posts: 1
    • View Profile
Re: BLOB/TEXT column 'description' can't have a default value
« Reply #1 on: November 07, 2019, 07:49:22 AM »
First you need to create a database to import. It does not need any tables. Then you can import your database.

start your MySQL command line first (apply username and password if you need)
C: \> mysql -u user -p

Create your own database and exit it

mysql> DROP DATABASE database;
mysql> CREATE DATABASE database;
mysql> Exit
Import the selected database from the dump file
C: \> mysql -u user -p -h localhost -D database -o <dumpfile.sql
You can replace localhost with an IP or domain for any MySQL server for which you want to import.

 

anything
anything