[drupal-support] Upgrading database from 4.5.4 to 4.6.2 (was Psychophobia)

[Gerhard Killesreiter]

On Wed, 20 Jul 2005 sunblockster at gmail.com wrote:

> > This has happened today to me as well. What I did is:
> >
> > mysqldump  -uuser -ppass db term_node -w 'tid = 0'| sort | uniq >
> > term_node.sql
> >
>
> Got this.
>
>
> > then I deleted the entries where tid = 0
> >
>
> How did you do this? Do you mean entries in a certain table? Is this
> something I could do through phpmyadmin?

Sure:

delete from term_node where tid = 0;

>
> > and re-imported term_node.sql
> >
>
> I am an ignoramus -- how did you do this?

You can upload the file through phpmyadmin or import through the mysql
commandline.

>
> > after deleting the table structure on top of the file.
> >
>
> And this?

Open in editor, edit.

You can also use the -t flag with mysqldump, then you can skip this.

>
> > Afterwards add the index:
> >
> > ALTER TABLE term_node ADD PRIMARY KEY (tid,nid);
> >
>
> This is just a mysql command?

Yes.

Cheers,
	Gerhard