 |
 |
Need help with a PHP and MySQL issue.
|
|
|
|
|
Forum Regular
Join Date: Jan 2005
Location: Utah
Status:
Offline
|
|
I just got thrown this website to take over and I am not a real big web guy. I know basic HTML and javascripts but I have no idea what I am doing here. The guy that I took it over from said that I have to export the database out of MySQL and reimport it because we moved webhosts.
http://www.apexindustrialpark.com
Can someone give me some pointers on this. If you click on the For Sale and Maps links you will see what I am talking about. I am an IT//Graphic/Photographer guy at my job but this web thing is over my head. I could possibly give someone a little bit of cash to help out on this.
Thanks,
Brandon
|
|
|
| |
|
|
|
|
|
|
|
Clinically Insane
Join Date: Mar 2001
Location: yes
Status:
Offline
|
|
Originally Posted by bmizar
I just got thrown this website to take over and I am not a real big web guy. I know basic HTML and javascripts but I have no idea what I am doing here. The guy that I took it over from said that I have to export the database out of MySQL and reimport it because we moved webhosts.
http://www.apexindustrialpark.com
Can someone give me some pointers on this. If you click on the For Sale and Maps links you will see what I am talking about. I am an IT//Graphic/Photographer guy at my job but this web thing is over my head. I could possibly give someone a little bit of cash to help out on this.
Thanks,
Brandon
If you look at the site in my sig, you can see that I've done a ton of database driven sites using MySQL (and some PostgreSQL). I'm also quite willing to help you out in here if you are willing to put in the time.
Do you have a preference?
What is the objective here, to move the site and data to a new webhost?
|
|
|
| |
|
|
|
|
|
|
|
Forum Regular
Join Date: Jan 2005
Location: Utah
Status:
Offline
|
|
The site is now sitting on the new host and as you can see the database is not working. I am willing to put in whatever time is necessary. I love to learn but like I said I am in over my head on this one.
|
|
|
| |
|
|
|
|
|
|
|
Clinically Insane
Join Date: Mar 2001
Location: yes
Status:
Offline
|
|
Originally Posted by bmizar
The site is now sitting on the new host and as you can see the database is not working. I am willing to put in whatever time is necessary. I love to learn but like I said I am in over my head on this one.
Do you have access to the data from the database? Do you have access to create new databases on your new host? Do you have command line/SSH access? What host is this? Does your host have an admin control panel?
If you have the data and the access you need, you can import the data using phpMyAdmin, which is a standard tool provided by countless web hosting providers for this and other purposes.
|
|
|
| |
|
|
|
|
|
|
|
Clinically Insane
Join Date: Mar 2001
Location: yes
Status:
Offline
|
|
Looking at your site further, it appears as if the web server is not setup such that PHP is enabled. If this web server doesn't support the PHP language, this is going to be a real problem, you'll need that for sure.
|
|
|
| |
|
|
|
|
|
|
|
Clinically Insane
Join Date: Mar 2001
Location: yes
Status:
Offline
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
Forum Regular
Join Date: Jan 2005
Location: Utah
Status:
Offline
|
|
Ok I just went into the control panel and turned on PHP. I thought it was turned on by default. Take a look and see what you think now.
I have access to all of the data from the old server.
|
|
|
| |
|
|
|
|
|
|
|
Forum Regular
Join Date: Jan 2005
Location: Utah
Status:
Offline
|
|
Those are the old passwords on the old FTP. The new ones are different.
|
|
|
| |
|
|
|
|
|
|
|
Clinically Insane
Join Date: Mar 2001
Location: yes
Status:
Offline
|
|
Originally Posted by bmizar
Ok I just went into the control panel and turned on PHP. I thought it was turned on by default. Take a look and see what you think now.
I have access to all of the data from the old server.
Better... okay, I'd still change your passwords, but I can show you how to do that.
In your admin control panel, you need to check to see if you have a database that matches the database name listed in the dbConnect.php file. You need to setup access to this database so that user "apex" has the privileges needed (don't know yet what sorts of privileges are necessary, you can start with all but admin privileges I guess). Then you need to set the password for this user to match whatever is in the dbConnect.php file.
Private message me if you'd prefer to work in private, I'll give you my email or IM address if you'd prefer.
|
|
|
| |
|
|
|
|
|
|
|
Clinically Insane
Join Date: Mar 2001
Location: yes
Status:
Offline
|
|
Once you have setup the necessary access to the DB, you should no longer get SQL access denied errors on pages like the following:
http://www.apexindustrialpark.com/sale.php
Once you get this far, there should be a section in phpMyAdmin (assuming this tool is available to you in the admin control panel) for importing your data into your database. If you can do this successfully, you'll be home free.
You might want to also check to make sure email forms and other custom programming works on the new host (things like permissions not being set correctly can cause errors).
|
|
|
| |
|
|
|
|
|
|
|
Forum Regular
Join Date: Jan 2005
Location: Utah
Status:
Offline
|
|
I sent you a PM with my IM name.
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
 
|
|
|
Forum Rules
|
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|
|
Top
