what is best way to move database etc from one server to ano

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
ozorowsky
Regular
Posts: 8
Joined: Fri Jan 19, 2007 2:25 am

what is best way to move database etc from one server to ano

Post by ozorowsky »

Hi there, I am trying to move all files and database from one server to another. the one problem I have is my default database name on my new server is secreta1_then the database name. So the database name will be different. Please help.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: what is best way to move database etc from one server to

Post by garvinhicking »

Hi!

You can use the same method as outlined in the FAQ on www.s9y.org - you can change the database prefix inside the config file that is mentioned in the steps.

HTH,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
ozorowsky
Regular
Posts: 8
Joined: Fri Jan 19, 2007 2:25 am

Post by ozorowsky »

I did the instructions per FAQ and keep getting this error Cannot write to directory C:/www/secretalliance/serendipity/templates_c. Please check the permissions. even though I chmod all files in directory to 777 "read/write/execute" any ideas?
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

If s9y reports that it cannot write to the directory sadly it must mean that this directory is not writable.

You must make the directory itself to 777, not only the files in there!

HTH,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
ozorowsky
Regular
Posts: 8
Joined: Fri Jan 19, 2007 2:25 am

Post by ozorowsky »

garvinhicking wrote:Hi!

If s9y reports that it cannot write to the directory sadly it must mean that this directory is not writable.

You must make the directory itself to 777, not only the files in there!

HTH,
Garvin
I did give full permission to directory and all directories/files within :(
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Are you on a windows server? If so, did you manage the permissions via FTP or via the Windows interface?

If PHP reports that the dir is not writable, it definitely is not writable for PHP...

Best regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
mrblah
Regular
Posts: 13
Joined: Sat Oct 07, 2006 8:39 pm
Contact:

Post by mrblah »

I am actual having a similar problem so I thought I'd post it in here. I get the "can't write to templates_c" but I have chmod the directory to 777. The thing that looks wrong is that the directory that it shows is from the old server that I'm moving off of. Do I need to edit a file that contains the directory structure? I didn't have to do anything with the database because I kept the same name and password when I imported the database over.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

When you move an installation according to the FAQ on www.s9y.org you need to login to the admin suite to first correct the paths, yes.

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
ozorowsky
Regular
Posts: 8
Joined: Fri Jan 19, 2007 2:25 am

Post by ozorowsky »

I am able to login to the admin page. I get this error:

We detected some errors while running some diagnostics on your entered information:- Cannot write to file serendipity_config_local.inc.php.
-> run chown -R www:www /html//serendipity (Change www to the user apache runs as (e.g. nobody).)
-> run chmod 770 /html//serendipity
Once you have done this, hit your browser's "reload" button

My webhost uses something called siteworkx if that helps at all.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

When you get that message it means you forgot to copy the 'serendipity_config_local.inc.php' to your new server or you did not make it writable for Serendipity!

Best regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
ozorowsky
Regular
Posts: 8
Joined: Fri Jan 19, 2007 2:25 am

Post by ozorowsky »

Sorry to be a pain. Still researching this. Everything seriously seems to be fine. Write permissions are on EVERY file, I hand went through EVERY file, and it all seems fine. I can't put my finger on this.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Are maybe symbolic links involved?

If you write a simple PHP script like this:

Code: Select all

<?php
if (is_writable('/home/serendipity/')) {
 echo 'dir is writable';
} else {
 echo 'dir is not writable';
}

if (file_exists('/home/serendipity/serendipity_config_local.inc.php')) {
  if (is_readable('/home/serendipity/serendipity_config_local.inc.php')) {
echo 'config exists and is readble';
  } else {
 echo 'config exists but not readable';
}
} else {
  echo 'Config file NOT existing!';
}
You might need to change the paths for proper content...

HTH,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
ozorowsky
Regular
Posts: 8
Joined: Fri Jan 19, 2007 2:25 am

Post by ozorowsky »

I uploaded test.php to my home directory with following code:


Code: Select all

<?php 
if (is_writable('serendipity')) { 
 echo 'dir is writable'; 
} else { 
 echo 'dir is not writable'; 
} 

if (file_exists('serendipity/serendipity_config_local.inc.php')) { 
  if (is_readable('serendipity/serendipity_config_local.inc.php')) { 
echo 'config exists and is readble'; 
  } else { 
 echo 'config exists but not readable'; 
} 
} else { 
  echo 'Config file NOT existing!'; 
} 
?>
Got this result:

dir is writableconfig exists and is readble
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Okay, thanks. Now try this PHP:

Code: Select all

<?php 
if (is_writable('serendipity/serendipity_config_local.inc.php')) { 
echo 'config writable'; 
} else { 
 echo 'config NOT writable, you must fix permissions!'; 
} 
?>
Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
ozorowsky
Regular
Posts: 8
Joined: Fri Jan 19, 2007 2:25 am

Post by ozorowsky »

Hey kevin get "config writeable" as reply. I'm wondering if I have my paths wrong...

I am able to get to the administration page. From there, I can see the configuration page.

settings are as follows:

Full path: /serendipity

Upload path: /uploads

Relative path: /serendipity

Relative template path: templates/

Relative upload path: uploads/

Index file: index.php

Does this all look correct?
Post Reply