Author:
erics , January 21st, 2020
echo ` mysql - uyourUser - pyourPassword - B -- disable - column - names - e "SELECT CONCAT('DROP DATABASE ', SCHEMA_NAME, ';') FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME LIKE 'yourPrefix%';" ` | mysql - uyourUser - pyourPassword - B
Categories: How-To's , Technology Tags: Concat , Database , DB , drop , DROP DATABASE , drop database like , howto , INFORMATION_SCHEMA , INFORMATION_SCHEMA.SCHEMATA , LIKE , Match , mysql , SCHEMA_NAME , SCHEMATA , tips
| No comments
Author:
erics , December 2nd, 2018
mysqldump -u {yourUserNameHere} -p –no-data –compact {yourDatabaseHere}
Categories: How-To's , Technology Tags: create table , Database , howto , mysql , mysqldump , Structure , Table , tips
| No comments
Author:
erics , October 2nd, 2013
wp-config.php
define ( 'DB_HOST' , '127.0.0.1:3306' ) ;
define ( 'DB_PORT' , 3306 ) ;
Categories: How-To's , Technology Tags: 127.0.0.1 , 3306 , Config , Connect , Database , DB_HOST , DB_PORT , Force , howto , mysql , TCP , tips , WordPress , wp-config , wp-config.php
| No comments
Author:
erics , January 18th, 2012
Procedure
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
/etc/yum.repos.d/10gen.repo For 64-bit:
[ 10gen ]
name = 10gen Repository
baseurl = http : //downloads-distro.mongodb.org/repo/redhat/os/x86_64
gpgcheck = 0
For 32-bit:
[ 10gen ]
name = 10gen Repository
baseurl = http : //downloads-distro.mongodb.org/repo/redhat/os/i686
gpgcheck = 0
Resource Links http://www.mongodb.org/display/DOCS/CentOS+and+Fedora+Packages http://www.if-not-true-then-false.com/2010/install-mongodb-on-fedora-centos-red-hat-rhel/ http://devzone.zend.com/1730/getting-started-with-mongodb-and-php/
Categories: How-To's , Technology Tags: Amazon , AWS , Database , howto , Linux , Mongo , MongoDB , Object , OOPS , Persistant Store , tips
| No comments
Author:
erics , December 3rd, 2011
YMMV…
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
Categories: How-To's , Technology Tags: Batch , Database , howto , mysql , Rename , SQL , tips
| No comments