Uploading MySQL to Register.com

herschen

I am having difficulty finding information on the web about uploading my perfectly functioning "localhost" website and MySQL database to register.com (or any web hosting company for that matter)

There is a database manager on register.com, but I can only create new databases and tables, it appears there is no way to import an existing SQL file.

I have been using PHPMyAdmin and HeidiSQL with XAMPP, so my website is in the directory "c:\xampp\htdocs\realestate" and the data for the database is in "c:\xampp\mysql\data"

I have been developing the pages in Dreamweaver, so I have MySQL connections to localhost and then to the appropriate database.

I just talked with a technician and he told me that the database folder on register.com is the "databases" folder (one level out from the "public" directory) and that the server to connect to is "sql5c6a.megasqlservers.com"

Do I just copy my databases up to the "databases" folder and then change the connection in Dreamweaver from "localhost" to "sql5c6a.megasqlservers.com?"

rulian

The best and easiest way to do that is simply to run PhpMyAdmin (best web app ever IMO) on both servers,
use the export function on your localhost and import function on your live server. Then in your code simply change the mysql loggin information and boom, your site shoudl work "in theory"

MarkR

You need to check the version of all software components.

In general, you can't hope for an application to work successfully when migrating between your development and production environments unless all software components are the same version. This includes:

Operating system vendor
Operating system version
Database vendor
Database version
Web server vendor and version
Any third party software components used.

It also includes many configuration settings for most of the above.

If you cannot say with complete certainty that all of the software is exactly the same between your development and production environments, you cannot reasonably expect your application to work.

Configuration also matters, particularly with PHP configuration where it affects general behaviour, including but not limited to: register_globals, magic_quotes_gpc, safe_mode, open_basedir.

If your hosting provider does not allow you to install an arbitrary version of all of the above, you must adapt your development environment to match production. This is usually desired anyway because your operations staff may want to choose the software versions for operational reasons.

Therefore, I suggest that you change your development system's software set until it matches production as closely as you can get (ideally exactly the same).

Where I work, we use virtual machines (Vmware, but others are available) to enable us to develop in a software environment as close to production as possible. I would recommend you do the same if possible.

Mark

herschen

Thank you for the quick responses. I've configured phpmyadmin with my username, password and the sql server. I uploaded phpmyadmin into my public directory, and succuessfully logged on. However, I've already created databases in register.com's Database Manager: 'properties_propertyhawaii_net,' and 'propertyhawaii_propertyhawaii_net' (the url is propertyhawaii.net). But phpmyadmin shows that there are no databases. When I try to create the database propertyhawaii_propertyhawaii_net, it says that the database already exists. And when I try to create a new database, it states that my username does not have access to do so. So please tell me why it doesn't show this database?

On a side note...I think this will be a problem after I solve the above issue. MarkR mentioned that both the server and the localhost should have the same config. My localhost is running with MySQL 5.0.45 and the register.com server is using MySQL 3.23.54. Will this be a huge problem and how do I downgrade if I need to?

I also see this message: 'Your PHP MySQL library version 3.23.54 differs from your MySQL server version 5.0.27. This may cause unpredictable behavior.' How do I make these the same?"

herschen

So on the left sidebar it says there is no database, but I was somehow able to create two new databases (that register.com's Database Manager doesn't see) and the website could only connect to one of them after I uploaded the data. So I just imported all the information from the second database into the first one and changed all the links on the web page to reflect that. I really don't know how I did this. Out of sheer luck I renamed the file 'properties_propertyhawaii?net' and it worked fine (rather than 'properties_propertyhawaii_net' or 'properties?propertyhawaii?net')

I am going to switch to a cheaper web hosting company than register.com, so I am not too particular how the data is organized on the server. Thank you for all your help.