Database Admin Controller for Code Igniter and Ext JS 4
I have been using Code Igniter and Ext JS 4 for several months. In that time, I have created a couple basic templates to display MySQL tables and perform CRUD…
Read moreCount number of tables in the database – MySQL
Determining the number of tables that are contained in a MySQL database is very straight-forward, although it is an often asked question. The simplest way to accomplish this is using…
Read moreWhat database does Facebook use?
What database does Facebook use is one of the most common questions asked when folks start taking about what database is the most scalable for large scale web applications. …
Read moreMySQL – A simple script to truncate all MySQL tables in a Database
Want a quick and dirty way to Truncate all the tables in a MySQL DB? You can use the following one line script. mysqldump -ppassword YourDBName –no-data dumpfile | mysql…
Read moreMySQL – Best way to remove all data from a table
There are multiple ways in which to remove all data from a MySQL Table. The first is to use the DROP TABLE command, which will remove the entire table with…
Read moreMySQL – Help, I lost the Root password! Error number 1045
Have you ever seen the dreaded MySQL Error number 1045 Access denied for user ‘root’@’localhost’ (using password: YES)? Don’t worry, this is an easy to recover from situation. Just follow…
Read more