• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Viewing million of data error (Unable to select the specified database)

Hello guys just need a little help here my problem is i have a huge amount of data estimated 2 million and 500,000 rows and if i attempt to view this it just loading and display a white page. And if i try to refresh or reload the page it says Unable to select the specified database
How can i view all the data. By the way I'm using a pagination to view this.

You need to use pagination for that many records.

I used a pagination in my view.

The error is telling you what is wrong it cannot find your database, either you named it wrong in your code or you forgot to load the database.

Actually my database is running in autoload.php. And my database.php is correct i double check every variable i set in this page. Only the member list is causing this error and the other pages is running perfectly. I think it is the execution time in mysql. The last record i tried to display is 19,000 member and it displays. I only overwrite my member table replacing it to 2 million member.

You can raise the mysql values in my.ini in the mysql\bin folder.

Ok i will try that thanks.

Ok but there's no my.ini in my bin folder . This is my directory C:\Program Files\MySQL\MySQL Server 5.5\bin is this right?

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.