![[Google]]( http://www.mickgenie.com/blog/wp-content/plugins/easy-adsenser/google-light.gif)
-
Archives
Categories
- Apache (9)
- ASP.Net (4)
- Blogging (14)
- cPanel (17)
- Database (14)
- DNS (2)
- DotNetPanel (1)
- FrontPage Extension (4)
- Gadget (1)
- Google Software/Tips (9)
- Helm (3)
- Internet/Technology (9)
- Joomla (2)
- Linux (37)
- Microsoft IIS (15)
- Microsoft Windows (26)
- Perl (1)
- PHP (7)
- Ruby on Rails (3)
- Smartermail (1)
- VBScript (1)
- Web Hosting (6)
- Web Site Tips (14)
- wordpress (10)
Blogroll
Blogster
Mick Genie Sub Site
Recent Comments
-
Tag
Amp Apache Asp Net Beta Version Blog cmd Configuration File cPanel Database Name domain name Error Message firefox FrontPage Extension Genie Google Google Software/Tips Htaccess File IP Ips Linux Lt Mick Genie Microsoft Microsoft Iis Microsoft IIS Mozilla Firefox Mysql Database notepad php plugin reboot Remote Server Running Scripts Server Administrator ssh Tar Gz Ubuntu Unix Url Windows Operating System Windows Server Windows Vista wordpress Yum
WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.
Superman
Top CommentatorsMeta
-
Category Archives: Database
SQL: Select
Assume that we have a table named MyTable and it contain 4 column named ID, Name, Date and City. Today, I will show some SQL Select command that might useful to SQL Administrator daily task. 1) SELECT * FROM MyTable … Continue reading
Posted in Database
Tagged Abc, Address Name, Asc, Ascending Order, Column Address, Current Date, Current Information, Database Name, Desc, Getdate, Johore, Memory Resident, Null Return, Null Values, Penang, Selec, Select Name, Servername, Sql Select, Visual Studio
Leave a comment
Remote MySQL Access for cPanel
By right, MySQL is one of the engine that used up lots of I/O and Memory resource from a server. Somehow you may use this scenario to setup so-called Clustering Web and MySQL server to reduce the I/O usage. To … Continue reading
Posted in Database, cPanel
Tagged 192 168 1 1, Cnf, Config, cPanel, Memory Resource, Mysql Access, Mysql Grant, Mysql Server, phpmyadmin, Port 3306, Privilege, Privileges, Remote Access, Remote Host, Root User, Server Client, Servers, Slave Server, Web Server
2 Comments
phpMyAdmin Socket Error
If you are webmaster who using the web interface database management, you shall be familiar with phpMyAdmin. Then you might get these error from your phpMyAdmin when you logged into the phpMyAdmin. #2002 - The server is not responding (or … Continue reading
Posted in Database
Tagged 2 Ways, Config Php, Database Management, Lib, Ln S, Localhost, Mysql Server, phpmyadmin, phpmyadmin socket error, Server Socket, Servers, Socket Error, Symbolic Link, Tmp, Web Interface
Leave a comment
Reset MySQL 5.1 Root password
Sometimes you might want to reset your used password since it is used for long time. To reset MySQL database password, you may need to consider different Operating System and it's version will have minor differences during the root password … Continue reading
Posted in Database
Tagged Amp, C Drive, cmd, Database Password, Delete File, File Password, Genie, Linux, Long Time, Minor Differences, Mysql Database, Mysql Set, Mysql Windows, Password Code, Password Reset, Privileges, Reset MySQL database password, Reset MySQL password, Reset Password, Services Exe, Windows Operating System
Leave a comment
Scheduled MySQL database backup
Assume that you are using crontab to schedule your task which you are using Unix system. To schedule a database backup, it will be very easy as step below. 1. Log into your SSH. 2. Type "crontab -e" without quote. … Continue reading
MySQL Useful Command
If you are the database administrator, today post will help you to mange your server easily. mysqladmin ping -check whether the server is alive mysqladmin status -display a short server status message. mysqladmin variable -display the server system variables and … Continue reading
Restore MySQL database with MySQLdump
MySQL database is one of the famous database engine used from the IT world. To you might have a question such as how to move the current hosted database to another server? Actually it is very easy through the command … Continue reading
Change MySQL Collation
Sometimes, the MySQL database collation could make your web content become question mark(?) and you might not know what is happening and what wrong from your scripting. To understand what is the server default collation, there are two ways to … Continue reading
How to repair your MySQL databases
If you are using MySQL databases as your database engine, you surely ever get the error message as below if your database grown day by day. Table "table" is marked as crashed and should be repaired. To understand MySQL database … Continue reading
Posted in Database
Tagged Database Engine, Database Name, Database Table, Error Message, File Extension, Ini, Myi, MYISAMchk, Mysql Database, Mysql Databases, Open Ssh, Path, repair mysql, tmpdir
1 Comment
Identify slow MySQL query
Sometimes, MySQL will make your server pain if you have user abusing it. Mick Genie will teach you to identify which MySQL database creating the problem to your server. Actually MySQL can log all of the those query that taking … Continue reading
Posted in Database
Tagged Cnf, Code 3, Code 7, Genie, Mick Genie, my.cnf, Mysql Database, MySQL Pain, Mysql Query, MySQL Slow Query, mysqld, Queries, Query Time, Time 3, vi editor, Wq
1 Comment
@h ju (5)
marccus (3)
arren (1)
canmasu (1)
EinsamSoldat (1)
GuTi (1)
Hire Dedicated C#... (1)
Jaylax (1)
K.C (1)
KcYeap (1)
Keat (1)
Steve (1)
