Flat-file to MySql conversion

Get help with installation and running PivotX 2.0.x here. Please do not post Extension or Theme related questions here.

Flat-file to MySql conversion

Postby wheels » Thu Jan 15, 2015 1:54 pm

Hi
I currently have a site that I run using Pivotx with flat-files. I would now like to run it using a mysql database.

I have created the database, but when I connect to it in the Pivotx control panel all the existing entries/pages/comments etc disappear. A new test page created after connecting to the Database shows correctly, so I know that there is nothing wrong at that end.

Is there a simple way to import the existing flat-files to the database?

Any help (preferably in very simple terms) will be gratefully received.

Phil
wheels
 
Posts: 8
Joined: Tue Dec 17, 2013 12:45 pm

Re: Flat-file to MySql conversion

Postby Harm10 » Thu Jan 15, 2015 5:12 pm

You can use the script mentioned in http://forum.pivotx.net/viewtopic.php?f=2&t=3375
But it only imports entries. What to do to let it also import pages is also mentioned in this post (I could do that for a reasonable fee).
Quality is in the detail of things............

Want to change or update your PivotX site? Mail or PM me!
I can also convert your site to a Wordpress site!
Harm10
Developer
 
Posts: 2010
Joined: Wed Jun 17, 2009 9:37 am
Location: Somewhere in The Netherlands (aka Holland)

Re: Flat-file to MySql conversion

Postby wheels » Fri Jan 16, 2015 12:31 am

Thanks.

That will be useful.

As the site is free, it has no income at all, so I can't pay you to sort this out for me - I did it to support local farmers and small food producers when I retired on a disability pension.

I wish it was otherwise, as Pivotx is great and you've obviously done a major amount of work to create it.

Phil
wheels
 
Posts: 8
Joined: Tue Dec 17, 2013 12:45 pm

Re: Flat-file to MySql conversion

Postby Harm10 » Fri Jan 16, 2015 7:35 am

You didn't post a link to your site. If you do not have a lot of pages then you can also copy them easily by hand (just install your back-up into another folder as a flat file again and access the page's content).
How much pages and entries do you have?
Quality is in the detail of things............

Want to change or update your PivotX site? Mail or PM me!
I can also convert your site to a Wordpress site!
Harm10
Developer
 
Posts: 2010
Joined: Wed Jun 17, 2009 9:37 am
Location: Somewhere in The Netherlands (aka Holland)

Re: Flat-file to MySql conversion

Postby wheels » Fri Jan 16, 2015 1:25 pm

Sorry, the site is:

http://www.localfoodheroes.co.uk

I don't have many pages so I can just copy them across.

I also have another site that I will change in due course:

http://www.thurlastononline.co.uk

It the website for the village where I live, and again is done at my expense.

Many thanks again for your help.

Phil
wheels
 
Posts: 8
Joined: Tue Dec 17, 2013 12:45 pm

Re: Flat-file to MySql conversion

Postby Harm10 » Fri Jan 16, 2015 4:57 pm

So if you have few pages you can import the entries yourself using the script?

If you want someone to help perhaps use PM?
Quality is in the detail of things............

Want to change or update your PivotX site? Mail or PM me!
I can also convert your site to a Wordpress site!
Harm10
Developer
 
Posts: 2010
Joined: Wed Jun 17, 2009 9:37 am
Location: Somewhere in The Netherlands (aka Holland)

Re: Flat-file to MySql conversion

Postby wheels » Fri Jan 16, 2015 5:58 pm

Yes, many thanks. I've now done it.

Phil
wheels
 
Posts: 8
Joined: Tue Dec 17, 2013 12:45 pm


Return to 2.x Support Forum

Who is online

Users browsing this forum: Bing [Bot] and 2 guests

cron