Tag: database
How to Install / Upgrade To MariaDB 10.4 on Ubuntu 18.04 / 20.04
Choose a mirror close to your server to download from: https://downloads.mariadb.org/mariadb/repositories/# Here are the commands to install MariaDB 10.4 from the MariaDB repository: 1. DigitalOcean mirrors…
How To Manually Upgrade phpMyAdmin
1. Back up phpMyAdmin You should back up your current phpMyAdmin folder by renaming it: $ sudo mv /usr/share/phpmyadmin/ /usr/share/phpmyadmin.bak…
Adminer – A Simple & Secure Replacement For phpMyAdmin
Why replace phpMyAdmin with Adminer? Replace phpMyAdmin with Adminer and you will get a tidier user interface, better support for MySQL features, higher performance and…
How To Install MongoDB On Ubuntu 16.04
https://www.digitalocean.com/community/tutorials/how-to-install-mongodb-on-ubuntu-16-04 1. Import they key for the official MongoDB repository $ sudo apt-key adv –keyserver hkp://keyserver.ubuntu.com:80 –recv EA312927 After successfully…
How To Export A MySQL Database Using The Command Prompt
https://stackoverflow.com/questions/3031412/how-to-export-a-mysql-database-using-command-prompt https://stackoverflow.com/questions/17666249/how-to-import-an-sql-file-using-the-command-line-in-mysql 1. Easiest Way For Export: $ mysqldump -u [username] -p [password] [dbname] > filename.sql To Import: $ mysql…
MariaDB/MySQL Will Not Start
https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/42921-unable-to-start-mysql-service ERROR: When there is a database error where your sites can’t connect to the db. This happened to me…