{"id":102,"date":"2018-04-24T05:42:40","date_gmt":"2018-04-24T05:42:40","guid":{"rendered":"http:\/\/td_uid_53_5adec3d08924f"},"modified":"2018-06-02T23:09:32","modified_gmt":"2018-06-02T23:09:32","slug":"how-to-use-sypex-dumper-to-restore-mysql-database","status":"publish","type":"post","link":"https:\/\/forumweb.hosting\/blog\/how-to-use-sypex-dumper-to-restore-mysql-database\/","title":{"rendered":"How to use Sypex Dumper to restore MySQL Database"},"content":{"rendered":"

In the process of building and developing the Website, the Backup and Restore Website is a regular work to ensure the safety of your website to avoid the unfortunate incident. Even if you back up your server automatically, it’s never too late to back up manually. Recent years, I am using Sypex Dumper as a great tool to back up\/restore Mysql database. It’s completely free and this is one of the best solutions when you need to BACKUP a large DATABASE.<\/p>\n

Why you should use Sypex Dumper<\/strong>
\n– It’s free
\n– Support for multi-level data compression (1 through 9 is Gzip, and BZip)
\n– Support multi languages
\n– Compact, convenient and very secure
\n– Can be extracted by table
\n– Ultra-simple interface, convenient use.<\/p>\n

How to use Sypex Dumper to restore database
\n<\/strong>1. Visit http:\/\/sypex.net\/en\/products\/dumper\/downloads\/ and down the latest backup
\nOr http:\/\/sypex.net\/files\/SypexDumper_209.zip
\n2. Unzip the file and click on the host to restore the database
\n3. Up the database file to the backup directory (in the directory that you just popped up, with cfg.php file)
\n4. Run http: \/\/yourdomain.com\/sxd\/ login using hosting account -> Import database<\/p>\n

\"\"<\/a><\/p>\n

Database (Schema): Select the database to restore
\nFile: database to restore (the file you just popped into the backup folder)<\/p>\n","protected":false},"excerpt":{"rendered":"

In the process of building and developing the Website, the Backup and Restore Website is a regular work to ensure the safety of your website to avoid the unfortunate incident. Even if you back up your server automatically, it’s never too late to back up manually. Recent years, I am using Sypex Dumper as a […]<\/p>\n","protected":false},"author":1,"featured_media":478,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[14],"tags":[65,64],"_links":{"self":[{"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/posts\/102"}],"collection":[{"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/comments?post=102"}],"version-history":[{"count":8,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/posts\/102\/revisions"}],"predecessor-version":[{"id":565,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/posts\/102\/revisions\/565"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/media\/478"}],"wp:attachment":[{"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/media?parent=102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/categories?post=102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/tags?post=102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}