Problems after splitting database and relocating tables

Asked By Mara Sanders 30 points N/A Posted on - 02/23/2012

There are a number of problems we are experiencing with our database since splitting it and having all the tables relocated to the back end and generating links to the tables located at the front end.

This was due to the increasing number of people using it which led some users to being unable to access the database.

Please help me figure out what might be the cause of these errors.

• Status: Open
• Question Views: 814
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Enterprise Software

Answered By Iamexpert 0 points N/A #104536

Problems after splitting database and relocating tables

Hi

DB of your server site is not working properly due to population of your site right this is why some peoples have no access to the DB and the tables right so you need to do:

1. First of all go to the DB and see all the table and get them together if all are scattered and then copy all the tables in that DB. Copy means export all the tables and then delete that DB and create the new DB with the same name and then import the tables on the DB and it will working and you will find that over loaded site does not affect the DB this time and the tables will not scattered and will not cause any problem.

Hope this solution will get you out of trouble.

About Iamexpert

Questions
0

Answers
195

Best Answers
34

• Vote Up 0 Vote Down

• Posted on - 02/23/2012
• Question Category: Enterprise Software