friends,
If you want to take dump of data and want to store data in mysql server then try this .
Store (.dump or .sql files ) in My Sql server
1> mysql -u root -p
or mysql -A;
2> mysql> SOURCE location of data file
SOURCE /home/jiten/Desktop/backupfile.sql or .dump
3> show databases;
4> use data base name;
use mysql;
5>show tables;
6>If you want to see schema of the table
describe table name;
describe text_class;
7> If you want to select all data from table
select * from table name;
select * from text_class;
Other command if you do not want to connect MySql server
1> mysql -h DBHOST -u DBUSER -pDBPASS DBNAME <>
mysql -h "localhost or server ip or server name" -u "user name root or other" -p "user password " data base name " mysql or other " < data name that data you want to store in data base " data.sql or backup.dump"
Take Data Backup in Mysql server to other place
1> mysqldump -u [Username] -p [password] [databasename] > [backupfile.sql]
mysqldump -u {root or jiten}-p{password} {jiten or mysql} > {jitenback.sql}
Thanks
jiten jha
