Current time: 09-25-2018, 05:46 AM Hello There, Guest! (LoginRegister)


Post Reply 
Import database from another server
Author Message
adivor Offline
Junior Member
*

Posts: 42
Joined: Apr 2009
Reputation: 0
Post: #1
Import database from another server
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!
03-13-2013 05:49 PM
Find all posts by this user Quote this message in a reply
FeG Offline
Banned

Posts: 222
Joined: Aug 2007
Post: #2
RE: Import database from another server
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
03-13-2013 06:28 PM
Find all posts by this user Quote this message in a reply
adivor Offline
Junior Member
*

Posts: 42
Joined: Apr 2009
Reputation: 0
Post: #3
RE: Import database from another server
Isn't necessary put:

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

mysql -u vuxxxxx -p database_name < file_name.sql
03-13-2013 06:31 PM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)