{"id":295,"date":"2020-09-14T11:58:41","date_gmt":"2020-09-14T10:58:41","guid":{"rendered":"http:\/\/kbnco.names.dev.pdunsford.localdev\/?post_type=ht_kb&p=295"},"modified":"2020-09-14T11:58:41","modified_gmt":"2020-09-14T10:58:41","slug":"how-to-access-backup-a-mysql-database","status":"publish","type":"ht_kb","link":"https:\/\/www.names.co.uk\/support\/articles\/how-to-access-backup-a-mysql-database\/","title":{"rendered":"How to access \/ backup a MySQL database"},"content":{"rendered":"\n

To assist customers in accessing their database we have provided a phpMyAdmin service. This can be found at\u00a0http:\/\/www.mydbadmin.co.uk<\/a><\/p>\n\n\n\n

\"phpmyadmin\"<\/p>\n\n\n\n

To log in, enter your database username and password, then select your database server and click Go<\/strong><\/p>\n\n\n\n

Once you are logged into your database you will have many options to choose from.
In this Support article we will be looking at how to access a database table and how to export\/backup a database.\"editorbackup\"<\/p>\n\n\n\n

How to access and edit a table.<\/p>\n\n\n\n

In order to edit a database table you will need to click on the table on the left (table_example).<\/p>\n\n\n\n

This will display all your database fields and give you options to add new fields, edit existing fields and delete fields.<\/p>\n\n\n\n

\"edit<\/figure>\n\n\n\n

There are many guides on the internet to assist with using phpMyAdmin, so I advise looking through these before making changes to your database.<\/p>\n\n\n\n

How to export \/ backup a database.<\/p>\n\n\n\n

Now that you have access to your database and know how to make changes we recommend exporting a copy of the database as a backup.

This is in case you need to roll back to a previous state due to an error or data loss.<\/p>\n\n\n\n

To export a copy of the database log in to the database through phpMyAdmin as described above.<\/p>\n\n\n\n

Next select Export<\/strong><\/p>\n\n\n\n

You will see the options as I have shown below.<\/p>\n\n\n\n

\"export<\/figure>\n\n\n\n

Advanced users will want to go through all the options for their database export<\/p>\n\n\n\n

For the purposes of a backup, you only need to select the Export type (CSV, PDF, SQL, etc…), ensure the Save as file<\/strong> box is ticked, and select Go.<\/strong><\/p>\n\n\n\n

A download box will pop up allowing you to download the exported database<\/p>\n\n\n\n

All that remains to do now is ensure you keep the copy safe as you never know when you might need it.<\/p>\n\n\n\n

If you have a website that is constantly updated, for example a public blog, we recommend backing up the database and website frequently.<\/p>\n","protected":false},"excerpt":{"rendered":"

To assist customers in accessing their database we have provided a phpMyAdmin service. This can be found at\u00a0http:\/\/www.mydbadmin.co.uk To log in, enter your database username and password, then select your database server and click Go Once you are logged into your database you will have many options to choose from.In this Support article we will be […]<\/p>\n","protected":false},"author":2,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[119],"ht-kb-tag":[120,129],"class_list":["post-295","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-hosting","ht_kb_tag-hosting","ht_kb_tag-mysql"],"yoast_head":"\nHow to access \/ backup a MySQL database - Support Centre - names.co.uk<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.names.co.uk\/support\/articles\/how-to-access-backup-a-mysql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to access \/ backup a MySQL database - Support Centre - names.co.uk\" \/>\n<meta property=\"og:description\" content=\"To assist customers in accessing their database we have provided a phpMyAdmin service. This can be found at\u00a0http:\/\/www.mydbadmin.co.uk To log in, enter your database username and password, then select your database server and click Go Once you are logged into your database you will have many options to choose from.In this Support article we will be […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.names.co.uk\/support\/articles\/how-to-access-backup-a-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Support Centre - names.co.uk\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/namesco\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2020\/09\/phpmyadminlogin.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@namesco\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.names.co.uk\/support\/articles\/how-to-access-backup-a-mysql-database\/\",\"url\":\"https:\/\/www.names.co.uk\/support\/articles\/how-to-access-backup-a-mysql-database\/\",\"name\":\"How to access \/ backup a MySQL database - Support Centre - names.co.uk\",\"isPartOf\":{\"@id\":\"https:\/\/www.names.co.uk\/support\/#website\"},\"datePublished\":\"2020-09-14T10:58:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.names.co.uk\/support\/articles\/how-to-access-backup-a-mysql-database\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.names.co.uk\/support\/articles\/how-to-access-backup-a-mysql-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.names.co.uk\/support\/articles\/how-to-access-backup-a-mysql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.names.co.uk\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to access \/ backup a MySQL database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.names.co.uk\/support\/#website\",\"url\":\"https:\/\/www.names.co.uk\/support\/\",\"name\":\"Support Centre - names.co.uk\",\"description\":\"names.co.uk Support Centre\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.names.co.uk\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to access \/ backup a MySQL database - Support Centre - names.co.uk","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.names.co.uk\/support\/articles\/how-to-access-backup-a-mysql-database\/","og_locale":"en_GB","og_type":"article","og_title":"How to access \/ backup a MySQL database - Support Centre - names.co.uk","og_description":"To assist customers in accessing their database we have provided a phpMyAdmin service. This can be found at\u00a0http:\/\/www.mydbadmin.co.uk To log in, enter your database username and password, then select your database server and click Go Once you are logged into your database you will have many options to choose from.In this Support article we will be […]","og_url":"https:\/\/www.names.co.uk\/support\/articles\/how-to-access-backup-a-mysql-database\/","og_site_name":"Support Centre - names.co.uk","article_publisher":"https:\/\/www.facebook.com\/namesco","og_image":[{"url":"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2020\/09\/phpmyadminlogin.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@namesco","twitter_misc":{"Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.names.co.uk\/support\/articles\/how-to-access-backup-a-mysql-database\/","url":"https:\/\/www.names.co.uk\/support\/articles\/how-to-access-backup-a-mysql-database\/","name":"How to access \/ backup a MySQL database - Support Centre - names.co.uk","isPartOf":{"@id":"https:\/\/www.names.co.uk\/support\/#website"},"datePublished":"2020-09-14T10:58:41+00:00","breadcrumb":{"@id":"https:\/\/www.names.co.uk\/support\/articles\/how-to-access-backup-a-mysql-database\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.names.co.uk\/support\/articles\/how-to-access-backup-a-mysql-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.names.co.uk\/support\/articles\/how-to-access-backup-a-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.names.co.uk\/support\/"},{"@type":"ListItem","position":2,"name":"How to access \/ backup a MySQL database"}]},{"@type":"WebSite","@id":"https:\/\/www.names.co.uk\/support\/#website","url":"https:\/\/www.names.co.uk\/support\/","name":"Support Centre - names.co.uk","description":"names.co.uk Support Centre","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.names.co.uk\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"}]}},"_links":{"self":[{"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb\/295","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/comments?post=295"}],"version-history":[{"count":0,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb\/295\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/media?parent=295"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb-category?post=295"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb-tag?post=295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}