How do you backup a database in MySQl?

  • MySQL Command - shell> mysqldump --databases test > dump.sql
    It is easy to backing up data with phpMyAdmin. Select the database you want to backup by clicking the database name in the left hand navigation bar. Then click the export button and make sure that all tables are highlighted that you want to backup. Then specify the option you want under export and save the output.

Previous Papers

Model Tests

Current Affairs

Question Answers

Related Question & Answers

How can one restart SQL Server in single user or minimal configuration modes?

How can we convert between Unix & MySQL timestamps?

What is SQLyog?

What is meant by transaction and ACID properties?

What do you mean by % and _ in the LIKE statement?

Related Practice Tests

MySQL Interview Questions for Freshers
Categories
AndroidC programmingC++ programmingCloud ComputingComputerComputer System ArchitecureData BaseData StructureInternet & Social MediaJava programmingManual TestingMS OfficeMySQLNetworkingOperating SystemPHPProgrammingSoftware EngineeringSoftware Testing
How do you backup a database in MySQl?
Home Ask Questions Study Current Affairs Previous Papers Kerala PSCIBPSUPSCRBITNPSCMPSCSSCCBSEUnited StatesModel Tests News More Answers Coaching Centres Careers Downloads Colleges