How To Upload A Database Into Internet

[surfermac 0]

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)

[surfermac 0]

sorry that i didnt mention what database i was usingi used db2 to create the database

[wutske 0]

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).

[yordan 10]

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.

[cory1405241578 0]

you need phpmyadmin

[iGuest 3]

uploading mysql database on webserverHow To Upload A Database Into Internet

Hello 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

[Selly 0]

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.

[8ennett 0]

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.

[Atomic0 0]

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.

[iGuest 3]

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