Moved wordpress from localhost to live and wp-admin shows white screen

2 comments

1. When you say moved WordPress, what do you mean exactly,

   • Did you copy your entire WordPress installation from your localhost to your remote server without installing WordPress first on your destination host?

   • Did you export your SQL database from localhost then import it to your remote server?

   • Did you install WordPress on your remote server before copying your theme folder across?

   It’s likely that the parameters found under Settings -> General for both,

   • WordPress Address (URL)
   • Site Address (URL)

   Are both incorrect and still pointing to your localhost environment.

   You should install WordPress from scratch on your remote server prior to copying over your theme instead of copying your entire WordPress folder from your localhost.

   Otherwise if you want, login to your MySQL manager (likely phpMyAdmin) and edit the entries for,

   • WordPress Address (URL)
   • Site Address (URL)

   Under the wp_options table.

   As suggested by Damien (in comments), there is of course a whole section on the Codex dedicated to this topic,

   http://codex.wordpress.org/Moving_WordPress

   In particular the following section title “If you forget to change the locations”, relates directly to the WordPress Address URL and Site Address URL mentioned above.

   Log in to Reply

2. Whenever I copy over my WordPress to a new location I always take over my database modifier php script:

   <?php
   
   $database_host = '';
   $database_user = '';
   $database_pass = '';
   $database_name = '';
   
   $replacement_values = array( 'http://oldurl' => 'http://newurl' );
   $text_fields = array( 'char', 'text', 'varchar' );
   
   $mysql = mysql_connect( $database_host, $database_user, $database_pass );
   if ( !$mysql ) {
       die( 'Could not connect: ' . mysql_error() );
   }
   
   $mysql_database = mysql_select_db( $database_name, $mysql );
   if ( !$mysql_database ) {
       die( 'Can't select database: ' . mysql_error() );
   }
   
   $tables_result = mysql_query( 'SHOW TABLES' );
   while ( $tables_row = mysql_fetch_row( $tables_result ) ) {
       foreach ( $tables_row as $table ) {
           $columns_result = mysql_query( 'SHOW COLUMNS FROM ' . $table );
           while ( $columns_row = mysql_fetch_assoc( $columns_result ) ) {
               $column = $columns_row[ 'Field' ];
               $type = $columns_row[ 'Type' ];
               foreach ( $text_fields as $text_field_type ) {
                   if ( strpos( $type, $text_field_type ) !== false ) {
                       echo '<p>' . $type . ' - ' . $column . ':' . $table . '</p>';
                       foreach ( $replacement_values as $replace => $replacement ) {
                           $replace_query = sprintf( 'UPDATE %s SET %s = REPLACE(%s, '%s', '%s')', $table, $column, $column, $replace, $replacement );
                           mysql_query( $replace_query );
                       }
                       break;
                   }
               }
           }
       }
   }
   
   mysql_free_result( $columns_result );
   mysql_free_result( $tables_result );
   mysql_close ( $mysql );
   
   ?>
   

   You can change the values here:

   $replacement_values = array( 'http://oldurl' => 'http://newurl' );

   to what you want to replace.

   Log in to Reply