1
msdana
Need to move database
  • 2006/1/24 1:14

  • msdana

  • Just can't stay away

  • Posts: 817

  • Since: 2005/12/11


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
[size=x-small]If God is watching us, the least we can do is be entertaining.[/size]
Graphic Worx : Xoops Themes

2
Lourdes
Re: Need to move database
  • 2006/1/24 1:32

  • Lourdes

  • Not too shy to talk

  • Posts: 119

  • Since: 2005/2/26


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

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

3
jdseymour
Re: Need to move database

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.

4
msdana
Re: Need to move database
  • 2006/1/24 1:37

  • msdana

  • Just can't stay away

  • Posts: 817

  • Since: 2005/12/11


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

Thanks!
[size=x-small]If God is watching us, the least we can do is be entertaining.[/size]
Graphic Worx : Xoops Themes

5
gecko
Re: Need to move database
  • 2006/1/24 8:48

  • gecko

  • Not too shy to talk

  • Posts: 152

  • Since: 2004/10/11


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??

6
jdseymour
Re: Need to move database

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.

7
gecko
Re: Need to move database
  • 2006/1/24 10:12

  • gecko

  • Not too shy to talk

  • Posts: 152

  • Since: 2004/10/11


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

8
jdseymour
Re: Need to move database

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

9
gecko
Re: Need to move database
  • 2006/1/26 0:42

  • gecko

  • Not too shy to talk

  • Posts: 152

  • Since: 2004/10/11


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

10
gecko
Re: Need to move database
  • 2006/1/26 0:55

  • gecko

  • Not too shy to talk

  • Posts: 152

  • Since: 2004/10/11


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

Login

Who's Online

219 user(s) are online (138 user(s) are browsing Support Forums)


Members: 0


Guests: 219


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits