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

how many table created when we create a table in mysql?

3 Answers  

Explain csv tables.

0 Answers  

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

0 Answers  

How to use like conditions?

0 Answers  

What is the maximum length of a table name, database name, and fieldname in MySQL?

3 Answers   Accenture, Pioneer, TISL,

What is mysql port?

0 Answers  

What?s the default port for MySQL Server?

4 Answers   Yahoo,

Can you tell the difference between ereg_replace() and eregi_replace()?

0 Answers  

What does myisamchk do?

1 Answers  

is it possible to assign two primary key in a table

8 Answers   IBM,

What is the difference between procedure and function in mysql?

0 Answers  

What is MySQL Stored Procedure?

1 Answers