Import database from another server

[adivor]

Hello to ALL!

I need to import a mysql tar.gz database from old server.

I have added new domain in ispcp domain and created SAME DB WITH SAME NAME E PASSWORD to old server.

I have insert from ftp my 400mb db file in home of my domain.

Can i use simply this command: mysql < FILE_NAME.sql -u root -p

THANKS!

[FeG]

Hi,

(03-13-2013 05:49 PM)adivor Wrote:  Can i use simply this command: mysql < FILE_NAME.sql -u root -p

This hould probably work, however depends on the format you used for exporting. If the sql file is a regular mysql dump, it shoul be fine. In any case, you might want to take a look at the sql commands first, to be sure.

Best,
FeG

[adivor]

Isn't necessary put:

mysql -u root -p database_name < file_name.sql
or

mysql -u vuxxxxx -p database_name < file_name.sql