Moving Files from WAMP to Server. Please Help.

Hello,

I've designed the zen cart template locally using WAMP.

I created a test sub domain so I can move the files to the server and do a live test before moving to main domain.

I uploaded all the zen cart files from WAMP to the sub domain.

Where do I go from here? I've been using the search feature but running into anything to push me in the right direction.

Do I have to set up a database on the server first? or does zen cart do that for me?

Do I go into the zc_install/index.php and do a fresh install on the sub-domain?

Please advise. I would greatly appreciate it.

https://www.zen-cart.com/tutorials/index.php?article=99
https://www.zen-cart.com/tutorials/index.php?article=122

the simplest way i do these so as not to have inaccuracies in my configure files is to do a new install,
Copy all your files from WAMP installtion including the zc_install
create a new database on your new host
install zencart as normal
when installed check to see it works

backup your WAMP database
using phpmyadmin with your new host, drop the tables in this new database, and then import your WAMP database

test your new site

Rob

Guys, thanks a lot. I have my test site live now.

Now I need to move the database on my local PC to the new database on the server.

Do I just export the db on my local and import on the new? There are lots of options when trying to export a db, so what do I choose?

Thanks again!

i have these box checked when i export

i dont know about the version that wamp user, but its worth a try unless you get advised other

http://www.carptalkxtra.co.uk/phpmyadmin.jpg

Rob

thanks for your prompt reply rob. I appreciate you taking out the time to do a screen shot.

using those settings that Rob suggested, i go to import the gzip file and get this error in the screenshot. any ideas?

did you empty your database with new server before you imported

that screenshot was a bit small to read too

Rob

this is what my screen looks like when i import a new database

http://www.carptalkxtra.co.uk/phpmyadmin_import.jpg

i think it might be an auto increment problem, when you made the backup did the settings look the same as my jpg earlier?

Rob

yes, my settings were the same as both screen shots you provided.

i didn't empty the database on the new server, maybe that is the issue.

on the new database, do i just go under the "Structure" tab, and check all the boxes and delete? would that empty it?

thanks again.

yes, select the database on new server, if you select the one of the left pane, it displays all the tables on the right, select all, scroll down and you will see a drop down, select DROP and ok that

always make backups before you do anything like this, and make sure you on the correct server for deleting these tables

when all tables have gone, then use the insert and select your file to import in

Rob

ok, i successfully did it. Thank you.

However, now I cannot login to the zen admin panel. does the login/pass information have anything to do with databases or is it seperate?

I even resent the pass to my email, tried to login and no dice.

it will be your username and pass that you used on your wamp

and yes the username and password is stored in the database

you can reset the username and password manually in the database, but this needs the name and password copying from a stand installation as the password is encrypted in the database

there is somewhere on here where its written but i cant seem to find it

Rob

hmm..ok thanks.

it's odd, but now I cannot login to the admin panel for wamp, and when i hit "resend password" i get an error.

Im going to have to reset the user and pass in phpmyadmin somehow. what do you mean by "stand installation"

go to your phpmyadmin to the table admin, click on browse, you will see your username there and a password

replace your password with this

ea6183639635d70f82383600b0cd768c:e4

go to your admin on your cart, place your username as listed in the database and the following for your password

admin10

once logged in, make your changes to the admin

Rob

brilliant. thank you rob for all your help. i have it all set up thanks to you! good karma points ;)