I have been using bugzilla 2.20 in windows environment, now i have installed VBS and want to import the entire mysql database from existing bugzilla to newly installed VBS mysql, how do i do that?

See our upgrade guide for migrating from previous version of VBS. It is not exactly about importing from MySQL backup, but it is a very similar thing.

--Igor

i have bugzilla2.20 version, i have exported the sql file from mysql as backup export through mysql administrator application, can i import the same sql file into my vbs mysql to restore the old database bugs? is it safe? is there any changes in database structure in 3.0 since 2.20?

Of course db structure has changed, so you need to:
1. create empty database
2. import your backup sql into the new database
3. edit "localconfig" file in bugzilla home dir and set new database name, user and password
4. run "./checksetup.pl" in bugzilla home to update new db structure for Bugzilla 3.0

Hope this helps!
Best regards,
Igor

Awesome, it worked, i took backup from my existing mysql using administrator applcation and i used WinSCP to transfer backup sql files between my windows machine and VBS. my bugzilla is up and running

me too wondering... anybody there?

Hey, Raja, what's up? Glad to hear you managed to get it working.

--Igor

Hey Igor, glad ur back....
I need to install testopia bug fix, to up and running testopia, but my VBS machine doesnt have internet access, can i download those patches manually and install to run testopia? if there's possibility please let me know the list of files needs to be downloaded or link for it. and location to install the patch...

thanks again.

Raja

Raja, I see the problem. Manual download may be a tedious task, because when you download using CPAN, all required packages are also automatically downloaded, and if you are going to manually download them you'll have to look for dependencies by yourself.

If it's possible to temporarily give internet access to the VBS, that would be the best way to go. Otherwise, you can visit cpan.org, find & download JSON, try to install it, and if it needs other packages, download and install those too.

Best regards,
Igor

This second option to download everything by myself sounds scary, i have internet access to my windows machine IP, as you know VBS will have different IP and that IP has no permission to connect to internet, my question here is, by any means can i share the internet access between my window system and VBS(different IP).

Raja, you can switch Ethernet connection type to "NAT" (click on the network card image on the VMWare window), that way VBS will share the host IP address for the purpose of internet access. If you previously configured a static IP, you'll to temporarily switch back to DHCP.

Cheers,
Igor

This seems to be working(connecting to server), this time i get differnt error message.

logging in as anonymous
error in server response, closing control connection.
retrying.

And Finally, it said "giving up" and Could not fetch modules/03modlist.data.gz ....etc

what can be done at this stage? Please view the screenshots.

Raja, sorry for a late reply. This really looks strange. I'm afraid I can't determine what the problem is just by looking at these screenshots, sorry. I hope you can dig into that yourself or wait until VBS 2.1 is out there. If there are commercial interests at stake, you can consider hiring a professional sysadmin through us to fix your VBS, though it is quite expensive.

Best regards,
Igor

I Moved the VBS folder from my system to my laptop and connected to Internet and tried the steps, it has downloaded the patch, its working fine.

I have moved the backup sql file from existing to vbs, imported database is reflected in bugzilla3.0, but i cant see any difference in bugzilla2.22(testopia). where do i import the backup sql for bugzilla2.22(testopia) and if there's any special steps to be followed other than normal import method specified in upgrade steps.

Raja, testopia uses database named "testopia" and home directory "/home/testopia". You can use the same import procedures, only with appropriate database name. Also, after running checksetup.pl I would advise running tr_install.pl also.

Hope this helps!
Igor

I cant login to testopia bugzilla(both with the admin/admin and old bugzilla id),
this is what i did
I created sql dumb file from exisitng bugzilla's mysql database using administrator tool,
I copied that sql file to ( /home/bugzilla/backup/sqlfile/backup.sql )
I dropped the existing testopia database (mysql -uroot -proot -e 'drop database testopia'
i recreated new database (mysql -uroot -proot -e 'create database testopia character set utf8'

i imported database,
i reached the folder /backup/sqlfile and used this command: mysql -uroot -proot testopia <backup.sql

it didnt return any error.
I reached this folder /home/testopia, and used the following commands: perl checksetup.pl and then perl tr_install.pl

then i opened testopia, when i opened it i cant login both with the default admin/admin account as well as the account existed in older bugzilla database.

what went wrong?
and then, when is vbs next release coming up?

The actions you describe seem correct. What does it say when you try to log in?

At this point, I would check the following:
a) what users are in the database (select login_name, cryptpassword from profiles;)
b) bugzilla parameters (file data/params -- you would normally edit them through web interface, but when you can't login you can edit them manually)
c) localconfig file -- to see if testopia really connects to "testopia" db.



I hope we'll have it ready this month, more probably by the end of it. I understand you need it very much, and I can promise we'll work on it as soon as we can, but no sooner, sorry.

Best regards,
Igor

using new version of VBS21
logged in using bugzilla/bugzilla account.

There is no "/home/testopia" directory under /home there is "bugzilla" and "grml" is testopia directory elsewhere?

Hi Raja,

Sorry, it's "/testopia".

Best regards,
Igor

Hi,
I created shortcut link for vbs/addon/testopia in /home/testopia and continued with others steps. its working great.

regarding database backup, i had problem directly using the sql file generated using mysql admistrator in windows machine to my testopia database, there is no problem if the sql file used in bugs. i restored this database file to bugs and from bugs i took backup using mysqldump and used that sql to testopia database, its working now.

How do you import the database in the vm? I can't seem to figure this part out.

You can use ftp or scp, for example:
On VMWare other than Player, you can also use shared host folders.

Hope this helps!
Igor

What is File name with extension of database file in Bugzilla ? I want to know exact file name of database where all bugs stored .
Thanks