Answer / rupa bagherwal

mysqldump -uusername -ppassword databasename --no-data >
backupfilename.sql

Answer / 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.

Answer / shripad chandratre

INSERT INTO Backup_file SELECT * FROM file

Answer / anil alpati

mysqldump --no-data --databases <dbname> > structurebackup.sql

Answer / sandeep

mysqldump -d -uusername -ppassword databasename --no-data
--skip-opt > /tmp/databasename.sql

Answer / sonali

mysqldump -d -uusername -ppassword databasename > backupfile.sql

Give the syntax of Grant and Revoke commands?

1 Answers  

How can a user get the current SQL version?

2 Answers  

What is the difference between char and varchar in mysql?

0 Answers  

Is mysql good for big data?

0 Answers  

What is the maximum number of columns per table?

0 Answers  

How to use case expression?

0 Answers  

how to Return total number of rows.

0 Answers  

Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters

3 Answers  

How to update a root password.

0 Answers  

How do you create a new database in mysql?

0 Answers  

How can I create table in mysql?

0 Answers  

How to see the create table statement of an existing table?

0 Answers