MySQL - How to Import File Into Database

MySQL

Use this query to import file (txt or csv) into your database. This query is also usefull when you need to import big file with a lot of data.

Create Database using UTF8 Charset in MySQL

MySQL

MySQL example query to create database using utf8 character set in MySQL

Multiple Database Connection in CodeIgniter

CodeIgniter

You can define your database groups in codeigniter database configuration to create multiple database connection

How to Create MySQL User

MySQL

Use this sql query to create mysql user. Easy ;)

Remote to Local MySQL Database Copy

MySQL

Basic mysql command to copy remote MySQL database to your local machine

MySQL: Repair All Database Tables

Bash

Basic command example to repair all tables in MySQL database using mysqlcheck

Basic MySQL Restore Command

Bash

Basic mysql command example to restore database from a sql dump file

Built In MySQL Database Function Examples

MySQL

List of MySQL database built in function examples