Page 1 of 1

Moving from a Windows Box back to Linux, How to keep Data?

Posted: Thu Jun 01, 2006 11:36 pm
by Capt Mike
Hi everyone,

I moving and need some help, anybody got a truck? :D

I have a ton of information on my site and want to move it all to a linux box I will have access to the linux box via C Panel. The windows box is a dedicated server so I have full access to that.

What do I do??? :shock:

www.stgeorgebroadcasting.com

Mike

Posted: Fri Jun 02, 2006 12:15 am
by jhermanns
hey,

use phpmyadmin to download a database dump of both serendipity's table structure and data.

then you import this data on the linux box (also via phpmyadmin).

once you have done that, you download your whole serendipity directory from your windows box and upload it to your linux box.

before you upload to linux, though, you must edit the serendipity_config_local.inc.php file to match the new paths and also the new database information (database name, username, password, ...).

let us know how it goes!

Thanks matey

Posted: Fri Jun 02, 2006 8:25 am
by Capt Mike
Avast! tis I, Capt mike

let me see if I understands you,

phpmyadmin, download to my home computer of tables and data, from the database

upload that to my new box, now do I create a fresh install, then copy the old files over that install on the tables? Im not so good with mysql, give me a hammer and I can get the job done, but mysql is well, not me cup of tea.

next, is the directory, how do I manage that, the download??

Then copy my old serendipity_config_local.inc.php, and paste it to the new one?

whew...

How do you like me new avatar? Am I hip or is it groovy? Never can tell these days...

may the wind be at your back
CM

Re: Thanks matey

Posted: Fri Jun 02, 2006 12:18 pm
by jhermanns
Capt Mike wrote:phpmyadmin, download to my home computer of tables and data, from the database
roger that!
Capt Mike wrote: upload that to my new box, now do I create a fresh install, then copy the old files over that install on the tables? Im not so good with mysql, give me a hammer and I can get the job done, but mysql is well, not me cup of tea.
You download the serendipity-directory to your computer, and then upload it to the new linux box. Then you open phpmyadmin on the windows box, select your database if nessesary and then click "export". Choose structure & contents and download this file. Then open phpmyadmin on your linux box, click "SQL" and chose the file you just downloaded
Capt Mike wrote: Then copy my old serendipity_config_local.inc.php, and paste it to the new one?
Ya, between downloading and uploading of your serendipity-directory you have to open "serendipity_config_local.inc.php" in a text editor and adjust some settings. E.g. on windows the paths are different (you'll see when you open the file) and your database-connection-information of course.

Don't be scared, give it a try :-)
Capt Mike wrote: How do you like me new avatar? Am I hip or is it groovy? Never can tell these days...
YARRRRRRRRRRRRRRR. Very nice, mr. McCallister :)

Posted: Fri Jul 21, 2006 11:24 am
by Capt Mike
Error!!

Cannot write to directory D:/websites/stgeorgebroadcasting/templates_c. Please check the permissions.

I moved everything over:

I got this error. where do i fix it please??

thanks guys!!

Posted: Fri Jul 21, 2006 11:32 am
by garvinhicking
Hi!

Do you get this error on a linux or windows box? It tells you that this directory either does not exist or is not writable.

Make it chmod 777 on a linux box, or use IIS properties on a windows box to adjust privileges.

Regards,
Garvin

Posted: Fri Jul 21, 2006 11:46 am
by Capt Mike
this error is from the linux box which we are moving to...the linux box is the new home.

the problem is the path,

this page is being moved from a windows box to a linux box, that error is generated on the linux box. I am unable to change permisison on it because it is calling a windows system path. I need to know were this path is defined so that i can change it to a linux path relative to the system.. I.E. /tmp/ and yes i will check permission at that point and ensure it can write.

here is the path to the site:
http://204.15.135.8/~skipper/index.php

this is the error we see:

Cannot write to directory D:/websites/stgeorgebroadcasting/templates_c. Please check the permissions.

Posted: Fri Jul 21, 2006 12:02 pm
by garvinhicking
Hi!

As mentioned in the FAQ on www.s9y.org you need to first enter the s9y admin interface on your new blog and there you can adjust the path settings :)

Best regards,
Garvin

ummm

Posted: Fri Jul 21, 2006 12:09 pm
by Capt Mike
Hi Gavin


Im now confused. I cannot see the admin interface, all I get is the error? So where do I edit the file manually? to correct the path...


Help :cry:

all i see is this when I go to the index page


Cannot write to directory D:/websites/stgeorgebroadcasting/templates_c. Please check the permissions.


where do we chage the path using a text editor??

thanks

Re: ummm

Posted: Fri Jul 21, 2006 12:18 pm
by garvinhicking
Hi!

You should be able to enter the admin interface here as usual:

http://204.15.135.8/~skipper/serendipity_admin.php

Best regards,
Garvin

Posted: Fri Jul 21, 2006 12:57 pm
by Capt Mike
thank you
!!

Thank you :)

Posted: Fri Jul 21, 2006 10:40 pm
by Capt Mike
Oh no!!

Well we fixed a few problems now we have a new ones!

None of the s9y images are showing up on the webpage?

should look like this:

http://www.stgeorgebroadcasting.com/


the new move looks like this:

http://204.15.135.8/~skipper/index.php

It is not calling the images, and some of css?? why is this?

Posted: Mon Jul 24, 2006 11:29 am
by garvinhicking
Hi!

Because you previously had s9y running on "/" and now it runs in "/~steve". So all image URLs are wrong.

You need to make s9y run on a "/" path again, then the liks willl be right. If you can't do that, you will need to manually fix all links, or edit the SQL dump file and re-upload that.

Best regards,
Garvin

Posted: Mon Jul 24, 2006 8:54 pm
by Capt Mike
wow, what a drag...

Thank you very much gavin...I will get to work on it... :(

I hate moving