MySQL Datenbanken per Konsole sichern und wiederherstellen

Einzelne MySQL Datenbank exportieren

mysqldump -u username -p database_name > dump.sql

Die Struktur einer MySQL Datenbank exportieren

mysqldump -u username -p --no-data database_name > dump.sql

Die Daten aus einer MySQL Datenbank exportieren

mysqldump -u username -p --no-create-info database_name > dump.sql

Mehrere MySQL Datenbanken exportieren

mysqldump -u username -p --databases db_name1 [db_name2 ...] > dump.sql

Alle MySQL Datenbanken exportieren

mysqldump -u username -p --all-databases > dump.sql

MySQL Datenbanken importieren

mysql -u username -p database_name < dump.sql

Vielen Dank an: Webprosa

Bootstrap 4 Template für CMS made Simple CMSMS

Dieser Beitrag wurde von übernommen und dienst lediglich als mein Öffentliches Bookmark.

Hier also das Template und die Vorgehensweise zur Installation.

This is my generic Bootstrap 4 template for use with CMSMS. It provides a central settings file to easily change the template, as well as a flexible template with 9 content sections. Sections can be styled through the Content Manager using the Bootstrap classes. It has the following dependencies:

Recommended CMSMS modules:

  • CGSmartImage
  • CGExtensions
  • CSSPreProcessor
  • SitemapMgr
  • Markdown1

Links to the template, stylesheets and required UDTs:

Template Files:
CSS Files:
Smarty plugins:

Place these in /assets/plugins/


  • Create a new design in Design Manager called Bootstrap4
  • Create each of the templates above, using the same names (eg „Bootstrap4 Settings“).
  • The default template shoudl be set to:
    • Bootstrap4 Nonuple Cols
  • The following templates should be set as unlisted:
    • Bootstrap4 Core
    • Bootstrap4 Settings
  • Create a new folder under /assets/themes called bootstrap4

Setting up the CSS.

Setting up the app-manifest
  • Create a new page.
  • Name it app-manifest.json
  • Make sure the alias includes the extension
  • Insert a placeholder in the content area. This will not be shown.
  • Set it to use the Bootstrap4 AppManifest template type.
  • Hide it from the menu
  • Update the $manifest_alias variable found around line # in the Bootstrap4 Settings template.

Anker bei Fixed Navbar treffen nicht

If you’re using a .navbar-fixed-top fixed to top navbar in Twitter Bootstrap you probably have noticed your anchor ahref links no longer line up correctly.

The easiset way to fix this is to the use the <section id="MyAnchor"> tag with a padding-top equal to the padding you’ve added to the body.

So for example if you have:

.body {

You will then want to add the same padding to your section CSS:

section {

If the 40px gap above each section is going to mess with your design mojo you can add a negative margin-bottom. So for example:

section {