LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 02-13-2012, 03:58 PM   #1
hwy9nightkid
LQ Newbie
 
Registered: Apr 2008
Distribution: openSuSe and PCLinuxOS
Posts: 23

Rep: Reputation: 0
Trying to migrate out of an OLD version of bugzilla.. I cannot find the DB


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..

Quote:
#mysqldump -u root -p --databases bugs > /home/bugs.db.backup

mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
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/
 
Old 02-13-2012, 07:32 PM   #2
klearview
Member
 
Registered: Aug 2006
Location: London
Distribution: Debian, Kubuntu
Posts: 572

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

Quote:
cat /etc/mysql/my.cnf | grep -B 2 sock
Quote:
ps ax | grep mysql
Also what's your distro?
 
1 members found this post helpful.
Old 02-16-2012, 12:02 PM   #3
hwy9nightkid
LQ Newbie
 
Registered: Apr 2008
Distribution: openSuSe and PCLinuxOS
Posts: 23

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by klearview View Post
Let's see what you get from these 2 first:...
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



Quote:
Originally Posted by klearview View Post
Also what's your distro?
this is RedHat Linux 2.4.21-60.EL #1 Mon Aug 24 20:25:55 EDT 2009 i686 i686 i386 GNU/Linux

Last edited by hwy9nightkid; 02-16-2012 at 12:07 PM.
 
Old 02-16-2012, 12:25 PM   #4
klearview
Member
 
Registered: Aug 2006
Location: London
Distribution: Debian, Kubuntu
Posts: 572

Rep: Reputation: 75
Ok, things are clearer now.

Quote:
# ps ax | grep mysql
5845 pts/0 S 0:00 grep mysql
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
Quote:
error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
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.
Old 02-16-2012, 02:28 PM   #5
hwy9nightkid
LQ Newbie
 
Registered: Apr 2008
Distribution: openSuSe and PCLinuxOS
Posts: 23

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by klearview View Post
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?
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.

Last edited by hwy9nightkid; 02-16-2012 at 05:05 PM.
 
Old 02-17-2012, 04:50 AM   #6
klearview
Member
 
Registered: Aug 2006
Location: London
Distribution: Debian, Kubuntu
Posts: 572

Rep: Reputation: 75
Quote:
Originally Posted by hwy9nightkid View Post
...could there be some... non-standard second mysql installation?...
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.
Old 02-18-2012, 01:41 AM   #7
hwy9nightkid
LQ Newbie
 
Registered: Apr 2008
Distribution: openSuSe and PCLinuxOS
Posts: 23

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by klearview View Post
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.
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.
 
Old 02-21-2012, 02:41 AM   #8
hwy9nightkid
LQ Newbie
 
Registered: Apr 2008
Distribution: openSuSe and PCLinuxOS
Posts: 23

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by klearview View Post
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.
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.

Last edited by hwy9nightkid; 02-21-2012 at 02:48 AM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
I can't find the new version of /initrd-[generic-]version.img temp2012temp Linux - Newbie 1 01-05-2012 11:08 AM
[GNU find version 4.2.27] find: paths must precede expression mechagojira Linux - Newbie 3 07-06-2011 06:34 AM
migrate from suse, what should i migrate to? any suggestions?:twocents: Siljrath Linux - General 4 12-26-2005 02:14 PM
HELP: can't find Bugzilla to report crashes kevingpo Fedora 1 08-11-2005 08:50 PM
Find out distribution + version (NOT: kernel version!) Tajci Red Hat 5 06-08-2005 04:17 PM


All times are GMT -5. The time now is 09:05 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration