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 the difference between the LIKE and REGEXP operators?

0 Answers  

How do I start mysql in mysql workbench?

0 Answers  

What is pdo in php mysql?

0 Answers  

Is foreign key indexed mysql?

0 Answers  

Can we rollback truncate in mysql?

0 Answers  

What are the types of queries?

0 Answers  

How to get current MySQL version?

0 Answers  

What is ntext?

0 Answers  

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 Answers  

Does mysql support sequence?

0 Answers  

How many concurrent queries can mysql handle?

0 Answers  

How can you move the master database

0 Answers   IBM,