Moving Database to new server

[Jade Dragon]

Just a couple quick questions.

How difficult is it to move a database from one server to another?

And is it possible to just move a selection of tables from one database to another?

If so how?

Any specific pointers would be helpful. Will need to do this in the future and would not like to lose any information in the crossing.

Thank you

[slateman]

Download yourself "Mascon" and do a dump of the selected tables and there contents. Then open up the new database and enter the SQL statement that was created in the dump and let her rip. You will transfer the tables and their contents like this:

Old Databast > Your Hard Drive > New Database

You will still have a copy on your old database though, so if you want it deleted you have to get rid of the tables after.

[Jade Dragon]

Thank You!

thought it would be possible. didn't think it's be that easy.

I will find and experiment, before trying with "real" data.

JD

[VBman]

Also, MySQL-Front will let you select any or all of the tables you want copied to a different database and copy them over.

[slateman]

Yeah, well I recently was in a bit of trouble so went into the process of backing up my database "just in case", 40 megs big, but I have to whole thing in case I need to move to a new server. But all is fixed now so I don't have to worry.

[Jade Dragon]

Thank you everyone. I will try your suggestions and hopefully everything will work out.