This repository has been archived by the owner on May 18, 2023. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
Maintenance
ZeroC0D3 Team edited this page Jan 19, 2018
·
1 revision
- Backup MySQL
mysqldump -h [hostname] --port=[port] -u [user_db] -p [db_name] > [dump.sql]
- Restore MySQL
mysql -h [hostname] -u [user_db] -p [db_name] < [dump.sql] # (Type your password after ENTER)
- Port MySQL
3306 # default / staging / production
- Recommendation Admin Tools
phpMyadmin => https://www.phpmyadmin.net/
adminer => https://www.adminer.org/
DBeaver => https://dbeaver.jkiss.org/
- Backup PostgreSQL
pg_dump --dbname=postgresql://[user_db]:[password]@[hostname]:[port]/[db_name] > [dump.sql]
- Restore Postgresql
sudo -i -u postgres
psql -h [hostname] -U [user_db] -W [db_name] < [dump.sql] # (Type your password after ENTER)
- Port PostgreSQL
5432 # default / staging
5433 # production
- Recommendation Admin Tools
pgAdmin => https://www.pgadmin.org/
DBeaver => https://dbeaver.jkiss.org/
- Troubleshoot
Forget postgres password => https://stackoverflow.com/questions/10845998/i-forgot-the-password-i-entered-during-postgres-installation
- Backup MongoDB
# Create Backup Folder
mkdir -p [path_backup]/[backup_folder_name]
# Run mongodump (without username & password)
mongodump --out [path_backup]/[backup_folder_name]
# Run mongodump (with username & password)
mongodump --host [hostname] --port [port] --username [username] --password '[password]' --out [path_backup]/[backup_folder_name]
- Restore MongoDB
# Restore without username & password
mongorestore [path_backup]/[backup_folder_name]
# Restore with username & password
mongorestore --host [hostname] --port [port] --username [username] --password '[password]' [path_backup]/[backup_folder_name]
- Port MongoDB
27017
- Recommendation Admin Tools
robo3t => http://www.robomongo.org
Kandaga Community Platform Applications
- Repositories: https://github.com/k4ndaga
- KandagaCMS: https://github.com/k4ndaga/KandagaCMS
- License: MIT License
- Install-Packages
- Setup-Server
- Setup-Account
- Configuration-Bash
- Configuration-Zsh
- Install-Bash-Theme
- Install-Zsh-Theme
- Install-Docker
- Install-Memcached
- Install-MongoDB
- Install-MySQL
- Install-NodeJS
- Install-PostgreSQL
- Install-Redis
- Install-Ruby
- Configuration-App
- Configuration-Crontab
- Configuration-Fstab
- Configuration-GCM
- Configuration-Hosts
- Configuration-Memcached
- Configuration-VueJS
- Configuration-Puma
- Configuration-Unicorn
- Nginx-Puma
- Nginx-Unicorn
- Logrotate