Author Topic: Backup products and categories  (Read 4924 times)

alexsai

  • Beginner
  • *
  • Posts: 40
Backup products and categories
« on: October 17, 2011, 15:51:34 pm »
Hi developers,
is there a way to backup and restore products?
Is it possible just to export the products table or it is linked with others tables?
This would be very usefull when something go bad and you have to reinstall VM from zero ( i did it so many times in the last weeks ).
Thx

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10406
  • VirtueMart Version: 3+
Re: Backup products and categories
« Reply #1 on: October 17, 2011, 16:43:21 pm »
yes, akeebah backup is what you need,


https://www.akeebabackup.com/
J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)

alexsai

  • Beginner
  • *
  • Posts: 40
Re: Backup products and categories
« Reply #2 on: October 17, 2011, 17:09:02 pm »
It seems a damn well done component, it will be very usefull.

But i have another question, let's make an example.
If I use VM RC2i and I backup all the product tables will I be able to restore them in version VM RC2m ( assuming that the structure of those tables is unchanged ).
es..
#__virtuemart_product_categories
#__virtuemart_product_customfields
#__virtuemart_product_downloads
#__virtuemart_product_manufacturers
#__virtuemart_product_medias
#__virtuemart_product_prices
#__virtuemart_product_relations
#__virtuemart_products

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10406
  • VirtueMart Version: 3+
Re: Backup products and categories
« Reply #3 on: October 17, 2011, 17:31:28 pm »
y not just backup the whole site?

J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)

alexsai

  • Beginner
  • *
  • Posts: 40
Re: Backup products and categories
« Reply #4 on: October 17, 2011, 17:39:51 pm »
Sometimes it happen to me that the upgrade system broke VM and i had to install from zero. 
I want to preserv only products data in order to load it in the fresh version. Like from i to l version.

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10406
  • VirtueMart Version: 3+
Re: Backup products and categories
« Reply #5 on: October 17, 2011, 17:44:28 pm »
ok, well akeebah has a restore point that saves a small backup anytime an update/or extension install occurs.

I dont know if its in the free, or pro version.

Its called "restore points" or something like that
J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10040
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Backup products and categories
« Reply #6 on: October 17, 2011, 18:49:32 pm »
hello alexsai. I am sorry that you had to reinstall vm2 so often again. When you want to backup your products, you must store all tables with virtuemart_product*, as you already described above.

But you should know that since RC2a or so,.. all virtuemart installers upgrade your database. When you want todo that manually, go to tools and use
"Install tables or if necessary update them". You can press this button as often as you want. You can always reset your database tables with the comands "Reset all tables and ....". This commands delete ALL virtuemart_ tables and execute the same sql as the installer. 
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

alexsai

  • Beginner
  • *
  • Posts: 40
Re: Backup products and categories
« Reply #7 on: October 17, 2011, 20:12:46 pm »
@BanquetTables.pro
 I seen that the selection of single components is a pro version feature. Anyway thanks, this is a great tool!

@Milbo
No problem, that's the price to pay for using a beta version :)
I used a lot the "reset function", it's very usefull. I'll try the other one soon. Thx!