Greetings,

I am currently stuck on Bugzilla 2.16 and TestRunner .6 *shudder*. I want to help my team by migrating out of TestRunner and moving into Testopia / Bugzilla 4.x.. however

the system we're using to host, doesn't want to dump the DB ... I tried the following command and it's failed. I think I need to check the /etc/my.cnf but totally lost as to what should go where..

I think I need to copy what's in this post's .cnf file.. or modify it somehow : http://www.linuxquestions.org/questi...nguage-835174/

Let's see what you get from these 2 first:

Also what's your distro?

1 members found this post helpful.

Thank you for replying:


# cat /etc/mysql/my.cnf | grep -B 2 sock
cat: /etc/mysql/my.cnf: No such file or directory

I searched in the root /etc and found the following:

# cat /etc/my.cnf | grep -B 2 sock
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

This directory does not exist, do I need to change these variables to the proper DIR to get commands working?

second commands results:

# ps ax | grep mysql
5845 pts/0 S 0:00 grep mysql



this is RedHat Linux 2.4.21-60.EL #1 Mon Aug 24 20:25:55 EDT 2009 i686 i686 i386 GNU/Linux

Ok, things are clearer now.

Your mysql server is not running so the mysqldump command from your opening post obviously has no chance of working - that's why you're getting
It's a bit surprising since you are supposed to have Bugzilla working but your mysql server is not running. Is it working currently?

1 members found this post helpful.

So I should do this?

>su
> cd /etc/init.d
>./mysql start

could there be some... non-standard second mysql installation? Bugzilla may not be working... but TestRunner certainly is available online and accepting new test runs. I would imagine that requires the database to be running.

When I do the sanity-check.pl I do get errors.. I'm dreading how I am going to properly export this data.

It's possible. Bugzilla may also not use MySQL at all - Postgres, Oracle and Sqlite may be in use. Or use MySQL server somewhere else other than localhost. (although since you know the database - 'bugs', then presumably you know some details about your installation)

The easiest thing to do is check Bugzilla config for details of its database. Then, once you've eastablished where it expects to find MySQL, start the server and try to connect to it with your mysqldump command again.

1 members found this post helpful.

I actually got that 'bugs' name from a google search for the command.. I don't know if that's the DB Table name .. I'll look into the bugzilla config file now. Thank you.

so I find 'localconfig' and it's revealed the following :

#
# How to access the SQL database:
#
$db_host = "<hostname>"; # where is the database?
$db_port = 3306; # which port to use
$db_name = "<dbname>"; # name of the MySQL database
$db_user = "<dbuser>"; # user to attach to the MySQL database


I guess the server is located on the other system.. Should I run my command locally over there? I need to migrate this database and/or copy the data out... Thanks for your help. Looks like I need to google what's next in terms of dumping the DB

What'd I'd Like to do is,

1 - Export the data from TestRunner to xml / html,

2 - bring up a new install of Bugzilla 4.x and testopia, using the default Local Mysql DB instead of the current setup.

3 - import the data somehow into testopia.