Finding Out Your Server Specs Through A PHP Script
Have you ever need to know what your server is running? Need to see if it runs mysql? Well here is a way of knowing what options are available in PHP and…
Category: MySQL
MySQL’s Status Command
Status allows you to see various stats on the MySQL daemon. To get to your MySQL shell, type the following command at your shell:
|
1 |
[icezip@saturn ~/]$ mysql -u icezip -p |
(where icezip is your user…
Counting Number Of Entries In A Database
Do you have your own database? How would you like to know how many entries you have in your database from a PHP page? Well its easy, I am going to show…
New to Mysql? Read the Series and Become an Expert
This is the beginning of a series where I will work through the basic Mysql commands that you will need to manage a database.These commands are covered in this part…
Database-Driven User Authentication
Ever have something that you wanted to put on the internet for only a group of people to see? Well then this script is for you. All you need is;…
Using MysqlDump
MysqlDump can be used for many different reasons. For one, you can use mysqldump to backup the data in your MySql DataBase. Here is what mysqldump does. MYSQLDUMP – takes all the information…
[Database] How to Install and Use Mysql Mac
All the required files are available on the the www.mysql.com download page, how to install and configure the interface described in detail can be seen in the following link: Note…
How to move your MySQL data store
Databases grow over time, and sometimes it’s necessary to add disk space to a server to accommodate that growth. Fortunately, moving your database is a fairly simple process. The following is tested…
Conceptual, Logical, and Physical Data Models
There are three levels of data modeling. They are conceptual, logical, and physical. This section will explain the difference among the three, the order with which each one is created,…
Step By Step Mysql Installation on Windows
We’re going to set up mysql by simply following the steps. 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19….