HELP, broke website by copying database

  • Resolved cwedge

    (@cwedge)


    8 years ago

    I tried to create a duplicate of a registration database within my website (which was entirely written by somebody else, hence I’m unfamiliar with the back end) without realising I was copying the database relating to the whole site. I renamed the database esrgroup_newesr to esrgroup_newesr2016 and then using operations-copy in myPHPadmin on cPanel copied the database with structure only to the name esrgoup_newesr. In my mind I was duplicating a database structure whilst storing the old data.
    I instantly realised this had killed the webpage (www.esr-group.org) so reversed my actions by renaming the new structure only database, and then renaming the original from esrgroup_newesr2016 back to esrgroup_newesr as it had originally been called
    This hasn’t restored the site though. On going to the wp login page https://www.esr-group.org/wp-admin I get the error message:

    We were able to connect to the database server (which means your username and password is okay) but not able to select the esrgroup_newesr database.

    Are you sure it exists?
    Does the user esrgroup_newesr have permission to use the esrgroup_newesr database?
    On some systems the name of your database is prefixed with your username, so it would be like username_esrgroup_newesr. Could that be the problem?

    Any suggestions of how to fix this would be much appreciated. Other help requests with this error message seem to relate to installation not an idiot killing their webpage by renaming the database so didn’t help. If I can get the site back on line I’ll not be meddling with a back-end I don’t understand again! Many thanks.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter cwedge

    (@cwedge)

    further to my message above I think I’ve fixed the problem by adding user esrgroup_newesr to database esrgroup_newesr (at least my website seems to be back online) but any advice on whether there might be other things broken that I need to fix would be much appreciated.
    Thanks for your time – I’ve learnt my lesson and won’t be fiddling again with things I don’t understand!

    Shiful H

    (@wsaiful)

    Hi,
    I think you had this issue for only the database table prefix. If it is please rename the prefix with notepad find aand replace command.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘HELP, broke website by copying database’ is closed to new replies.