Skip to main content

Dump `mysql` db by tables

Hello friends,

Welcome back again. In this story, I’m going to explain how to export mysql database by tables.

When we use `mysqldump` command for exporting entire database, it actually exports db in a single file. For some reason, I need to export all tables from a database but in separate/split files but it was not possible by using `mysqldump`. So I googled for it and I found solution, which I’m sharing here with you.

Actually this is a small bash shell script, through which I’ve exported database into multiple files by table. This bash shell script runs on linux. For windows/mac, I’ll share solution as I get.

Linux Code:


Execute above code in terminal, it will ask every time for password, if you want to avoid of asking password, then add your password after -p parameter in `mysqldump` command.

Enjoy coding 😃

Thanks.
Labels:

Comments

Post a Comment

Want to share something? Add here...

Popular posts from this blog

Import multiple db files from folder into mysql db

Hello friends, Welcome back In the previous article, we've seen how to export database by table files, not the entire db file. Now in this article, here we're going to see the sample code for importing multiple sql files into same db. This also has been achieved by using a simple shell script. In this script, applied a for loop on list of files in a directory and by using that file name, mysql's import command is executed. The code is simple, you'll learn in just few minutes. Linux shell script: Execute above code in linux terminal to import all files into the given db. Hope this would help you. Thanks.
Post a Comment
Read more

The final keyword in java

Hello friends, Welcome back 🙂. In this article, I'm going to give a short introduction to final keyword which would be helpful to know more about it. The final keyword in java has multiple uses. The main purpose of the final keyword is to add some restrictions on java elements (class, member and method). The restrictions have been described as below. Use of final keyword: 1. The final class : We can say the class is final when it declared as final. The restriction on final class is that the final class cannot be extended by any class. Rest of the behavior of the class remains same as any normal class. 2. The final method : The method declared using final keyword is to be said as final method. The restriction is that the final method cannot be overridden by derived class. This restriction applies to static method also. 3. The final member : The final member is the java class's member which is declared using final keyword. The restriction is that it can be initial...
Post a Comment
Read more

XML tools on linux

Hello friends, Welcome back 🙂 In this article, we're going through XML tools which are useful for manipulation of XML. Recently I've worked on 3 tools so for now, adding those 3 tool's information, but as I get more, I'll update the article. These tools useful for validation and split/merge the XML. These tools available on both RHEL family and Debian family  linux which are same in use for both debian and RHEL. The tools are: 1. xmllint: This tool is used for xml validation. For some reason, we need to validate XML tags with its proper openings and closing i.e. syntactic validation, also we need to validate the data in the XML. The data can be different by its type which is defined in the XML's DTD, to detect this also, xmllint is useful. With this tool, there are multiple options we can use i.e. only syntactic validation, schema validation, DTD validation etc. When I was facing issue for validating the XML which having schema, I found this tool. H...
Post a Comment
Read more