The author selected the Free and Open Source Fund to receive a donation as part of the Write for DOnations program. Show IntroductionImporting and exporting databases is a common task in software development. You can use data dumps to back up and restore your information. You can also use them to migrate data to a new server or development environment. In this tutorial, you will work with database dumps in MySQL or MariaDB (the commands are interchangeable). Specifically, you will export a database and then import that database from the dump file. PrerequisitesTo import or export a MySQL or MariaDB database, you will need:
Note: As an alternative to manual installation, you can explore the DigitalOcean Marketplace’s MySQL One-Click Application. Step 1 — Exporting a MySQL or MariaDB DatabaseThe Use
The command will produce no visual output, but you can inspect the contents of Run the following command:
The top of the file should look similar to this, showing a MySQL dump for a database named
If any errors occur during the export process, Step 2 — Importing a MySQL or MariaDB DatabaseTo import an existing dump file into MySQL or MariaDB, you will have to create a new database. This database will hold the imported data. First, log in to MySQL as root or another user with sufficient privileges to create new databases:
This command will bring you into the MySQL shell prompt. Next, create a new database with the following command. In
this example, the new database is called
You’ll see this output confirming the database creation.
Then exit the MySQL shell by pressing
If the command runs successfully, it won’t produce any output. If any errors occur during the process, ConclusionIn this tutorial you created a database dump from a MySQL or MariaDB database. You then imported
that data dump into a new database. To learn more about MySQL, check out our MySQL resource page. To learn more about MySQL queries, check out our tutorial, “An Introduction to Queries in MySQL”. How do I view MySQL dump files?Answer. From the command line on the machine where MySQL is installed (locally or in an SSH session), run: mysqldump -uusername -ppassword \<database name> --opt > myDBDump.. Then, you can check the output file with a text editor to verify the integrity of the data.. How do I load a MySQL dump file?To import an SQL dump file:. Connect to your MySQL database.. Choose Import > From SQL Dump… from the File menu.. This will bring up a dialog box, select the file on your file system that you would like to import, then click Import .. Your database will now be updated. Click the Refresh button (Cmd + R) if needed.. How do I run a MySQL dump file in Windows?How to use the mysqldump utility to create a backup of your database?. Open a Windows command prompt from your VPS.. Click Start -> Run.. Enter “cmd” into the dialog box and click the “OK” button.. Change the directory to the following to access the mysqldump utility. ... . Create a dump of your current MySQL database.. How do I run a SQL dump file?Show activity on this post.. Open the MySQL command line.. Type the path of your mysql bin directory and press Enter.. Paste your SQL file inside the bin folder of mysql server.. Create a database in MySQL.. Use that particular database where you want to import the SQL file.. Type source databasefilename.sql and Enter.. |