How to Backup and Restore Data (Contacts - Apps - Message etc) on Your Android Smartphone



How to Back Up and Restore Data in MySQL

Multiple backups should be taken. E.g.

  • One copy on the same computer or locally networked computer that can be used to quickly replace a database that is in use.
  • Another copy in a physically different location in case something happens at the current location (fire, flood). This could be another computer at a remote site or some portable medium like a tape or CD.

If using Windows, open a command prompt window. If using Linux, execute the commands on the command line. The examples below are for Linux - convert backslashes and add.exeto the command for the Windows equivalents.

Steps

  1. To make a backup:
    • mysqldump --user=username--password=password databasename>path/backupfilename
  2. To repair a table:
    1. Stop the MySQL server:
      • mysqladmin -uusername-p 'password' shutdown
    2. Start the repair:
      • myisamchk -rdatabasepath/databasename/tablename.MYI
        • databasepath- The complete path to your data directory.
        • tablenamecan be "*" which means fix all tables.
    3. You should see output on the screen telling you which tables are being checked.
    4. Restart the MySQL server:
      • mysqladmin -uusername-p start
  3. If the repair doesn't work, you may need to delete the table and restore from the backup file:
    1. Delete the table - in MySQL, send the query:
      • DROP TABLEtablename
    2. Back at the command prompt:
      • mysql -uusername-pdatabasename</path/backupfilename

Community Q&A

Search
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.

Video

Warnings

  • The backup file contains all INSERT commands to restore all tables you specified when you made the backup. If you only want to restore some of the tables, you'll need to edit the backup file before running the restore command.





Video: How to Backup and Restore Data on Samsung Galaxy S8, S8+, NOTE 8

How to Back Up and Restore Data in MySQL
How to Back Up and Restore Data in MySQL images

2019 year
2019 year - How to Back Up and Restore Data in MySQL pictures

How to Back Up and Restore Data in MySQL recommendations
How to Back Up and Restore Data in MySQL recommendations photo

How to Back Up and Restore Data in MySQL pictures
How to Back Up and Restore Data in MySQL picture

How to Back Up and Restore Data in MySQL How to Back Up and Restore Data in MySQL new images
How to Back Up and Restore Data in MySQL new foto

pics How to Back Up and Restore Data in MySQL
foto How to Back Up and Restore Data in MySQL

Watch How to Back Up and Restore Data in MySQL video
Watch How to Back Up and Restore Data in MySQL video

Forum on this topic: How to Back Up and Restore Data , how-to-back-up-and-restore-data/
Discussion on this topic: How to Back Up and Restore Data , how-to-back-up-and-restore-data/ , how-to-back-up-and-restore-data/

Related News


Why Does Harvey Brody Get So Many Skin Cancers
Listen to the voice of experience
10 Early Signs You Might Be Pregnant
What Your Wedding Invitation Suite Should Include
Can Ultrasound Help Relieve Rheumatoid Arthritis Pain
Putin wants to host the Trump team when the time is right
How to Paint a Barn
Top 25 Celebrities Before And After Plastic Surgery And Nose Jobs
Small Bump in Blood Pressure During Pregnancy Might Harm Baby
Spring Must-Have Jewelry at Rebecca Minkoff



Date: 12.12.2018, 18:30 / Views: 71293