migrating data from 3.4 to 3.6.2

[Plotkin, Brian]

I have a .sql data dump from my 3.4 system that I was able to obtain
before the server crashed completely. I've installed 3.6.2 on my new
server. How do I load the 3.4 data?

[Max Kanat-Alexander]

Drop the 3.4 database, "CREATE DATABASE bugs;", import the mysqldump of
the 3.4 database into the now-empty "bugs" database, then run checksetup.pl.

-Max
--
http://www.everythingsolved.com/
Competent, Friendly Bugzilla and Perl Services. Everything Else, too.

[Plotkin, Brian]

The steps I've attempted to perform are:

1) login to mysql using 'bugs'
2) drop database bugs;
3) create database bugs;
4) use bugs;
4) source bugs.sql (loading data from the 3.4 version)
5) quit
6) run checksetup.pl

When I run checksetup I get the following error:

DBD::mysql::st execute failed: Table 'bugs.flags' doesn't exist [for
Statement "SHOW INDEX FROM flags"] at Bugzilla/DB/Mysql.pm line 990

Bugzilla::DB::Mysql::bz_index_info_real('Bugzilla::DB::Mysql=HASH(0x516b
f54)', 'flags', 'flags_bidattid_idx') called at Bugzilla/DB/M
ysql.pm line 410

Bugzilla::DB::Mysql::bz_setup_database('Bugzilla::DB::Mysql=HASH(0x516bf
54)') called at checksetup.pl line 147

_______________________________________________
support-bugzilla mailing list
support-...@lists.mozilla.org
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put support-...@lists.mozilla.org in the To: field when you
reply.

[H X]

Hi,

Does any one know how to check if the Web Service is enabled in Bugzilla? If it is not enabled, how to enable web service?

Thanks,
Hanna

[Max Kanat-Alexander]

On 08/30/2010 02:34 PM, Plotkin, Brian wrote:
> DBD::mysql::st execute failed: Table 'bugs.flags' doesn't exist [for
> Statement "SHOW INDEX FROM flags"] at Bugzilla/DB/Mysql.pm line 990

Okay, so there are two possibilities:

1) Your backup is not complete.
2) Your backup got restored to a different database than "bugs"
(perhaps by having a "use" statement in the backup SQL).