Due to incompatibility issues with my host's version of MySQL, I need to move the database only (not the XOOPS directory) to a different server with a compatible version of MySQL. Is this possible, and if so, do I need to change anything other than the mainfile.php?

Thanks in advance!

Dana

hhttps://xoops.org/modules/smartfaq/category.php?categoryid=19

I think that section of the FAQ may answer the questions you have :)

Yes it is possible, as long as the data is not damaged by the incompatibilities. See my article here: MySQL Database Restore. This method uses either the MySQL commandline, or Cron for import.

And see: XOOPS Site Migration for methods using phpmyadmin.

HTH.

Thanks for the replies! I plan on using phpmyadmin to do this. Thankfully, the data is not damaged.

Thanks!

I am try to change host..

I have uploaded database to new sever with php my admin no worries

copied exactly my folder to new host and tried to configure mainfile.php

i get this error
Warning: main(http//:mydomain.com/~patsy/include/common.php): failed to open stream: No such file or directory in /home/patsy/public_html/mainfile.php on line 93


I cannot figure out why it keeps looking at this No such file or directory in /home/patsy/public_html/mainfile.php on line 93 cause there is no /home/patsy/public_html/mainfile.php thats a string off the old host.

any ideas??

If you already changed the paths in mainfile.php, clear your cache and template_c folders, some files pointing to the old hosts may be there.

Thanks JD but i still get the following errors

Warning: main(http//:mydomain.com/~patsy/public_html/include/common.php): failed to open stream: No such file or directory in /home/patsy/public_html/mainfile.php on line 93

Warning: main(http//:mydomain.com/~patsy/public_html/include/common.php): failed to open stream: No such file or directory in /home/patsy/public_html/mainfile.php on line 93

Warning: main(): Failed opening 'http//:mydomain.com/~patsy/public_html/include/common.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/patsy/public_html/mainfile.php on line 93

Warning: main(http//:mydomain.com/~patsy/public_html/class/xoopsblock.php): failed to open stream: No such file or directory in /home/patsy/public_html/header.php on line 28

Warning: main(): Failed opening 'http//:mydomain.com/~patsy/public_html/class/xoopsblock.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/patsy/public_html/header.php on line 28

Warning: main(http//:mydomain.com/~patsy/public_html/class/template.php): failed to open stream: No such file or directory in /home/patsy/public_html/header.php on line 62

Fatal error: main(): Failed opening required 'http//:mydomain.com/~patsy/public_html/class/template.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/patsy/public_html/header.php on line 62


have checked cache and templates permissions and deleted all files inside these folders not sure where to look now

Have you double checked the physical path in mainfile.php?

Okay i have now got it running in a fashion
this was the problem in case this helps anyone else.

My hosting is cpanel enabled. thet path they gave me was
http//:mydomain.com/~patsy/public_html
but if i drop the ~
and just put /home/patsy/public_html
It starts to run.


So my site is going on the new server but the theme is not there, in fact there is no styling what so ever so it must be permissions in the themes...


Can someone tell me what module folders require being set to 777??

running all standard modules and xcgallery
cheers
Gecko

Hmmmmmmm no good
I have the front page with no styling
but click a link and it tries to look at this sort of path like it is doubling up

http://mydomain.com/~patsy/http//:mydomain.com/patsy/modules/news/article.php?storyid=106

any help would be appreciated