Welcome Guest, Not a member yet? Register   Sign In
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?




Theme © iAndrew 2016 - Forum software by © MyBB