If you want to take a full backup i.e., all databases, procedures, routines, and events without interrupting any connections: mysqldump -u [username] -p -A -R -E –triggers –single-transaction > full_backup.sql -A For all databases (you can also use –all-databases) -R For all routines (stored procedures & triggers) -E For all events –single-transaction Without locking the … Read more
This will produce export.sql with structure from all tables and data from all tables excluding table_name mysqldump –ignore-table=db_name.table_name db_name > export.sql mysqldump –no-data db_name table_name >> export.sql
You can accomplish this using the mysqldump command-line function. For example: If it’s an entire DB, then: $ mysqldump -u [uname] -p db_name > db_backup.sql If it’s all DBs, then: $ mysqldump -u [uname] -p –all-databases > all_db_backup.sql If it’s specific tables within a DB, then: $ mysqldump -u [uname] -p db_name table1 table2 > … Read more
You didn’t mention how your backup was made, so the generic answer is: Usually with the psql tool. Depending on what pg_dump was instructed to dump, the SQL file can have different sets of SQL commands. For example, if you instruct pg_dump to dump a database using –clean and –schema-only, you can’t expect to be … Read more
mongo client can parse MongoDB connection string URI, so instead of specifying all connection parameters separately you may pass single connection string URI. In your case you’re trying to pass connection URI as a host, but 127.0.0.1/development is not a valid host name. It means you should specify database parameter separately from the host: mongodump … Read more
To dump your database for backup you call this command on your terminal mongodump –db database_name –collection collection_name To import your backup file to mongodb you can use the following command on your terminal mongorestore –db database_name path_to_bson_file