Export databases is a basic task for all web developers when using MySQL or MariaDB. <\/span><\/p>\n Use MySQL dump for database backup its require for migration or server exchange.\u00a0<\/span><\/p>\n Command for MySql or MariaDB Database export.<\/span><\/p>\n Nginx server database export without login to SQL.<\/span><\/p>\n Export MariaDB or MySql Database<\/span><\/p>\n <\/p>\n <\/p>\n You have to create a file in your home directory with SQL credentials.\u00a0<\/span><\/p>\n Use the given command to create a file.<\/span><\/p>\n Now add your MySQL credentials as given below.<\/span><\/p>\n Save and close the file and every time you can provide a file in place of credentials like in the code given below.<\/span><\/p>\n Parameters Signifies<\/span><\/p>\n -u : MySQL username.<\/span><\/p>\n -p : MySQL password.<\/span><\/p>\n DBNAME : <\/span>The name of the database that you want to backup.<\/p>\n DBBACKUP.sql <\/span><\/p>\n The name of the backup file you want to generate.<\/span><\/p>\n -h : Hostname<\/span><\/p>\n \u2013databases : Determine the database.<\/span><\/p>\n -all-databases : Backup all databases.<\/span><\/p>\n \u2013default-auth=plugin <\/span><\/p>\n It is used to specify the client-side authentication plugin to use.<\/span><\/p>\n \u2013compress : Enable compression in server\/client protocol.<\/span><\/p>\n -P : Port number to use for MySQL connection.<\/span><\/p>\n Configuration<\/span><\/p>\n Set the network buffer length (for large size files)<\/span><\/p>\n After done all don\u2019t forget to enable the foreign key<\/span><\/p>\n Export Databases in MySQL or MariaDB Export databases is a basic task for all web developers when using MySQL or MariaDB. Use MySQL dump for database backup its require for […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[46,50,45],"tags":[],"class_list":["post-1574","post","type-post","status-publish","format-standard","hentry","category-mysql","category-ngnix","category-ssh-commands"],"acf":[],"yoast_head":"\nUse my mysqldump for export single, multiple or all databses.\u00a0<\/span><\/h3>\n
Export single database<\/span><\/h3>\n
mysqldump -u USERNAME -p PASSWORD DBNAME > DBBACKUP.sql<\/span><\/pre>\nfor store database in root\u00a0<\/span><\/h3>\n
mysqldump -u USERNAME -p PASSWORD DBNAME > ~\/DBBACKUP.sql<\/span><\/pre>\nExport multiple database<\/span><\/h3>\n
mysqldump -u USERNAME -p PASSWORD --databases DB1 DB2 DB3.. >DBBACKUP.sql<\/span><\/pre>\nfor store database in root<\/span><\/h3>\n
mysqldump -u USERNAME -p PASSWORD --databases DB1 DB2 DB3.. > ~\/DBBACKUP.sql<\/span><\/pre>\nfor store database in root<\/span><\/h3>\n
mysqldump -u USERNAME -p PASSWORD --all-databases > ~\/ALLDBBACKUP.sql<\/span><\/pre>\nExports only tables from selected database.<\/span><\/h3>\n
mysqldump -u username -p database_name tablename_1 tablename_2 > name_sql_file.sql<\/span><\/pre>\nfor store database in root<\/span><\/h3>\n
mysqldump -u username -p database_name tablename_1 tablename_2 > ~\/name_sql_file.sql<\/span>\r\n\r\nmysqldump -u [user name] \u2013p [password] [options] [database_name] [tablename] > [dumpfilename.sql]<\/span><\/pre>\nHow to download MySql or MariaDB database in compress format<\/span><\/h3>\n
mysqldump -u root -ppassword wpdb | gzip > wpdb_backup.sql.gz<\/span><\/pre>\nExpert database with login to your SQL Shell\u00a0<\/span><\/h3>\n
mysql -u root -p;<\/span>\r\nImport your dump sql file in your SQL<\/span>\r\nsource ~\/wordpress.sql<\/span><\/pre>\nHow to Use mysqldump Without Password?<\/span><\/strong><\/h3>\n
nano ~\/mysql.txt<\/span><\/strong><\/pre>\n[mysqldump]<\/span>\r\nuser=root<\/span>\r\npassword=password<\/span><\/pre>\nmysqldump --defaults-file=~\/mysql.txt wpdb > wpdb_backup.sql<\/span><\/pre>\nset global net_buffer_length=1000000;<\/span>\r\nSet the maximum allowed packet size<\/span>\r\nset global max_allowed_packet=1000000000;<\/span>\r\nTo avoid delays or errors, disable the foreign key.<\/span>\r\nSET foreign_key_checks = 0;<\/span>\r\nSET UNIQUE_CHECKS = 0;<\/span>\r\nSET AUTOCOMMIT = 0;<\/span><\/pre>\nSET foreign_key_checks = 1;<\/span>\r\nSET UNIQUE_CHECKS = 1;<\/span>\r\nSET AUTOCOMMIT = 1;<\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"