Solved

Import dumped MySql file into database on local machine

Posted on 2014-02-14
4
530 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
Creating and Managing Databases with phpMyAdmin in cPanel.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

726 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