Tag Archives: Database Name

SQL: Select

Posted on July 11, 2010 by Mick Genie

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

MySQL Useful Command

Posted on May 25, 2010 by Mick Genie

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 →

Posted in Database | Tagged Backup Mysql, Database Administrator, Database Name, Lt, Mysql Database, MySQL Handy Guide, Queries, Server Status, Server System, Sql Backup, Sql Database, Stat, Status Message, System Variables | Leave a comment

Restore MySQL database with MySQLdump

Posted on May 24, 2010 by Mick Genie

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 →

Posted in Database | Tagged Current, Database Code, Database Engine, Database Name, Database Server, File Password, File Restore, Mysql Database, Password Code, Password Database, Remote Ip, Remote Server, Restore File, restore MySQL database, Sql Code, Sql Database | 1 Comment

How to repair your MySQL databases

Posted on May 18, 2010 by Mick Genie

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

Schedule backup for MSSQL to remote computer

Posted on April 29, 2010 by Mick Genie

If you familiar with MSSQL maintenance plan and ever configured backup through this tool and you should know that to backup the MSSQL database to remote computer, you have to configure Log On setting from services. Okay, today we assume … Continue reading →

Posted in Database, Microsoft Windows | Tagged Bat, Batch Command, Batch File, Database Name, Database Task, Directory, Maintenance Plan, Maintenance Tool, Mssql Database, Remote Backup, Remote Computer, Remote Server, Server C, Server Name, Windows Task Scheduler, Xcopy | Leave a comment

MySQL Check Table Syntax

Posted on April 15, 2009 by Mick Genie

If you are getting error like below. ===========ERROR LOG============= 090415 0:59:06090415 0:59:06 [ERROR] Cannot find table database/tables from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data … Continue reading →

Posted in Database | Tagged Check Html, Check Table, Data Dictionary, Database Name, Database Tables, Doc, Frm File, Frm Files, InnoDB, MyISAM, MYISAMchk, MySQL, Refman, Repair Table, Shell, Table Database, Table Html, Table Syntax, Type Login, Url | Leave a comment

Tag Archives: Database Name

SQL: Select

MySQL Useful Command

Restore MySQL database with MySQLdump

How to repair your MySQL databases

Schedule backup for MSSQL to remote computer

Archives

Categories

Blogroll

Blogster

Mick Genie Sub Site

Recent Comments

Tag

Superman

Meta

Sponsored Links