Sorry to persist but it didnt work or I didnt follow it properly...!!
A fresh installation requires me to create a new admin and a new blank database where all blank tables of new installations appear...!!
My older backup taken with help of MySQL Workbench (outside the forum) is complete backup, which when imported using PhpMyAdmin restores everything using the old db name... Shouldnt that backup already have the admin and a database name where it was running last...??
Sorry but I seem to be missing some step in between...!!!
Would you pls confirm that in my situation, I would need a fresh installation to be first done, right...?? This would involve all the routine steps like creating a blank db first and running /install/index.php and it would take me thru all the steps of asking for blank db name, db server, db login, db password etc and finally would ask me to 'create' a new admin with fresh password etc...!!! Once done, I delete Install Folder and end up with a blank forum...!!!
Where do I go next from here using my backup of previous forum...??
in your first post you said you already installed a fresh board on the new server.
therefore, if you then import your old database backup using phpmyadmin to the new fresh database, it will overwrite the new with the old. you will then need to check that the info in the config.php file is correct.
it should be except for possibly the table prefix. make sure that the table prefix of the old database is what you are using in the new config.php file.
the database import will overwrite all the data in the new database. therefore, your admin account will be exactly the same as it was for the old board.
1) Installed the new board on my new webserver, after creating a 'blank' db with exact same name as my old board...
2) Chose the same admin username and password when prompted while installing the new board...
3) Didnt fiddle with table name prefixes too...!!!
4) using PhpMyAdmin, imported the dump.sql file of old board and it successfully was imported ("Import has been successfully finished, 1045 queries executed. (Dump20161009.sql)")
5) Then tried running localhost/index.php and following is what I got...
"Fatal error: Uncaught exception 'Twig_Error_Loader' with message 'Unable to find template "index_body.html" (looked into: ).' in C:\xampp\htdocs\amforum\vendor\twig\twig\lib\Twig\Loader\Filesystem.php:215 Stack trace: #0 C:\xampp\htdocs\amforum\phpbb\template\twig\loader.php(107): Twig_Loader_Filesystem->findTemplate('index_body.html') #1 C:\xampp\htdocs\amforum\vendor\twig\twig\lib\Twig\Loader\Filesystem.php(139): phpbb\template\twig\loader->findTemplate('index_body.html') #2 C:\xampp\htdocs\amforum\vendor\twig\twig\lib\Twig\Environment.php(312): Twig_Loader_Filesystem->getCacheKey('index_body.html') #3 C:\xampp\htdocs\amforum\vendor\twig\twig\lib\Twig\Environment.php(378): Twig_Environment->getTemplateClass('index_body.html', NULL) #4 C:\xampp\htdocs\amforum\phpbb\template\twig\environment.php(151): Twig_Environment->loadTemplate('index_body.html', NULL) #5 C:\xampp\htdocs\amforum\vendor\twig\twig\lib\Twig\Environment.php(362): phpbb\template\twig\environment->loadTemplate('index_body.html') #6 C:\xampp\htdocs\amforum\p in C:\xampp\htdocs\amforum\vendor\twig\twig\lib\Twig\Loader\Filesystem.php on line 215"
Would greatly appreciate any help on this....!!!
My earlier board, whose backup I have, is phpbb 3.0.x and the new one is 3.1.x...
david63 wrote:If it does then try re-uploading it as it may be corrupt.
Did that quite a few times... Downloaded the latest forum files from download section and unzipped them and placed them in the server root... Repeated the same exercise quite a few times by now but each time the error appears... ...!!
This contains your extensions and any of your core modifications.
2) Your databazse SQL file. This containes all the settings and posts
Do this:
Rename the site location in the ACP to reflect your new domain if you have a new domain. You probably can also do this in Xampp in localhost/phpmyadmin. Make sure your port is correct as well. Either 80 or 443 if you use SSL.
Upload that database file to your live host's phpmyadmin. Change the options in the config.php file to reflect your new database.
Upload your public_html files to the public_html folder.
Now delete everything in the cache folder except index.html and .htaccess.
That's a basic way of doing this. I have transferred my forum before and configured a complete forum in Xampp and installed it on a live website. Although, I had to use Notepadd++ and change the engine in the database to MyISAM for some reason.
Bringing this issue up again for any other inputs which I can try...!!! I am still trying with the migration of my existing forum from existing webserver to the new webserver...!!
Some additional info, which I just happen to notice, is that my existing forum (the one which is running and I intend to shift to new webserver) uses MySQL Software Version 5.5.6-rc. The xampp installation which I am trying to import the old forum on, says its database is 10.1.16-MariaDB.... Are the two same and should seamlessly import from the former....??
Could this be a cause of all those errors that are being flashed after a seemingly succesfull db import process...?? Just thot to share this info, as it was not mentioned anywhere in the earlier posts...