Answer Posted / nivedita
select INTO statement id used to take a back of the table.
syntax
select coloum_name(s) INTO NewTable(in external database)
from source table;
example: select * into person_backup from persons;
------------
another way is to take a dump
mysqldump -h hostname -u username -p password database >
backupdtabase.sql
o [username] - this is your database username
o [password] - this is the password for your database
o [databasename] - the name of your database
o [backupfile.sql] - the file to which the backup
should be written.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How do I select a table in mysql?
What is the difference between having and where clause in mysql? Explain
How do I find my mysql username and password?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
How do you kill a long running query in mysql?
Write a query to stop mysql in unix
What is 'mysqld'?
Can I use mariadb instead of mysql?
Which is faster innodb or myisam?
Can we join 3 tables in mysql?
How to get a version of mysql?
What are the advantages of MySQL when compared with Oracle?
What is the difference between mysql_connect and mysqli_connect?
What are the 3 main types of search queries?
How to do login in mysql with unix shell.