Mysqldump , Drop database , create database from database list file

I have any file with database name each line (database.txt):

database1
database2
.....

How can I use this file to :

$create database
$mysqldump
$drop database


create database from database.txt
$mysqldump database > database  from database.txt
$drop database , from database.txt

Thanks

Copyright Notice：Content Author:「Pardis」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/25338896/mysqldump-drop-database-create-database-from-database-list-file

Products recommended by Amazon

More >>>

SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN

HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs

AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler

Timberland Men's 6-Inch Premium Waterproof Boot

More about “Mysqldump , Drop database , create database from database list file” related questions

Mysqldump , Drop database , create database from database list file

I have any file with database name each line (database.txt): database1 database2 ..... How can I use this file to : $create database $mysqldump $drop database create database from database.txt $

Show Detail

mysqldump inserts "drop database" statement in the middle of the dump

I am dumping databases from a system using mysqldump. the problem is: Sometimes the SQL file contains a "delete database" in the MIDDLE of the file, Unfortunately the import of those files fails - ...

Show Detail

mysqldump not creating create database syntax

I am using mysql database. I am using mysqldump to create a dump of my database. I want the database to be dumped such that there is a drop database if exists command followed by create database co...

Show Detail

mysqldump with create database if not exist for 1 table

As the subject suggests, I'm trying to use mysqldump to create a file that includes CREATE DATABASE IF NOT EXISTS but only output a single table. I've tried multiple combinations of --databases, --

Show Detail

Is it correct mysqldump --add-drop-database generate !40000?

I am using MySql v 6.1.7601. I was dumping a database trough this command: mysqldump -u USERNAME -pPASSWORD --routines --add-drop-database --databases myDatabase> ...pathToSavedFile.sql I was

Show Detail

Using mysqldump and database users

I'm attempting to assemble all the options that I need for mysqldump to create everything used by my applications database into a single script. This includes the database itself and all the datab...

Show Detail

mysqldump only if the database is available

To get a dump from a mysql database I use, mysqldump -u root -p my_db --databases --add-drop-database --no-data --skip-triggers >> ./mydump It works fine and create the dump. But now wha...

Show Detail

mysqldump will not export an individual database

I am trying to export a database using mysqldump from command line. I am using the following syntax: mysqldump -u root -ppassword databasename > outputfile.sql I've tried several variations on...

Show Detail

Create database schema using source database without using mysqldump

I'm developing SaaS application where every client has it's own database. For every new client I need to create new instance with new database using same schema. Is there any way to clone schema ba...

Show Detail

create database if not exists in mysqldump command while importing database

I've exported database by using following command. mysqldump -u root myDB -R > E:\Java\AkshayProject\Dump\DBbackup.sql I want to import this database to another machine. I tried, mysqldump -u...

Show Detail