Update from backup.

[Kold]

Hi.

I have a mySQL .sql file from backup, I now wish to put this on a new server. I have full access to the server (colocated). The file is around 40mb.

What is the best way to go about this?

Thanks.

[Houdini]

Break it into smaller chunks of about 5 meg, but you could start with 10 and see if it works without timing out.

[Kold]

How do you mean?

I wont be using phpmyadmin, and will have full access to the server.

Would starting mysql with '--init-file=/my-database-file.sql' be the best way to do it?

Thanks.
K.

[liquorvicar]

How about

mysql -u USER -p DATABASE < file.sql

It should then prompt you for your password. You can omit DATABASE if your sql script includes a CREATE DATABASE statement.