# copy mongo db.copyDatabase(’source’, ‘target’) # drop mongo use <dbname> db.runCommand({dropDatabase:1})# copy mongo db.copyDatabase(‘source’, ‘target’) # drop mongo use <dbname> db.runCommand({dropDatabase:1})
Category: Databases
Mongo GUI
3T MongoChef is a MongoDB GUI for Mac, Windows, and Linux. 3T MongoChef is free for personal and non-commercial use. Full support for MongoDB 3.0.
MySQL: show current database
$result = mysql_query("SELECT database() databaseName"); $row = mysql_fetch_assoc($result); var_dump($row);$result = mysql_query("SELECT database() databaseName"); $row = mysql_fetch_assoc($result); var_dump($row);
MySQL: MariaDB
MariaDB is a drop-in replacement for MySQL. MariaDB strives to be the logical choice for database professionals looking for a robust, scalable, and reliable SQL server.
MySQL: backup tools
Percona Percona XtraBackup is an open-source hot backup utility for MySQL – based servers that doesn’t lock your database during the backup. It can back up data from InnoDB, XtraDB, and MyISAM tables on MySQL 5.1, 5.5 and 5.6 servers. This tool is a combination of the xtrabackup C program, and the innobackupex Perl script. The
Continue reading MySQL: backup tools