Brumpost
  • COVID-19
  • Best Products
  • News
  • How Tos
  • The Bargainer
  • Reviews
  • Tireposts
  • @Work
  • 5G
No Result
View All Result
Brumpost
Home How Tos BP-Hack

Quickly import/export your MySQL database

Quick and easy guide to ensure data safety

Ret SILO by Ret SILO
3 years ago
in BP-Hack
Reading Time: 4min read
0
Share on FacebookShare on TwitterPin It

The word Export or Import database could be somehow too technical for the new guy in web Dev world. Many people don’t even know where the database is located or how to even access it or what it really is. But since we all need to learn, that’s what this video is for.

HostGator Web Hosting
ADVERTISEMENT

Previously I wrote an article about how to create a Database and access it in PHPMyAdmin*** And so today, we’ll be talking about how to import/export databases.

The first thing to do is if you aren’t able or unfamiliar with the PHPMyAdmin, you can read my intro to PHPMyAdmin here**** to get you kick started. But here, I’ll take the task one after the other. So…

The text is a guideline for the video so watch and read to get better understanding of the MySQL database.

DON’T MISS OUT AGAIN!
Get all the latest about tech trends in your mailbox every morning
FREE SIGN UP
By signing up, you agree to BRUMPOST Terms of Use and acknowledge the data practices in our Privacy Policy. You may unsubscribe at any time.

#1. Exporting Database

To export your database tables or a table, all you need to do is simple. Firstly, login to your Dashboard (C-Panel or Your Webpabel if Dreamhost) and then look around for your MYSQL or Database area.

If you use Dreamhost, you can find that under the collapsible Menu Goodie >> Manage Database. In IPage, click on MySQL databases and then look for the exact database you want to work with.

Assuming you had created a database with the Name “MyTestDB” then hover on it and when the PHPMyAdmin option shows, click on it.

In the case of Dreamhost, that is already set in front of the database so you don’t need hovering. Ones you are logged in or your Database structures shows up, simply look for the exact table you want to export and then click in it.

Bit assuming you want to move your website to another server and needs your database, then you might want to check all tables without omitting any of them.

Now, the next thing is look for the export button and then click it. Depending in your client, you might be prompted where you want to export the database.
Note: Before you flick on Export button, you need to first of all click on the type of file you wanna save the database with. You could save it as a “.SQL” file or “.ZIP” or any other format presented to you depending in your host’s file manager.

But remember that the .SQL file is the raw file of the MySQL database while the .zip us the compressed version. The key reason for compression is that many database importer won’t allow you to import more than a set value e.g “8mb” so exporting a very large .SQL database could be useless so you’ll need it compressed.

2. Importing Database

Now, assuming you have created your http://www.sample.com website a host and you want to move it back to your new host server, this is what the importation does.

Rather than having to restart the months or weeks of development just to suit your very need. Aside from Drupal or WordPress or any other CMS, there are some scripts that doesnt allow or are unable to create databases all by themselves during installation and so you might be needing to import in those tables into a new database or an empty one and point it to the Config.php files of those scripts.

But either way, our main focus here would be importing the database. So all you need to do just you’ve done before is look for the import Tab and then click on it.

After that, you’ll see the new interface where you can simply browse the directory where you’ve uploaded your exported database.

Now, click in it and then click on the go button. After waiting for some moments depending on your network’s speed, you should see a green success above the page and so to confirm the importation, click on the Browse button and then see your tables.

In some other cases, you might want to import a database table into an existing database let’s take for example, sometimes while working on a new WordPress install, I initially installed the mailpoet plugin but later deleted it for mailchimp.

Later on, I decided to have them both together to experiment but because I have deleted all the tables of the Mailpoet from my database, I couldn’t do anything.

Mailpoets can’t recreate another table so I had to export those mailpoet tables from my localhost WordPress install and then uploaded them into my existing server new WordPress.

So if you want to do something like that, you just need to be able to locate where exactly to import that or those tables and then import it directly in there with the click of the Import button rather than using the import tab which serves as the interface for bulk importing.

Like the Mailpoet databases, they are all in the open table like every other WordPress tables rather than being in the WP_Option table (WP_ ) is just a prefix.

So now you can just try that and get more familiarity with the PHPMyAdmin interface as it would help your relationship with your database.

Secure your database tables with powerful passwords because your website can be hacked straight from the DB and not necessarily from the website administrative panel itself.

HostGator Web Hosting
ADVERTISEMENT

Related Posts

iPhone 12 OLED screen
Rumors

What we know about the iPhone 13 or whatever it will be called

by Liam Hall

Sorry! It's probably called an iPhone 12S

Read more

Xiaomi Mi 11 just got 10% Discount and you should grab it

1 Pair Electric Heated Shoe Insoles For Warmer Feet during cold weathers

SESAR-JU An European Consortium has launched a two-year Urban Air Mobility Program

New Argo Autonomous Hardware upgrade meant to make self-driving tech better

Sovol SV01 Direct Drive 3D Printer is cheaper and may be right for you

Leave a Reply Cancel reply

BEST HOLIDAY DEALS

It’s holiday season and on Brumpost Bargainers, we actually get you the best values and amazing deals by scouring the entire web for the most affordable yet high quality products ever for you.

Learn more
  • About us
  • Advertise
  • Mobile
  • Write for us
  • FAQ
  • Cookie Policy
  • Contact us
  • Career
  • Terms of Use
Menu
  • About us
  • Advertise
  • Mobile
  • Write for us
  • FAQ
  • Cookie Policy
  • Contact us
  • Career
  • Terms of Use
© 2020 BRUMPOST MEDIA LLC
All Rights Reserved
FOLLOW US
AFFILIATE DISCLOSURE
Brumpost may get a commission from retail offers.
  • Login
  • Sign Up
No Result
View All Result
  • Tech News
    • Industry News
    • Gears & Gadgets
    • Sci-Tech
    • Culture
    • Enterprise
    • Rumors
  • Products Review
    • Smartphones
    • Smartwatches
    • Bluetooth Speakers
    • Headphones
    • PC & Computers
  • “How-to” Guide
    • Apps/Software
    • BP-Hack
    • Gadgets
    • Internet
  • Tirepost
    • Best Cars
    • Car Reviews
    • Green
    • Latest News
  • @Work
  • The Bargainer
    • under $50
    • Under $100
    • Under $200
    • Under 300
    • under $400
    • Under $500
  • Videos
  • Pictures
  • COVID-19 Monitor

©Copyright 2018 Brumpost Media, Inc.

Welcome Back!

Login to your account below

Forgotten Password? Sign Up

Create New Account!

Fill the forms below to register

*By registering into our website, you agree to the Terms & Conditions and Privacy Policy.
All fields are required. Log In

Retrieve your password

Please enter your username or email address to reset your password.

Log In
DON’T MISS OUT AGAIN!
GET THE LATEST UPDATES IN YOUR INBOX EVERYDAY
FREE SIGN UP
By signing up, you agree to BRUMPOST Terms of Use and acknowledge the data practices in our Privacy Policy. You may unsubscribe at any time.
Learn how to grow every aspect of your
GET THE BEST SMALL BUSINESS RESOURCES & TIPS DAILY
FREE SIGN UP
By signing up, you agree to BRUMPOST Terms of Use and acknowledge the data practices in our Privacy Policy. You may unsubscribe at any time.
DON’T MISS OUT AGAIN!
Get all the latest about tech trends in your mailbox every morning
FREE SIGN UP
By signing up, you agree to BRUMPOST Terms of Use and acknowledge the data practices in our Privacy Policy. You may unsubscribe at any time.
FREE SIGN UP
Sign-up for exclusive content. Be the first to hear about Brumpost Tech news.
Subscribe
close-image

WE'VE GOT BUNCH OF COOKIES HERE!

Brumpost uses cookies to enhance your experience and by continuing to use the website, you are giving consent to those cookies being used. To learn more, click below
COOKIE POLICY
close-link
Click Me