MySQL database's upload via FTP

Discussion in 'MySQL' started by narekm, Oct 14, 2011.

  1. narekm

    narekm New Member

    Joined:
    Mar 23, 2011
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    0
    Hello there . I am developing my PHP-MySQL site locally on XAMPP installed. And I am creating databses and tables in my MySQL databse . So after finishing things with the databse can i "upload" the "configuration" of my database to the hosting company's provided database? . So if lets say i have set up the database locally so that users can egister and the same now they can do with the remote database .
    I mean how to make my local and remote database look exactly the same ??? .(So i wont have to type all long SQL queries on phpMyAdmin).


    Thanks in advance!!
     
  2. alia123

    alia123 New Member

    Joined:
    Jan 8, 2016
    Messages:
    65
    Likes Received:
    5
    Trophy Points:
    0
    Hey,
    One thing is you need to export the database on your local server and import it into your host's server.
    Also you can use a tool like MySQLDump which should be within your MySQL install on 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.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice