+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Import database from another server (/thread-16518.html)
Import database from another server - adivor - 03-13-2013 05:49 PM
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!
RE: Import database from another server - FeG - 03-13-2013 06:28 PM
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
RE: Import database from another server - adivor - 03-13-2013 06:31 PM
Isn't necessary put:
mysql -u root -p database_name < file_name.sql
or
mysql -u vuxxxxx -p database_name < file_name.sql