MySQL Databases

[Mr. Rogers]

I am thinking about getting a new web hosting company. If I download all my MySQL databases from this one and upload them to the other one, will everything still work alright? I will need to move my forums over to the new one, so that's why I was wondering.

[John316]

If you know what you're doing, yes. If not, yes if you're lucky.

[Mithrandir]

All mysql databases (from the same version of mysql) are equal.

If you have shell access, and can use the mysqldump command, it's really easy to do this. If you don't, some companies are ok and others aren't...

[RefractedAhav]

I just installed mysql version 4 on my computer, and every time I try to set the root password I get this error

ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp onds to your MySQL server version for the right syntax to use near '/usr/bin/mys qladmin -u root password quokka' at line 1

even though I am yousing the command from the manual. Can any one help me?

[shooraijin]

You type that in at the shell prompt, not at the mysql> prompt. mysqladmin is a Unix command.

[RefractedAhav]

tnks