MySQL Command Line Untuk Backup/Restore

Ntah berapa kali guna web untuk backup kadangkala banyak halangan dan membuat perasaan yang membengangkan so kembali ke zaman porba kala kita gunakan command line. Cuba korank try syiok gak backup MYSQL.

Single databases : korank gunakan command mysqldumb macam kat bawah ni

mysqldump database_name > database_name.sql

Multiple databases korank gunakan untuk multiple databse sekali backup

mysqldump --databases database_one database_two > two_databases.sql

Dengan kod ni korank akan backup 2 DB dalam satu sql statement , jadi bila korank run sql ni , ia akan create 2 DB sekaligus.

Kalau korank nak cepat gunakan command kat bawah ni, backup semua skali ... ha ha ha senang je.

mysqldump --all-databases > all_databases.sql

Restore Balik Backup MYSQL

Dah korank backup so kena la reatore balikkan. Jadi just bagitau je mysql apa yang direstore.

mysql database_name < database_name.sql

Seperti biasa kalau nak cepat gunakan command ajaib yang ada perkataan all. ATau korank boleh gak tarik single DB dengan gunakan macam kat bawah ni.

mysql --one-database database_name < all_databases.sql

Plugins Yang Perlu Ada Sebagai Web Developer

1. MEASUREIT
2. SEARCH STACK OVERFLOW
3. RESPONSIVE INSPECTOR
4. CODE COLA
5. PHP CONSOLE

Mega Calendar for Redmine

Plugin for redmine: Brings a better calendar and more oppurtunities to set holidays.

Only compatible/tested with redmine 3.0.X, 3.1.X, 3.2.X, 3.3.X and Ruby 2.2, Rails 4.2
Please test this plugin for other redmine versions and let me know if there are any bugs.

Installation

Standard redmine plugin installation: You can read the generic plugin installation guide here or you can use the following guide (Debian 7, Apache2/Passenger).

Go to your redmine plugins-folder
cd /srv/redmine/plugins
Download the latest plugin-Version:
wget https://github.com/berti92/mega_calendar/archive/master.zip
Unzip the downloaded zip-File
unzip master.zip
Rename the folder:
mv mega_calendar-master mega_calendar
Give the folder the right privileges in this case apache (to execute the command you must be root)
chown -R www-data.www-data mega_calendar
Go to the plugin folder
cd /srv/redmine/plugins/mega_calendar
Install the gems
bundle
Go back to your redmine folder
cd /srv/redmine
Migrate the database
bundle exec rake redmine:plugins:migrate RAILS_ENV=production
Now restart your redmine and you can configure the plugin in the admin settings in redmine.
To start redmine under apache2/passenger, please execute the following commands 
cd /srv/redmine
touch tmp/restart.txt

Usage

Within a issue you are able to set a time as start and end, to get a better calendar view. On top of the page you can reach the calendar and holiday section.

Please make sure that you set your users, that will be allowed to use this plugin and that the sub-path is set to "/" without quotes at the plugin settings.

Screenshots

A quick overview about this plugin, you'll get on http://mega-calendar.devbert.de/

History

1.4.0: Added export functionality (ics) - Please make sure, that you have installed the gems -> WIKI

1.3.8: Now you are able to set the start of the week within the plugin settings

1.3.7: Bugfix

1.3.6: Bugfix

1.3.5: Bugfix

1.3.4: Added ability to create issues from the calendar, just click on a free space on the calendar

1.3.3: Added support for Redmine 3.3.X

1.3.2: Added support for Redmine 3.2.X

1.3.1: Bugfix

1.3.0: Added right for this plugin

1.2.0: Added support for sub paths

1.1.0: Fixed a few bugs, added widget to MyPage

1.0.0: First release

You like my work?

If you like my work, you can buy me a coffee  or try my new browser game: Sketcharama

License

MIT License