Ticker

6/recent/ticker-posts

How to export and import a MySQL database Windows and Linux

Export and Import



Method #1: Use the mysqldump

Export your MySQL database to a dump file:-

mysqldump command-line through to create a dump file and backup or copied to another system.


mysqldump –u username –p db_name > test_dump_file.sql

Import your MySQL database to a dump file:-

Command-line through any MySQL .sql file import in database.

mysql –u username –p new_db_name < test_dump_file.sql


Method #2: Use the phpMyAdmin

You can export and import a MySQL database using the phpMyAdmin web interface.

phpmyadmin

phpMyAdmin interface through you can directly database export and import.



Method #3: Use the MySQL Workbench Software

First Download the MySQL Workbench. After login the database host, Username, and Password credentials enter.

workbeanch


Data Export via MySQL Workbench

Export database





Data Import via MySQL Workbench

Import workbench



Method #4: Use the DBeaver Software

You can also Database import and export via DBeaver software.


DBeaver database




Reactions

Post a Comment

1 Comments

Emoji
(y)
:)
:(
hihi
:-)
:D
=D
:-d
;(
;-(
@-)
:P
:o
:>)
(o)
:p
(p)
:-s
(m)
8-)
:-t
:-b
b-(
:-#
=p~
x-)
(k)