migrading cms pages

[nickon]

Hi all, 

A prestashop site is too messed up to migrate. So I was thinking to do a fresh tb install and migrade thing manually. the only thing I don't know how to migrade are the cms pages. I was thinking to export the pages via phpmyadmin and then importing to tb

Does anyone has an idea on how to do this ?

Kind Regards

Edited September 1, 2019 by nickon

[DRMasterChief]

Hmm yes, simply export these files via  phpmyadmin  or just safe them as  plain txt,  then import it.  I think CMS sites are not that numerous and big than items ?!? 

 

Good luck!  Maybe you will let us know when you are finished and 'how to' do this. 

[nickon]

43 minutes ago, DRMasterChief said:

Hmm yes, simply export these files via  phpmyadmin  or just safe them as  plain txt,  then import it.  I think CMS sites are not that numerous and big than items ?!? 

 

Good luck!  Maybe you will let us know when you are finished and 'how to' do this. 

I was hoping somebody could post a sql query on how to do this 🙂 I could copy paste them as txt but I don't want to risk loosing id's  structure etc.. 

[movieseals]

Just select the cms pages tables in your old prestashop database and export those via PHPmyAdmin.

Then modify the sql tables names in any text editor to reflect the name of your TB table - ex. ps_cms to tb_cms

Then import those tables in your TB database using the import function of PHPmyAdmin and you are done.

[DRMasterChief]

1 hour ago, movieseals said:

...Then modify the sql tables names in any text editor to reflect the name of your TB table - ex. ps_cms to tb_cms...

That was my idea with  plain txt  thing,  movieseals was more detailed about this.

[nickon]

1 hour ago, DRMasterChief said:

That was my idea with  plain txt  thing,  movieseals was more detailed about this.

Yeah I missed the database name change. moving on...

Thanks all

Edited September 1, 2019 by nickon