surfermac 0 Report post Posted August 23, 2009 (edited) i have developed a database on my system and want to upload the database on to the internet and use it for my website how do i do this Edited August 23, 2009 by surfermac (see edit history) Share this post Link to post Share on other sites
surfermac 0 Report post Posted August 23, 2009 sorry that i didnt mention what database i was usingi used db2 to create the database Share this post Link to post Share on other sites
wutske 0 Report post Posted August 25, 2009 That might be a bit of a problem since almost every hosting pack comes with MySQL instead of DB2. So you'll either have to convert your whole database to MySQL or find a DB2 host (or host your own DB2 server). Share this post Link to post Share on other sites
yordan 10 Report post Posted August 25, 2009 And I also don't understand the aim of your question.If you want to put your database on a db2 remote server, you simply have to use the db2 tools in order to export your database to a local flat file, ftp this flat file to the remote db2 server, and use the remote db2 server import tool in order to load the data from the flat file into the remote db2 database.And of course, from a philosophical point of view, we usually work the opposite way.When I want to create programs for a remote mysql database, i install mysql and php on my PC, I test it on my PC, and I upload it to the remote server. But I always look at the remote server first, and secondly install on my PC the same softs as the server. This is the first time I see somebody first creating a db2 database and secondly looking for a remote db2 server. You must know that db2 servers are very professional and incredibly expensive servers, so only huge company can sustain the corresponding fees. Whereas you can find mysql servers for rather reasonable costs. Share this post Link to post Share on other sites
cory1405241578 0 Report post Posted August 26, 2009 you need phpmyadmin Share this post Link to post Share on other sites
iGuest 3 Report post Posted December 14, 2009 uploading mysql database on webserverHow To Upload A Database Into InternetHello All.  I need to upload my existing database developed in mysql in my local machine to my web server. Web server supports MySql. Please tell me how to upload database and update my connection string in php to point the database.  Thanks  -reply by Asif Ali Share this post Link to post Share on other sites
Selly 0 Report post Posted January 11, 2011 It’s not too hard. You can upload your database into web server by database backup file. Only this is you should get a back up file from your database and go to control panel and open your MySQL and import your database back up file into it. Share this post Link to post Share on other sites
8ennett 0 Report post Posted January 11, 2011 Yes, very easy to upload mysql database. Just get phpmyadmin on your home server, export the database using the export tab, and usually for me it just displays all the mysql code instead of offering to save a file, so I copy the code, open phpmyadmin on my remote server, click the sql tab (for writing sql queries in to) and simply paste the copied code and run it. Share this post Link to post Share on other sites
Atomic0 0 Report post Posted January 13, 2011 There are a number of different posts on other forums e.g. Devshed, which shed some light on how to migrate databases e.g. db2 to MySQL. By the way, a quick Google search often turns up useful information on any topic, including database migration.In summary, you can use specialised Database Management applications that support the different database servers / formats to migrate the data over e.g. DB Extract for DB2 (http://www.sqlmanager.net/en/products/db2/extract/) which exports DB2 databases in SQL scripts that can be run to recreate the data as a SQL database e.g. MySQL. Another option is the export the data held inside the databases into common format such as XML or CSV files that can then be imported into the database system you wish to migrate to. Share this post Link to post Share on other sites
iGuest 3 Report post Posted April 30, 2011 upload the mdb file to ftp serverHow To Upload A Database Into InternetI want to upload ms access database file (.Mdb file) to ftp server using asp.Net or C#...Thanks and Regards,Raj Gupta-question by Raj Gupta Share this post Link to post Share on other sites