Skip to main content

Backup and Restore Mysql Database




1.mysqldump allows you to backup a single database and multiple databases as well.
2.Now, assume that you want to take backup of database named source.

Backup Single Database:

mysqldump source > destination.sql

Backup Multiple Databases:

mysqldump --databases source-one source-two source-three > destination3.sql

3.Restore MySQL Database

mysqldump source < destination.sql

source is the name of database you want to restore and destination.sql is the backup file to be restored.

Comments

Post a Comment

Popular posts from this blog

Send Email(with subject,body,attachment) using SSMTP through Terminal in linux?

1.Install ssmtp as              $ sudo apt-get update && sudo apt-get install ssmtp 2.Configure smtp file by editing the following file as, $ sudo gedit /etc/ssmtp/ssmtp.conf Update file with the following: AuthUser=Sendermail@gmail.com AuthPass=SenderPasswordforGMAIL FromLineOverride=YES mailhub=smtp.gmail.com:587 UseSTARTTLS=YES Now ssmtp.conf file should look like as the following one, AuthUser=Sendermail@gmail.com AuthPass=SenderPasswordforGMAIL # # Config file for sSMTP sendmail # # The person who gets all mail for userids < 1000 # Make this empty to disable rewriting. root=postmaster # The place where the mail goes. The actual machine name is required no # MX records are consulted. Commonly mailhosts are named mail.domain.com mailhub=smtp.gmail.com:587 # Where will the mail seem to come from? #rewriteDomain= # The full hostname hostname=tele-desktop118 # Are users allowed to set their own From: address? # Y
1 comment
Read more

Backup (or) Download MYSQL Database as a zip file Using PHP

NOTE:Please change below credentials  with respect to your Database and Run the file. <?php define ( "DB_USER" ,  'DatabaseUSERNAME' ); define ( "DB_PASSWORD" ,  'DatabasePASSWORD' ); define ( "DB_NAME" ,  'DatabaseNAME' ); define ( "DB_HOST" ,  'localhost' ); define ( "BACKUP_DIR" ,  'myphp-backup-files' );  // Comment this line to use same script's directory ('.') define ( "TABLES" ,  '*' );  // Full backup //define("TABLES", 'table1, table2, table3'); // Partial backup of required tables define ( "CHARSET" ,  'utf8' ); define ( "GZIP_BACKUP_FILE" ,  true );   // Set to false if you want plain SQL backup files (not gzipped) class  Backup_Database {     var  $host ;     var  $username ;     var  $passwd ;     var  $dbName ;     var  $charset ;     var  $conn ;     var  $backupDir ;     var  $backupFile ;     var  $
1 comment
Read more

Upload and Retrieve an image from database

/*Create table in sql:*/ CREATE TABLE `images` ( `id` int(11) NOT NULL AUTO_INCREMENT, `image` longblob NOT NULL, `created` datetime NOT NULL, PRIMARY KEY (`id`) ); /*Uploading an image to Database*/ <?php if ( isset ( $_POST [ "submit" ])){ $check = getimagesize ( $_FILES [ "image" ][ "tmp_name" ]); if ( $check !== false ){ $image = $_FILES [ 'image' ][ 'tmp_name' ]; $imgContent = addslashes ( file_get_contents ( $image )); $dbHost = 'localhost' ; $dbUsername = 'root' ; $dbPassword = 'root' ; $dbName = 'sample' ; //Create connection and select DB $db = new mysqli( $dbHost , $dbUsername , $dbPassword , $dbName ); // Check connection if ( $db -> connect_error ){ die ( "Connection failed: " . $db -> connect_error ); } $dateTime = date ( "Y-m-d H:i:s" )
Post a Comment
Read more