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

#1
[eluser]rochellecanale[/eluser]
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.

#2
[eluser]InsiteFX[/eluser]
You need to use pagination for that many records.

#3
[eluser]rochellecanale[/eluser]
I used a pagination in my view.

#4
[eluser]InsiteFX[/eluser]
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.

#5
[eluser]rochellecanale[/eluser]
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.

#6
[eluser]InsiteFX[/eluser]
You can raise the mysql values in my.ini in the mysql\bin folder.

#7
[eluser]rochellecanale[/eluser]
Ok i will try that thanks.

#8
[eluser]rochellecanale[/eluser]
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-2019 MyBB Group.