Jump to content

backup database changing passwords


Guest

Recommended Posts

I want to restore a database that is set up for wholesale customers to a separate database setup in a subdomain for retail customers. All the data and graphics is the same except I will be changing prices. The new database has a different database name, user name, password, administrator user name, and administrator password. I get an error so I know I need to change these values. What is the easiest way?

I have done a search using several variables and nothing comes up.

Thanks for the help.

Link to comment
Share on other sites

I am able to access my passwords and user name so they are easily changed to match. I believe my problem is that I have a database with one name "lure" and want to restore it to a database with another name "lure_retail". Is there a way to bypass the database name record (table?) or the "checking" and have it just restore the options and category data so I don't have to reenter it. I am a neophyte with SQL and php, but understand that everything needs to match or be a global replace. Since the lure_store is empty I am not going to write over anything.

Thank you for your help.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...