Tutorial: MySQL- und MariaDB-Datenbanken über SSH mit Putty exportieren und importieren

Tutorial: Datenbanken über SSH exportieren und importieren MySQL und MariaDB Datenbanken unter Putty exportieren und importieren Einführung In diesem Tutorial erfahren Sie, wie Sie SSH in Verbindung mit Putty verwenden, um MySQL- und MariaDB-Datenbanken zu exportieren und zu importieren. SSH bietet eine sichere Verbindung zu Ihrem Server, während Putty ein beliebter SSH-Client für Windows ist. Schritt 1: SSH-Zugang einrichten und Putty verwendenInstallieren Sie Putty auf Ihrem Windows-Computer und öffnen Sie das Programm. Rufen Sie die IP-Adresse oder den Hostnamen Ihres Servers ab und geben Sie diese in Putty ein. Stellen Sie sicher, dass der SSH-Port (Standard: 22) für die Verbindung geöffnet ist. Geben Sie Ihre SSH-Anmeldeinformationen ein (Benutzername und Passwort) und stellen Sie eine erfolgreiche Verbindung her. Schritt 2: Exportieren einer MySQL-DatenbankGeben Sie den Befehl mysqldump -u [Benutzername] -p [Datenbankname] > export.sql ein, um die gewünschte MySQL-Datenbank zu exportieren.Geben Sie das Passwort für den MySQL-Benutzer ein, wenn Sie dazu aufgefordert werden. Dadurch wird die Datenbank in eine SQL-Datei namens export.sql exportiert. Schritt 3: Exportieren einer MariaDB-DatenbankVerwenden Sie den Befehl mysqldump -u [Benutzername] -p [Datenbankname] > export.sql wie im vorherigen Schritt beschrieben. Geben Sie das Passwort für den MariaDB-Benutzer ein, wenn Sie dazu aufgefordert werden. Die MariaDB-Datenbank wird nun in die SQL-Datei export.sql exportiert. Der Dateiname export.sql steht als Platzhalter und kann von Ihnen frei vergeben werden. Sie sollten auf die Nutzung von Umlauten, Sonderzeichen und Leerzeichen verzichten. Schritt 4: Importieren einer DatenbankLaden Sie die SQL-Datei export.sql auf Ihren Server hoch, zum Beispiel via FTP. Verbinden Sie sich mit Ihrem Server über SSH und stellen Sie sicher, dass Sie sich im richtigen Verzeichnis befinden. Verwenden Sie den Befehl mysql -u [Benutzername] -p [Datenbankname] < export.sql um die Datenbank zu importieren. Geben Sie das Passwort für den MySQL- oder MariaDB-Benutzer ein, wenn Sie dazu aufgefordert werden. Die Datenbank wird nun importiert und steht Ihnen zur Verfügung. Tipp: Packen und Entpacken von SQL-DateienUm die SQL-Datei zu packen, können Sie den Befehl zip export.zip export.sql verwenden, um eine ZIP-Datei zu erstellen, oder tar -czvf export.tar.gz export.sql für eine GZIP-komprimierte TAR-Datei. Um die gepackte Datei zu entpacken, verwenden Sie unzip export.zip für ZIP-Dateien oder tar -xzvf export.tar.gz mysqldump -u [Benutzername] -p [Datenbankname] > export.sql JTL Servicepartner Anfrage Sie sind auf der suche nach einem JTL Servicepartner oder interessieren sich für einen ansprechenden Shop? Dann sind Sie bei uns genau richtig! Werfen Sie einen Blick in unsere Referenzen, überzeugen Sie sich von unseren JTL Projekten, welche wir erfolgreich für unsere Kunden durchführen dürften und nehmen Sie gerne mit uns Kontakt auf: Hinweis: Für diesen Inhalt ist JavaScript erforderlich. var formDisplay=1;var nfForms=nfForms||[];var form=[];form.id='1_1';form.settings={"objectType":"Form Setting","editActive":true,"title":"Kontakt","key":"","created_at":"2022-12-22 18:00:33","default_label_pos":"below","conditions":[],"show_title":0,"clear_complete":"1","hide_complete":"1","wrapper_class":"","element_class":"","add_submit":"1","logged_in":"","not_logged_in_msg":"","sub_limit_number":"","sub_limit_msg":"","calculations":[],"formContentData":["betreff_1685715865487","name","email","nachricht_1671729346936","ich_stimme_der_less_than_a_href_datenschutzerklaerung_target_blank_greater_than_datenschutzerklaerung_less_than_a_greater_than_zu_1686833338959","nachricht_senden_1671729558805"],"container_styles_background-color":"","container_styles_border":"","container_styles_border-style":"","container_styles_border-color":"","container_styles_color":"","container_styles_height":"","container_styles_width":"","container_styles_font-size":"","container_styles_margin":"","container_styles_padding":"","container_styles_display":"","container_styles_float":"","container_styles_show_advanced_css":"0","container_styles_advanced":"","title_styles_background-color":"","title_styles_border":"","title_styles_border-style":"","title_styles_border-color":"","title_styles_color":"","title_styles_height":"","title_styles_width":"","title_styles_font-size":"","title_styles_margin":"","title_styles_padding":"","title_styles_display":"","title_styles_float":"","title_styles_show_advanced_css":"0","title_styles_advanced":"","row_styles_background-color":"","row_styles_border":"","row_styles_border-style":"","row_styles_border-color":"","row_styles_color":"","row_styles_height":"","row_styles_width":"","row_styles_font-size":"","row_styles_margin":"","row_styles_padding":"","row_styles_display":"","row_styles_show_advanced_css":"0","row_styles_advanced":"","row-odd_styles_background-color":"","row-odd_styles_border":"","row-odd_styles_border-style":"","row-odd_styles_border-color":"","row-odd_styles_color":"","row-odd_styles_height":"","row-odd_styles_width":"","row-odd_styles_font-size":"","row-odd_styles_margin":"","row-odd_styles_padding":"","row-odd_styles_display":"","row-odd_styles_show_advanced_css":"0","row-odd_styles_advanced":"","success-msg_styles_background-color":"","success-msg_styles_border":"","success-msg_styles_border-style":"","success-msg_styles_border-color":"","success-msg_styles_color":"","success-msg_styles_height":"","success-msg_styles_width":"","success-msg_styles_font-size":"","success-msg_styles_margin":"","success-msg_styles_padding":"","success-msg_styles_display":"","success-msg_styles_show_advanced_css":"0","success-msg_styles_advanced":"","error_msg_styles_background-color":"","error_msg_styles_border":"","error_msg_styles_border-style":"","error_msg_styles_border-color":"","error_msg_styles_color":"","error_msg_styles_height":"","error_msg_styles_width":"","error_msg_styles_font-size":"","error_msg_styles_margin":"","error_msg_styles_padding":"","error_msg_styles_display":"","error_msg_styles_show_advanced_css":"0","error_msg_styles_advanced":"","allow_public_link":0,"public_link":"https:\/\/www.bbfdesign.de\/ninja-forms\/1u4fa","embed_form":"","changeEmailErrorMsg":"Bitte gib eine g\u00fcltige E-Mail-Adresse ein.","changeDateErrorMsg":"Bitte gib ein g\u00fcltiges Datum ein!","confirmFieldErrorMsg":"Diese Felder m\u00fcssen \u00fcbereinstimmen!","fieldNumberNumMinError":"Die eingegebene Zahl ist zu klein.","fieldNumberNumMaxError":"Die eingegebene Zahl ist zu gross.","fieldNumberIncrementBy":"Bitte erh\u00f6hen in Schritten von","formErrorsCorrectErrors":"Bitte korrigiere die Fehler, bevor du das Formular sendest.","validateRequiredField":"Dies ist ein Pflichtfeld.","honeypotHoneypotError":"Honeypot-Fehler","fieldsMarkedRequired":"Felder mit einem * sind Pflichtfelder","currency":"","unique_field_error":"Ein Formular mit diesem Wert wurde bereits eingereicht.","drawerDisabled":false,"public_link_key":"1u4fa","form_title_heading_level":"3","ninjaForms":"Ninja Forms","fieldTextareaRTEInsertLink":"Link einf\u00fcgen","fieldTextareaRTEInsertMedia":"Medien einf\u00fcgen","fieldTextareaRTESelectAFile":"Eine Datei ausw\u00e4hlen","formHoneypot":"Falls du ein Mensch bist und dieses Feld siehst, dann lasse es bitte leer.","fileUploadOldCodeFileUploadInProgress":"Datei-Upload l\u00e4uft.","fileUploadOldCodeFileUpload":"DATEI-UPLOAD","currencySymbol":"","thousands_sep":".","decimal_point":",","siteLocale":"de_DE","dateFormat":"m\/d\/Y","startOfWeek":"1","of":"von","previousMonth":"Vorheriger Monat","nextMonth":"N\u00e4chster Monat","months":["Januar","Februar","M\u00e4rz","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember"],"monthsShort":["Jan","Feb","Mrz","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez"],"weekdays":["Sonntag","Montag","Dienstag","Mittwoch","Donnerstag","Freitag","Samstag"],"weekdaysShort":["So","Mo","Die","Mi","Do","Fr","Sa"],"weekdaysMin":["So","Mo","Di","Mi","Do","Fr","Sa"],"recaptchaConsentMissing":"reCaptcha validation couldnt load.","recaptchaMissingCookie":"reCaptcha v3 validation couldnt load the cookie needed to submit the form.","recaptchaConsentEvent":"Accept reCaptcha cookies before sending the form.","currency_symbol":"","beforeForm":"","beforeFields":"","afterFields":"","afterForm":""};form.fields=[{"objectType":"Field","objectDomain":"fields","editActive":false,"order":1,"idAttribute":"id","label":"Betreff","type":"listselect","key":"betreff_1685715865487","label_pos":"above","required":1,"options":[{"errors":[],"max_options":0,"label":"JTL Servicepartner","value":"JTL Servicepartner","calc":"","selected":0,"order":0,"settingModel":{"settings":false,"hide_merge_tags":false,"error":false,"name":"options","type":"option-repeater","label":"Optionen Erstellen Importieren","width":"full","group":"","value":[{"label":"Eins","value":"eins","calc":"","selected":0,"order":0},{"label":"Zwei","value":"zwei","calc":"","selected":0,"order":1},{"label":"Drei","value":"drei","calc":"","selected":0,"order":2}],"columns":{"label":{"header":"Beschriftung","default":""},"value":{"header":"Wert","default":""},"calc":{"header":"Berechneter Wert","default":""},"selected":{"header":"","default":0}}},"manual_value":true},{"errors":[],"max_options":0,"label":"JTL Shop","value":"JTL Shop","calc":"","selected":0,"order":1,"settingModel":{"settings":false,"hide_merge_tags":false,"error":false,"name":"options","type":"option-repeater","label":"Optionen Erstellen Importieren","width":"full","group":"","value":[{"label":"Eins","value":"eins","calc":"","selected":0,"order":0},{"label":"Zwei","value":"zwei","calc":"","selected":0,"order":1},{"label":"Drei","value":"drei","calc":"","selected":0,"order":2}],"columns":{"label":{"header":"Beschriftung","default":""},"value":{"header":"Wert","default":""},"calc":{"header":"Berechneter Wert","default":""},"selected":{"header":"","default":0}}},"manual_value":true},{"errors":[],"max_options":0,"label":"JTL POS","value":"JTL POS","calc":"","selected":0,"order":2,"settingModel":{"settings":false,"hide_merge_tags":false,"error":false,"name":"options","type":"option-repeater","label":"Optionen Erstellen Importieren","width":"full","group":"","value":[{"label":"Eins","value":"eins","calc":"","selected":0,"order":0},{"label":"Zwei","value":"zwei","calc":"","selected":0,"order":1},{"label":"Drei","value":"drei","calc":"","selected":0,"order":2}],"columns":{"label":{"header":"Beschriftung","default":""},"value":{"header":"Wert","default":""},"calc":{"header":"Berechneter Wert","default":""},"selected":{"header":"","default":0}}},"manual_value":true},{"errors":[],"max_options":0,"order":3,"new":false,"options":[],"label":"Anderes JTL Thema","value":"Anderes JTL Thema","calc":"","selected":0,"settingModel":{"settings":false,"hide_merge_tags":false,"error":false,"name":"options","type":"option-repeater","label":"Optionen Erstellen Importieren","width":"full","group":"","value":[{"label":"Eins","value":"eins","calc":"","selected":0,"order":0},{"label":"Zwei","value":"zwei","calc":"","selected":0,"order":1},{"label":"Drei","value":"drei","calc":"","selected":0,"order":2}],"columns":{"label":{"header":"Beschriftung","default":""},"value":{"header":"Wert","default":""},"calc":{"header":"Berechneter Wert","default":""},"selected":{"header":"","default":0}}},"manual_value":true},{"errors":[],"max_options":0,"order":4,"new":false,"options":[],"label":"Allgemeine E-Commerce Themen","value":"Allgemeine E-Commerce Themen","calc":"","selected":0,"settingModel":{"settings":false,"hide_merge_tags":false,"error":false,"name":"options","type":"option-repeater","label":"Optionen Erstellen Importieren","width":"full","group":"","value":[{"label":"Eins","value":"eins","calc":"","selected":0,"order":0},{"label":"Zwei","value":"zwei","calc":"","selected":0,"order":1},{"label":"Drei","value":"drei","calc":"","selected":0,"order":2}],"columns":{"label":{"header":"Beschriftung","default":""},"value":{"header":"Wert","default":""},"calc":{"header":"Berechneter Wert","default":""},"selected":{"header":"","default":0}}},"manual_value":true},{"errors":[],"max_options":0,"order":5,"new":false,"options":[],"label":"Individuelle Entwicklung","value":"Individuelle Entwicklung","calc":"","selected":0,"settingModel":{"settings":false,"hide_merge_tags":false,"error":false,"name":"options","type":"option-repeater","label":"Optionen Erstellen Importieren","width":"full","group":"","value":[{"label":"Eins","value":"eins","calc":"","selected":0,"order":0},{"label":"Zwei","value":"zwei","calc":"","selected":0,"order":1},{"label":"Drei","value":"drei","calc":"","selected":0,"order":2}],"columns":{"label":{"header":"Beschriftung","default":""},"value":{"header":"Wert","default":""},"calc":{"header":"Berechneter Wert","default":""},"selected":{"header":"","default":0}}},"manual_value":true},{"errors":[],"max_options":0,"order":6,"new":false,"options":[],"label":"Anderes Thema","value":"Anderes Thema","calc":"","selected":0,"settingModel":{"settings":false,"hide_merge_tags":false,"error":false,"name":"options","type":"option-repeater","label":"Optionen Erstellen Importieren","width":"full","group":"","value":[{"label":"Eins","value":"eins","calc":"","selected":0,"order":0},{"label":"Zwei","value":"zwei","calc":"","selected":0,"order":1},{"label":"Drei","value":"drei","calc":"","selected":0,"order":2}],"columns":{"label":{"header":"Beschriftung","default":""},"value":{"header":"Wert","default":""},"calc":{"header":"Berechneter Wert","default":""},"selected":{"header":"","default":0}}},"manual_value":true}],"container_class":"","element_class":"","admin_label":"","help_text":"","drawerDisabled":false,"id":"52_1","beforeField":"","afterField":"","value":"","parentType":"list","element_templates":["listselect","input"],"old_classname":"list-select","wrap_template":"wrap"},{"objectType":"Field","objectDomain":"fields","editActive":false,"order":2,"idAttribute":"id","label":"Name","key":"name","type":"textbox","created_at":"2022-12-22 18:00:33","label_pos":"hidden","required":1,"placeholder":"Ihr Name","default":"","wrapper_class":"","element_class":"","container_class":"first one-half","input_limit":"","input_limit_type":"characters","input_limit_msg":"Character(s) left","manual_key":"","disable_input":"","admin_label":"","help_text":"","desc_text":"","disable_browser_autocomplete":"","mask":"","custom_mask":"","wrap_styles_background-color":"","wrap_styles_border":"","wrap_styles_border-style":"","wrap_styles_border-color":"","wrap_styles_color":"","wrap_styles_height":"","wrap_styles_width":"","wrap_styles_font-size":"","wrap_styles_margin":"","wrap_styles_padding":"","wrap_styles_display":"","wrap_styles_float":"","wrap_styles_show_advanced_css":0,"wrap_styles_advanced":"","label_styles_background-color":"","label_styles_border":"","label_styles_border-style":"","label_styles_border-color":"","label_styles_color":"","label_styles_height":"","label_styles_width":"","label_styles_font-size":"","label_styles_margin":"","label_styles_padding":"","label_styles_display":"","label_styles_float":"","label_styles_show_advanced_css":0,"label_styles_advanced":"","element_styles_background-color":"","element_styles_border":"","element_styles_border-style":"","element_styles_border-color":"","element_styles_color":"","element_styles_height":"","element_styles_width":"","element_styles_font-size":"","element_styles_margin":"","element_styles_padding":"","element_styles_display":"","element_styles_float":"","element_styles_show_advanced_css":0,"element_styles_advanced":"","cellcid":"c3277","custom_name_attribute":"","personally_identifiable":"","value":"","drawerDisabled":false,"id":"1_1","beforeField":"","afterField":"","parentType":"textbox","element_templates":["textbox","input"],"old_classname":"","wrap_template":"wrap"},{"objectType":"Field","objectDomain":"fields","editActive":false,"order":3,"idAttribute":"id","label":"Email","key":"email","type":"email","created_at":"2022-12-22 18:00:33","label_pos":"hidden","required":1,"placeholder":"E-Mail Adresse","default":"","wrapper_class":"","element_class":"","container_class":"one-half","admin_label":"","help_text":"","desc_text":"","wrap_styles_background-color":"","wrap_styles_border":"","wrap_styles_border-style":"","wrap_styles_border-color":"","wrap_styles_color":"","wrap_styles_height":"","wrap_styles_width":"","wrap_styles_font-size":"","wrap_styles_margin":"","wrap_styles_padding":"","wrap_styles_display":"","wrap_styles_float":"","wrap_styles_show_advanced_css":0,"wrap_styles_advanced":"","label_styles_background-color":"","label_styles_border":"","label_styles_border-style":"","label_styles_border-color":"","label_styles_color":"","label_styles_height":"","label_styles_width":"","label_styles_font-size":"","label_styles_margin":"","label_styles_padding":"","label_styles_display":"","label_styles_float":"","label_styles_show_advanced_css":0,"label_styles_advanced":"","element_styles_background-color":"","element_styles_border":"","element_styles_border-style":"","element_styles_border-color":"","element_styles_color":"","element_styles_height":"","element_styles_width":"","element_styles_font-size":"","element_styles_margin":"","element_styles_padding":"","element_styles_display":"","element_styles_float":"","element_styles_show_advanced_css":0,"element_styles_advanced":"","cellcid":"c3281","custom_name_attribute":"email","personally_identifiable":1,"value":"","drawerDisabled":false,"id":"2_1","beforeField":"","afterField":"","parentType":"email","element_templates":["email","input"],"old_classname":"","wrap_template":"wrap"},{"objectType":"Field","objectDomain":"fields","editActive":false,"order":4,"idAttribute":"id","label":"Nachricht","key":"nachricht_1671729346936","type":"textarea","created_at":"2022-12-22 18:00:34","label_pos":"hidden","required":1,"placeholder":"Nachricht","default":"","wrapper_class":"","element_class":"","container_class":"","input_limit":"","input_limit_type":"characters","input_limit_msg":"Character(s) left","manual_key":"","disable_input":"","admin_label":"","help_text":"","desc_text":"","disable_browser_autocomplete":"","textarea_rte":"","disable_rte_mobile":"","textarea_media":"","wrap_styles_background-color":"","wrap_styles_border":"","wrap_styles_border-style":"","wrap_styles_border-color":"","wrap_styles_color":"","wrap_styles_height":"","wrap_styles_width":"","wrap_styles_font-size":"","wrap_styles_margin":"","wrap_styles_padding":"","wrap_styles_display":"","wrap_styles_float":"","wrap_styles_show_advanced_css":0,"wrap_styles_advanced":"","label_styles_background-color":"","label_styles_border":"","label_styles_border-style":"","label_styles_border-color":"","label_styles_color":"","label_styles_height":"","label_styles_width":"","label_styles_font-size":"","label_styles_margin":"","label_styles_padding":"","label_styles_display":"","label_styles_float":"","label_styles_show_advanced_css":0,"label_styles_advanced":"","element_styles_background-color":"","element_styles_border":"","element_styles_border-style":"","element_styles_border-color":"","element_styles_color":"","element_styles_height":"","element_styles_width":"","element_styles_font-size":"","element_styles_margin":"","element_styles_padding":"","element_styles_display":"","element_styles_float":"","element_styles_show_advanced_css":0,"element_styles_advanced":"","cellcid":"c3284","value":"","drawerDisabled":false,"id":"3_1","beforeField":"","afterField":"","parentType":"textarea","element_templates":["textarea","input"],"old_classname":"","wrap_template":"wrap"},{"objectType":"Field","objectDomain":"fields","editActive":false,"order":5,"idAttribute":"id","type":"checkbox","label":"Ich stimme der Datenschutzerkl\u00e4rung zu.","key":"ich_stimme_der_less_than_a_href_datenschutzerklaerung_target_blank_greater_than_datenschutzerklaerung_less_than_a_greater_than_zu_1686833338959","label_pos":"right","required":1,"container_class":"","element_class":"","manual_key":false,"admin_label":"","help_text":"","default_value":"unchecked","checked_value":"Ausgew\u00e4hlt","unchecked_value":"Nicht ausgew\u00e4hlt","checked_calc_value":"","unchecked_calc_value":"","id":"61_1","beforeField":"","afterField":"","value":"","parentType":"checkbox","element_templates":["checkbox","input"],"old_classname":"","wrap_template":"wrap"},{"objectType":"Field","objectDomain":"fields","editActive":false,"order":6,"idAttribute":"id","label":"Nachricht senden","key":"nachricht_senden_1671729558805","type":"submit","created_at":"2022-12-22 18:00:34","processing_label":"Verarbeite","container_class":"","element_class":"","wrap_styles_background-color":"","wrap_styles_border":"","wrap_styles_border-style":"","wrap_styles_border-color":"","wrap_styles_color":"","wrap_styles_height":"","wrap_styles_width":"","wrap_styles_font-size":"","wrap_styles_margin":"","wrap_styles_padding":"","wrap_styles_display":"","wrap_styles_float":"","wrap_styles_show_advanced_css":0,"wrap_styles_advanced":"","label_styles_background-color":"","label_styles_border":"","label_styles_border-style":"","label_styles_border-color":"","label_styles_color":"","label_styles_height":"","label_styles_width":"","label_styles_font-size":"","label_styles_margin":"","label_styles_padding":"","label_styles_display":"","label_styles_float":"","label_styles_show_advanced_css":0,"label_styles_advanced":"","element_styles_background-color":"","element_styles_border":"","element_styles_border-style":"","element_styles_border-color":"","element_styles_color":"","element_styles_height":"","element_styles_width":"","element_styles_font-size":"","element_styles_margin":"","element_styles_padding":"","element_styles_display":"","element_styles_float":"","element_styles_show_advanced_css":0,"element_styles_advanced":"","submit_element_hover_styles_background-color":"","submit_element_hover_styles_border":"","submit_element_hover_styles_border-style":"","submit_element_hover_styles_border-color":"","submit_element_hover_styles_color":"","submit_element_hover_styles_height":"","submit_element_hover_styles_width":"","submit_element_hover_styles_font-size":"","submit_element_hover_styles_margin":"","submit_element_hover_styles_padding":"","submit_element_hover_styles_display":"","submit_element_hover_styles_float":"","submit_element_hover_styles_show_advanced_css":0,"submit_element_hover_styles_advanced":"","cellcid":"c3287","id":"4_1","beforeField":"","afterField":"","value":"","label_pos":"below","parentType":"textbox","element_templates":["submit","button","input"],"old_classname":"","wrap_template":"wrap-no-label"}];nfForms.push(form); The post Tutorial: MySQL- und MariaDB-Datenbanken über SSH mit Putty exportieren und importieren appeared first on bbfdesign.de.

Netz: bbfdesign - Ihr Partner für JTL, Online-Shops und Webdesign
Aktualisiert: 3.3.2024

zum Artikel gehen

Tutorial: MySQL- und MariaDB-Datenbanken über SSH mit Putty exportieren und importieren

Aufnahme mit Audacity

Audacity spielt nur halbe Minute der Audio ab

Zu lange Aufnahme kürzen bei Audacity

Video Tutorial: Arbeiten mit Schrägen

BIM in der Landschaftsarchitektur