MYSQL ( Lesson No. VII )

How to Create Backup & Restore Data in MYSQL  

This is a simplify Coding of Backup & Restore Databases in MYSQL.If you want to make any project and use the databases of another PC same databases then to use this coding and Restore the database.And if your PC in a networking then to use this coding and give the IP addresses then you were use the same databases in another PC's.

1.)  //dumping database
c:\programe files>mysqldump -u root -p database name>c:\filename.txt
type password

2.) //dumping table
c:\programe files>mysqldump -u root -p database_name table_name>c:\filename.txt
type password

3.) //importing database
c:\program files>mysql -u root -p database_name<c:\file_name
type password

4.) //dumping data of a table
mysql>select * into outfile 'c:\\file_name' from table;

5.) //loading data from 1 file
mysql>load data infile 'c:\\ss.txt' into table table_name;