{"id":72059,"date":"2021-04-26T11:46:49","date_gmt":"2021-04-26T15:46:49","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/?page_id=72059"},"modified":"2023-06-07T08:54:19","modified_gmt":"2023-06-07T12:54:19","slug":"databases","status":"publish","type":"page","link":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/","title":{"rendered":"Working with Databases"},"content":{"rendered":"<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"538\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/04\/working-with-databases-header-img-1024x538.png\" alt=\"Working with Databases pillar page header image\" class=\"wp-image-72063\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/04\/working-with-databases-header-img-1024x538.png 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/04\/working-with-databases-header-img-300x158.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/04\/working-with-databases-header-img-768x403.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/04\/working-with-databases-header-img.png 1200w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure>\n\n\n\n<p>Most websites these days are driven by a database, which stores and organizes information in a different coding language \u2013\u00a0<em>e.g. MySQL, MariaDB, PostreSQL<\/em>. If you are working with databases then our guides on creating, importing, exporting, connecting, and troubleshooting can help provide knowledge for your management needs.<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading\">Creating, Importing, and Exporting Databases<\/h2>\n\n\n\n<p>Learn how to create, import, and export databases in this section.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<ul class=\"wp-block-list\" id=\"block-50ea2704-075a-4acb-8741-ae305331f4b8\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/\" target=\"_blank\">Create and attach a database user in cPanel<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-mysql-database\/\" target=\"_blank\">Create a MySQL Database<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/export-database-using-phpmyadmin\/\" target=\"_blank\">Export a MySQL Database with phpMyAdmin<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/\" target=\"_blank\">Import a MySQL Database with phpMyAdmin<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/backup-and-restore\/backup-database-ssh\/\" target=\"_blank\">Export a database through shell<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/import-database-through-shell\/\" target=\"_blank\">Import a database through shell<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading\">Connecting<\/h2>\n\n\n\n<p>This section includes popular articles regarding making a database connection.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<ul class=\"wp-block-list\" id=\"block-07f8b9b4-fbd1-459a-a978-7101f0cf31b6\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/connect-database-remotely-mysql-workbench\/\" target=\"_blank\">Connecting to a DB with MySQL Workbench 5.2<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/connecting-heidi-sql-database\/\" target=\"_blank\">Connecting Remotely to your DB with Heidi SQL<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/connect-database-navicat\/\" target=\"_blank\">Connecting to your DB with Navicat for MySQL 10<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/connecting-to-a-database-using-php\/\" target=\"_blank\">Connecting to a DB using PHP<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/\" target=\"_blank\">Setting up a Remote MySQL connection in cPanel<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mysql-command-line\/\" target=\"_blank\">How to access MySQL via command line<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading\">Troubleshooting Errors<\/h2>\n\n\n\n<p>This section covers some of the common errors you may experience regarding databases.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<ul class=\"wp-block-list\">\n<li><a aria-label=\"Check and Repair Databases\u2028 (opens in a new tab)\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/check-and-repair-databases-in-cpanel\/\" target=\"_blank\" rel=\"noreferrer noopener\">Check and Repair Databases<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mysql-1044-access-denied-error-message\/\" target=\"_blank\">MySQL \u2013 1044 Access Denied Error Message<\/a>\u00a0<\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/error-numbers\/why-do-i-get-a-maxuserconnections-error\/\" target=\"_blank\">Why do I get a max_user_connections error?<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/error-1064\/\" target=\"_blank\">MySQL Error 1064: You have an error in your SQL syntax<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/error-numbers\/error-1052\/\" target=\"_blank\">Error 1052 Column in where clause is ambiguous<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading\">Working with phpMyAdmin<\/h2>\n\n\n\n<p>Effortlessly Manage Your MySQL Databases with phpMyAdmin in cPanel: Step-by-Step Walkthrough Guides for <a href=\"https:\/\/www.inmotionhosting.com\/php-hosting\">PHP Hosting<\/a>.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<ul class=\"wp-block-list\" id=\"block-66996b13-99d2-4771-beac-50cc98d57820\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-phpmyadmin-to-optimize-a-database\/\" target=\"_blank\">How to Use phpMyAdmin To Optimize a Database<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-phpmyadmin-to-optimize-a-database\/\" target=\"_blank\">Installing PHPMyAdmin on your Account<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-phpmyadmin-to-optimize-a-database\/\" target=\"_blank\">How to delete or drop a table in phpMyAdmin<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-phpmyadmin-to-optimize-a-database\/\" target=\"_blank\">How to determine the data type of a data column in phpMyAdmin<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading\">Working with MariaDB<\/h2>\n\n\n\n<p>This section includes walk-through guides for the use of MariaDB.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<ul class=\"wp-block-list\" id=\"block-ac4c2502-9f8c-4f9e-8892-56778e80546a\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/ssh\/what-is-mariadb\/\" target=\"_blank\">What is MariaDB?<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/ssh\/what-is-mariadb\/\" target=\"_blank\">How to Create a MariaDB database<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/ssh\/what-is-mariadb\/\" target=\"_blank\">How to Delete a Database with MariaDB<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading\">Working with MySQL<\/h2>\n\n\n\n<p>These articles cover the use of MySQL within cPanel.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<ul class=\"wp-block-list\" id=\"block-b2a96162-5469-4922-b67d-ff9c2ffef6e0\">\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/database-setup\/\" target=\"_blank\" rel=\"noreferrer noopener\">Setting up a Database to Handle Form Data<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/manage-mysql-database-in-phpmyadmin\/\">Managing a MySQL Database in cPanel with PHPMyAdmin<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/different-version-of-php-mysql\/\">I need a different version of PHP\/MySQL<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mysql-tuner-dedicated-server\/\">The Basics of Tuning MySQL on Dedicated Servers<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mysql-tuner-dedicated-server\/\">Monitoring MySQL Performance<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mysql-tuner-dedicated-server\/\">Download a Copy of your Database<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading\">Working with Percona DB<\/h2>\n\n\n\n<p>This section provides information on working with Percona DB.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<ul class=\"wp-block-list\" id=\"block-0bf93041-926b-40f8-ae9b-5f28925d65fa\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/percona-db\/\" target=\"_blank\">What is Percona DB?<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/percona-db\/\" target=\"_blank\">How to install P<\/a><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/ssh\/install-percona-db-server\/\" target=\"_blank\">ercona DB<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading\">Working with Postgre<\/h2>\n\n\n\n<p>This section provides information on working with PostgreSQL.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<ul class=\"wp-block-list\" id=\"block-ac196501-0780-4301-b0f1-28924141573b\">\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/creating-users-adding-them-to-database\/\">Creating a PostgreSQL User &amp; Adding them to a database<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/creating-users-adding-them-to-database\/\">Creating a PostgreSQL Database<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/install-setup\/\">How to get PostgreSQL on a VPS \/ Dedicated Server<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading\">General<\/h2>\n\n\n\n<p>General database articles are included within this section.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<ul class=\"wp-block-list\" id=\"block-a1e7d979-907f-43aa-b2b6-a83cf20802c3\">\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/find-database-users\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Find Which Users are Attached to Databases<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/reset-database-password\/\" target=\"_blank\">How to reset your database password within cPanel<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/check-and-repair-databases-in-cpanel\/\" target=\"_blank\">How to Check and Repair a Database<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-convert-a-database-to-utf-8\/\" target=\"_blank\">How to Convert a Database to UTF-8<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-convert-mysql-time\/\" target=\"_blank\">How to convert MySQL time<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-change-mysql-server-time-zone\/\" target=\"_blank\">How to change MySQL server time zone<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/storage-engines-innodb-and-myisam\/\" target=\"_blank\">MySQL Storage Engines \u2013 InnoDB and MyISAM<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mysql-datatypes\/\" target=\"_blank\">Learning the different data types in MySQL<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/find-mysql-version\/\" target=\"_blank\">How to determine your MySQL version number<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity is-style-wide\">\n\n\n<ul class=\"lcp_catlist\" id=\"lcp_instance_0\"><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/\">How To Manage Databases in cPanel with phpMyAdmin<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mysql-tuner-dedicated-server\/\">Database Optimization: Tips Using MySQL Tuner<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/find-mysql-version\/\">How to determine your MySQL or MariaDB version number<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-change-mysql-server-time-zone\/\">How to change MySQL server time zone<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/create-an-er-diagram-in-dbeaver\/\">How to Create an ER Diagram in DBeaver<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/database-corruption\/\">Database Corruption &#8211; Causes &#038; Troubleshooting<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/\">How to Edit the MySQL my.cnf File<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/\">MariaDB: Adding and Removing Indexes<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-install-mongodb\/\">How to Install MongoDB<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/how-to-deactivate-plugins-from-the-wordpress-database\/\">How To Deactivate Plugins From The WordPress Database<\/a><\/li><\/ul><ul class='lcp_paginator'><li class='lcp_currentpage'>1<\/li><li><a href='https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/72059?lcp_page0=2#lcp_instance_0' title='2'>2<\/a><\/li><li><a href='https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/72059?lcp_page0=3#lcp_instance_0' title='3'>3<\/a><\/li><li><a href='https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/72059?lcp_page0=4#lcp_instance_0' title='4'>4<\/a><\/li><li><a href='https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/72059?lcp_page0=5#lcp_instance_0' title='5'>5<\/a><\/li><li><a href='https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/72059?lcp_page0=6#lcp_instance_0' title='6'>6<\/a><\/li><span class='lcp_elipsis'>...<\/span><li><a href='https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/72059?lcp_page0=11#lcp_instance_0' title='11'>11<\/a><\/li><li><a href='https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/72059?lcp_page0=2#lcp_instance_0' title='2' class='lcp_nextlink'>&gt;&gt;<\/a><\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Most websites these days are driven by a database, which stores and organizes information in a different coding language \u2013\u00a0e.g. MySQL, MariaDB, PostreSQL. If you are working with databases then our guides on creating, importing, exporting, connecting, and troubleshooting can help provide knowledge for your management needs. Creating, Importing, and Exporting Databases Learn how to<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/\"> Read More ><\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"parent":67257,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"class_list":["post-72059","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Working with Databases | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"If you are working with databases then you will need to learn about how to connect, import, export, troubleshoot, and manage databases for your website or app.\" \/>\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.inmotionhosting.com\/support\/server\/databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Working with Databases\" \/>\n<meta property=\"og:description\" content=\"If you are working with databases then you will need to learn about how to connect, import, export, troubleshoot, and manage databases that you may need for your website or web-based application.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-07T12:54:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/04\/working-with-databases-header-img.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/\",\"name\":\"Working with Databases | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/04\/working-with-databases-header-img-1024x538.png\",\"datePublished\":\"2021-04-26T15:46:49+00:00\",\"dateModified\":\"2023-06-07T12:54:19+00:00\",\"description\":\"If you are working with databases then you will need to learn about how to connect, import, export, troubleshoot, and manage databases for your website or app.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/04\/working-with-databases-header-img.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/04\/working-with-databases-header-img.png\",\"width\":1200,\"height\":630,\"caption\":\"Working with Databases\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Server Technologies: Learning How Your Favorite Websites Work\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/server\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Working with Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support &amp; Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Working with Databases | InMotion Hosting","description":"If you are working with databases then you will need to learn about how to connect, import, export, troubleshoot, and manage databases for your website or app.","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.inmotionhosting.com\/support\/server\/databases\/","og_locale":"en_US","og_type":"article","og_title":"Working with Databases","og_description":"If you are working with databases then you will need to learn about how to connect, import, export, troubleshoot, and manage databases that you may need for your website or web-based application.","og_url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_modified_time":"2023-06-07T12:54:19+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/04\/working-with-databases-header-img.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@InMotionHosting","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/","url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/","name":"Working with Databases | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/04\/working-with-databases-header-img-1024x538.png","datePublished":"2021-04-26T15:46:49+00:00","dateModified":"2023-06-07T12:54:19+00:00","description":"If you are working with databases then you will need to learn about how to connect, import, export, troubleshoot, and manage databases for your website or app.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/04\/working-with-databases-header-img.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/04\/working-with-databases-header-img.png","width":1200,"height":630,"caption":"Working with Databases"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"Server Technologies: Learning How Your Favorite Websites Work","item":"https:\/\/www.inmotionhosting.com\/support\/server\/"},{"@type":"ListItem","position":3,"name":"Working with Databases"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support &amp; Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/72059","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=72059"}],"version-history":[{"count":11,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/72059\/revisions"}],"predecessor-version":[{"id":104757,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/72059\/revisions\/104757"}],"up":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/67257"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=72059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}