Tag Archives: restore

PostgreSQL database Backup and Restore from the CLI

Warning: count(): Parameter must be an array or an object that implements Countable in /home/wwwmani/public_html/42/wp-content/plugins/wp-shkshell/wp-shkshell.php on line 59

Quick note about how to backup and restore a PostgreSQL database from the command line. Things to know: – Name of the database you want to backup; – Username and password of the database user; – your way around a command line – at least how to open it or who to ask to open… Read More »

MySQL Command Line – Part 1

This is a simple reminder of the mysql command line tool. In windows, open a command line, navigate to mysql binary folder (if you have it on your PATH, you can skip the navigation part), and use: To login: mysql -u #username# -p#password# (if you dont add the #password#.. it will ask you for one.… Read More »