[mythtv-users] Re: Clean 0.15 install, what should I save from the old DB?

[BP]

Aleaxander wrote:

> I brought up the mysql prompt by entering
> $mysql -u root -p
> 
> Then I entered:
> mysql>ALTER TABLE record ADD COLUMN recorddups INT DEFAULT 0 NOT NULL;
> 
> But it gave me the following error:
> ERROR 1046: No Database Selected
> 
> So then I tried adding "mythconverg" to the end of the command, but got 
> this error:
> ERROR 1064: You have an error in your SQL syntax near 'mythconverg' at 
> line 1
> 

Specify the database when you start the mysql session:

$mysql -u root -p mythconverg

or

$mysql -u root -p
mysql> use mythconverg;