How to setup a Remote Connection to MySQL

I have a very large database, so large in fact that my shared hosting plan will not let me upload/import the backup sql file needed to populate the database. The file is 17,584,460 bytes and even zipped its too big for their limits.

So what I want to do is place my database on another server (dedicated) and serve it up to my shared host.

I am familiar with MySQLs Grant Privileges. I would just like some help on getting this issue resolved.

I need to know what command to issue the MySql monitor...

Lets say my dedicated server has an IP of [url removed, login to view] and that is where the MySQL database is residing.

But my website is hosted on a shared server... by pinging my domain name I see that my sites IP is [url removed, login to view] but that is just the shared IP of the server my domain is being served from.. Should I get a dedicated IP for this hosted website to make this connection work?

(NOT Actual IPs.. Used for examples purposes only

I would like to step by step instruction or advice!

Thank You!

Evner: Linux, PHP

Se mere: website how to make, website how make, remote work php, php and mysql connection, i say my name, i how, how work it, how i make a website, how do you get linux, where do i want to work, let me serve you up, upload-some-big, sql mysql, setup server, remote server, remote help, php remote work, Mysql, mysql backup, linux serve, ip to domain, ip monitor, instruction, import mysql, how should

Om arbejdsgiveren:
( 82 bedømmelser ) cocoa, United States

Projekt ID: #80688