Backup installation issues

[aquatonex]

I've successfully backed up my SquirrelCart v1.1.0 to a different server. I want to make sure this backup works so I am attempting to have it 'run' on this second server.

The entire squirrelcart dir structure was copied along with the MySQL table set (via MySQL-Front).

I changed the config.php so that the $site_www_root, $site_isp_root, $site_secure_root, $cart_page, $img_path, $sql_host, $sql_username, $sql_password, and $db vars reflect this new server.

When going to the index.php homepage, the top control panel loads up with no little green blinking light on the end of it. Further, the usual two images (the logo and slogan) do not show up. Instead there are those evil deadlink x's you receive when the image doesn't exist. I look at the source for the IMG tag and it only comes up with my domain name, not the actual link to an image file.

Also, the login/password area is totally empty.

I think I have a setting incorrect, but I'm fiddling with the vars and nothing is changing.

thanks,
Greg

[Rich]

It definitely sounds like you have a problem in the config.php file.

Please open a ticket (http://www.ldev.com/helpdesk/) so we can assist in troubleshooting this. Be sure to include the URL to your cart, an administrative username and password for it, and FTP information that will have rights to Squirrelcart's files.

[aquatonex]

Ok, I submitted a tech report. I also have updated information...

To recap, I have the shopping cart live on one server. I copied the entire script plus the MySQL db to a second server for backup purposes. This backup copy is currently not working 100%.

I changed the vars in config.php and it still didn't work.

NEW STUFF:
If I change the database variables (i.e. host, uname, pass, db) to the original database on my other server, it works fine! Also, I created a third clone of the MySQL db, connected that up, and that one worked fine also.

I removed the database that's giving me issues and made a new one, same error.

[aquatonex]

OK, so I have resolved my issue. The problem was that the table names are CASE SENSITIVE.

Yes, it is true that MySQL tables are not case sensitive (in general).

However, when coupled with MySQL-Front, SquirrelCart, and a UNIX server, this is not the case.

This issue was caused when I copied the MySQL db to a Windows 2000 server from a UNIX server using MySQL-Front. It lowercased my entire table set. When using the Windows 2000 server db (with the lowercased tables), the cart works without problem. However, when I clone this to a second UNIX server and reset the config to point to this new UNIX db, pffffffffft.

The trick was to clone the database from UNIX server 1 to UNIX server 2 without the Windows 2000 interim server. This maintained the capitalized first letter of each table, effectively maintaining shopping cart coherence.

Thank you Jaime and Rich for lending an ear to me!