[SOLVED] Data Migration problem

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Joele25
Registered User
Posts: 15
Joined: Sat Jul 23, 2016 1:24 pm

[SOLVED] Data Migration problem

Post by Joele25 » Thu Mar 14, 2019 9:44 pm

Hi, so today I bought a new server for my website and I got stuck trying restoring the forum.
This is what I did:
I went to the mysql folder and copy the "forum" folder directly into the same directory but in my new server so from "/var/lib/mysql/forum" to "/var/lib/mysql/forum" but in another server. Set the folder and files to mysql:mysql with main folder 755 and files 660.
Then I did the same thing with the forum folder from "/var/www/vhosts/deltaforceitalia.eu/httpdocs/forum" to "/var/www/vhosts/deltaforceitalia.eu/httpdocs/forum" also set the files permissions but with no chown.
I set the dns so my domain is setted to the new IP and then I tried to connect to my forum at https://deltaforceitalia.eu/forum/index.php.
As you can see if you go there it says

Code: Select all

SQL ERROR [ mysqli ]

Table 'forum.phpbb_config_text' doesn't exist [1146]

SQL

SELECT * FROM phpbb_config_text WHERE config_name = 'reparser_resume'

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 997
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/config/db_text.php
LINE: 133
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/phpbb/config/db_text.php
LINE: 68
CALL: phpbb\config\db_text->get_array()

FILE: [ROOT]/phpbb/textreparser/manager.php
LINE: 63
CALL: phpbb\config\db_text->get()

FILE: [ROOT]/phpbb/cron/task/text_reparser/reparser.php
LINE: 88
CALL: phpbb\textreparser\manager->get_resume_data()

FILE: [ROOT]/cache/production/container_4335734bbdd20f586549a504dff5f80c.php
LINE: 1341
CALL: phpbb\cron\task\text_reparser\reparser->set_reparser()

FILE: [ROOT]/vendor/symfony/dependency-injection/Container.php
LINE: 297
CALL: phpbb_cache_container->getCron_Task_TextReparser_PmTextService()

FILE: [ROOT]/vendor/symfony/dependency-injection/ContainerBuilder.php
LINE: 442
CALL: Symfony\Component\DependencyInjection\Container->get()

FILE: [ROOT]/phpbb/di/service_collection.php
LINE: 72
CALL: Symfony\Component\DependencyInjection\ContainerBuilder->get()

FILE: [ROOT]/phpbb/di/service_collection_iterator.php
LINE: 44
CALL: phpbb\di\service_collection->offsetGet()

FILE: [ROOT]/phpbb/cron/manager.php
LINE: 59
CALL: phpbb\di\service_collection_iterator->current()

FILE: [ROOT]/phpbb/cron/manager.php
LINE: 46
CALL: phpbb\cron\manager->load_tasks()

FILE: [ROOT]/cache/production/container_4335734bbdd20f586549a504dff5f80c.php
LINE: 1160
CALL: phpbb\cron\manager->__construct()

FILE: [ROOT]/vendor/symfony/dependency-injection/Container.php
LINE: 297
CALL: phpbb_cache_container->getCron_ManagerService()

FILE: [ROOT]/vendor/symfony/dependency-injection/ContainerBuilder.php
LINE: 442
CALL: Symfony\Component\DependencyInjection\Container->get()

FILE: [ROOT]/includes/functions.php
LINE: 4693
CALL: Symfony\Component\DependencyInjection\ContainerBuilder->get()

FILE: [ROOT]/index.php
LINE: 246
CALL: page_footer()
What should I do now? I also tried to do a fresh install and then restore the database in the ACP but It doesn't work because it just load for an eternity of time.
Last edited by Joele25 on Sun Mar 17, 2019 11:09 am, edited 1 time in total.

User avatar
Lumpy Burgertushie
Registered User
Posts: 65886
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Data Migration problem

Post by Lumpy Burgertushie » Thu Mar 14, 2019 10:11 pm

as far as I know that is not how you transfer a database.

you need to go back to the old server, use phpmyadmin or whatever database management tool you have and export the old database to your computer as a sql file.

then, on the new server, you have to create a new blank database and import your sql file into it.
then you have to edit the config.php file in your phpbb files to reflect the new database name, usernmame/password etc.

then it should work.


robert
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

Joele25
Registered User
Posts: 15
Joined: Sat Jul 23, 2016 1:24 pm

Re: Data Migration problem

Post by Joele25 » Fri Mar 15, 2019 12:41 am

I also tried that way but it's the exact same

.m.
Registered User
Posts: 363
Joined: Wed Nov 04, 2009 8:39 pm

Re: Data Migration problem

Post by .m. » Fri Mar 15, 2019 4:04 am

^ now it looks like you have succeeded the task :)

User avatar
Mick
Support Team Member
Support Team Member
Posts: 20711
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: Data Migration problem

Post by Mick » Fri Mar 15, 2019 8:43 am

For future reference the knowledge base is always a good place to start in such matters, this Knowledge Base - Transferring Your Board to a New Host or Domain specifically in your case.
"The more connected we get the more alone we become" - Kyle Broflovski

There are no ‘threads’ in phpBB, they are topics.

Joele25
Registered User
Posts: 15
Joined: Sat Jul 23, 2016 1:24 pm

Re: Data Migration problem

Post by Joele25 » Sun Mar 17, 2019 11:08 am

I have solved this, some mysql problem was going on. now It's fixed

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: AngelM, garfy and 18 guests