how to take mysql database structure backup

Categories >> Software >> Databases >> MySQL
Suggest New Category

Question Posted / guest

6 Answers
9656 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to take mysql database structure backup..

Answer / rupa bagherwal

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

Is This Answer Correct ?

5 Yes

0 No

how to take mysql database structure backup..

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.

Is This Answer Correct ?

5 Yes

1 No

how to take mysql database structure backup..

Answer / shripad chandratre

INSERT INTO Backup_file SELECT * FROM file

Is This Answer Correct ?

5 Yes

2 No

how to take mysql database structure backup..

Answer / anil alpati

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

Is This Answer Correct ?

4 Yes

3 No

how to take mysql database structure backup..

Answer / sandeep

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

Is This Answer Correct ?

1 Yes

0 No

how to take mysql database structure backup..

Answer / sonali

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

Is This Answer Correct ?

1 Yes

1 No

Post New Answer