<div>
If you're using command-line Mysql, change into the directory in which the dump file exists first. Then start command-line mysql. &nbsp;Create your DB and &quot;use&quot; that Db.<br />
<br />
Then say <br />
source filename;<br />
<br />
I restore from dump files frequently with this. &nbsp;Now ... for some reason ... the dump files do not usually include the stored procedures. &nbsp;So if you have SP's, you'll need to add them separately.
</div>


If you're using command-line Mysql, change into the directory in which the dump file exists first. Then start command-line mysql.  Create your DB and "use" that Db.

Then say
source filename;

I restore from dump files frequently with this.  Now ... for some reason ... the dump files do not usually include the stored procedures.  So if you have SP's, you'll need to add them separately.

<div>
Thanks for the help. I had tried import previously but it did not work. I tried again just now and it completed OK. It took 3 or 4 minutes. Maybe I did not allow it to complete previously.<br />
<br />
I dont normally use command line,<br />
<br />
Regards<br />
<br />
John
</div>


Thanks for the help. I had tried import previously but it did not work. I tried again just now and it completed OK. It took 3 or 4 minutes. Maybe I did not allow it to complete previously.

I dont normally use command line,

Regards

John

<div>
You're welcome, glad to help.
</div>


<div>
<div class="content wysiwyg-content">
I have a MySql database on the 1and1 linux server.<br />
<br />
I exported the database on the 1and1 server into a dumped file on my local machine. <br />
I wish to import/update this on to the original db on to my local machine.<br />
<br />
I cannot find any way to do this, I am using Navicat or phpmyadmin<br />
<br />
I know the location of the dumped file<br />
<br />
Can anyone please assist?<br />
<br />
Many thanks<br />
<br />
John
</div>
</div>


I have a MySql database on the 1and1 linux server.

I exported the database on the 1and1 server into a dumped file on my local machine. 
I wish to import/update this on to the original db on to my local machine.

I cannot find any way to do this, I am using Navicat or phpmyadmin

I know the location of the dumped file

Can anyone please assist?

Many thanks

John

Import dumped MySql file into database on local machine

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

The Apache HTTP Server is a secure, efficient and extensible server that provides HTTP services in sync with the current HTTP standards. Typically Apache is run on a Unix-like operating system, but it is available for a wide variety of operating systems, including Linux, Novell NetWare, Mac OS-X and Windows. Released under the Apache License, Apache is open-source software.