CodeIgniter Forums
Viewing million of data error (Unable to select the specified database) - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: Viewing million of data error (Unable to select the specified database) (/thread-56312.html)



Viewing million of data error (Unable to select the specified database) - El Forum - 12-09-2012

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


Viewing million of data error (Unable to select the specified database) - El Forum - 12-10-2012

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



Viewing million of data error (Unable to select the specified database) - El Forum - 12-10-2012

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


Viewing million of data error (Unable to select the specified database) - El Forum - 12-10-2012

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



Viewing million of data error (Unable to select the specified database) - El Forum - 12-10-2012

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


Viewing million of data error (Unable to select the specified database) - El Forum - 12-10-2012

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



Viewing million of data error (Unable to select the specified database) - El Forum - 12-10-2012

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


Viewing million of data error (Unable to select the specified database) - El Forum - 12-10-2012

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