Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MySQL (http://www.go4expert.com/forums/mysql-forum/)
-   -   MySQL database's upload via FTP (http://www.go4expert.com/forums/mysql-databases-upload-via-ftp-t26933/)

narekm 14Oct2011 13:01

MySQL database's upload via FTP
 
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!!

alia123 10Feb2016 17:17

Re: MySQL database's upload via FTP
 
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.


All times are GMT +5.5. The time now is 15:22.