Solved

Import dumped MySql file into database on local machine

Posted on 2014-02-14
4
529 Views
Last Modified: 2014-02-18
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
0
Comment
Question by:johnhardy
  • 2
4 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 39860554
In phpMyAdmin, you would normally use the Import function.  Have you tried that?  It's on one of the tabs across the top.
0
 
LVL 32

Expert Comment

by:Daniel Wilson
ID: 39864863
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.
0
 

Author Closing Comment

by:johnhardy
ID: 39866939
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
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39867936
You're welcome, glad to help.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Display images from mysql blob type (Not working) 9 40
PHP error function not working on AWS 10 68
Where on a calculated field 1 21
LINUX Field Separators 7 34
In Solr 4.0 it is possible to atomically (or partially) update individual fields in a document. This article will show the operations possible for atomic updating as well as setting up your Solr instance to be able to perform the actions. One major …
The purpose of this article is to demonstrate how we can use conditional statements using Python.
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question