Importing mysql dump file to my Local Server

Murali · #1 11-14-2007, 01:46 AM

A small query in importing mysql dump file to my Local Server.

Actually I have installed 5.1.22-rc-community to my local system. I have a mysql dump sql file in one of my server, now I want to execute the script to my local host mysql, how can I do it?

I normally will execute the script using the following command,

Code:

mysql -u root -p –h [My Server IP]  < [File Path].sql

How should I have to issue the command for importing the sql file to my localhost ? Any Ideas?

priyan · #2 12-12-2007, 06:10 AM

Hi Murali,

I assume that you are using Win-XP and installed 5.1.22-rc-community on your machine(localhost).

If my assumption is right then you can use the same code which you specified in your post.

HTML Code:

 mysql -u root -p –h [My Server IP]  < [File Path].sql

Note : Since you are connecting your localhost as root user from remote machine, make sure that the following setting is enabled in your (localhost) mysql 5.1.22 server.

HTML Code:

        MySQL Server Instance configuration
	             Modifiy Security Settings
	             Enable root access from remote machines.

Either you can enable this setting or you can create another user in your localhost with all privileges and import your data using that user since root user not allowed to connect from remote machines.

eg.
If the new user created on your local machine is 'adminuser' then

HTML Code:

 mysql -u adminuser -p –h [My Server IP]  < [File Path].sql

Try this and let me know your feedback if you found any other issues ...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Importing data from excel to MYSQL	komal.kukreja	PHP Programming	1	06-26-2009 10:54 PM
Importing MS Excel Data into a MySQL database using PHP	jamilvoss	PHP Programming	0	12-26-2008 11:33 AM
ERROR 2002 (HY000): Can't connect to local MySQL server through socket	Gopisoft	Database Support	1	10-29-2007 02:07 AM
how to access local file from server?	varghese	HTML, CSS and Javascript Coding Techniques	5	10-17-2007 11:15 PM
mysql dump	JSureshkumar	PHP Programming	3	03-14-2007 03:55 AM