How to check the downloaded database is fully received or not?

By aby.va | 04th June 2015 | 2 min read

A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic, full-text, numeric, and images. We know the each web application have its own databases.

Once I tried to set up the project locally by clone from remote server. That was a Drupal project. We know in Drupal site have very important thing is database settings. All database details is in settings.php. From that I took database name and start to dumb the database. For that I export the corresponding database from C panel or like things.

I export the data base ,but I notified there is a problem. i.e The size of database in c-panel and downloaded database are different. Why these two have such difference?

I searched about this. This is because DBMS stores information on disks. In the data in database are stored in hard disk then its size is recorded. If the project executed then the database may be increase or decrease. In case of increasing size of the disk storage for database is increased and re-record it. But In case of decreasing the database, the size of the disk storage for database have no change is occurred and still the large recorded size is shown in database.

If the data base is changed from one storage place to another storage place then the databases original size of current moment is shown in copied database.

By this some place we have a lot of confusion are occur i.e the database was full received or not..etc. So How to check the downloaded database is fully received or not?

So there is some simple ways to know about the downloaded database is correct or not;

1: Check the no. of tables are equal or not.

2: Check each tables rows are equal.

3: Check columns of each tables are equal.

4: Check rows of each tables are equal.

5: Check columns of last tables are equal.

6: Check rows of last tables are equal.

Using these simple methods we can find out the downloaded database is fully received or not.