{"id":1707,"date":"2014-01-24T22:08:32","date_gmt":"2014-01-24T21:08:32","guid":{"rendered":"https:\/\/ridgesolutions.ie\/?p=1707"},"modified":"2014-01-24T22:08:32","modified_gmt":"2014-01-24T21:08:32","slug":"making-an-external-connection-to-a-blaknight-mysql-database","status":"publish","type":"post","link":"https:\/\/www.ridgesolutions.ie\/index.php\/2014\/01\/24\/making-an-external-connection-to-a-blaknight-mysql-database\/","title":{"rendered":"Making an external connection to a Blaknight MySQL database"},"content":{"rendered":"

You can connect to a Blacknight MySQL database from an external tool (e.g. mysql or mysqlimport commandline) if you change some of the database’s settings. This can be useful if you need to manage your database, for example if you need to perform a large database import (one that is so large it causes phpMyAdmin to time out).<\/p>\n

First you need to configure the database to allow external connections, in the Blacknight control panel choose to edit the database’s settings and check the ‘Access from external hosts’ check-box. This change on its own isn’t sufficient, next you must add your ip address to the ‘Access Hosts’ list.<\/p>\n

\"enable_external_access\"<\/a><\/p>\n

When on the database properties page, click on the ‘Access Hosts’ tab, click on ‘Add new access host’ and add your ip address. To find your IP address, just google ‘my ip address’ and your address will be displayed near the top of the results page. <\/p>\n

\"add_ip_address_blacknight\"<\/a><\/p>\n

Once you have made these changes you should be able to make external connections to the database. When you are finished it is probably a good idea to remove external access again.<\/p>\n

You can now do something like import a database, get the hostname from the ‘external hostname’ field on the blacknight control panel:<\/p>\n

\r\nmysql --host=\"mysq12666.cp.blacknight.com\"   --user='u1273449_the_user' --password=\"ThePassword\" database_name < .\/db4.sql\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
You can connect to a Blacknight MySQL database from an external tool (e.g. mysql or mysqlimport commandline) if you change some of the database’s settings. This can be useful if you need to manage your database, for example if you need to perform a large database import (one that is so large it causes phpMyAdmin […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[218,109],"class_list":["post-1707","post","type-post","status-publish","format-standard","hentry","category-general","tag-blacknight","tag-mysql"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t