Interested to Buy Any Domain ? << Click Here >> for more details...
How can we take a backup of a mysql table and how can we
restore it. ?
- 7 Answers
- 17631 Views
- Brain Infosys, Oracle, I also Faced
- E-Mail Answers
Answer Posted / david
With dbForge Studio you can perform full database backup or restoring only selected database objects.
Database menu or from the shortcut menu of the database node of the Database Explorer window -> Backup Database -> Database Backup Wizard.
1. Select a database to back up, backup script file name and location, click the Next button.
2. Select Structure and Data, check Include all objects, click the Next button.
3. Set the backup options, click the Backup button.
4. Choose whether to open the backup script file in SQL Editor and wether to save the backup project for future use, and click the Finish button.
Backing Up Certain Database Objects
1. Choose a database to backup, script file name and location, click the Next button.
2. Select required information to backup.
3. Select database objects to backup their structure if you have chosen Structure or Data to backup on the Backup Content page, click the Next button.
4. Select tables to backup their data if you have chosen Data or Structure to backup on the Backup Content page, click the Next button.
5. Set backup options, click the Backup button.
6. Choose whether to open the backup script file in SQL Editor and wether to save the backup project for future use, and click the Finish button.
Restoring Database from Backup Script
To call Database Restore Wizard and restore the database from the backup script:
1. Select Restore Database... from the Database menu or from the shortcut menu of a database node of the Database Explorer window.
2. Select backup script file to restore and target database. If backup script file contains CREATE DATABASE statement, backup data will be restored to the created database instead of the selected database.
3. Check that the encoding for the restored file is selected correctly. The program automatically selects it basing on the restored file, if it fails, the default encoding (the current Windows encoding on the machine where dbForge Studio is running) is selected. You can always select a required encoding from the drop-down list.
4. Click the Restore button.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are getters and setters php?
Explain the value of the variable input is a string 1,2,3,4,5,6,7. How would you get the sum of the integers contained inside input?
Tell me are parent constructors called implicitly inside a class constructor?
What is json php?
A process can run only in the background. State Whether True or False?
Tell me how can we check the value of a given variable is alphanumeric?
am from coimbatore.am learning php&mysql. what will be the approx salary for me if i get a job in coimbatore.
discuss the issue of software theft in ghana and how it has affected the economy
What are arguments in php?
What is the use of strip_tags() method?
Tell me how can I display text with a php script?
How failures in execution are handled with include() and require() functions?
What is php form validation?
What is csrf verification?
Why do we use interface in php?
