How to Transfer a SQL-Database

sql

[newdawn]

I am about to switch my hosts, and of course want to switch all my contents. The only problem for me is the transfer of the sql-database.

Does anyone know how to do it?

[jatar_k]

Welcome to WebmasterWorld newdawn,

take a look at mysqldump [dev.mysql.com]

that will get it out

[dreamcatcher]

Welcome to Webmaster World newdawn. :)

Also, you can use the 'Export' function if you use PHPMyAdmin to take a backup of your database.

dc

[newdawn]

Thanks for the answers.

I used phpmyadmin to export the database but the problem for me is importing it with my new phpmyadmin.

Sven

[maccas]

Create a database and then select it and click on SQL and browse. Or is there another problem?

[newdawn]

The problem is that I somehow need to upload it, which is what I can't figure out.

[maccas]

Ok just do what I said in my previous message.

[newdawn]

I will try that. Thanks.