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

[Capt Mike]

Hi everyone,

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

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

www.stgeorgebroadcasting.com

Mike

[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!

[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

[jhermanns]

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

roger that!

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

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

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

YARRRRRRRRRRRRRRR. Very nice, mr. McCallister

[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!!

[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

[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.

[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

[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

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

[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

[Capt Mike]

thank you
!!

Thank you

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

[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

[Capt Mike]

wow, what a drag...

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

I hate moving