How to Export MySQL Database (Command Line) to a File

-
Let's cut to the chase.

Open up your terminal, and type in the following command:


mysqldump --add-drop-table -u admin -p dbname > dbname.sql

Enter your password in the prompt and press enter.

Replace the following with your relevant information:
admin --> Your username
dbname --> Your database name
dbname.sql --> The name you want to give the exported file.

If all goes well, you'll have an sql file inside whatever directory you invoked the command.
Note that when you import this file inside another database, it will drop and replace the tables in the database. If you just want the data to be merged, then omit the --add-drop-table parameter from the command above.

That's all! 👦

Comments

Post a Comment

Popular posts from this blog

How to set up Allegro 5 Library for Android Development

-
Image
Okay, so in this post, I'm going to be showing you how to set up the Allegro 5 Library for game development on the Android platform. This will be particularly useful for those who are having difficulty setting up the environment for deploying your games made in Allegro 5. Later, I'll be making a couple of tutorial series that will show how to make Allegro 5 games from scratch for those who are just starting out. I already made a video on this topic, and if you prefer to follow a video tutorial instead of reading this stuff, then you can watch the video below. Without further ado, let's get started with the requirements. Requirements Android Studio Android SDK with the following installed packages: Android NDK (make sure you take the latest version) CMake LLDB Once you have all these ready, we can start. First, we need to download the Allegro 5 libraries for android. So navigate to  the maven repository  as shown in the screenshot below. Clic...
Read more

Assembly Language Tutorial For Beginners Part 1

-
Image
Assembly language is a Low Level Language that sits directly atop the machine language of a particular machine. There are different versions of assembly language, for different operating systems and architecture. In this tutorial, we'll be looking at assembly language on the Linux platform (x86_64). You might wonder why you need to learn assembly language in this age and period. We're not learning assembly language to develop software but for reverse engineering. If you're going to be doing serious reverse engineering, then you'll encounter programs that you'll have to dig into the low-level details, and there assembly language will be waiting for you. So even if you won't be developing any software using assembly language, it will definitely be invaluable if you plan to venture into reverse engineering. What You're Going To Learn In this tutorial, we're going to cover the following: Registers Hardware Stack   What You Need To follow along w...
Read more