VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: kiro789 on October 09, 2015, 10:58:44 AM

Title: Rebuild Virtuemart + Joomla
Post by: kiro789 on October 09, 2015, 10:58:44 AM
Hello,
I have one Joomla 3 and Virtuemart 3 site. What I want to do is:
I want to build the site again with frish joomla installation and virtuemart (because I have too many exentions and modules installed and I have some viruses in the site) I want to rebuild the site again, but I have 2000 products which I want to move.
My Plan is:
1. I will create a subdomain
2. build a new joomla on the subdomain
3. download and install the virtuemart
4.Buy new Virtuemart template
And than? Which database should I move?
Any help will be good
Regards!
Title: Re: Rebuild Virtuemart + Joomla
Post by: GJC Web Design on October 09, 2015, 11:39:57 AM
5. move only the tables that you require from the old DB to the new

6. run the Joomla & VM table updaters to ensure they are to date
Title: Re: Rebuild Virtuemart + Joomla
Post by: elleclouds on October 21, 2015, 23:02:58 PM
Quote from: GJC Web Design on October 09, 2015, 11:39:57 AM
5. move only the tables that you require from the old DB to the new

6. run the Joomla & VM table updaters to ensure they are to date

would this work if I am going from Joomla 2.5 to Joomla 3.0 and VM2 to VM3 in the process?
Title: Re: Rebuild Virtuemart + Joomla
Post by: GJC Web Design on October 21, 2015, 23:37:17 PM
install a fresh J2.5 -- install VM 2.6

move the required tables

upgrade VM to 3

upgrade J to 3

apply template
Title: Re: Rebuild Virtuemart + Joomla
Post by: elleclouds on October 22, 2015, 18:51:40 PM
Quote from: GJC Web Design on October 21, 2015, 23:37:17 PM
install a fresh J2.5 -- install VM 2.6

move the required tables

upgrade VM to 3

upgrade J to 3

apply template

Moving the tables is in the phpmyadmin.. that I know.  Is there a tutorial on how to actually move export and import just the VM tables.  Does the prefix matter also?
Title: Re: Rebuild Virtuemart + Joomla
Post by: GJC Web Design on October 22, 2015, 19:38:38 PM
you just use the database view in phpmyadmin .. tick anything you want .. e.g. all starting with #__virtuemart_xxx

then with chosen tables export..  simple  so you have a .sql file

D/L and open in Notepad++  etc and change the prefix to the new DB one

Drop or rename all the #__virtuemart_xxx tables in the new

then import the .sql file you have

then run the VM Tools table updater
Title: Re: Rebuild Virtuemart + Joomla
Post by: Milbo on November 27, 2015, 14:05:37 PM
http://docs.virtuemart.net/tutorials/installation-migration-upgrade/198-upgrade-virtuemart-2-to-virtuemart-3.html