Backup DB is a dfferent version to new host :(
 

Hi peeps

I am moving to a new host but i cannot import my DB as its a different
version. Whats the best way to convert the database to another version?

Is there a program that will do this?

My database is My-SQL is 4.1.12
New Host My-SQL is 4.0.18

any advice?

Mail your host and ask them to upgrade :-)

Not applicable im afraid!

I need a moderator or admin to help me out here if poss?

I know nothing about SSH access an i have been told if
i use this method then i will be able to backup the database
to be compatible with MySQL 4.0.18. by entering the
following command:

mysqldump --compatible=mysql40 DATABASE_NAME > database.sql.

Replace "DATABASE_NAME" with the name of the database.

Is there a mod or admin that can help me with this please, I have got SSH
activated on my existing account, I need a mod or admin as i dont think i can
really trust anyone ese to have this sort of access to my hosts servers?

Please can someone help as i really need this resolving asap as i need to get
the other server up and running?

Yours hopefully

just contact your host I'm positive they'll be fine woth it.

Hi m8, already tried that, they say they cannot do it as they dont have the newer version or sommat....

I think there fobbing me off to be honest!

Why would it not work? Database dumps haven't really changed between those two versions.

I really dont know, I have just tried myself using SSH and got this error:
Error 1045: Access denied for user `bashys-place.com`@localhost`
(using password: NO) when trying to connect

I got this error when running the command: mysqldump --compatible=mysql40 web18_4rum > database.sql.

Well, that is a user error. You need to set up that user and password first.

Hi Jump

There aint anywhere to actually setup a user.
All i had to do was activate SSH then wait an hour and hey presto
i have access now....

To me it looks like im locked out of using that command?

Have your host, or anyone with GRANT Privs, set up a user.

Or better yet, don't use that host. It seems to be a step down in service. Don't they have a control panel?