Urgent

[Guest]

Hi there, I'm done with testing on a dummy server and now my friend wants me to help him migrate everythign to another new domain. How do i actually go about doing that? how do i migrate my table with the same passwords and usernames? i want everything to be the same and i am definitely not willing to retype all oen by one. tried importing and exporting the database but phpadmin returned this error :"#1044 - Access denied for user 'asiatat'@'localhost' to database 'seantatz_osc1'"

 

i have cpanel, should i create a new database? then import the tables one by one?

[Jack_mcs]

You have to create a database using CPanel and then import the database using phpmyadmin.

 

Jack

[Wolfsfable]

You can also use the admin interface built into osComm to create a backup of the database. It's under the tools section.

[aznkpride0922]

Hi there, I'm done with testing on a dummy server and now my friend wants me to help him migrate everythign to another new domain. How do i actually go about doing that? how do i migrate my table with the same passwords and usernames? i want everything to be the same and i am definitely not willing to retype all oen by one. tried importing and exporting the database but phpadmin returned this error :"#1044 - Access denied for user 'asiatat'@'localhost' to database 'seantatz_osc1'"

 

i have cpanel, should i create a new database? then import the tables one by one?

 

First, you should configure the db server address correctly. Well, if it's the localhost, and it used to be the localhost, then it doesn't matter.

Also, if you did not transfer db to th new server, you should do so. If your db is too large, phpmyadmin cannot import large sql files due to php's upload limit (default is 2MB). First of all, try zipping... and if you have control over php.ini, temporarily change the upload limit to fit your sql file. Otherwise, you should upload the sql file via ftp to your account and contact the server admin to import that for you.

you can do that easily in phpmyadmin.

 

For access denied issue, you have to create a new user with enough privileges for osc functions.

you will find the username and its password used by osc in configure.php. copy those and use them for the new user.

For better security, set privileges specific for the db, not for the username itself.

[Guest]

hi there,

i've imported the old database into my new webspace.

 

i'm not sure what i've done wrong, i can't log in to my admin. should i set the password (new password) and username in configure.php or cpanel?

i've made sure all the passwords and usernames were identical in cpanel and configure.php. but i still can't login. can someone please explain step by step how to do migration without facing this kind of problem? thanks

[Jack_mcs]

The username is probably different so you have to change that too, in case you haven't, in the configure files.

 

Jack

[Guest]

i've changed the user and pass many times to match exactly what i've configured.

 

funny how cpanel always add a prefix of my database name in front of my username. eg database called shop_osc1, then the username would be shop_user1 when i set it to "user". or at least that's how it was displayed in my cpanel..

 

should i include the prefix into configure.php? or should i just set as 'user'? oh btw i noticed that my old configure.php files had displayed the password encrypted. how do i know how's the password (string) to be like after encryption, so that i could add into configure.php? or it doesn't matter if i enter encrypted password or not?

[Jack_mcs]

That part that cpanel adds is the username for the account and is required.

 

Jack