need help with transfering mysql

[aaron]

hey im changing webhosts, and i need to transfer my entire mysql database in order to keep my sites php message board/forum information/posts from being erased off the board. is this possible? will i have to download the database onto my computer first? what do i need to do??

[RayOfSky]

I think u must export mysql messages to your computer from ur old web site and next u must import to your new web site....

[raf]

1. Create a dump file of your database
2. Import the dumpfille on the new server

I don't think it is necessarely to store the dumpfile on your machine, but it's probably easier.

You can use phpMyAdmin to create and import the dumpfiles, or another front (depends on what the hosts provide. I use MySQL-front on my local machine, and phpMyAdmin on the server...

[michael.hd]

raf is right,
but, if you don't have a clue how to do this (like me) then try this.

I downloaded Navicat Premiumsoft Mysql studio (30 day trial)

from www.mysqlstudio.com

it has a button you can press to dump the sql file to your hard disk, then change the details to connect to your new server and press the import button.

The whole thing will take 10 mins and you will still not have a clue how to import export dbs. But the job will be done!

There are lots of good packages out their to help. I like navicat cos it is point and click (my level)

[raf]

you will still not have a clue how to import export dbs

Well, there not much happening. When you create a dumpfile, a large textfile is created. This textfile contains all sql-statements that are necessary to create the table and insert all records. (a create table statement + insert statements for each record)
Importing it, is just running all sql statements in the textfile.

All good db-frontends should have the option to only dumpt the data, the data and design or the design.

There are indeed many packages, buth i couldn't hurt to open the dumpfiel in notepad and take a look.