1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How can you access your mySQL databases from an FTP?

Discussion in 'PHP' started by boyponga, Feb 23, 2007.

  1. ezprint2008

    ezprint2008 Well-Known Member

    Messages:
    611
    Likes Received:
    15
    Best Answers:
    2
    Trophy Points:
    140
    Digital Goods:
    1
    #21
    Access your SQL database through your Control Panel and Admin tools at your web host, not through FTP.
    FTP is a File Transfer Protocol that uploads files to your web host /server it doesn't connect or interface with your Database itself.
     
    ezprint2008, Dec 14, 2012 IP
  2. annaharris

    annaharris Active Member

    Messages:
    119
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    51
    #22
    You can use a tool like MySQLDump, which should be within your MySQL install on a local server to dump the database to a .sql file, then send that file to your host, and they should import it for you into your database on your hosted server.
     
    annaharris, Dec 19, 2012 IP
  3. Sycrid

    Sycrid Well-Known Member

    Messages:
    130
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    128
    #23
    Simple answer for you. Save your SQL from MySql into a file, upload to your FTP, then you can log into your FTP, access the file. Import the file into a software reader and off you go.

    If you're clever enough you could even write some code to export your SQL database to a file, every 24 hours and push it into your FTP.

    Major problem you will have, is then you have 2 security challenges. A) your original SQL database, is it secure (you have this issue anyway) and B) if you set up an FTP is the FTP access secure enough for you to not be worried about someone else getting in there and accessing a file which holds all your SQL. ... I guess you could encrypt the sql file, before placing it on the FTP...

    Have a think about that for a solution... not sure if it's a good one, or clever, but it does answer your original question or query. If this is not what you're looking for, then I have to ask that you listen to others in the top of the thread and write your questions more clearly in future. Hope this helps you mate.
     
    Sycrid, Apr 14, 2015 IP