How To Get the Structure of All Tables in a MySQL Database Using mysqldump

Author: , December 2nd, 2018

mysqldump -u {yourUserNameHere} -p –no-data –compact {yourDatabaseHere}

How To Force WordPress to Connect to the Database via TCP

Author: , October 2nd, 2013

wp-config.php 1 2 define(’DB_HOST’, ’127.0.0.1:3306′); define(’DB_PORT’, 3306); define(‘DB_HOST’, ’127.0.0.1:3306′); define(‘DB_PORT’, 3306);

How To Install MongoDB Via Yum On CentOS/Amazon Linux

Author: , January 18th, 2012

Procedure 1 2 3 4 5 6 7 8 9 vim  /etc/yum.repos.d/10gen.repo yum install mongo-10gen mongo-10gen-server vim /etc/mongod.conf – set dbpath variable mkdir /volumes/data/mongo chown mongod:mongod /volumes/data/mongo chmod 2775 /volumes/data/mongo chkconfig mongod on service mongod start pecl install mongo vim /etc/yum.repos.d/10gen.repo yum install mongo-10gen mongo-10gen-server vim /etc/mongod.conf – set dbpath variable mkdir /volumes/data/mongo chown mongod:mongod […]

How To Rename A MySQL Database

Author: , December 3rd, 2011

YMMV… 1 2 mysql –batch -u root -p -e "create database yourDataBaseBackup; SELECT CONCAT(‘RENAME TABLE ‘,table_schema,’.’,table_name,’ TO ‘,’yourDataBaseBackup.’,table_name,’;’) FROM information_schema.TABLES WHERE table_schema LIKE ‘yourDataBase’;" > backup.sql mysql -u root -p < backup.sql mysql –batch -u root -p -e “create database yourDataBaseBackup; SELECT CONCAT(‘RENAME TABLE ‘,table_schema,’.’,table_name,’ TO ‘,’yourDataBaseBackup.’,table_name,’;’) FROM information_schema.TABLES WHERE table_schema LIKE ‘yourDataBase’;” > backup.sql […]

How To Import Excel CSV Into MySQL Via phpMyAdmin

Author: , July 22nd, 2010