Skip to main content

Importing and Exporting a Database using command prompt?





Importing .sql file to a database through command prompt:
mysql -u root -p

It will prompt you to enter mysql_Password

Enter password:give_your_mysql_password_here

use database_name_to_which_.sqlfile_should_import;
SOURCE /path/to/sql_file
      
           (or)


mysql -u root -p database_name_to_which_.sqlfile_should_import < example.sql;

Example:
use sample;

SOURCE  /home/desktop/sample.sql;

Exporting Database to a .sql file through command prompt:

mysqldump -u root -p database_name_to_export > example.sql;

It will prompt you to enter mysql_Password

Enter password:give_your_mysql_password_here

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 # A...
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 ;   ...
1 comment
Read more

How to Integrate SMS API's with PHP?

<?php $message  =  "Happy Coding..A Test Message to Check API" ; $students  =  "9999999999"  //your mobile number to test $msg  =  urlencode ( $message );          $url = "http://www.bulksmsapps.com/api/apibulkv2.aspx?apikey=XXX-XXXX-XXXX-XXX-XXXXXXXX&sender=XXXXX&number=" . $students . "&message=" . $msg ; $curl_handle = curl_init (); curl_setopt ( $curl_handle , CURLOPT_URL , $url ); curl_setopt ( $curl_handle , CURLOPT_RETURNTRANSFER , 1 );  curl_setopt ( $curl_handle ,  CURLOPT_FOLLOWLOCATION ,  false ); set_time_limit ( 0 ); $response  =  curl_exec ( $curl_handle ); err  =  curl_error ( $curl_handle ); curl_close ( $curl_handle ); if ( $err ) {     echo  "cURL Error #:"  .  $err ; } else {     echo  $response ; } ?> ...
9 comments
Read more