Moving website to another local host to try - no errors, but no data is shown

Question

This is my first time transferring my local dev site to another local site to test out, and can't access the database in the new site. Both computers are running XAMPP on Macs. The test site has successfully installed XAMPP, and has placed database files under Applications/XAMPP/xamppfiles/var/mysql. The test user is able to start Apache and MySQL, and see database files in PHPMyAdmin. The test user is also able to access the local web site with no error messages.

EDIT: The database files were copied over by copying/zipping the file on my end, and unzipping/dropping the copied files on the test end.

However, the local web site does not seem to see the database. Pages that are supposed to return data just show the default "sorry, we're sold out" message or show "image not found" graphics, and the admin is unable to log in.

The index page calls

include_once "common/base.php";

which consists of

<?php
// Set the error reporting level
error_reporting(E_ALL);
ini_set("display_errors", 1);

// Start a PHP session   
session_start();
$_SESSION['docroot'] = $_SERVER['DOCUMENT_ROOT'] . '/mysite/';

// Include site constants
include_once $_SERVER['DOCUMENT_ROOT'] . "/inc/constants.inc.php";

    if ( !isset($_SESSION['token']) )
{
    $_SESSION['token'] = md5(uniqid(rand(), TRUE));
    $_SESSION['token_time'] = time();
}

// Create a database object
try {
    $dsn = "mysql:host=".DB_HOST.";dbname=".DB_NAME;
    $_db = new PDO($dsn, DB_USER, DB_PASS);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
    exit;
}
?>

If there was a connection problem, I would expect to see an error message returned, which I can verify by changing the constants in inc/constants.inc.php to bogus values. So I don't believe there's a connection problem.

If you were in my position, what would you check?

EDIT: I just found out about the Export function in PHPMyAdmin. I'm going to try deleting the db files that were copied over, exporting the files from PHPMyAdmin, and then importing them in the test machine.

EDIT: I just had the test machine do a simple

$sql = "SELECT FirstName From users";

    $stmt = $_db->prepare($sql);
    $stmt->execute();
    $aaData = array();

    while($row = $stmt->fetch(PDO::FETCH_NUM)){
    $aaData[] = $row;
    }

    $stmt->closeCursor();

print_r($aaData);

on the index page, it shows the correct list of users. So the connection is good, and there's an issue elsewhere. Would y'all say that I still need to delete the copied db and use the "correct" way (export/import), or is that a waste of time?

FINAL EDIT: I did redo the move using Export/Import and everything is working well now. Thanks to all.

Have you checked the database on this new host? Have you migrated the data or only the structure of the DB? — Ricardo Souza, Apr 29 '12 at 15:17
Also, have you just copied the DB files to the mysql directory? — Ricardo Souza, Apr 29 '12 at 15:19
@rcdmk, when you say "have I checked the database", what specifically do you mean? I've checked that the database exists and can be accessed through PHPMyAdmin. — earachefl, Apr 29 '12 at 15:46
@sudantha, the config file uses the defaults : DB_USER is root and DB_PASS is blank, which is what the default XAMPP install uses. Yes, I know... this is just a local server, not outward-facing. — earachefl, Apr 29 '12 at 15:50
**Hope this helps :** [PHP produces a completly white page, no errors, logs, or headers][1] [1]: http://stackoverflow.com/questions/1944105/php-produces-a-completly-white-page-no-errors-logs-or-headers — Sudantha, Apr 29 '12 at 16:03
This is not a very good idea to drop a raw SQL file in to the folder, a most appropriate way would be exporting an SQL dump and importing to new database table with same access settings. — Nazariy, Apr 30 '12 at 01:22
@earachefl I mean if you have checked the database is created and attached and there is some data in the database to show. — Ricardo Souza, Apr 30 '12 at 03:22

score 2 · Accepted Answer · answered May 03 '12 at 22:18

First off, zipping files in the mysql data directory and moving them is not the best way to go. It can work if you have completely flushed/shut down the mysql server before moving them. You are better off using mysqldump or a similar tool to move entire databases at a time.

It sounds to me like you moved over your app's database files, but you probably forgot to add the user/password credentials to the new MySQL setup. You mentioned you use phpMyAdmin, so when you login on the other machine click the "Privileges" tab and make sure it matches up with the Privileges tab on your dev machine.

If it's not that, then it is entirely likely that by zipping and copying the files some/all of the tables were corrupted. Try using phpMyAdmin's Export and Import capabilities to move the database over. If the data is very large let me know and I can give you some command line entries to run.

Hope this helps.

Thanks Michael, I already redid the move using Export/Import and checked the permissions on the target, and all is well. — earachefl, May 04 '12 at 13:09
Have you checked the username/password that you are using on your mysql_connect() line? I wasn't referring to the permissions on the files, but the user used to make the MySQL connections from your scripts. — Michael Taggart, May 04 '12 at 18:25

Moving website to another local host to try - no errors, but no data is shown

1 Answers1