Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Copying SQL AriQ data
(1 viewing) (1) Guest
component
Go to bottomPage: 12
TOPIC: Copying SQL AriQ data
#71895
Copying SQL AriQ data 2 Months, 3 Weeks ago Karma: 1
Hi, Im about to move my AriQ from an old site to new, but need to copy the AriQ SQL tables - is there an easy way to do this? Now that I'm in PHPmyadmin it doesnt look straightforward? Maybe it's easy but some guidance would be appreciated. TIA
The administrator has disabled public write access.
 
#71898
Re:Copying SQL AriQ data 2 Months, 3 Weeks ago Karma: 748
Hello,

PHPMyAdmin supports import/export functionalities. You can export DB tables (structure and data) to SQL file and then use this file to import DB table to another database. Make sure an appropriate DB prefix will be used (J! 2.5 and J! 5 can use different DB table prefix).

Regards,
ARI Soft
The administrator has disabled public write access.
 
#71899
Re:Copying SQL AriQ data 2 Months, 3 Weeks ago Karma: 1
Thanks, I think if I want to export the AriQ tables with phpadmin I have to do one at a time? (select table, dump all rows?)

or is there a way to do all of the AriQ tables at once?

can I modify the prefix after import to new J5 DB? - the prefixes are different and this is the bit I am uncertain of.
The administrator has disabled public write access.
 
#71900
Re:Copying SQL AriQ data 2 Months, 3 Weeks ago Karma: 748
You can choose as many tables as you want on "Export" tab in PHPMyAdmin:



It will generate .sql file. You can open it in any text editor and use find/replace functionality to change table prefix.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#71901
Re:Copying SQL AriQ data 2 Months, 3 Weeks ago Karma: 1
Perfect thanks. I think Ive managed to import the old db into the new, but after installing AQ in the J5 I get:


- Points rules were not installed becased EasySocial component is not installed.

- Extension Install: Custom install routine failure.

Its possible this is because I had some custom coding done by you when I first purchased AQ - not sure, but perhaps I may need to update the new sites code?


Any help appreciated
Last Edit: 2024/04/06 18:28 By munchman007.
The administrator has disabled public write access.
 
#71902
Re:Copying SQL AriQ data 2 Months, 3 Weeks ago Karma: 748
1. Do you need integration with EasySocial?

2. Could you specify when this error occurs? When install the latest version of "ARI Quiz"? What's custom customization were made?

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 12