Importing Pages With PhpMyAdmin
Dominik
Hi there
I exported the pages from #sppagebuilder using phpMyAdmin and now wanted to import them into the new database. I searched for #sppagebuilder in the new database and found it, selected the database, went to import, and imported it. Logically, the database has a different prefix, and I can see it. But how do I get the records with the pages into #sppagebuilder? They have to go in there, right? Or have I completely misunderstood something?
Thank you Dominik
Paul Frankowski
Accepted AnswerUsing Export-Import method you can import only whole new table.
If you have old one, just rename its name before using Import.
Paul Frankowski
Accepted AnswerHi Dominik
Read > https://www.joomshaper.com/documentation/sp-page-builder/database-tables-used-by-sppb
Indeed, prefix_sppagebuilder is the most important, but it contains only main content.
if you want to import whole SPPB (from site A to site B), export table(s) , then rename prefix to new one inside .sql file before import, Use Find & Replace. Save changes.
And then using PHPMyAdmin use Import from file. As last step, using FTP copy image files.
Dominik
Accepted AnswerHi Paul
Thank you very much. Unfortunately, I get an error message in phpMyAdmin saying that the table already exists and cannot be imported into #_sppagebuilder. I'm a bit at a loss...