Sir
Thanks for your support.
Export command
sudo mysqldump - u username -p dbname > path to .sql file
import
sudo mysql -u username -p dbname < path to .sql file.
my error log is
141209 14:56:26 [Note] Event Scheduler: Purging the queue. 0 events
141209 14:56:26 InnoDB: Starting shutdown...
141209 14:56:27 InnoDB: Shutdown completed; log sequence number 2336225673
141209 14:56:27 [Note] /usr/sbin/mysqld: Shutdown complete
141209 15:58:20 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
141209 15:58:20 [Note] Plugin 'FEDERATED' is disabled.
141209 15:58:20 InnoDB: The InnoDB memory heap is disabled
141209 15:58:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141209 15:58:20 InnoDB: Compressed tables use zlib 1.2.8
141209 15:58:20 InnoDB: Using Linux native AIO
141209 15:58:20 InnoDB: Initializing buffer pool, size = 128.0M
141209 15:58:20 InnoDB: Completed initialization of buffer pool
141209 15:58:20 InnoDB: highest supported file format is Barracuda.
141209 15:58:31 InnoDB: Waiting for the background threads to start
141209 15:58:32 InnoDB: 5.5.38 started; log sequence number 2336225673
141209 15:58:32 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
141209 15:58:32 [Note] - '127.0.0.1' resolves to '127.0.0.1';
141209 15:58:32 [Note] Server socket created on IP: '127.0.0.1'.
141209 15:58:33 [Note] Event Scheduler: Loaded 0 events
141209 15:58:33 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.38-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
I did not understand anything from this.Am totally confused sir.