login
Forgot?
Login with Facebook

Don't have an account? Register one now!

How to setup a Remote Connection to MySQL

Bids 
25
Avg Bid
N/A
CLOSED

  • Project ID:

    80688

  • Project Type:

    Fixed

  • Budget:

    $30-$100 USD

Project Description:

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 83.164.240.192 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 205.103.140.32 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!


Skills required:

Linux, PHP
See more: serve, linux file server, shared database, linux remote, remote linux, sql server mysql, upload large file, shared hosting, setup linux, setup website php mysql, pinging, file host website, sql file, serve file php, import sql database domain, shared server, import mysql sql, mysql upload, backup dedicated server, database populate, step step serve, sql server import, php domain name, linux file hosting server, import large mysql database

Project posted by:

FSUstudent06 United States
(81 Reviews)
Last seen:
Post a Project like this Report Project

Public Clarification Board

2 messages

  • timmytots

    Hi,

    crewSFX (www.crewsfx.com) is a UK based cutting-edge web design and development company providing a full range of services, including contemporary design, Flash, search engine optimisation, logos, graphics, xhtml, css, eCommerce solutions and PHP related functions.

    We specialise in unique, visually stunning design, as well as corporate identity. We are ideal for artists, individuals and small businesses alike.

    Please see our portfolio: www.crewsfx.com

    We hope to hear from you soon. Thanks!

    over 5 years ago

  • danilaro

    It may require for your ISP to route access your database server.

    over 5 years ago


If you are the project creator or one of the bidders, please Log In for more options.


Bids are hidden by the project creator. Log in as the project creator or as one of the bidders to view bids. You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

All Bids ()

Freelancer.com (formerly GetAFreelancer) is the world's largest outsourcing and crowdsourcing marketplace for small business. We have hundreds of thousands of satisfied customers from all over the world. We connect over employers and freelancers globally from over 234 countries & regions. Through our website, employers can hire freelancers to do work in areas such as software, writing, data entry and design right through to engineering and the sciences, sales and marketing, and accounting & legal services. The average job is under US$200, making outsourcing for the first time extremely cost effective for small businesses.

Would you like to find freelance jobs and make money online? Just sign up to get started! We have created a safe environment for both freelancers and employers via our secure milestone payment system. We have thousands of freelance coders, writers, programmers, designers, marketers and more. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.

© Copyright 2011 Freelancer Technology Pty Limited (ACN 142 189 759)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)