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

What is RMS Migrations

0 Answers   Steria,

What is a mysql server?

0 Answers  

How to display top 50 rows?

0 Answers  

Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

0 Answers  

What is a csv table?

0 Answers  

How do you flush privileges?

0 Answers  

What are the advantages and disadvantages of MySQL?

0 Answers   Satyam,

what are the different tables present in mysql? : Mysql dba

0 Answers  

How to make a copy values from one column to another in mysql?

0 Answers  

How to delete a database from mysql server.

0 Answers  

how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.

0 Answers  

What does mysql_fetch_assoc do?

0 Answers