configure.php problems

[schoolboy]

Originally Posted by oxan

Hello guys...I have a simmilar problem..but with the installation of template to my zencart...im recieving the same report...as "the first installation of zencart report"..I installed the zencart manually...all was working...than i moved all templates files via ftp..and its not working..well...I made up all of my website offline..on pc..localhost..with xampp...and than just coppied all of the files from xampp/htdocs/zen "zen is my zencart directory"...to my public_html...hope it will be possible to fix it..as i set up everything on the website..i spent so many hours...to do that...all of the work...Id say...its neccessary to do a path in configure.php...but i dont know what to change...and also...i made up new database also..but i would like to move old one..from my offline work...as all is there..thats the second problem....as i exported it form offline localhost..saved it as....xxx.sql txt file...its pretty big 1,6mb..and tried it to import to the new database...and error...access denied..etc...can it be due to big file?....tme main thing is that i want to import the website to my hosting...as i did it on localhost....i dont want to make up brand new again...not again...thanks in advance guys....

It's a bit laborious, and you need to be careful, but you can "import" the database by inserting everything as SQL queries via phpMyAdmin. I do this with big databases.

Did you then edit your configure.php files to reflect the new server paths and database info?

[oxan]

Well...I imported the sql file...but it wasnt working at all...still the same error..access denied...etc..ill try to go step by step..maybe i missed something..and as to configure.php...i didnt change it..thats why im asking..what exaclty to change..i dont know...should i change both of the configure.php in /includes and admion/includes?

[schoolboy]

Originally Posted by oxan

Well...I imported the sql file...but it wasnt working at all...still the same error..access denied...etc..ill try to go step by step..maybe i missed something..and as to configure.php...i didnt change it..thats why im asking..what exaclty to change..i dont know...should i change both of the configure.php in /includes and admion/includes?

The Username set up for the database may not have full access permissions.

Go into Cpanel and if you can EDIT that user, give it full access rights to the database.

If not, create a NEW user with full rights to that DB, then alter your configure.php files to show the new user for that dbase.

ALSO... you HAVE TO edit both configure.php files when changing location of a zc installation. Both the PATH settings and the DATABASE settings need changing.

You should also run fix_cache_key.php when yiou finally get it to connect.

[oxan]

hm..still the same problem...

1044 Access denied for user 'oxandrol_rogue'@'localhost' to database 'zencart'
in:
[DROP DATABASE zencart;]

[schoolboy]

Do you know what DROP DATABASE means?

I don't know why you're getting this message, but If I saw that out of the blue I'd be mighty pleased that MySQL stopped it from happening!

There is no way I can offer further help as I cannot establish a psychic link between my (very tired) brain and your database installation/configuration.

I'd suggest you post for help in Commercial Help wanted.