database import

[robin01]

Hello all,

I have a websit that I need to duplicate on to a test server.

I installed Ubuntu and mysql/php/apach/phpmyadmin installed and working correctly.

No root password set on mysql but its internal so it doesn't matter.

I exported the mysql database from my website to my local drive.
how do i import the database so i have an exact duplicate on my test server.
i tried importing using phpmyadmin and it gave me some error message about file being too big.

whats the command line command to import this file(database.sql) into mysql server(remember i dont have a password set on mysql and i'm very new to mysql)?
all i want to do is make a duplicate database entire on my test server.
any help you can give me would be greatly appreciated.
thanks

[big_nerd]

mysql -u root < database.sql

From your command line.

I strongly recommend setting a password for root. even if the priv's don't allow external access.

Not that anyone with decent enough local priv's couldn't get in.. just a good idea.