CodeIgniter Forums

Full Version: Viewing million of data error (Unable to select the specified database)
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[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.

El Forum

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

El Forum

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

El Forum

[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.

El Forum

[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.

El Forum

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

El Forum

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

El Forum

[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?