Migrating Fabrik Tables/Forms/etc. to another Joomla Site

[tyrusmanuel]

I have been doing some serious dev on a sandbox with Fabrik and am ready to start migrating stuff over to the live site. Normally an export CSV and import would be fine, however as Hugh can attest, I have some serious entanglements between various tables and forms and joins. So I was wondering if anyone has done any serious fabrik migrations or if there are any best practices that anyone has found.

I don't want to recreate all this stuff from scratch, mainly because I am not sure it will work again

Thanks!!

[cheesegrits]

At the moment, the best way is:

Apply latest SVN to sandbox, make sure everything works.
Install Fabrik on live site, and upgrade to latest SVN .
Export all the Fabrik internal tables (jos_fabrik_whatever), and your own data tables from the sandbox, and import them into the live site, using your tool of choice (phpMyAdmin, NaviCat, etc).
On the live site, go to the Fabrik Connections tab, edit and save the default site connection one time.
If you have custom file system based content, like uploaded files, script files, templates etc, copy those over.

We are working on our "Packages" feature, which when done will allow you to select a group of tables/forms on the sandbox, export them and import them into Fabrik on the live site. Which will make this whole process a lot easier. But for now ... the above is the best way of doing it.

-- hugh

	SVN SVN (short for Sub Version) is the source code control system we use to manage the Fabrik code with. The SVN will always contain bug fixes and new features which have been added since the last ZIP in the downloads area was built. We allow public access to our SVN repository, so users always have access to the latest and greatest version. Click the link next to this popup to go to a page which describes how to access our SVN repository.

[tyrusmanuel]

Thanks Hugh! I will give that a shot.

[iidx036]

I moved my Joomla site from one server to another only yesterday. It was also a different domain name (don't know whether your in the same boat?)

I did the following:

1. Export the whole Joomla db using phpmyadmin.
2. FTP everything under public_html to the the other server.
3. Create the new db on the new server using phpmyadmin.
4. Import the .sql file using phpmyadmin.
5. Edit configuration.php to reflect the new paths for logs etc and change the domain name.

It really was easy to do - don't know if that helps and if you need anymore info then give me a shout.

Cheers

Jay

[cheesegrits]

Don't forget to go to the Fabrik Connections page, and edit and save the default site connection one time. This isn't always necessary (if the database name / username / password for the site connection are all the same) but is worth doing just to make sure.

-- hugh