How do I get a database from mysql server 2005 to Plesk hosting?

i've got a database stored on my computer using mysql server 2005, and I've just registered for hosting which uses the Plesk control panel.

In plesk I've setup a database and relevant user. What the easiest way of exporting the whole database on my computer and getting it onto my hosting account?

Hi littlened,

I'm sorry to tell you that Wsoft Plesk is a third party tool and is not supported in this forum.For how to import/export from/to Plesk, you can visit their official site(http://www.swsoft.com/plesk/) or contact your database hosting company directly. thanks

This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

|||

Lighten up Bo Chen,

If you dont know the answer, don't bother to reply to littlened's thread.

LittleNed, The answer is to download a webapp called phpmyadmin. This is a php based tool which is also in the plesk panel.

This tool can be downloaded via sourceforge and will allow you to export your whole database into a compatible .sql script file, which you can execute on your hosting account db.

I hope I have made sense and God bless you in your data migration.

|||

You should check out the SQL Server Hosting Toolkit on CodePlex:http://www.codeplex.com/sqlhost

The Toolkit can help you deploy your local database to your remote server. Note that you probably need permissions to create a database on your remote server. Plesk has an option to create a database though (if your hosting company provides it). Go to your domain, select databases and add the information necessary. Then you can use the Toolkit to script your database structure and data.

Hope this helps!

|||

Hi, Thanks for that.

I use PHPMYSQL alot when I'm using PHP, so I know all about it, however I found out I can use SQL to copy a database directly to my hosting company, and manage the database through SQL or VS

|||oh. you mean sql server 2005 I thought the article was about a mysql database migration. I am not that fluent in sql server 2005 but am in 2000. if your server has an enterprise manager installed you can right click on the db and choose to generate a sql script of the structure the export the data to a .csv. these should then be easily transferrable onto your hosting environment system. this is assuming that the hosting db is only accessible via control panel. if not, you simply need to perform a dts.