Page 1 of 1
MySQL Databases
PostPosted: Wed Dec 01, 2004 1:39 pm
by 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.
PostPosted: Wed Dec 01, 2004 2:21 pm
by John316
If you know what you're doing, yes. If not, yes if you're lucky.
PostPosted: Wed Dec 01, 2004 2:36 pm
by 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...
PostPosted: Fri Aug 05, 2005 9:09 am
by 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?
PostPosted: Fri Aug 05, 2005 6:56 pm
by shooraijin
You type that in at the shell prompt, not at the mysql> prompt. mysqladmin is a Unix command.
PostPosted: Fri Aug 05, 2005 10:16 pm
by RefractedAhav
tnks
