Jump to content
xisto Community
surfermac

How To Upload A Database Into Internet

Recommended Posts

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

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

Share this post


Link to post
Share on other sites

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

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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.