Quality Testing

Quality is delighting customers

how to take backup database ? how do you take backup table? without using tools like mysql query browser tools.....

Views: 221

Replies to This Discussion

Can you specify how do you want to take the backup ? Like into XML file, automatic backup.

from command line. 

If i open mysql query browser tool then i can.  

if you tell to take on xml that is alsogr8 and good for me..

 

 

1) Query To take a back up of table in MSSQL

select into new_table name from old_table name

example if u want to take the backup of table named student

Then 

Select into students_bak from students

for convetring it to XML

Select *From tablenme for XML auto

RSS

TTWT Magazine


Advertisement

Advertisement

Advertisement

Advertisement

© 2019   Created by Quality Testing.   Powered by

Badges  |  Report an Issue  |  Terms of Service