Can you make a mysql database on one host and use it for a site on a different host, and if so how?

My friend needs a mysql database, and her host hasn’t been online to set her up (long story) and so I’d like to make a database with my server, and let her use it. Is this possible, and if so how?

yes

in stead of "localhost" in her database connection parameters, she inserts your DNS adress or IP adress.

on your end: make sure she uses a decent username/password, also open ports on your firewall if applicable.

Technorati Tags: Connection Parameters, Database Connection, Database Server, Different Host, Dns Adress, firewall, Ip Adress, mysql database, Mysql Host, Open Ports, Site Host, Stead

Is there any issues with regards to importing an old wordpress mysql database to a new one?

I imported my old wordpress mysql database to a new database in my hosting account, then deleted the old one. The site’s showing up ok, as of now. So i’m wondering if I missed any step during the importation that might pose as a problem in the future. Did I do right?

Assuming your host is the same, your site/domain is the same, and the structure didn’t change, everything should be fine.

The WordPress database is very stable and easy to move, even from site to site. Like the other answer says, as long as your site is working, you’re probably going to be just fine.

Technorati Tags: database hosting, Importation, mysql database, Wordpress

Login with a seperate server database?

I just have two questions. If I use a database host like x10 hosting, cound I make a login on my Freewebs site, relating to my x10 database and server?

What is a better way to do this?
Thanks!

Assuming that both host a MySQL database, you must make sure that your database accepts your IP address. (I know that if they’re using CPanel to configure the sites, you have an option to do that there.)

Then, one you know this works, you need to determine the actual address of your database. It might not be the address of your site; it will probably be the address of one of their servers.

Good luck!

Technorati Tags: Address Database, Database Host, Database Server, Good Luck, Ip Address, mysql database, Seperate Server, Server Database, servers, X10

godaddy says i cannot use dreamweaver to setup a connection to my mysql database hosted by them?

Has anyone else come accross this?
maybe you have or havent been able to do this yourself?

I don’t think you can connect Dreamweaver to ANY mysql database. That’s not how you manipulate MySQL.

Typically there will be a database administration tool on your control panel. This takes you to PhpMyAdmin. Use this to manage your database directly.

You can use Dreamweaver (or any other text editor with FTP support) to modify PHP files on the server. You can then write PHP programs to manipulate the database. It doesn’t matter what the PHP program was written in. Dreamweaver is unnecessary, because it isn’t really optimized for PHP. You’re probably better off with a dedicated text editor like Aptana or Komodo.

Technorati Tags: Aptana, Control Panel, Database Administration Tool, Database Tool, dreamweaver, Ftp Files, Komodo, mysql database, Php Files, Php Program, Php Programs, phpmyadmin

Can someone me help to install Coppermine Gallery for my fansite?

I have Yahoo! Small Business for webhosting. What I have trouble with is when I try to install the gallery, it displays a message whenever I enter "mysql" as the local host. HELP!

Make sure you have a mysql database setup. And the localhost setting is most likely localhost. You need to check with yahoo for sure to get the right setting for that.

Technorati Tags: business webhosting, Database Setup, Displays, Local Host, Localhost, mysql database, yahoo, Yahoo Business, Yahoo Small Business

How do I upload an Access file to a mysql database?

I have an Access file that I need to upload to my online database (hosted at GoDaddy) thru Dreamweaver. How?

There’s an easy way and a hard way. The easy way involved buying a conversion utility. ("Full Convert Enterprise" is a nice one).

Depending on the complexity of the database, it might be easy to write simple SQL commands to populate the mysql database from an xml file (should be able to export xml from access). Since I maintain a Windows server (IIS) it’s really easy to translate the access to XML and then back again to mysql.

Technorati Tags: Access Database, Access File, Complexity, Conversion Utility, Database Access, dreamweaver, Easy Access, Enterprise, File Upload, Iis, Mysql Access, mysql database, Online Database, Sql Commands, Translate, Upload File, Windows Server, Xml Access, Xml File

How do i connect a windows C# application to a remote Mysql database?

I’m currently connected to a local Microsoft SQL server. I’m new to windows programming and i need the code snippets to connect my windows C# application to a remote Mysql database. I have a website which is connected to my web host’s Mysql database. I want to be able to connect my windows C# app. to that same data base. Need your expert advice. By the way, I’m using visual studio.

It’s the same for a remote database as local. When you set up the data source, just specify the remote server.

Technorati Tags: C Application, Code Snippets, Data Base, Data Source, Expert Advice, microsoft, Microsoft Server, Microsoft Sql Server, mysql database, New Windows, Remote Server, Using Visual Studio, Web Database, web host, Windows C, Windows Programming

What is a good application for designing a MySQL-driven website on Mac OS X?

I am developing a web site that allows users to search for information stored in a MySQL database on a Mac.

I am looking for an application to assist in the design of the web site, allowing me to create search forms to retrieve the data from a MySQL database on a Mac OS X computer.

I do not want to outsource this task or to have another company host it.

Any suggestions and/or advice will be appreciated.

Thanks.

I personally use Coda, by panic for my web programming. I also highly recommend it over Dreamweaver.

Technorati Tags: Coda, Driven Website, Mac Computer, Mac Os X, mysql database, Os X, Search Forms, That Allows Users, Web Programming

Is there a program that will host a MySQL database on my computer?

Is there a program that will host a MySQL database on my computer? I need one becasue I want to develop a site but I don’t want to pay for hosting until it’s done.

Try one of the Apache distributions like Wamp. this has the Apache web server, mysql and php.

Technorati Tags: Apache Php, Apache Server, Apache Web Server, Computer Program, Distributions, Mysql And Php, mysql database, Mysql Php, Server Mysql, Wamp

1&1 Hosting MySQL Database over ODBC (or ADO.NET)?

I have a beginner hosting plan at 1&1, and would like to create a MySQL database that I can use to manage contact lists. I would like to create a desktop program to do this, but as I cannot connect to this database directly via ODBC, I was wondering if there is any PHP software I can install on my server space that will allow me to connect to this MySQL database directly from a desktop (probably VB.NET 2008 Win Forms) application.

Thanks for your help!

I’m not 100 percent sure about what 1&1 allows on its servers, but I do know that they do not allow remote connections. The only way I can think of to have a desktop application that manipulates a database on a hosting company like 1&1 would be to write a web service (if they allow it) that has the necessary code to manipulate the database. But this would be very code intensive. So not only would you need to write the desktop application, but also write a fairly complicated web service to act as an interface to MySQL on their servers.

No doubt, a daunting task

Technorati Tags: Ado Net, Amp, Contact Lists, database hosting, Daunting Task, Desktop Application, Desktop Program, Hosting Company, Hosting Plan, Interface, mysql database, Mysql Odbc, Necessary Code, No Doubt, Php Software, Server Space, servers, Thanks For Your Help, Vb Net, Web Service